search

sassoftware / event-provenance-registry

The Event Provenance Registry (EPR) is a service that manages and stores events and tracks event-receivers and event-receiver-groups.
Apache License 2.0
5 stars 4 forks source link

ERROR: insert or update on table "event_receiver_group_to_event_receivers" violates foreign key constraint #94

Open xbcsmith opened 4 months ago

xbcsmith commented 4 months ago

2024/05/05 12:22:16 "POST http://localhost:8042/api/v1/graphql/query HTTP/1.1" from 127.0.0.1:49358 - 200 323B in 1.482334ms time=2024-05-05T12:24:01.039-04:00 level=INFO msg=created eventReceiver="&{ID:01HX4S3H7B529DRCP9RVE48F3D Name:foo-python-cli Type:dev.foo.python.cli Version:1.0.0 Description:foo python cli event receiver Schema:{} Fingerprint:9fb8af394a9c4cdfefe7b74d7d9e3111f7ffca07abff19dfe57da98e0d349852 CreatedAt:{Date:{wall:17794000 ext:63850523041 loc:0x103b90a80}}}" 2024/05/05 12:24:01 "POST http://localhost:8042/api/v1/graphql/query HTTP/1.1" from 127.0.0.1:55340 - 200 63B in 38.449042ms 2024/05/05 12:24:01 "POST http://localhost:8042/api/v1/graphql/query HTTP/1.1" from 127.0.0.1:55355 - 200 323B in 3.361167ms time=2024-05-05T12:24:01.382-04:00 level=INFO msg=created eventReceiver="&{ID:01HX4S3HJZN1XHRGSWANWA73HX Name:bar-python-cli Type:dev.bar.python.cli Version:1.0.0 Description:bar python cli event receiver Schema:{} Fingerprint:915bb11d1ee2f34aaf7d6c99e989ad71061557ee39f9ba8165a43fcb956094e3 CreatedAt:{Date:{wall:376499000 ext:63850523041 loc:0x103b90a80}}}" 2024/05/05 12:24:01 "POST http://localhost:8042/api/v1/graphql/query HTTP/1.1" from 127.0.0.1:55368 - 200 63B in 7.721167ms 2024/05/05 12:24:01 "POST http://localhost:8042/api/v1/graphql/query HTTP/1.1" from 127.0.0.1:55383 - 200 323B in 5.239458ms time=2024-05-05T12:24:01.825-04:00 level=ERROR msg="error creating event receiver group" error="ERROR: insert or update on table \"event_receiver_group_to_event_receivers\" violates foreign key constraint \"fk_event_receiver_group_to_event_receivers_event_receiver\" (SQLSTATE 23503)" input="{Name:foo-bar-python-cli Type:dev.foo.bar.python.cli Version:1.0.0 Description:foo bar python cli event receiver group Enabled:true EventReceiverIDs:[01HX4S3H7B529DRCP9RVE48F3D 01HX4S3HJZN1XHRGSWANWA73HX]}" 2024/05/05 12:24:01 "POST http://localhost:8042/api/v1/graphql/query HTTP/1.1" from 127.0.0.1:55398 - 200 265B in 23.45025ms

xbcsmith commented 4 months ago

We should probably return a better error message.