com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • There is an intermittent issue with the TestDrive-ResetDatabase Jenkins Job. (As of 9/9/13, the problem has occurred twice since KFS 5.0.2 was deployed in the Test Drive environment in late June 2013, once on 7/8/13 and once on 9/8/13). After the Job runs, the Test Drive environment fails to come back up. The root cause appears to be a problem when applying the kfs-parameter-group to the new db instance the job creates and then restarting the db instance for the new parameters to take effect. This is the error message from the log: {noformat} 2013-09-09 04:01:40,291 [main] u:/d: INFO org.kuali.rice.ksb.messaging.config.KSBConfigurer :: Synchronizing remote services with service bus after KSB startup... 2013-09-09 04:01:40,347 [main] u:/d: INFO BOOT :: PersistencebrokerFactory class instantiated: org.apache.ojb.broker.core.PersistenceBrokerFactorySyncImpl@51cfc277 2013-09-09 04:01:40,947 [main] u:/d: ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl :: * SQLException during execution of sql-statement: * sql statement was 'SELECT A0.SVC_DEF_ID,A0.SVC_NM,A0.SVC_URL,A0.INSTN_ID,A0.APPL_ID,A0.SRVR_IP,A0.TYP_CD,A0.SVC_VER,A0.STAT_CD,A0.SVC_DSCRPTR_ID,A0.CHKSM,A0.VER_NBR FROM KRSB_SVC_DEF_T A0 WHERE A0.STAT_CD = ?' * Exception message is [Table 'kfs.KRSB_SVC_DEF_T' doesn't exist] * Vendor error code [1146] * SQL state code [42S02] * The root stack trace is --> * com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kfs.KRSB_SVC_DEF_T' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) {noformat} I believe this is related to the lower_case_table_names parameter which we have set to 1 (per MySQL docs, “If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive.”). See also: http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html The Jenkins job is configured to restart the db instance so the new parameter can take effect, but it appears this occasionally doesn't work as expected, however there is a workaround: Workaround * Stop Tomcat on KFS Test Drive EC2 instance (kfs-ptd5) * Reboot KFS Test Drive RDS db instance (kfs-ptd5) * Start Tomcat on KFS Test Drive EC2 instance (kfs-ptd5) Note: this issue and the workaround have been documented in Confluence on the Test Drive Deployment and Troubleshooting page: https://wiki.kuali.org/x/xq9TEg
    via by Bryan Hutchinson,
  • There is an intermittent issue with the TestDrive-ResetDatabase Jenkins Job. (As of 9/9/13, the problem has occurred twice since KFS 5.0.2 was deployed in the Test Drive environment in late June 2013, once on 7/8/13 and once on 9/8/13). After the Job runs, the Test Drive environment fails to come back up. The root cause appears to be a problem when applying the kfs-parameter-group to the new db instance the job creates and then restarting the db instance for the new parameters to take effect. This is the error message from the log: {noformat} 2013-09-09 04:01:40,291 [main] u:/d: INFO org.kuali.rice.ksb.messaging.config.KSBConfigurer :: Synchronizing remote services with service bus after KSB startup... 2013-09-09 04:01:40,347 [main] u:/d: INFO BOOT :: PersistencebrokerFactory class instantiated: org.apache.ojb.broker.core.PersistenceBrokerFactorySyncImpl@51cfc277 2013-09-09 04:01:40,947 [main] u:/d: ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl :: * SQLException during execution of sql-statement: * sql statement was 'SELECT A0.SVC_DEF_ID,A0.SVC_NM,A0.SVC_URL,A0.INSTN_ID,A0.APPL_ID,A0.SRVR_IP,A0.TYP_CD,A0.SVC_VER,A0.STAT_CD,A0.SVC_DSCRPTR_ID,A0.CHKSM,A0.VER_NBR FROM KRSB_SVC_DEF_T A0 WHERE A0.STAT_CD = ?' * Exception message is [Table 'kfs.KRSB_SVC_DEF_T' doesn't exist] * Vendor error code [1146] * SQL state code [42S02] * The root stack trace is --> * com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kfs.KRSB_SVC_DEF_T' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) {noformat} I believe this is related to the lower_case_table_names parameter which we have set to 1 (per MySQL docs, “If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive.”). See also: http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html The Jenkins job is configured to restart the db instance so the new parameter can take effect, but it appears this occasionally doesn't work as expected, however there is a workaround: Workaround * Stop Tomcat on KFS Test Drive EC2 instance (kfs-ptd5) * Reboot KFS Test Drive RDS db instance (kfs-ptd5) * Start Tomcat on KFS Test Drive EC2 instance (kfs-ptd5) Note: this issue and the workaround have been documented in Confluence on the Test Drive Deployment and Troubleshooting page: https://wiki.kuali.org/x/xq9TEg
    via by Bryan Hutchinson,
  • shark 安装 遇到的问题 - CSDN博客
    via by Unknown author,
  • Php - Pdo Execute Multiple Queries
    via by Unknown author,
    • com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kfs.KRSB_SVC_DEF_T' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    MattyMatty
    2 times, last one,
    Михайло ТітовМихайло Тітов
    5 times, last one,
    slashslash
    2 times, last one,
    rocdayrocday
    1 times, last one,
    110 more bugmates