31 lines
2.0 KiB
Plaintext
31 lines
2.0 KiB
Plaintext
Mapping says allocationSize=50, the database sequence says INCREMENT BY 1 (schema created by hand)
|
|
|
|
######## H2 ########
|
|
|
|
== hibernate.id.sequence.increment_size_mismatch_strategy = (unset)
|
|
SessionFactory startup FAILED: MappingException -> MappingException: The increment size of the [seq_pooled_item] sequence is set to [50] in the entity mapping but the mapped database sequence increment size is [1]
|
|
|
|
== hibernate.id.sequence.increment_size_mismatch_strategy = EXCEPTION
|
|
SessionFactory startup FAILED: MappingException -> MappingException: The increment size of the [seq_pooled_item] sequence is set to [50] in the entity mapping but the mapped database sequence increment size is [1]
|
|
|
|
== hibernate.id.sequence.increment_size_mismatch_strategy = LOG
|
|
SessionFactory started
|
|
application instance A : ids [1, -47, -46]
|
|
application instance B : FAILED after ids [-46, -45, -44] : ConstraintViolationException -> JdbcSQLIntegrityConstraintViolationException: SQLState 23505, Unique index or primary key violation: "PUBLIC.CONSTRAINT_D PRIMARY KEY ON PUBLIC.SEQPOOLEDITEM(ID) ( /* key:-46 */ CAST(-46 AS BIGINT), 'a2')"; SQL statement:
|
|
database sequence INCREMENT BY, as the database sees it : 1
|
|
|
|
== hibernate.id.sequence.increment_size_mismatch_strategy = FIX
|
|
SessionFactory started
|
|
application instance A : ids [1, 2, 3]
|
|
application instance B : ids [4, 5, 6]
|
|
database sequence INCREMENT BY, as the database sees it : 1
|
|
|
|
== hibernate.id.sequence.increment_size_mismatch_strategy = NONE
|
|
SessionFactory started
|
|
application instance A : ids [1, -47, -46]
|
|
application instance B : FAILED after ids [-46, -45, -44] : ConstraintViolationException -> JdbcSQLIntegrityConstraintViolationException: SQLState 23505, Unique index or primary key violation: "PUBLIC.CONSTRAINT_D PRIMARY KEY ON PUBLIC.SEQPOOLEDITEM(ID) ( /* key:-46 */ CAST(-46 AS BIGINT), 'a2')"; SQL statement:
|
|
database sequence INCREMENT BY, as the database sees it : 1
|
|
|
|
######## POSTGRES ########
|
|
SKIPPED: no Docker daemon was reachable when this transcript was generated, so PostgreSQL was not run.
|