Sure, will have a quick look now. Regards, Aparna.
On Wed, Oct 7, 2015 at 3:14 PM, Isuruwan Herath <[email protected]> wrote: > 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 <0714002533>* >>> >> >> >> >> -- >> Isura Dilhara Karunaratne >> Senior Software Engineer >> >> Mob +94 772 254 810 >> >> > > > -- > Isuruwan Herath > Technical Lead > > Contact: +94 776 273 296 > -- *Regards,* *Aparna Karunarathna.* *Associate Technical Lead - QAWSO2 Inc.Mobile: 0714002533*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
