#27297 Fehler beim Initialisieren der Datenbank auf PostgreSQL und Oracle

Verbesserung

Wichtig

#26283

In-App konfigurierte globale Dialoge

#27261

Abkündigung: project-*, tl-perf, tl-export, tl-sync-demo-*, vw-pmt, tl-themes-glossy

Detail

#27264

Selektionskomponenten sollen ein-elementige Mengen nicht auspacken

#27267

ListModelBuilder soll in getModel(...) eine Collection zurückliefern

#27281

ApplicationTesting: Bessere Fehlermeldung bei nicht ausführbaren Kommandos

Fehlerbehebung

Wichtig

#27297

Fehler beim Initialisieren der Datenbank auf PostgreSQL und Oracle

Detail

#27256

MEInstanceTableModelBuilder.supportsListElement wirft NPE bei Wrapper.tType() == null

#27286

Dateifilter im Uploaddialog erlaubt Upload von anderen Dateien

#27288

Fehlende Dokumentation bei unvollständigem Workspace

Fehlerbehebung

Wichtig

#27297

Fehler beim Initialisieren der Datenbank auf PostgreSQL und Oracle

Oracle PostgreSQL

Wird mit PostgreSQL die Anwendung auf einer leeren Datenbank hochgefahren, bricht der Bootvorgang mit dem Fehler

2023-04-19T11:54:13,114 WARN  [main]: org.eclipse.jetty.webapp.WebAppContext - Failed startup of context o.e.j.w.WebAppContext@6a30e569{TL-Demo,/demo,[file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.demo/deploy/local/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.demo/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.reporting/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.doc/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.layout.formeditor/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.layout.wysiwyg.highlighter/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.layout.themeedit/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.layout.scripting.template/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.template/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.mail/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.addons.loginmessages/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.graph.diagramjs.server/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.graph.layouter/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.umljs/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/ext.com.google.fonts/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.graph.server/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.ajax.server/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.monitoring/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.themes.dezent/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.themes.modern/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.search.lucene/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.search.base/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.layout.icons/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.importer/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.office/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/ext.com.bootstrap.icons/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/ext.com.fontawesome/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.chart.chartjs/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/ext.org.chartjs/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.xio/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.service.openapi.server/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.service.openapi.client/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.service.openapi.common/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.model.wysiwyg/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.layout.wysiwyg/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/ext.com.ckeditor/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.model.search/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.reporting.flex/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.reporting.common/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.layout.codeedit/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/ext.io.c9.ace/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.contact/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.element/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.security.auth.pac4j/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/bos-settings/bos-deepl/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/bos-settings/bos-ldap/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.dob.persist/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.basic.db.schema/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.dsa/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.dob/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.basic.db/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.convert/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/com.top_logic.basic/src/main/webapp/, file:///home/dbu/Development/workspaces/CWS_1/git/tl-engine/ext.org.mozilla.pdfjs/src/main/webapp/, jar:file:///home/dbu/.m2/repository/org/webjars/highlightjs/11.5.0/highlightjs-11.5.0.jar!/META-INF/resources, jar:file:///home/dbu/.m2/repository/org/webjars/chartjs/4.1.2/chartjs-4.1.2.jar!/META-INF/resources, jar:file:///home/dbu/.m2/repository/org/webjars/npm/swagger-ui-dist/4.17.0/swagger-ui-dist-4.17.0.jar!/META-INF/resources, jar:file:///home/dbu/.m2/repository/org/webjars/jquery/3.6.3/jquery-3.6.3.jar!/META-INF/resources, jar:file:///home/dbu/.m2/repository/org/webjars/bower/fotorama/4.6.4/fotorama-4.6.4.jar!/META-INF/resources, jar:file:///home/dbu/.m2/repository/org/webjars/bower/jquery/3.6.3/jquery-3.6.3.jar!/META-INF/resources],UNAVAILABLE}
com.top_logic.knowledge.service.KnowledgeBaseException: Database operation failed.
	at com.top_logic.knowledge.service.db2.DefaultDBContext.commitTransaction(DefaultDBContext.java:846)
	at com.top_logic.knowledge.service.db2.TransactionImpl.internalCommit(TransactionImpl.java:162)
	at com.top_logic.knowledge.service.AbstractTransaction.commit(AbstractTransaction.java:71)
	at com.top_logic.util.AbstractStartStopListener.commitStartupChanges(AbstractStartStopListener.java:605)
	at com.top_logic.util.AbstractStartStopListener.startupModuleSystem(AbstractStartStopListener.java:590)
	....
	at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
	at org.eclipse.jetty.server.Server.doStart(Server.java:387)
	at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
	at com.top_logic.ide.jetty.Bootstrap.start(Bootstrap.java:196)
	at com.top_logic.ide.jetty.Bootstrap.run(Bootstrap.java:99)
	at com.top_logic.ide.jetty.Bootstrap.main(Bootstrap.java:72)
Caused by: java.sql.SQLException: Batch entry 0 INSERT INTO "I18NHTML_ATTRIBUTE_STORAGE" ("BRANCH","IDENTIFIER","REV_MAX","REV_MIN","REV_CREATE","OBJECT_TYPE","OBJECT_ID","META_ATTRIBUTE_ID","FILENAME","CONTENT_TYPE","DATA","HASH","LANG") VALUES (1, 4070, 9223372036854775807, 22, 22, 'tl.doc.Page', 4066, 1557, 'grafik_3.png', 'image/png', ?, 'c3eff513219993e6e5c2da5f7ed9649b2ad41d21', 'en') was aborted: ERROR: insufficient data left in message  Call getNextException to see other errors in the batch.: INSERT INTO "I18NHTML_ATTRIBUTE_STORAGE" ("BRANCH","IDENTIFIER","REV_MAX","REV_MIN","REV_CREATE","OBJECT_TYPE","OBJECT_ID","META_ATTRIBUTE_ID","FILENAME","CONTENT_TYPE","DATA","HASH","LANG") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	at com.top_logic.basic.sql.SQLH.enhanceMessage(SQLH.java:592)
	at com.top_logic.basic.db.sql.PrepStmtBasedCompiledStatement.enhanceMessage(PrepStmtBasedCompiledStatement.java:142)
	at com.top_logic.basic.db.sql.PrepStmtBasedCompiledStatement$1.executeBatch(PrepStmtBasedCompiledStatement.java:129)
	at com.top_logic.knowledge.service.db2.DefaultDBAccess.executeInsertBatch(DefaultDBAccess.java:403)
	at com.top_logic.knowledge.service.db2.DefaultDBAccess.insertAll(DefaultDBAccess.java:369)
	at com.top_logic.knowledge.service.db2.VersionedDBAccess.storeAll(VersionedDBAccess.java:502)
	at com.top_logic.knowledge.service.db2.VersionedDBAccess.insertAll(VersionedDBAccess.java:486)
	at com.top_logic.knowledge.service.db2.DefaultDBContext.commitNew(DefaultDBContext.java:522)
	at com.top_logic.knowledge.service.db2.DefaultDBContext.commitTransaction(DefaultDBContext.java:775)
	... 36 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "I18NHTML_ATTRIBUTE_STORAGE" ("BRANCH","IDENTIFIER","REV_MAX","REV_MIN","REV_CREATE","OBJECT_TYPE","OBJECT_ID","META_ATTRIBUTE_ID","FILENAME","CONTENT_TYPE","DATA","HASH","LANG") VALUES (1, 4070, 9223372036854775807, 22, 22, 'tl.doc.Page', 4066, 1557, 'grafik_3.png', 'image/png', ?, 'c3eff513219993e6e5c2da5f7ed9649b2ad41d21', 'en') was aborted: ERROR: insufficient data left in message  Call getNextException to see other errors in the batch.
	at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2367)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:560)
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:893)
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:916)
	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1684)
	at com.top_logic.basic.db.sql.AbstractStatementBatch.executeBatch(AbstractStatementBatch.java:44)
	at com.top_logic.basic.db.sql.PrepStmtBasedCompiledStatement$1.executeBatch(PrepStmtBasedCompiledStatement.java:127)
	... 42 more
Caused by: org.postgresql.util.PSQLException: ERROR: insufficient data left in message
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
	... 48 more

ab. Ein zweites Booten der Anwendung ist erfolgreich, allerdings sind dann keine Hilfeseiten vorhanden.

Das gleiche Problem tritt mit Oracle auf.

Test

test.com.top_logic.basic.sql.TestDBHelper#testBlobUnknownSize()