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