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

Kuali JIRA | Bryan Hutchinson | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 4 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