liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE xwikidates ALTER COLUMN XWS_ID BIGINT: is referenced by FOREIGN KEY constraint: PUBLIC.FKDEAEAB5D3433FD87 in statement [ALTER TABLE xwikidates ALTER COLUMN XWS_ID BIGINT]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via XWiki.org JIRA by Sorin Burjan, 1 year ago
Error executing SQL ALTER TABLE xwikidates ALTER COLUMN XWS_ID BIGINT: is referenced by FOREIGN KEY constraint: PUBLIC.FKDEAEAB5D3433FD87 in statement [ALTER TABLE xwikidates ALTER COLUMN XWS_ID BIGINT]
via Atlassian JIRA by Gurleen Anand [Atlassian], 1 year ago
Error executing SQL ALTER TABLE `stash`.`stash_user` ADD CONSTRAINT `uq_stash_user_slug` UNIQUE (`slug`): Specified key was too long; max key length is 767 bytes
via Atlassian JIRA by Gurleen Anand [Atlassian], 1 year ago
Error executing SQL ALTER TABLE `stash`.`stash_user` ADD CONSTRAINT `uq_stash_user_slug` UNIQUE (`slug`): Specified key was too long; max key length is 767 bytes
via GitHub by lbesnard
, 7 months ago
Error executing SQL DROP VIEW IF EXISTS profile_summary CASCADE: ERROR: deadlock detected Detail: Process 23694 waits for AccessExclusiveLock on relation 49097486 of database 16415; blocked by process 23825. Process 23825 waits for AccessShareLock on relation 49097476 of database 16415; blocked by process 23694. Hint: See server log for query details.
via JIRA by Ross Attrill, 1 year ago
Error executing SQL CREATE TABLE ACTION (ACTION_ID INTEGER CONSTRAINT ACTION_PK PRIMARY KEY AUTOINCREMENT AUTOINCREMENT NOT NULL, ACTION TEXT NOT NULL, ACTION_SOURCE_CODE TEXT NOT NULL): [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE xwikidates ALTER COLUMN XWS_ID BIGINT: is referenced by FOREIGN KEY constraint: PUBLIC.FKDEAEAB5D3433FD87 in statement [ALTER TABLE xwikidates ALTER COLUMN XWS_ID BIGINT]
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.Table.checkColumnInFKConstraint(Unknown Source)
at org.hsqldb.TableWorks.retypeColumn(Unknown Source)
at org.hsqldb.StatementSchema.getResult(Unknown Source)
at org.hsqldb.StatementSchema.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:113)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$4.doInHibernate(HibernateDataMigrationManager.java:245)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1206)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1245)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.invokeLiquibase(HibernateDataMigrationManager.java:224)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:177)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsForDatabase(AbstractDataMigrationManager.java:510)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:458)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:296)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:386)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:664)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:811)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:744)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:726)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1430)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1473)
at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2207)
at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2239)
at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.loadPreferences(XWikiMacrosMappingRenderer.java:107)
at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.(XWikiMacrosMappingRenderer.java:83)
at com.xpn.xwiki.render.DefaultXWikiRenderingEngine.(DefaultXWikiRenderingEngine.java:72)
at com.xpn.xwiki.XWiki.resetRenderingEngine(XWiki.java:1106)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:786)
at com.xpn.xwiki.XWiki.(XWiki.java:734)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:395)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:482)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538)
at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)
at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66)
at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:476)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:346)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1048)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
at java.lang.Thread.run(Thread.java:679)

Users with the same issue

226 times, 3 months ago
749 times, 10 months ago
7 times, 11 months ago
Once, 2 weeks ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
94 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.