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
  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 | 6 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

  1. Kialandei 1 times, last 2 weeks ago
  2. kid 8 times, last 5 months ago
  3. poroszd 3 times, last 7 months ago
  4. rp 16 times, last 6 months ago
  5. MoYapro 1 times, last 2 weeks ago
27 more registered users
66 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

    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