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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
