Hi Aparna, Shall we have a quick look at this in the QA set up?
Thanks! On Wed, Oct 7, 2015 at 3:04 PM, Isura Karunaratne <[email protected]> wrote: > Registry team, > > Do you have any input on this issue ? > > > Thanks > Isura > On Wed, Oct 7, 2015 at 12:55 PM, Aparna Karunarathna <[email protected]> > wrote: > >> Hi Isuru / Isuruwan, >> >> I was able to reproduce the issue now, that Table exists. >> >> ERROR {org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO} - Failed to >> update log batch records . Table 'is510reg.REG_LOG' doesn't exist >> java.sql.BatchUpdateException: Table 'is510reg.REG_LOG' doesn't exist >> at >> com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2056) >> at >> com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) >> 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 'is510reg.REG_LOG' doesn't exist >> 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:422) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >> at com.mysql.jdbc.Util.getInstance(Util.java:386) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) >> at >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460) >> at >> com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2008) >> ... 5 more >> [2015-10-07 07:21:51,665] ERROR >> {org.wso2.carbon.registry.core.utils.LogWriter} - Unable to save log >> records >> org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to >> update log batch records . Table 'is510reg.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 'is510reg.REG_LOG' >> doesn't exist >> at >> com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2056) >> at >> com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCLogsDAO.addLogRecords(JDBCLogsDAO.java:160) >> ... 3 more >> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >> Table 'is510reg.REG_LOG' doesn't exist >> 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:422) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >> at com.mysql.jdbc.Util.getInstance(Util.java:386) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) >> at >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460) >> at >> com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2008) >> ... 5 more >> >> >> Regards, >> Aparna. >> >> On Wed, Oct 7, 2015 at 11:48 AM, Aparna Karunarathna <[email protected]> >> wrote: >> >>> Hi Isuru, >>> >>> To troubleshoot the wso2.war deploying issue, I have dropped and created >>> databases several times. Since this is intermittent issue didn't try to >>> troubleshoot it much. We have reported this because we got the same issue >>> on two different databases(mssql 2012 & mysql 5.6.25 and OSs(Linux, >>> Windows). >>> >>> Regards, >>> Aparna >>> >>> On Wed, Oct 7, 2015 at 11:32 AM, Isura Karunaratne <[email protected]> >>> wrote: >>> >>>> Adding Aparna >>>> >>>> On Tue, Oct 6, 2015 at 10:41 PM, Isuruwan Herath <[email protected]> >>>> wrote: >>>> >>>>> Hi Isura, >>>>> >>>>> Is it possible to verify that in QA DB, REG_LOG table has been created >>>>> in *is510reg* database and access granted to the DB user which is >>>>> configured in IS node, to the same database? >>>>> >>>> @Aparna, >>>> Can you verify this? >>>> >>>> Thanks >>>> Isura >>>> >>>>> >>>>> Thanks, >>>>> Isuruwan >>>>> >>>>> On Tue, Oct 6, 2015 at 8:26 PM, Isura Karunaratne <[email protected]> >>>>> wrote: >>>>> >>>>>> >>>>>> Hi, >>>>>>> >>>>>>> QA reported [1] in IS5.1.0 alpha and we observed that the same error >>>>>>> was occurred in ESB [2] and APIM[3] products as well. They resolved >>>>>>> these >>>>>>> issues as "Cannot Reproduce" >>>>>>> >>>>>>> @Greg team >>>>>>> >>>>>>> We are also unable to reproduce the issue and what would be the >>>>>>> reason for occurring this issue in QA environment? >>>>>>> >>>>>>> >>>>>>> Thanks >>>>>>> Isura. >>>>>>> >>>>>>> >>>>>>> >>>>>>> [1] https://wso2.org/jira/browse/IDENTITY-3750 >>>>>>> [2] https://wso2.org/jira/browse/ESBJAVA-2539 >>>>>>> [3] https://wso2.org/jira/browse/APIMANAGER-2199 >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Isura Dilhara Karunaratne >>>>>>> Senior Software Engineer >>>>>>> >>>>>>> Mob +94 772 254 810 >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Isura Dilhara Karunaratne >>>>>> Senior Software Engineer >>>>>> >>>>>> Mob +94 772 254 810 >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Isuruwan Herath >>>>> Technical Lead >>>>> >>>>> Contact: +94 776 273 296 >>>>> >>>> >>>> >>>> >>>> -- >>>> Isura Dilhara Karunaratne >>>> Senior Software Engineer >>>> >>>> Mob +94 772 254 810 >>>> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> *Regards,* >>> >>> *Aparna Karunarathna.* >>> >>> >>> *Associate Technical Lead - QAWSO2 Inc.Mobile: 0714002533 <0714002533>* >>> >> >> >> >> -- >> *Regards,* >> >> *Aparna Karunarathna.* >> >> >> *Associate Technical Lead - QAWSO2 Inc.Mobile: 0714002533* >> > > > > -- > Isura Dilhara Karunaratne > Senior Software Engineer > > Mob +94 772 254 810 > > -- Isuruwan Herath Technical Lead Contact: +94 776 273 296
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
