MiscService-> mergeALFEvent fails to MERGE INTO during highly parallel incoming events #1

New Issue

irn-bru · 2023-09-26T14:59:35+02:00

irn-bru commented

2023-09-26 14:59:35 +02:00

When sending a high number of events using the same event_type, object_type and obj_id values, the service throws an SQL exception KEY violation.

The reason is the merge into statement seems not to synchronize properly for an embedded H2 in-memory database (may only work with client/ server H2)

When sending a high number of events using the same event_type, object_type and obj_id values, the service throws an SQL exception KEY violation. The reason is the merge into statement seems not to synchronize properly for an embedded H2 in-memory database (may only work with client/ server H2)

irn-bru added the

bug

label 2023-09-26 14:59:35 +02:00

irn-bru self-assigned this 2023-09-26 14:59:35 +02:00

irn-bru referenced this issue from a commit

2023-09-26 15:07:53 +02:00

Synchronising MERGE INTO alf event inbound queue. This fixes #1

irn-bru closed this issue

2023-09-26 15:07:53 +02:00

Sign in to join this conversation.