com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kfs.KRSB_SVC_DEF_T' doesn't exist

Kuali JIRA | Bryan Hutchinson | 3 years ago
  1. 0

    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

    Kuali JIRA | 3 years ago | Bryan Hutchinson
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kfs.KRSB_SVC_DEF_T' doesn't exist
  2. 0

    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

    Kuali JIRA | 3 years ago | Bryan Hutchinson
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kfs.KRSB_SVC_DEF_T' doesn't exist
  3. 0

    MySQL query syntax error, corresponds to your MySQL server version for the right syntax, while ordering table by name

    Stack Overflow | 4 years ago | Hallaz
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from Makanan p where p.name='sego kucing'' at line 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC SQL Exception: query executes correctly on the MySQL prompt but gives error in java

    Stack Overflow | 3 years ago | user2524652
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
  6. 0

    JPQL: set a column to null in an update

    Stack Overflow | 4 years ago | AndrewBourgeois
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS NULL WHERE `B0`.`ID` = 9' at line 1

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

      Table 'kfs.KRSB_SVC_DEF_T' doesn't exist

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
    2. Java RT
      DelegatingConstructorAccessorImpl.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      3 frames