Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
Sure, will have a quick look now.
Regards,
Aparna.
On Wed, Oct 7, 2015 at 3:14 PM, Isuruwan Herath 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 wrote:
>
>> Registry team,
>>
>> Do you have any input on this issue ?
>>
>>
>> Thanks
>> Isura
>> On Wed, Oct 7, 2015 at 12:55 PM, Aparna Karunarathna
>> 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
>>> wrote:
>>>
Hi Isuru,
To troubleshoot the wso2.war deployin
Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
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 wrote:
> Registry team,
>
> Do you have any input on this issue ?
>
>
> Thanks
> Isura
> On Wed, Oct 7, 2015 at 12:55 PM, Aparna Karunarathna
> 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
>> 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
Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
Registry team,
Do you have any input on this issue ?
Thanks
Isura
On Wed, Oct 7, 2015 at 12:55 PM, Aparna Karunarathna
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
> 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
>> wrote:
>>
>>> Adding Aparna
>>>
>>> On Tue, Oct 6, 2015 at 10:41 PM, Isuruwan Herath
>>> wrote:
>>>
Hi Isura,
Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
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
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 wrote:
>
>> Adding Aparna
>>
>> On Tue, Oct 6, 2015 at 10:41 PM, Isuruwan Herath
>> 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, I
Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
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 wrote: > Adding Aparna > > On Tue, Oct 6, 2015 at 10:41 PM, Isuruwan Herath > 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 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 > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Regards,* *Aparna Karunarathna.* *Associate Technical Lead - QAWSO2 Inc.Mobile: 0714002533* ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
Adding Aparna On Tue, Oct 6, 2015 at 10:41 PM, Isuruwan Herath 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 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 Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
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? Thanks, Isuruwan On Tue, Oct 6, 2015 at 8:26 PM, Isura Karunaratne 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 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Table 'is510reg.REG_LOG' doesn't exist" error was thrown when starting the server
> 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 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
