on 2020 Mar 31 6:09 AM
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)
Request clarification before answering.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.