postgre und autosetup.validate.schema.enabled=true

[Matthias Dörr]

Hallo,

ich wollte ein paar nicht mehr verwendete Entitäten löschen bekomme aber eine Fehlermeldung „org.postgresql.util.PSQLException: FEHLER: Index »xie__ckpvz5nktzalartoqn7rhbcou« existiert nicht“.

Nun wollte ich die Constrains löschen und neu erstellen lassen mit „autosetup.validate.schema.enabled=true“ siehe wiki hidden features. Leider bekomme ich dabei die folgende Fehlermeldung 1 im log file. Nun dachte ich man könnte das AUTOCOMMIT vielleicht Serverseitig ausschalten, was aber seit postgres 7.3. nicht mehr geht. Somit denke ich das es sich um ein bug handelt ?!

Habe danach den Server nochmals neu gestartet, mit dem Ergebnis daß beim constrain remove 308 mal der Fehler 2 auftaucht (für die verscheidenen entitäten). Nuclos funktioniert danach soweit ich bisher beurteilen kann fehlerfrei.

Gruß, Matthias

Fehler 1:
[spoiler]2015-02-11 08:05:53,962 INFO [org.nuclos.server.autosync.AutoDbSetup] – Removing SYS constraints for autosetup.validate.schema.enabled finished successfully
2015-02-11 08:05:53,962 INFO [org.nuclos.common.SpringApplicationContextHolder] – Spring main context setSpringReady: 7
2015-02-11 08:05:54,040 INFO [org.nuclos.server.autosync.SchemaHelper] – schema validation round 1…
2015-02-11 08:06:43,494 INFO [org.nuclos.server.autosync.SchemaHelper] – schema validation finished!
2015-02-11 08:06:43,494 INFO [org.nuclos.common.SpringApplicationContextHolder] – Spring main context setSpringReady: 8
2015-02-11 08:06:43,525 INFO [org.nuclos.common.SpringApplicationContextHolder] – Spring main context setSpringReady: 9
2015-02-11 08:06:43,588 INFO [org.nuclos.common.SpringApplicationContextHolder] – Spring main context setSpringReady: 10
2015-02-11 08:06:43,697 ERROR [org.nuclos.server.spring.AutoDbSetupComplete] – recreate sys constraints after autosetup.validate.schema.enabled failed: Cannot commit when autoCommit is enabled.
org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:824)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.commit(DataSourceExecutor.java:387)
at org.nuclos.server.dblayer.PersistentDbAccess.commit(PersistentDbAccess.java:113)
at org.nuclos.server.autosync.AutoDbSetup.createSysConstraints(AutoDbSetup.java:549)
at org.nuclos.server.validation.DefaultSchemaValidation.createSysConstraints(DefaultSchemaValidation.java:72)
at org.nuclos.server.spring.AutoDbSetupComplete.afterAutoDbSetup(AutoDbSetupComplete.java:165)
at org.nuclos.server.web.NuclosContextLoaderListener$1.run(NuclosContextLoaderListener.java:116)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
2015-02-11 08:06:43,697 ERROR [org.nuclos.server.web.NuclosContextLoaderListener] – startup of heart beat server thread in timer task failed: org.nuclos.common.NuclosFatalException: recreate sys constraints after entity remove failed: Cannot commit when autoCommit is enabled.
org.nuclos.common.NuclosFatalException: recreate sys constraints after entity remove failed: Cannot commit when autoCommit is enabled.
at org.nuclos.server.spring.AutoDbSetupComplete.afterAutoDbSetup(AutoDbSetupComplete.java:168)
at org.nuclos.server.web.NuclosContextLoaderListener$1.run(NuclosContextLoaderListener.java:116)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:824)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.commit(DataSourceExecutor.java:387)
at org.nuclos.server.dblayer.PersistentDbAccess.commit(PersistentDbAccess.java:113)
at org.nuclos.server.autosync.AutoDbSetup.createSysConstraints(AutoDbSetup.java:549)
at org.nuclos.server.validation.DefaultSchemaValidation.createSysConstraints(DefaultSchemaValidation.java:72)
at org.nuclos.server.spring.AutoDbSetupComplete.afterAutoDbSetup(AutoDbSetupComplete.java:165)
… 3 more
[/spoiler]

Fehler 2:
[spoiler]2015-02-11 08:38:40,707 FATAL [org.nuclos.server.autosync.AutoDbSetup] – Error during Removing SYS constraints for autosetup.validate.schema.enabled #308: Drop foreign key constraint T_MD_JOBDBOBJECT.XR__4H2ZJ2CSSHKZ7B6X2CHJPY2BCU (STRUID_T_MD_JOBCONTROLLER) references T_MD_JOBCONTROLLER (STRUID): org.nuclos.server.dblayer.DbException: org.postgresql.util.PSQLException: FEHLER: Constraint ܸr__4h2zj2csshkz7b6x2chjpy2bcuˠvon Relation ܴ_md_jobdbobjectˠexistiert nicht
org.nuclos.server.dblayer.DbException: org.postgresql.util.PSQLException: FEHLER: Constraint ܸr__4h2zj2csshkz7b6x2chjpy2bcuˠvon Relation ܴ_md_jobdbobjectˠexistiert nicht
at org.nuclos.common.dal.DalCallResult.addDbException(DalCallResult.java:77)
at org.nuclos.server.dblayer.impl.SqlSequentialUnit.process(SqlSequentialUnit.java:62)
at org.nuclos.server.dblayer.impl.BatchImpl.process(BatchImpl.java:128)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeBatch(StandardSqlDBAccess.java:430)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitStructureChange(StandardSqlDBAccess.java:1181)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitStructureChange(StandardSqlDBAccess.java:1)
at org.nuclos.server.dblayer.statements.DbStructureChange.accept(DbStructureChange.java:108)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.execute(StandardSqlDBAccess.java:158)
at org.nuclos.server.dblayer.DbAccess.execute(DbAccess.java:212)
at org.nuclos.server.dblayer.PersistentDbAccess.execute_aroundBody2(PersistentDbAccess.java:50)
at org.nuclos.server.dblayer.PersistentDbAccess$AjcClosure3.run(PersistentDbAccess.java:1)
at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:59)
at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:65)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266)
at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:63)
at org.nuclos.server.dblayer.PersistentDbAccess.execute(PersistentDbAccess.java:49)
at org.nuclos.server.autosync.AutoDbSetup.executeSetupStatements(AutoDbSetup.java:722)
at org.nuclos.server.autosync.AutoDbSetup.executeSetupStatementsAndIgnoreErrors(AutoDbSetup.java:701)
at org.nuclos.server.autosync.AutoDbSetup.removeSysConstraints(AutoDbSetup.java:533)
at org.nuclos.server.validation.DefaultSchemaValidation.removeSysContraints(DefaultSchemaValidation.java:60)
at org.nuclos.server.spring.AutoDbSetupComplete.afterAutoDbSetup(AutoDbSetupComplete.java:159)
at org.nuclos.server.web.NuclosContextLoaderListener$1.run(NuclosContextLoaderListener.java:116)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Caused by: java.sql.SQLException: FEHLER: Constraint ܸr__4h2zj2csshkz7b6x2chjpy2bcuˠvon Relation ܴ_md_jobdbobjectˠexistiert nicht
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.nuclos.server.dblayer.impl.postgresql.PostgreSQLPreparedStringExecutor$1.performImpl(PostgreSQLPreparedStringExecutor.java:106)
at org.nuclos.server.dblayer.impl.postgresql.PostgreSQLPreparedStringExecutor$1.perform(PostgreSQLPreparedStringExecutor.java:82)
at org.nuclos.server.dblayer.impl.postgresql.PostgreSQLPreparedStringExecutor$1.perform(PostgreSQLPreparedStringExecutor.java:1)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:186)
at org.nuclos.server.dblayer.impl.postgresql.PostgreSQLPreparedStringExecutor.executePreparedStatement(PostgreSQLPreparedStringExecutor.java:68)
at org.nuclos.server.dblayer.impl.SqlSequentialUnit.process(SqlSequentialUnit.java:58)
… 22 more[/spoiler]

[Sebastian Süßdorf]

Hallo Matthias,
Wie hast Du Dein Problem damals gelöst?

Ich habe ähnliche Fehlermeldungen indem ich eine Datenbank eines Windowsrechner Psql 9.5 auf ein Debian Psql 10.7 geschoben habe. Der Nuclosserver läuft, der Client lässt sich nicht starten.
Muss ich die Datenbank irgendwie migrieren oder sollte sich die Datenbank auf 10.7 einfach wiederherstellen lassen?

VG. Sebastian

[Autor]

Beiträge