User encountered bug when deleting a tap

[lennartkoopmann]

Reported by RobG on Discord.

2024-07-04T19:46:51.943340094+02:00 17:46:51.942 [grizzly-http-server-5] ERROR app.nzyme.core.rest.NzymeExceptionMapper - Error while handling REST call.
2024-07-04T19:46:51.943357516+02:00 org.jdbi.v3.core.statement.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: update or delete on table "tap_captures" violates foreign key constraint "link_freqs2captures" on table "tap_captures_frequencies"
2024-07-04T19:46:51.943366837+02:00   Detail: Key (uuid)=(667ba244-2c8d-4d0a-9539-8844ce23b2e9) is still referenced from table "tap_captures_frequencies". [statement:"DELETE FROM taps WHERE organization_id = :organization_id AND tenant_id = :tenant_id AND uuid = :uuid", arguments:{positional:{}, named:{tenant_id:f3452573-8b95-49a5-9ea7-2a15df3ef447,organization_id:0219e817-032e-456d-9c4b-77c653facae7,uuid:e6d25d04-576b-49a5-852f-636c10c13b1e}, finder:[]}]
2024-07-04T19:46:51.943369297+02:00 at org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1803) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943371414+02:00 at org.jdbi.v3.core.result.ResultProducers.lambda$returningUpdateCount$0(ResultProducers.java:48) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943374024+02:00 at org.jdbi.v3.core.statement.Update.execute(Update.java:69) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943376023+02:00 at org.jdbi.v3.core.statement.Update.execute(Update.java:57) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943378404+02:00 at app.nzyme.core.security.authentication.AuthenticationService.lambda$deleteTap$68(AuthenticationService.java:972) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943380788+02:00 at org.jdbi.v3.core.HandleConsumer.lambda$asCallback$0(HandleConsumer.java:32) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943382794+02:00 at org.jdbi.v3.core.Jdbi.withHandle(Jdbi.java:371) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943386743+02:00 at org.jdbi.v3.core.Jdbi.useHandle(Jdbi.java:387) ~[
nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943388866+02:00 at app.nzyme.core.database.DatabaseImpl.useHandle(DatabaseImpl.java:206) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943391212+02:00 at app.nzyme.core.security.authentication.AuthenticationService.deleteTap(AuthenticationService.java:966) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943393253+02:00 at app.nzyme.core.rest.resources.system.authentication.mgmt.OrganizationsResource.deleteTap(OrganizationsResource.java:1241) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943395280+02:00 at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
2024-07-04T19:46:51.943397353+02:00 at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
2024-07-04T19:46:51.943399401+02:00 at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
2024-07-04T19:46:51.943401718+02:00 at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
2024-07-04T19:46:51.943404037+02:00 at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943406230+02:00 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:134) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943408308+02:00 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:177) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943410332+02:00 at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943412355+02:00 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:81) ~[
nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943414383+02:00 at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:478) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943419142+02:00 at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:400) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943421379+02:00 at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943423412+02:00 at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:261) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943425410+02:00 at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943427435+02:00 at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943429429+02:00 at org.glassfish.jersey.internal.Errors.process(Errors.java:292) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943439463+02:00 at org.glassfish.jersey.internal.Errors.process(Errors.java:274) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943441904+02:00 at org.glassfish.jersey.internal.Errors.process(Errors.java:244) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943443937+02:00 at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943445982+02:00 at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:240) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943447998+02:00 at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:697) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943450061+02:00 at org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.service(GrizzlyHttpContainer.java:367) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943452078+02:00 at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:190) [
nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943454158+02:00 at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:535) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943456149+02:00 at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:515) [nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943458586+02:00 at java.lang.Thread.run(Thread.java:829) [?:?]
2024-07-04T19:46:51.943460608+02:00 Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "tap_captures" violates foreign key constraint "link_freqs2captures" on table "tap_captures_frequencies"
2024-07-04T19:46:51.943462603+02:00   Detail: Key (uuid)=(667ba244-2c8d-4d0a-9539-8844ce23b2e9) is still referenced from table "tap_captures_frequencies".
2024-07-04T19:46:51.943464596+02:00 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943466568+02:00 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943468562+02:00 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943470612+02:00 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943472618+02:00 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943474693+02:00 at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943476702+02:00 at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943478829+02:00 at org.jdbi.v3.core.statement.SqlLoggerUtil.wrap(SqlLoggerUtil.java:32) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943484237+02:00 at org.jdbi.v3.core.
statement.SqlStatement.internalExecute(SqlStatement.java:1801) ~[nzyme-2.0.0-alpha.13.jar:?]
2024-07-04T19:46:51.943486393+02:00 ... 36 more