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 'USING BTREE' at line 1

JFrog JIRA | Jascha Lee | 5 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

    I installed artifactory 2.5.1.1-13098 via the RPM onto a working 2.3.3 system that uses mysql. Now it won't start up. I get the following in /var/log/artifactory/artifactory.log: 2012-03-22 21:15:17,500 [art-init] [INFO ] (o.a.i.c.ChecksumPathsImpl:149) - Creating the checksumPaths table... 2012-03-22 21:15:17,590 [art-init] [ERROR] (o.a.j.c.u.d.ConnectionHelper:492) - Failed to execute SQL (stacktrace on DEBUG log level) 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 'USING BTREE' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.6.0_30] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [na:1.6.0_30] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [na:1.6.0_30] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [na:1.6.0_30] at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:381) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2643) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1356) [mysql-connector-java-5.1.9.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:450) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyUpdate(ConnectionHelper.java:325) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:310) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:306) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:488) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper.update(ConnectionHelper.java:306) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.artifactory.io.checksum.ChecksumPathsImpl.init(ChecksumPathsImpl.java:152) [artifactory-jcr-storage-2.5.1.1.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_30] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [na:1.6.0_30] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_30] at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_30] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:121) [artifactory-jcr-storage-2.5.1.1.jar:na] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:49) [artifactory-jcr-storage-2.5.1.1.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at $Proxy59.init(Unknown Source) [na:na] at org.artifactory.spring.ArtifactoryApplicationContext.refresh(ArtifactoryApplicationContext.java:253) [artifactory-core-2.5.1.1.jar:na] at org.artifactory.spring.ArtifactoryApplicationContext.<init>(ArtifactoryApplicationContext.java:113) [artifactory-core-2.5.1.1.jar:na] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.6.0_30] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [na:1.6.0_30] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [na:1.6.0_30] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [na:1.6.0_30] at org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.configure(ArtifactoryContextConfigListener.java:174) [artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.access$1(ArtifactoryContextConfigListener.java:113) [artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.ArtifactoryContextConfigListener$1.run(ArtifactoryContextConfigListener.java:68) [artifactory-web-application-2.5.1.1.jar:na] In /opt/artifactory/tomcat/logs/localhost.2012-03-22.log, I get: INFO: Using artifactory.home at '/var/lib/artifactory'. Mar 22, 2012 8:53:40 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [default] in context with path [/artifactory] threw exception java.lang.NullPointerException at org.artifactory.webapp.servlet.ArtifactoryFilter.bind(ArtifactoryFilter.java:78) at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:182) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Mar 22, 2012 9:02:35 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [default] in context with path [/artifactory] threw exception java.lang.NullPointerException at org.artifactory.webapp.servlet.ArtifactoryFilter.bind(ArtifactoryFilter.java:78) at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:182) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) What can I do?

    JFrog JIRA | 5 years ago | Jascha Lee
    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 'USING BTREE' at line 1
  2. 0

    I installed artifactory 2.5.1.1-13098 via the RPM onto a working 2.3.3 system that uses mysql. Now it won't start up. I get the following in /var/log/artifactory/artifactory.log: 2012-03-22 21:15:17,500 [art-init] [INFO ] (o.a.i.c.ChecksumPathsImpl:149) - Creating the checksumPaths table... 2012-03-22 21:15:17,590 [art-init] [ERROR] (o.a.j.c.u.d.ConnectionHelper:492) - Failed to execute SQL (stacktrace on DEBUG log level) 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 'USING BTREE' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.6.0_30] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [na:1.6.0_30] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [na:1.6.0_30] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [na:1.6.0_30] at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:381) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2643) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077) [mysql-connector-java-5.1.9.jar:na] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1356) [mysql-connector-java-5.1.9.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) [commons-dbcp-1.2.2.jar:1.2.2] at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:450) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyUpdate(ConnectionHelper.java:325) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:310) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:306) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:488) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper.update(ConnectionHelper.java:306) [jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.artifactory.io.checksum.ChecksumPathsImpl.init(ChecksumPathsImpl.java:152) [artifactory-jcr-storage-2.5.1.1.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_30] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [na:1.6.0_30] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_30] at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_30] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:121) [artifactory-jcr-storage-2.5.1.1.jar:na] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:49) [artifactory-jcr-storage-2.5.1.1.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at $Proxy59.init(Unknown Source) [na:na] at org.artifactory.spring.ArtifactoryApplicationContext.refresh(ArtifactoryApplicationContext.java:253) [artifactory-core-2.5.1.1.jar:na] at org.artifactory.spring.ArtifactoryApplicationContext.<init>(ArtifactoryApplicationContext.java:113) [artifactory-core-2.5.1.1.jar:na] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.6.0_30] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [na:1.6.0_30] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [na:1.6.0_30] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [na:1.6.0_30] at org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.configure(ArtifactoryContextConfigListener.java:174) [artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.access$1(ArtifactoryContextConfigListener.java:113) [artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.ArtifactoryContextConfigListener$1.run(ArtifactoryContextConfigListener.java:68) [artifactory-web-application-2.5.1.1.jar:na] In /opt/artifactory/tomcat/logs/localhost.2012-03-22.log, I get: INFO: Using artifactory.home at '/var/lib/artifactory'. Mar 22, 2012 8:53:40 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [default] in context with path [/artifactory] threw exception java.lang.NullPointerException at org.artifactory.webapp.servlet.ArtifactoryFilter.bind(ArtifactoryFilter.java:78) at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:182) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Mar 22, 2012 9:02:35 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [default] in context with path [/artifactory] threw exception java.lang.NullPointerException at org.artifactory.webapp.servlet.ArtifactoryFilter.bind(ArtifactoryFilter.java:78) at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:182) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) What can I do?

    JFrog JIRA | 5 years ago | Jascha Lee
    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 'USING BTREE' at line 1
  3. 0

    Unable to load the Data follow the Documentation example

    Google Groups | 3 years ago | tao...@yahoo-inc.com
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'druid.druid_segments' doesn't exist [statement:"SELECT id FROM druid_segments WHERE id = :identifier", located:"SELECT id FROM druid_segments WHERE id = :identifier", rewritten:"SELECT id FROM druid_segments WHERE id = ?", arguments:{ positional:{}, named:{identifier:'wikipedia_2013-08-31T00:00:00.000Z_2013-09-01T00:00:00.000Z_2014-03-26T16:58:38.587Z'}, finder:[]}]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MySQLSyntaxErrorException: You have an error in your SQL syntax;

    Google Groups | 3 years ago | David Montgomery
    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 'where datasource='_default'' at line 1 [statement:"SELECT id from where datasource='_default';", located:"SELECT id from where datasource='_default';", rewritten:"SELECT id from where datasource='_default';", arguments:{ positional:{}, named:{}, finder:[]}]
  6. 0

    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax.

    soso.io | 9 months ago
    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 'form_bytes=_binary'<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//E' at line 14
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

    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 'USING BTREE' at line 1

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.6.0_30]
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)[na:1.6.0_30]
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)[na:1.6.0_30]
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)[na:1.6.0_30]
    4 frames
  3. MySQL jdbc
    PreparedStatement.execute
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)[mysql-connector-java-5.1.9.jar:na]
    2. com.mysql.jdbc.Util.getInstance(Util.java:381)[mysql-connector-java-5.1.9.jar:na]
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)[mysql-connector-java-5.1.9.jar:na]
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)[mysql-connector-java-5.1.9.jar:na]
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)[mysql-connector-java-5.1.9.jar:na]
    6. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)[mysql-connector-java-5.1.9.jar:na]
    7. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)[mysql-connector-java-5.1.9.jar:na]
    8. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)[mysql-connector-java-5.1.9.jar:na]
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2643)[mysql-connector-java-5.1.9.jar:na]
    10. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)[mysql-connector-java-5.1.9.jar:na]
    11. com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1356)[mysql-connector-java-5.1.9.jar:na]
    11 frames
  4. Commons DBCP
    DelegatingPreparedStatement.execute
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)[commons-dbcp-1.2.2.jar:1.2.2]
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)[commons-dbcp-1.2.2.jar:1.2.2]
    2 frames
  5. Jackrabbit Data
    ConnectionHelper.update
    1. org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:450)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b]
    2. org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyUpdate(ConnectionHelper.java:325)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b]
    3. org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:310)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b]
    4. org.apache.jackrabbit.core.util.db.ConnectionHelper$2.call(ConnectionHelper.java:306)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b]
    5. org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:488)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b]
    6. org.apache.jackrabbit.core.util.db.ConnectionHelper.update(ConnectionHelper.java:306)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b]
    6 frames
  6. org.artifactory.io
    ChecksumPathsImpl.init
    1. org.artifactory.io.checksum.ChecksumPathsImpl.init(ChecksumPathsImpl.java:152)[artifactory-jcr-storage-2.5.1.1.jar:na]
    1 frame
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.6.0_30]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)[na:1.6.0_30]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[na:1.6.0_30]
    4. java.lang.reflect.Method.invoke(Method.java:597)[na:1.6.0_30]
    4 frames
  8. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    3 frames
  9. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)[spring-tx-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    1 frame
  10. org.artifactory.jcr
    LockingAdvice.invoke
    1. org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:121)[artifactory-jcr-storage-2.5.1.1.jar:na]
    2. org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:49)[artifactory-jcr-storage-2.5.1.1.jar:na]
    2 frames
  11. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2 frames
  12. Unknown
    $Proxy59.init
    1. $Proxy59.init(Unknown Source)[na:na]
    1 frame
  13. org.artifactory.spring
    ArtifactoryApplicationContext.<init>
    1. org.artifactory.spring.ArtifactoryApplicationContext.refresh(ArtifactoryApplicationContext.java:253)[artifactory-core-2.5.1.1.jar:na]
    2. org.artifactory.spring.ArtifactoryApplicationContext.<init>(ArtifactoryApplicationContext.java:113)[artifactory-core-2.5.1.1.jar:na]
    2 frames
  14. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.6.0_30]
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)[na:1.6.0_30]
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)[na:1.6.0_30]
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)[na:1.6.0_30]
    4 frames
  15. org.artifactory.webapp
    ArtifactoryContextConfigListener$1.run
    1. org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.configure(ArtifactoryContextConfigListener.java:174)[artifactory-web-application-2.5.1.1.jar:na]
    2. org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.access$1(ArtifactoryContextConfigListener.java:113)[artifactory-web-application-2.5.1.1.jar:na]
    3. org.artifactory.webapp.servlet.ArtifactoryContextConfigListener$1.run(ArtifactoryContextConfigListener.java:68)[artifactory-web-application-2.5.1.1.jar:na]
    3 frames