#27297 Error initializing the database on PostgreSQL and Oracle

enhancement

major

#26283
In-app configured global dialogs
minor

#27261
discontinuation: project-*, tl-perf, tl-export, tl-sync-demo-*, vw-pmt, tl-themes-glossy
#27264
Selection components should not unpack one-element sets
#27267
ListModelBuilder shall return a collection in getModel(...).
#27281
ApplicationTesting: Better error message for non-executable commands
defect

major

#27297
Error initializing the database on PostgreSQL and Oracle
minor

#27256
MEInstanceTableModelBuilder.supportsListElement throws NPE if wrapper.tType() == null
#27286
File filter in upload dialog allows upload of other files
#27288
Missing documentation with incomplete workspace
defect
major

#27297

Error initializing the database on PostgreSQL and Oracle

Database
If the application is started with PostgreSQL on an empty database, the boot process fails with the error
2023-04-19T11:54:13,114 WARN  [main]: org.eclipse.jetty.webapp.WebAppContext - Failed to start 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
. A second boot of the application is successful, but then no help pages are available.
The same problem occurs with Oracle.
Test

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