<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Dear community!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US>I tried out to installing zanata with the zanata installer 3.6.0 for wildfly 8.1.0 on Oracle JDK 1.8.0_60-ea-b07. I followed the instructions on readthedocs. But I get the following exception while liquibase is applying the sql migration scripts:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,389Z ERROR [liquibase] (MSC service thread 1-4) db/db.changelog.xml: db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com: Change Set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com failed. Error: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm':<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>For testing I tried again giving all rights to the mysql user but without any change. Do you have any idea how to fix this?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Many thanks in advance!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Widura<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm'><p class=MsoNormal style='border:none;padding:0cm'><span lang=EN-US><o:p> </o:p></span></p></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Excerpt of the server log file:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>…<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:40:45,597Z INFO [org.jboss.modules] (main) JBoss Modules version 1.3.3.Final<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:40:46,190Z INFO [org.jboss.msc] (main) JBoss MSC version 1.2.2.Final<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:40:46,408Z INFO [org.jboss.as] (MSC service thread 1-6) JBAS015899: WildFly 8.1.0.Final "Kenny" starting<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:40:46,424Z DEBUG [org.jboss.as.config] (MSC service thread 1-6) Configured system properties:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> awt.toolkit = sun.awt.windows.WToolkit<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> file.encoding = Cp1252<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> file.encoding.pkg = sun.io<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> file.separator = \<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.awt.printerjob = sun.awt.windows.WPrinterJob<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.class.path = C:\zanata\zanata-3.6.0\jboss-modules.jar<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.class.version = 52.0<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.endorsed.dirs = C:\zanata\jdk1.8.0_60\jre\lib\endorsed<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.ext.dirs = C:\zanata\jdk1.8.0_60\jre\lib\ext;C:\Windows\Sun\Java\lib\ext<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.home = C:\zanata\jdk1.8.0_60\jre<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.io.tmpdir = C:\Users\ADMINI~1\AppData\Local\Temp\2\<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.library.path = C:\zanata\jdk1.8.0_60\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;%SystemRoot%\system32\WindowsPowerShell\v1.0\;C:\zanata\jdk1.8.0_60\bin;C:\PROGRA~2\PARALL~1\Plesk\ADDITI~1\Perl\site\bin;C:\PROGRA~2\PARALL~1\Plesk\ADDITI~1\Perl\bin;C:\Program Files (x86)\Parallels\Plesk\Mail Servers\Mail Enable\BIN;C:\Program Files (x86)\Parallels\Plesk\Additional\Python\Scripts;C:\Program Files (x86)\Parallels\Plesk\Additional\Python\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Parallels\Plesk\Mail Servers\Mail Enable\BIN64;c:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;;C:\Program Files\Boot2Docker for Windows;.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.net.preferIPv4Stack = true<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.runtime.name = Java(TM) SE Runtime Environment<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.runtime.version = 1.8.0_60-ea-b07<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.specification.name = Java Platform API Specification<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.specification.vendor = Oracle Corporation<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.specification.version = 1.8<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.util.logging.manager = org.jboss.logmanager.LogManager<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vendor = Oracle Corporation<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vendor.url = http://java.oracle.com/<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vendor.url.bug = http://bugreport.sun.com/bugreport/<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.version = 1.8.0_60-ea<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vm.info = mixed mode<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vm.name = Java HotSpot(TM) Client VM<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vm.specification.name = Java Virtual Machine Specification<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vm.specification.vendor = Oracle Corporation<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vm.specification.version = 1.8<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> java.vm.vendor = Oracle Corporation<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> </span>java.vm.version = 25.60-b07<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>…<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US>08:42:35,235Z INFO [liquibase] (MSC service thread 1-4) db/db.changelog.xml: db/changelogs/db.changelog-1.5.xml::7::aeng@redhat.com: Foreign key contraint added to HGlossaryEntry (srcLocaleId)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:35,687Z INFO [liquibase] (MSC service thread 1-4) db/db.changelog.xml: db/changelogs/db.changelog-1.5.xml::7::aeng@redhat.com: Columns sourceRef(longtext) added to HGlossaryEntry<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:35,687Z INFO [liquibase] (MSC service thread 1-4) db/db.changelog.xml: db/changelogs/db.changelog-1.5.xml::7::aeng@redhat.com: ChangeSet db/changelogs/db.changelog-1.5.xml::7::aeng@redhat.com ran successfully in 2387ms<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,311Z INFO [liquibase] (MSC service thread 1-4) db/db.changelog.xml: db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com: Column HGlossaryTerm.sourceRef dropped<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,389Z ERROR [liquibase] (MSC service thread 1-4) db/db.changelog.xml: db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com: Change Set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com failed. Error: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm': liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:103) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1513) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1496) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:40) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:64) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.Liquibase.update(Liquibase.java:137) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.integration.servlet.LiquibaseServletListener.executeUpdate(LiquibaseServletListener.java:220) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.integration.servlet.LiquibaseServletListener.contextInitialized(LiquibaseServletListener.java:102) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:173) [undertow-servlet-1.0.15.Final.jar:1.0.15.Final]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:190) [undertow-servlet-1.0.15.Final.jar:1.0.15.Final]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:87)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_60-ea]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_60-ea]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_60-ea]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Caused by: java.sql.SQLException: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2777)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:90) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:50) [liquibase-core-3.0.7.jar:]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> ... 18 more<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,452Z INFO [liquibase] (MSC service thread 1-4) db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com: Successfully released change log lock<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,467Z ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./zanata: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./zanata: Failed to start service<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1904) [jboss-msc-1.2.2.Final.jar:1.2.2.Final]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_60-ea]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_60-ea]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_60-ea]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Caused by: java.lang.RuntimeException: java.lang.RuntimeException: liquibase.exception.MigrationFailedException: Migration failed for change set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:219)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:87)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948) [jboss-msc-1.2.2.Final.jar:1.2.2.Final]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881) [jboss-msc-1.2.2.Final.jar:1.2.2.Final]<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> ... 3 more<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Caused by: java.lang.RuntimeException: liquibase.exception.MigrationFailedException: Migration failed for change set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.integration.servlet.LiquibaseServletListener.contextInitialized(LiquibaseServletListener.java:107)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:173)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:190)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> ... 7 more<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:376)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:40)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:64)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.Liquibase.update(Liquibase.java:137)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.integration.servlet.LiquibaseServletListener.executeUpdate(LiquibaseServletListener.java:220)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.integration.servlet.LiquibaseServletListener.contextInitialized(LiquibaseServletListener.java:102)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> ... 9 more<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:103)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1513)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1496)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> ... 14 more<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Caused by: java.sql.SQLException: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2777)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:90)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:50)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> ... 18 more<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,514Z ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("deploy") failed - address: ([("deployment" => "zanata.war")]) - failure description: {"JBAS014671: Failed services" => {"jboss.undertow.deployment.default-server.default-host./zanata" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./zanata: Failed to start service<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Caused by: java.lang.RuntimeException: java.lang.RuntimeException: liquibase.exception.MigrationFailedException: Migration failed for change set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Caused by: java.lang.RuntimeException: liquibase.exception.MigrationFailedException: Migration failed for change set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set db/changelogs/db.changelog-1.5.xml::8::aeng@redhat.com:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT AUTO_INCREMENT: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> Caused by: java.sql.SQLException: Cannot change column 'id': used in a foreign key constraint 'UKglossaryterm_glossary_entry_id' of table 'zanata.hglossaryterm'"}}<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,639Z INFO [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "zanata.war" (runtime-name : "zanata.war")<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,639Z INFO [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "mysql-connector-java.jar" (runtime-name : "mysql-connector-java.jar")<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,639Z INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>JBAS014777: Services which failed to start: service jboss.undertow.deployment.default-server.default-host./zanata: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./zanata: Failed to start service<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,795Z INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:10090/management<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,795Z INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:10090<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:36,795Z ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: WildFly 8.1.0.Final "Kenny" started (with errors) in 112009ms - Started 443 of 502 services (2 services failed or missing dependencies, 107 services are lazy, passive or on-demand)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:37,185Z INFO [org.hibernate.validator.internal.util.Version] (MSC service thread 1-6) HV000001: Hibernate Validator 5.1.0.Final<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:40,539Z INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015877: Stopped deployment zanata.war (runtime-name: zanata.war) in 3571ms<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:40,898Z INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018558: Undeployed "zanata.war" (runtime-name: "zanata.war")<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>08:42:40,898Z INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>JBAS014775: New missing/unsatisfied dependencies:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component.DeadLetterQueueReceiver.START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component.EjbSynchronizations.START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component.EmailQueueMessageReceiver.START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component.ExpiryQueueReceiver.START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component.TimerServiceDispatcher.START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."com.sun.faces.config.ConfigureListener".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."de.novanic.eventservice.service.EventServiceImpl".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."javax.faces.webapp.FacesServlet".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."javax.faces.webapp.FacetTag".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."javax.servlet.jsp.jstl.tlv.ScriptFreeTLV".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."liquibase.integration.servlet.LiquibaseServletListener".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."managed-bean.org.richfaces.VersionBean".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."managed-bean.org.richfaces.skin.SkinBean".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."net.bull.javamelody.MonitoringFilter".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."net.bull.javamelody.SessionListener".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.jboss.seam.servlet.SeamFilter".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.jboss.seam.servlet.SeamListener".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.jboss.seam.servlet.SeamResourceServlet".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.tuckey.web.filters.urlrewrite.UrlRewriteFilter".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.zanata.seam.interceptor.MonitoringWrapper".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.zanata.servlet.FileUploadServlet".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.zanata.servlet.GWTCacheControlFilter".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.zanata.servlet.LeakListener".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.zanata.servlet.MDCInsertingServletFilter".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.zanata.servlet.MultiFileUploadServlet".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.deployment.unit."zanata.war".component."org.zanata.webtrans.server.GwtDispatchService".START (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> service jboss.undertow.deployment.default-server.default-host./zanata (missing) dependents: [service jboss.deployment.unit."zanata.war".deploymentCompleteService] <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>JBAS014777: Services which failed to start: service jboss.undertow.deployment.default-server.default-host./zanata<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>…<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></body></html>