Hi Devs,
The following error log appear in IS 5.1.0, APIM 1.10.0 and ESB 4.9.0
distributed setups, configured with mysql data sources, when starting up
for the first time. This issue has been reported previously [2 - 4] as
well, but no proper resolution has been found. Any idea what might be
causing this?
[1].
[2016-04-27 05:48:28,070] ERROR - JDBCLogsDAO Failed to update log batch
records . Table 'APIM_DB.REG_LOG' doesn't exist
java.sql.BatchUpdateException: Table 'APIM_DB.REG_LOG' doesn't exist
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1809)
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1271)
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO.addLogRecords(JDBCLogsDAO.java:160)
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO.saveLogBatch(JDBCLogsDAO.java:124)
at
org.wso2.carbon.registry.core.utils.LogWriter.logWrite(LogWriter.java:106)
at org.wso2.carbon.registry.core.utils.LogWriter.run(LogWriter.java:91)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'APIM_DB.REG_LOG' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1767)
... 5 more
[2016-04-27 05:48:28,116] ERROR - LogWriter Unable to save log records
org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to
update log batch records . Table 'APIM_DB.REG_LOG' doesn't exist
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO.addLogRecords(JDBCLogsDAO.java:177)
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO.saveLogBatch(JDBCLogsDAO.java:124)
at
org.wso2.carbon.registry.core.utils.LogWriter.logWrite(LogWriter.java:106)
at org.wso2.carbon.registry.core.utils.LogWriter.run(LogWriter.java:91)
Caused by: java.sql.BatchUpdateException: Table 'APIM_DB.REG_LOG' doesn't
exist
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1809)
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1271)
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO.addLogRecords(JDBCLogsDAO.java:160)
... 3 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'APIM_DB.REG_LOG' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1767)
... 5 more
[2]. https://wso2.org/jira/browse/ESBJAVA-2539
[3]. https://wso2.org/jira/browse/IDENTITY-3750
[4]. https://wso2.org/jira/browse/APIMANAGER-2199
--
Thanks and Regards,
Isuru H.
+94 716 358 048* <http://wso2.com/>*
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
