Unknown Server Error when inserting an Entity

load dumpcaosroot.2023-10-19T17511697730708.tar.gz

caosdb.2023-10-19T15_51_48.778771417+00_00.dump.sql

Execute the following:

pers = db.Record()
pers.add_parent("Person")
pers.add_property("lastname", "Wood")
pers.add_property("firstname", "Tom")
pers.insert()

SERVER: dev (caosdb-server@c0e43851) PYLIB: dev (6e20e12d) MYSQLBACKEND: dev (65f34f84) WEBUI: dev (347eee83) ADVANCEDUSERTOOLS: dev (058b7678)

	15:52:29	127.0.0.1	-	127.0.0.1	10443	HEAD	/Entities	-	401	0	0	1	https://localhost:10443	curl/7.74.0	-
linkahead        | java.lang.NullPointerException: Replacement was null
linkahead        | 	at org.caosdb.server.database.backend.implementation.MySQL.DatabaseUtils.replace(DatabaseUtils.java:352)
linkahead        | 	at org.caosdb.server.database.backend.implementation.MySQL.DatabaseUtils.transformToDeepPropertyTree(DatabaseUtils.java:326)
linkahead        | 	at org.caosdb.server.database.backend.implementation.MySQL.MySQLRetrieveProperties.execute(MySQLRetrieveProperties.java:70)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveProperties.executeNoCache(RetrieveProperties.java:67)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveProperties.executeNoCache(RetrieveProperties.java:40)
linkahead        | 	at org.caosdb.server.database.CacheableBackendTransaction.execute(CacheableBackendTransaction.java:62)
linkahead        | 	at org.caosdb.server.database.CacheableBackendTransaction.execute(CacheableBackendTransaction.java:45)
linkahead        | 	at org.caosdb.server.database.BackendTransaction.execute(BackendTransaction.java:248)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveFullEntityTransaction.retrieveFullEntity(RetrieveFullEntityTransaction.java:121)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveFullEntityTransaction.retrieveFullEntitiesInContainer(RetrieveFullEntityTransaction.java:89)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveFullEntityTransaction.execute(RetrieveFullEntityTransaction.java:77)
linkahead        | 	at org.caosdb.server.database.BackendTransaction.executeTransaction(BackendTransaction.java:162)
linkahead        | 	at org.caosdb.server.transaction.TransactionInterface.execute(TransactionInterface.java:49)
linkahead        | 	at org.caosdb.server.transaction.Retrieve.retrieveFullEntities(Retrieve.java:117)
linkahead        | 	at org.caosdb.server.transaction.Retrieve.transaction(Retrieve.java:112)
linkahead        | 	at org.caosdb.server.transaction.Transaction.execute(Transaction.java:285)
linkahead        | 	at org.caosdb.server.resource.transaction.RetrieveEntityResource.httpGetInChildClass(RetrieveEntityResource.java:83)
linkahead        | 	at org.caosdb.server.resource.AbstractCaosDBServerResource.httpGet(AbstractCaosDBServerResource.java:239)
linkahead        | 	at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
linkahead        | 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
linkahead        | 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
linkahead        | 	at org.restlet.resource.ServerResource.doHandle(ServerResource.java:511)
linkahead        | 	at org.restlet.resource.ServerResource.get(ServerResource.java:723)
linkahead        | 	at org.restlet.resource.ServerResource.doHandle(ServerResource.java:603)
linkahead        | 	at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:662)
linkahead        | 	at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:348)
linkahead        | 	at org.restlet.resource.ServerResource.handle(ServerResource.java:1020)
linkahead        | 	at org.restlet.resource.Finder.handle(Finder.java:236)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.caosdb.server.CaosDBServer$2.handle(CaosDBServer.java:590)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.caosdb.server.CaosDBServer$3.handle(CaosDBServer.java:608)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
linkahead        | 	at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77)
linkahead        | 	at org.restlet.Application.handle(Application.java:385)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
linkahead        | 	at org.restlet.Component.handle(Component.java:408)
linkahead        | 	at org.caosdb.server.CaosDBComponent.handle(CaosDBServer.java:938)
linkahead        | 	at org.restlet.Server.handle(Server.java:507)
linkahead        | 	at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63)
linkahead        | 	at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143)
linkahead        | 	at org.restlet.ext.jetty.JettyServerHelper$WrappedServer.handle(JettyServerHelper.java:237)
linkahead        | 	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
linkahead        | 	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
linkahead        | 	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
linkahead        | 	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
linkahead        | 	at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
linkahead        | 	at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
linkahead        | 	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
linkahead        | 	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
linkahead        | 	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
linkahead        | 	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:762)
linkahead        | 	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:680)
linkahead        | 	at java.base/java.lang.Thread.run(Thread.java:829)
linkahead        | UNKNOWN ERROR
linkahead        | 
linkahead        | java.lang.NullPointerException: Replacement was null
linkahead        | 	at org.caosdb.server.database.backend.implementation.MySQL.DatabaseUtils.replace(DatabaseUtils.java:352)
linkahead        | 	at org.caosdb.server.database.backend.implementation.MySQL.DatabaseUtils.transformToDeepPropertyTree(DatabaseUtils.java:326)
linkahead        | 	at org.caosdb.server.database.backend.implementation.MySQL.MySQLRetrieveProperties.execute(MySQLRetrieveProperties.java:70)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveProperties.executeNoCache(RetrieveProperties.java:67)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveProperties.executeNoCache(RetrieveProperties.java:40)
linkahead        | 	at org.caosdb.server.database.CacheableBackendTransaction.execute(CacheableBackendTransaction.java:62)
linkahead        | 	at org.caosdb.server.database.CacheableBackendTransaction.execute(CacheableBackendTransaction.java:45)
linkahead        | 	at org.caosdb.server.database.BackendTransaction.execute(BackendTransaction.java:248)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveFullEntityTransaction.retrieveFullEntity(RetrieveFullEntityTransaction.java:121)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveFullEntityTransaction.retrieveFullEntitiesInContainer(RetrieveFullEntityTransaction.java:89)
linkahead        | 	at org.caosdb.server.database.backend.transaction.RetrieveFullEntityTransaction.execute(RetrieveFullEntityTransaction.java:77)
linkahead        | 	at org.caosdb.server.database.BackendTransaction.executeTransaction(BackendTransaction.java:162)
linkahead        | 	at org.caosdb.server.transaction.TransactionInterface.execute(TransactionInterface.java:49)
linkahead        | 	at org.caosdb.server.transaction.Retrieve.retrieveFullEntities(Retrieve.java:117)
linkahead        | 	at org.caosdb.server.transaction.Retrieve.transaction(Retrieve.java:112)
linkahead        | 	at org.caosdb.server.transaction.Transaction.execute(Transaction.java:285)
linkahead        | 	at org.caosdb.server.resource.transaction.RetrieveEntityResource.httpGetInChildClass(RetrieveEntityResource.java:83)
linkahead        | 	at org.caosdb.server.resource.AbstractCaosDBServerResource.httpGet(AbstractCaosDBServerResource.java:239)
linkahead        | 	at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
linkahead        | 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
linkahead        | 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
linkahead        | 	at org.restlet.resource.ServerResource.doHandle(ServerResource.java:511)
linkahead        | 	at org.restlet.resource.ServerResource.get(ServerResource.java:723)
linkahead        | 	at org.restlet.resource.ServerResource.doHandle(ServerResource.java:603)
linkahead        | 	at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:662)
linkahead        | 	at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:348)
linkahead        | 	at org.restlet.resource.ServerResource.handle(ServerResource.java:1020)
linkahead        | 	at org.restlet.resource.Finder.handle(Finder.java:236)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.caosdb.server.CaosDBServer$2.handle(CaosDBServer.java:590)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.caosdb.server.CaosDBServer$3.handle(CaosDBServer.java:608)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
linkahead        | 	at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77)
linkahead        | 	at org.restlet.Application.handle(Application.java:385)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Router.doHandle(Router.java:422)
linkahead        | 	at org.restlet.routing.Router.handle(Router.java:641)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.routing.Filter.doHandle(Filter.java:150)
linkahead        | 	at org.restlet.routing.Filter.handle(Filter.java:197)
linkahead        | 	at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
linkahead        | 	at org.restlet.Component.handle(Component.java:408)
linkahead        | 	at org.caosdb.server.CaosDBComponent.handle(CaosDBServer.java:938)
linkahead        | 	at org.restlet.Server.handle(Server.java:507)
linkahead        | 	at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63)
linkahead        | 	at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143)
linkahead        | 	at org.restlet.ext.jetty.JettyServerHelper$WrappedServer.handle(JettyServerHelper.java:237)
linkahead        | 	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
linkahead        | 	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
linkahead        | 	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
linkahead        | 	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
linkahead        | 	at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
linkahead        | 	at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
linkahead        | 	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
linkahead        | 	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
linkahead        | 	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
linkahead        | 	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
linkahead        | 	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:762)
linkahead        | 	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:680)
linkahead        | 	at java.base/java.lang.Thread.run(Thread.java:829)

DoD

• review and merge !21 (merged)
• review and merge caosdb-server!107 (merged)