Dupliate Primary Key Error when searching for referencing objects
Created by: Henrik tom Wörden
The following query FIND RECORD Subsample WHICH IS REFERENCED BY Subsample WHICH IS REFERENCED BY 113
leads to the error
obe_creation.py:150: in find_subsample
parent_sample = db.execute_query(query)
../../../../../../../../caosdb-pylib/src/caosdb/common/models.py:3432: in execute_query
**kwargs)
../../../../../../../../caosdb-pylib/src/caosdb/common/models.py:3396: in execute
query_dict=query_dict, **kwargs)
../../../../../../../../caosdb-pylib/src/caosdb/connection/connection.py:450: in retrieve
http_response = self._http_request(method="GET", path=path, **kwargs)
../../../../../../../../caosdb-pylib/src/caosdb/connection/connection.py:530: in _http_request
**kwargs)
../../../../../../../../caosdb-pylib/src/caosdb/connection/connection.py:567: in _retry_http_request
_handle_response_status(http_response)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
http_response = <caosdb.connection.connection._WrappedHTTPResponse object at 0x7f0a7955b310>
def _handle_response_status(http_response):
status = http_response.status
if status == 200:
return
# emtpy response buffer
body = http_response.read()
if status == 401:
raise LoginFailedException(
"Request failed. The response returned with status "
"{}.".format(status))
elif status == 403:
raise AuthorizationException(
"Request failed. The response returned with status "
"{}.".format(status))
elif status == 404:
raise EntityDoesNotExistError("This entity does not exist.")
elif status in (413, 414):
raise URITooLongException(
"Request failed. The response returned with status "
"{}.".format(status))
elif 399 < status < 500:
raise ClientErrorException(msg=("Request failed. The response returned"
"with status {}.").format(status), status=status, body=body)
elif status > 499:
> raise ServerErrorException(body=body)
E caosdb.exceptions.ServerErrorException: An unexpected server error has occurred.
E
E SRID = 80c07b1386d40124d8410e18942fc813
E
E Please report this server error to and include the SRID into your report.
../../../../../../../../caosdb-pylib/src/caosdb/connection/connection.py:379: ServerErrorException
On server side the error looks like
caosdb-server_1 | caosdb.server.query.Query$QueryException: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '112-109' for key 'PRIMARY'
caosdb-server_1 | at caosdb.server.query.Backreference.apply(Backreference.java:152)
caosdb-server_1 | at caosdb.server.query.Query.sourceStrategy(Query.java:268)
caosdb-server_1 | at caosdb.server.query.Query.executeStrategy(Query.java:441)
caosdb-server_1 | at caosdb.server.query.Query.execute(Query.java:477)
caosdb-server_1 | at caosdb.server.jobs.core.ExecuteQuery.job(ExecuteQuery.java:43)
caosdb-server_1 | at caosdb.server.jobs.FlagJob.run(FlagJob.java:35)
caosdb-server_1 | at caosdb.server.jobs.ScheduledJob.run(Schedule.java:42)
caosdb-server_1 | at caosdb.server.jobs.Schedule.runJob(Schedule.java:122)
caosdb-server_1 | at caosdb.server.jobs.Schedule.runJobs(Schedule.java:104)
caosdb-server_1 | at caosdb.server.transaction.Transaction.execute(Transaction.java:126)
caosdb-server_1 | at caosdb.server.resource.transaction.EntityResource.httpGetInChildClass(EntityResource.java:113)
caosdb-server_1 | at caosdb.server.resource.AbstractCaosDBServerResource.httpGet(AbstractCaosDBServerResource.java:250)
caosdb-server_1 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
caosdb-server_1 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
caosdb-server_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
caosdb-server_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
caosdb-server_1 | at org.restlet.resource.ServerResource.doHandle(ServerResource.java:511)
caosdb-server_1 | at org.restlet.resource.ServerResource.get(ServerResource.java:723)
caosdb-server_1 | at org.restlet.resource.ServerResource.doHandle(ServerResource.java:603)
caosdb-server_1 | at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:662)
caosdb-server_1 | at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:348)
caosdb-server_1 | at org.restlet.resource.ServerResource.handle(ServerResource.java:1020)
caosdb-server_1 | at org.restlet.resource.Finder.handle(Finder.java:236)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at caosdb.server.CaosDBServer$2.handle(CaosDBServer.java:524)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at caosdb.server.CaosDBServer$3.handle(CaosDBServer.java:542)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
caosdb-server_1 | at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77)
caosdb-server_1 | at org.restlet.Application.handle(Application.java:385)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
caosdb-server_1 | at org.restlet.Component.handle(Component.java:408)
caosdb-server_1 | at caosdb.server.CaosDBComponent.handle(CaosDBServer.java:880)
caosdb-server_1 | at org.restlet.Server.handle(Server.java:507)
caosdb-server_1 | at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63)
caosdb-server_1 | at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143)
caosdb-server_1 | at org.restlet.ext.jetty.JettyServerHelper$WrappedServer.handle(JettyServerHelper.java:256)
caosdb-server_1 | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
caosdb-server_1 | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
caosdb-server_1 | at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
caosdb-server_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
caosdb-server_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
caosdb-server_1 | at java.base/java.lang.Thread.run(Thread.java:834)
caosdb-server_1 | Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '112-109' for key 'PRIMARY'
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:533)
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
caosdb-server_1 | at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
caosdb-server_1 | at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826)
caosdb-server_1 | at com.mysql.cj.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1923)
caosdb-server_1 | at com.mysql.cj.jdbc.CallableStatement.executeQuery(CallableStatement.java:839)
caosdb-server_1 | at snaq.db.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:144)
caosdb-server_1 | at caosdb.server.query.Backreference.executeStmt(Backreference.java:205)
caosdb-server_1 | at caosdb.server.query.Backreference.apply(Backreference.java:149)
caosdb-server_1 | ... 74 more
caosdb-server_1 | UNKNOWN ERROR
caosdb-server_1 |
caosdb-server_1 | caosdb.server.query.Query$QueryException: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '112-109' for key 'PRIMARY'
caosdb-server_1 | at caosdb.server.query.Backreference.apply(Backreference.java:152)
caosdb-server_1 | at caosdb.server.query.Query.sourceStrategy(Query.java:268)
caosdb-server_1 | at caosdb.server.query.Query.executeStrategy(Query.java:441)
caosdb-server_1 | at caosdb.server.query.Query.execute(Query.java:477)
caosdb-server_1 | at caosdb.server.jobs.core.ExecuteQuery.job(ExecuteQuery.java:43)
caosdb-server_1 | at caosdb.server.jobs.FlagJob.run(FlagJob.java:35)
caosdb-server_1 | at caosdb.server.jobs.ScheduledJob.run(Schedule.java:42)
caosdb-server_1 | at caosdb.server.jobs.Schedule.runJob(Schedule.java:122)
caosdb-server_1 | at caosdb.server.jobs.Schedule.runJobs(Schedule.java:104)
caosdb-server_1 | at caosdb.server.transaction.Transaction.execute(Transaction.java:126)
caosdb-server_1 | at caosdb.server.resource.transaction.EntityResource.httpGetInChildClass(EntityResource.java:113)
caosdb-server_1 | at caosdb.server.resource.AbstractCaosDBServerResource.httpGet(AbstractCaosDBServerResource.java:250)
caosdb-server_1 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
caosdb-server_1 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
caosdb-server_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
caosdb-server_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
caosdb-server_1 | at org.restlet.resource.ServerResource.doHandle(ServerResource.java:511)
caosdb-server_1 | at org.restlet.resource.ServerResource.get(ServerResource.java:723)
caosdb-server_1 | at org.restlet.resource.ServerResource.doHandle(ServerResource.java:603)
caosdb-server_1 | at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:662)
caosdb-server_1 | at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:348)
caosdb-server_1 | at org.restlet.resource.ServerResource.handle(ServerResource.java:1020)
caosdb-server_1 | at org.restlet.resource.Finder.handle(Finder.java:236)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at caosdb.server.CaosDBServer$2.handle(CaosDBServer.java:524)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at caosdb.server.CaosDBServer$3.handle(CaosDBServer.java:542)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
caosdb-server_1 | at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77)
caosdb-server_1 | at org.restlet.Application.handle(Application.java:385)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422)
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150)
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197)
caosdb-server_1 | at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
caosdb-server_1 | at org.restlet.Component.handle(Component.java:408)
caosdb-server_1 | at caosdb.server.CaosDBComponent.handle(CaosDBServer.java:880)
caosdb-server_1 | at org.restlet.Server.handle(Server.java:507)
caosdb-server_1 | at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63)
caosdb-server_1 | at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143)
caosdb-server_1 | at org.restlet.ext.jetty.JettyServerHelper$WrappedServer.handle(JettyServerHelper.java:256)
caosdb-server_1 | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
caosdb-server_1 | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
caosdb-server_1 | at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
caosdb-server_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
caosdb-server_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
caosdb-server_1 | at java.base/java.lang.Thread.run(Thread.java:834)
caosdb-server_1 | Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '112-109' for key 'PRIMARY'
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:533)
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
caosdb-server_1 | at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
caosdb-server_1 | at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826)
caosdb-server_1 | at com.mysql.cj.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1923)
caosdb-server_1 | at com.mysql.cj.jdbc.CallableStatement.executeQuery(CallableStatement.java:839)
caosdb-server_1 | at snaq.db.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:144)
caosdb-server_1 | at caosdb.server.query.Backreference.executeStmt(Backreference.java:205)
caosdb-server_1 | at caosdb.server.query.Backreference.apply(Backreference.java:149)
caosdb-server_1 | ... 74 more
caosdb-server_1 | 2019-10-10 06:40:28 10.3.128.1 - 10.3.128.3 10443 GET /Entity query=FIND%20RECORD%20Subsample%20%20WHICH%20IS%20REFERENCED%20BY%20Subsample%20%20WHICH%20IS%20REFERENCED%20BY%20113 500 -0 129 https://localhost:10443 - -
caosdb-server_1 | 06:40:28.569 [qtp638695843-26] ERROR REQUEST_ERRORS_LOGGER - SRID: 80c07b1386d40124d8410e18942fc813
caosdb-server_1 | REQUEST: GET https://localhost:10443/Entity?query=FIND%20RECORD%20Subsample%20%20WHICH%20IS%20REFERENCED%20BY%20Subsample%20%20WHICH%20IS%20REFERENCED%20BY%20113 HTTPS/1.1
caosdb-server_1 | REQUEST HEADERS: [Cookie: SessionToken=["PAM","admin",1570689628377,600000,"97ac2ddd-406a-43d5-a45f-3a2613236f48","c0933c7243fe5a8ce7d5eae86877aa1e44e33ba7346b1304c1021d106fdf4550e539055188eeb48aad0bffe95f77702653c4241a53054cfa7336542d7ef77a5d"];][Host: localhost:10443][Accept-Encoding: identity]
caosdb-server_1 | RESPONSE: HTTPS/1.1 - Internal Server Error (500) - The server encountered an unexpected condition which prevented it from fulfilling the request
caosdb-server_1 | RESPONSE ENTITY:<?xml version="1.0" encoding="UTF-8"?>
caosdb-server_1 | <?xml-stylesheet type="text/xsl" href="https://localhost:10443/webinterface/webcaosdb.xsl" ?>
caosdb-server_1 | <Response username="admin" realm="PAM" srid="80c07b1386d40124d8410e18942fc813" timestamp="1570689628435" baseuri="https://localhost:10443">
caosdb-server_1 | <UserInfo username="admin" realm="PAM">
caosdb-server_1 | <Roles>
caosdb-server_1 | <Role>administration</Role>
caosdb-server_1 | </Roles>
caosdb-server_1 | </UserInfo>
caosdb-server_1 | <Error code="500" description="An unexpected server error has occurred.">SRID = 80c07b1386d40124d8410e18942fc813
caosdb-server_1 |
caosdb-server_1 | Please report this server error to and include the SRID into your report.</Error>
caosdb-server_1 | </Response>
caosdb-server_1 |
caosdb-server_1 | caosdb.server.query.Query$QueryException: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '112-109' for key 'PRIMARY'
caosdb-server_1 | at caosdb.server.query.Backreference.apply(Backreference.java:152) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.query.Query.sourceStrategy(Query.java:268) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.query.Query.executeStrategy(Query.java:441) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.query.Query.execute(Query.java:477) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.jobs.core.ExecuteQuery.job(ExecuteQuery.java:43) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.jobs.FlagJob.run(FlagJob.java:35) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.jobs.ScheduledJob.run(Schedule.java:42) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.jobs.Schedule.runJob(Schedule.java:122) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.jobs.Schedule.runJobs(Schedule.java:104) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.transaction.Transaction.execute(Transaction.java:126) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.resource.transaction.EntityResource.httpGetInChildClass(EntityResource.java:113) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.resource.AbstractCaosDBServerResource.httpGet(AbstractCaosDBServerResource.java:250) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
caosdb-server_1 | at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
caosdb-server_1 | at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
caosdb-server_1 | at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
caosdb-server_1 | at org.restlet.resource.ServerResource.doHandle(ServerResource.java:511) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.resource.ServerResource.get(ServerResource.java:723) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.resource.ServerResource.doHandle(ServerResource.java:603) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:662) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:348) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.resource.ServerResource.handle(ServerResource.java:1020) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.resource.Finder.handle(Finder.java:236) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.CaosDBServer$2.handle(CaosDBServer.java:524) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.CaosDBServer$3.handle(CaosDBServer.java:542) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.Application.handle(Application.java:385) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.doHandle(Router.java:422) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Router.handle(Router.java:641) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.doHandle(Filter.java:150) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.routing.Filter.handle(Filter.java:197) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.Component.handle(Component.java:408) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.CaosDBComponent.handle(CaosDBServer.java:880) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.Server.handle(Server.java:507) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.restlet.ext.jetty.JettyServerHelper$WrappedServer.handle(JettyServerHelper.java:256) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) [caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at java.lang.Thread.run(Thread.java:834) [?:?]
caosdb-server_1 | Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '112-109' for key 'PRIMARY'
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:533) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at com.mysql.cj.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1923) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at com.mysql.cj.jdbc.CallableStatement.executeQuery(CallableStatement.java:839) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at snaq.db.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:144) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.query.Backreference.executeStmt(Backreference.java:205) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
caosdb-server_1 | at caosdb.server.query.Backreference.apply(Backreference.java:149) ~[caosdb-server-0.1-SNAPSHOT-jar-with-dependencies.jar:?]
Imported comments:
By Henrik tom Wörden on 2019-11-20T12:34:24.803Z
closed