cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

hybris 1811 server start up throw error code [0]; Column 'Collation' not found.

liu_chun_yin
Explorer
0 Likes
376

Hi,
I am configing hybris 1811 to use proxysql https://www.proxysql.com/,
During server start, HybrisStorefrontContextLoaderListener throw below.
Anyone can help ?
When directly connect jdbc with same config, everything work fine that server can start up.

INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 | org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [S0022]; error code [0]; Column 'Collation' not found.; nested exception is java.sql.SQLException: Column 'Collation' not found.
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:360)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.bootstrap.ddl.tools.persistenceinfo.PersistenceInformation.getDeploymentColumnNames(PersistenceInformation.java:136)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.bootstrap.ddl.tools.AbstractStrategy.containsColumn(CreateTypeSystemNameColumnInYDeploymentsTable.java:97)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.bootstrap.ddl.tools.AbstractStrategy.getStatementsToExecute(CreateTypeSystemNameColumnInYDeploymentsTable.java:88)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.bootstrap.ddl.tools.CreateTypeSystemNameColumnInYDeploymentsTable.getStatementsToExecute(CreateTypeSystemNameColumnInYDeploymentsTable.java:40)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.bootstrap.ddl.tools.TypeSystemHelper.assureTypeSystemStructureIsUpToDate(TypeSystemHelper.java:122)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.AbstractTenant.assureTypeSystemStructureIsUpToDate(AbstractTenant.java:843)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.AbstractTenant.doStartupSafe(AbstractTenant.java:750)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.AbstractTenant.doStartUp(AbstractTenant.java:698)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.Registry.assureTenantStarted(Registry.java:658)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.Registry.activateTenant(Registry.java:719)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.Registry.setCurrentTenant(Registry.java:566)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.Registry.activateMasterTenant(Registry.java:626)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.Registry.startup(Registry.java:444)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.core.ClassLoaderUtils.executeWithWebClassLoaderParentIfNeeded(ClassLoaderUtils.java:42)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.spring.HybrisContextLoaderListener.startRegistry(HybrisContextLoaderListener.java:325)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.spring.HybrisContextLoaderListener.doInitWebApplicationContext(HybrisContextLoaderListener.java:211)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.spring.HybrisContextLoaderListener.initWebApplicationContext(HybrisContextLoaderListener.java:199)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at de.hybris.platform.spring.HybrisContextLoaderListener.contextInitialized(HybrisContextLoaderListener.java:95)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1421)

INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1411)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at java.lang.Thread.run(Thread.java:748)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 | Caused by: java.sql.SQLException: Column 'Collation' not found.
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1069)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5166)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.509 |         at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2465)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.510 |         at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2340)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.510 |         at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.510 |         at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2338)
INFO   | jvm 1    | main    | 2020/03/31 10:32:42.510 |         at de.hybris.bootstrap.ddl.tools.persistenceinfo.PersistenceInformation$1.doInConnection(PersistenceInformation.java:155)

Accepted Solutions (0)

Answers (0)