AnsweredAssumed Answered

MYSQL Database Schema auto-update failed

Question asked by andrehesel on Jul 25, 2015
Latest reply on Sep 30, 2015 by clementr
Hi All,

I'm new to Alfresco and Actually tried to run Alfresco Community
Using Maven SDK2.1 , it got SUCESS

But after i configured MYSQL using below tutorial
http://docs.alfresco.com/5.0/tasks/alfresco-sdk-tutorials-using-mysql-all-in-one.html

It shown connected to sql but FAILED TO UPDATE SCHEMA
It just generate two table in database
* alf_applied_patch
* alf_bootstrap_lock

Many thanks for the help

Regards
Andre Hesel
===============================================================================================================================
2015-07-25 20:35:57,779 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:mysql://localhost:3306/alfrescoaio, UserName=alfresco@localhost, MySQL Connector Java
2015-07-25 20:35:57,780 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.H2Dialect.
2015-07-25 20:35:58,041 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
   at com.mysql.jdbc.Util.getInstance(Util.java:383)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2769)
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:128)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:46)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:39)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:946)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1702)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at java.lang.Thread.run(Thread.java:745)
2015-07-25 20:35:58,048 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06250000 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1801)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
   at com.mysql.jdbc.Util.getInstance(Util.java:383)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2769)
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:128)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:46)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:39)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:946)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1702)
   … 19 more
2015-07-25 20:36:11,674 WARN  [org.springframework.web.context.support.XmlWebApplicationContext] [localhost-startStop-1] Exception thrown from ApplicationListener handling ContextClosedEvent
java.lang.NullPointerException
   at org.alfresco.repo.workflow.jbpm.JBPMScheduler.onShutdown(JBPMScheduler.java:69)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:67)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:185)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
   at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1049)
   at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1010)
   at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:586)
   at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:143)
   at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4980)
   at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5626)
   at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at java.lang.Thread.run(Thread.java:745)

Attachments

Outcomes