Skip to content

Instantly share code, notes, and snippets.

@yorickvP
Created March 14, 2018 20:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yorickvP/9d6fba5d8168e988fb6a2911b0e2e303 to your computer and use it in GitHub Desktop.
Save yorickvP/9d6fba5d8168e988fb6a2911b0e2e303 to your computer and use it in GitHub Desktop.
Mar 14 20:57:57 wiki postgresql-start[635]: 2018-03-14 20:57:57.044 GMT [7545] ERROR: column t1.tgconstrname does not exist at character 113
Mar 14 20:57:57 wiki postgresql-start[635]: 2018-03-14 20:57:57.044 GMT [7545] STATEMENT: SELECT DISTINCT NULL::text as pnspname, NULL::text as fnspname, c1.relname as prelname, c2.relname as frelname, t1.tgconstrname, a.attnum as keyseq, ic.relname as fkeyname, t1.tgdeferrable, t1.tginitdeferred, t1.tgnargs,t1.tgargs, p1.proname as updaterule, p2.proname as deleterule FROM pg_class c1 JOIN pg_index i ON (c1.oid=i.indrelid) JOIN pg_class ic ON (i.indexrelid=ic.oid) JOIN pg_attribute a ON (ic.oid=a.attrelid), pg_class c2, pg_trigger t1 JOIN pg_proc p1 ON (t1.tgfoid=p1.oid), pg_trigger t2 JOIN pg_proc p2 ON (t2.tgfoid=p2.oid) WHERE (t1.tgrelid=c1.oid AND t1.tgisconstraint AND t1.tgconstrrelid=c2.oid AND p1.proname ~ '^RI_FKey_.*_upd$') AND (t2.tgrelid=c1.oid AND t2.tgisconstraint AND t2.tgconstrrelid=c2.oid AND p2.proname ~ '^RI_FKey_.*_del$') AND i.indisprimary AND c2.relname='activitystream_events'ORDER BY prelname,keyseq
Mar 14 20:57:57 wiki xwiki-start[7503]: 2018-03-14 20:57:57,047 [XWiki initialization] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 42703
Mar 14 20:57:57 wiki xwiki-start[7503]: 2018-03-14 20:57:57,048 [XWiki initialization] ERROR o.h.u.JDBCExceptionReporter - ERROR: column t1.tgconstrname does not exist
Mar 14 20:57:57 wiki xwiki-start[7503]: Position: 113
Mar 14 20:57:57 wiki xwiki-start[7503]: 2018-03-14 20:57:57,053 [XWiki initialization] ERROR .HibernateDataMigrationManager - Failed to migrate database [xwiki]...
Mar 14 20:57:57 wiki xwiki-start[7503]: com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:179)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:742)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:664)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:346)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:644)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:621)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:538)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:669)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:880)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1835)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1895)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1284)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1258)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1197)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1111)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.<init>(XWiki.java:1084)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.xwiki.job.AbstractJob.run(AbstractJob.java:189)
Mar 14 20:57:57 wiki xwiki-start[7503]: at java.lang.Thread.run(Thread.java:748)
Mar 14 20:57:57 wiki xwiki-start[7503]: Caused by: org.hibernate.HibernateException: Failed creating schema update script
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWikiHibernateBaseStore.java:404)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:301)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:194)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:175)
Mar 14 20:57:57 wiki xwiki-start[7503]: ... 23 common frames omitted
Mar 14 20:57:57 wiki xwiki-start[7503]: Caused by: org.hibernate.exception.SQLGrammarException: could not get table metadata: activitystream_events
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:128)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:1202)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWikiHibernateBaseStore.java:397)
Mar 14 20:57:57 wiki xwiki-start[7503]: ... 26 common frames omitted
Mar 14 20:57:57 wiki xwiki-start[7503]: Caused by: org.postgresql.util.PSQLException: ERROR: column t1.tgconstrname does not exist
Mar 14 20:57:57 wiki xwiki-start[7503]: Position: 113
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3558)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3751)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getImportedKeys(DelegatingDatabaseMetaData.java:312)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.tool.hbm2ddl.TableMetadata.initForeignKeys(TableMetadata.java:161)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:60)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:113)
Mar 14 20:57:57 wiki xwiki-start[7503]: ... 28 common frames omitted
Mar 14 20:57:57 wiki xwiki-start[7503]: 2018-03-14 20:57:57,066 [XWiki initialization] ERROR .HibernateDataMigrationManager - Main wiki database migration failed, it is not safe to continue!
Mar 14 20:57:57 wiki xwiki-start[7503]: 2018-03-14 20:57:57,067 [XWiki initialization] ERROR c.x.x.XWiki - Failed to initialize mandatory document
Mar 14 20:57:57 wiki xwiki-start[7503]: com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.WikiMacroParameterClass]
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1007)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1835)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1895)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1284)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1258)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1197)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1111)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.XWiki.<init>(XWiki.java:1084)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206)
Mar 14 20:57:57 wiki xwiki-start[7503]: at org.xwiki.job.AbstractJob.run(AbstractJob.java:189)
Mar 14 20:57:57 wiki xwiki-start[7503]: at java.lang.Thread.run(Thread.java:748)
Mar 14 20:57:57 wiki xwiki-start[7503]: Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:345)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:669)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:880)
Mar 14 20:57:57 wiki xwiki-start[7503]: ... 12 common frames omitted
Mar 14 20:57:57 wiki xwiki-start[7503]: Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Main wiki database migration failed, it is not safe to continue!
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:667)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:346)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:644)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:621)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:538)
Mar 14 20:57:57 wiki xwiki-start[7503]: at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)
Mar 14 20:57:57 wiki xwiki-start[7503]: ... 16 common frames omitted
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment