Home > Back-end >  MySQL8.0 sonarqube - 6.7.1 connection error for a great god for help
MySQL8.0 sonarqube - 6.7.1 connection error for a great god for help

Time:09-16

2019.03.27 18:44:23 INFO web [] [O.S.P.P rocessEntryPoint] Starting web
2019.03.27 18:44:24 INFO web [] [O.A.T.U.N.N ioSelectorPool] Using a Shared the selector for the servlet write/read
2019.03.27 18:44:27 INFO web [] [O.E.P.P luginsService] no modules the loaded
2019.03.27 18:44:27 INFO web [] [O.E.P.P luginsService] the loaded plugin [org. Elasticsearch. Index. Reindex. ReindexPlugin]
2019.03.27 18:44:27 INFO web [] [O.E.P.P luginsService] the loaded plugin [org. Elasticsearch. Join. ParentJoinPlugin]
2019.03.27 18:44:27 INFO web [] [O.E.P.P luginsService] the loaded plugin [org. Elasticsearch. Percolator. PercolatorPlugin]
2019.03.27 18:44:27 INFO web [] [O.E.P.P luginsService] the loaded plugin ty4Plugin [org.elasticsearch.transport.Net]
2019.03.27 18:44:32 INFO web [] [O.S.S.E.E sClientProvider] Connected to the local Elasticsearch: [127.0.0.1:9001]
2019.03.27 18:44:32 INFO web [] [O.S.S.P.L ogServerVersion] SonarQube Server/6.7.1.35068/426519346 f51f7b980a76f9050f983110550509d
2019.03.27 18:44:32 INFO web [] [grown onar. The Database] Create a JDBC data source for JDBC: mysql://localhost: 3306/sonar? UseUnicode=true& CharacterEncoding=utf8 & amp; RewriteBatchedStatements=true& UseConfigs=maxPerformance& UseSSL=false& ServerTimezone=UTC
2019.03.27 18:44:33 INFO web [] [O.S.S.P.S erverFileSystemImpl] SonarQube home: D: \ SonarQube - 6.7.1
2019.03.27 18:44:33 INFO web [] [O.S.S.U.S ystemPasscodeImpl] System authentication by passcode is disabled
2019.03.27 18:44:34 ERROR web [] [O.S.S.P.P latform] web server startup failed
Java. Lang. An IllegalStateException: Can not check that the table schema_migrations exists
The at org. Sonar. Db. DatabaseUtils. WrapSqlException (DatabaseUtils. Java: 326)
The at org. Sonar. Db. DatabaseUtils. TableExists (DatabaseUtils. Java: 321)
At org. Sonar. Server. Platform. The migration. History. MigrationHistoryTableImpl. Start (MigrationHistoryTableImpl. Java: 44)
The at Java. Util. Optional. IfPresent (Unknown Source)
The at org. Sonar. Server. Platform. Platformlevel. PlatformLevel2. Start (PlatformLevel2. Java: 86)
At org. Sonar. Server platform. The platform. The start (211) platform. Java:
At org. Sonar. Server. Platform. Platform. StartLevel2Container (177) platform. Java:
At org. Sonar. Server platform. The platform. The init (87) platform. Java:
The at org. Sonar. Server. Platform. Web. PlatformServletContextListener. ContextInitialized (PlatformServletContextListener. Java: 45)
The at org. Apache. Catalina. Core. StandardContext. ListenerStart (StandardContext. Java: 4745)
The at org. Apache. Catalina. Core. StandardContext. StartInternal (StandardContext. Java: 5207)
The at org. Apache. Catalina. Util. LifecycleBase. Start (LifecycleBase. Java: 150)
The at org. Apache. Catalina. Core. ContainerBase $StartChild. Call (1419) ContainerBase. Java:
The at org. Apache. Catalina. Core. ContainerBase $StartChild. Call (1409) ContainerBase. Java:
The at Java. Util. Concurrent. FutureTask. Run (Unknown Source)
The at Java. Util. Concurrent. ThreadPoolExecutor. RunWorker (Unknown Source)
The at Java. Util. Concurrent. ThreadPoolExecutor $Worker. The run (Unknown Source)
The at Java. Lang. Thread. The run (Unknown Source)
Under Caused by: Java. SQL. SQLSyntaxErrorException: 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 'HAVING TABLE_TYPE IN (" TABLE ", null, null, null, null) ORDER BY TABLE_TYPE, TABLE_SC' at line 1
At com. Mysql. Cj. JDBC. Exceptions. SQLError. CreateSQLException (SQLError. Java: 118)
At com. Mysql. Cj. JDBC. Exceptions. SQLError. CreateSQLException (SQLError. Java: 95)
At com. Mysql. Cj. JDBC. Exceptions. SQLExceptionsMapping. TranslateException (SQLExceptionsMapping. Java: 122)
At com. Mysql. Cj. JDBC. ClientPreparedStatement. ExecuteInternal (ClientPreparedStatement. Java: 960)
At com. Mysql. Cj. JDBC. ClientPreparedStatement. ExecuteQuery (ClientPreparedStatement. Java: 1019)
At com. Mysql. Cj. JDBC. DatabaseMetaDataUsingInfoSchema. ExecuteMetadataQuery (DatabaseMetaDataUsingInfoSchema. Java: 62)
At com. Mysql. Cj. JDBC. DatabaseMetaDataUsingInfoSchema. GetTables (DatabaseMetaDataUsingInfoSchema. Java: 835)
At org.apache.com mons. DBCP. DelegatingDatabaseMetaData. GetTables (DelegatingDatabaseMetaData. Java: 604)
The at org. Sonar. Db. DatabaseUtils. TableExists (DatabaseUtils. Java: 312)
. 16 common frames omitted

CodePudding user response:

Sonarqube mysql8.0 and above version is not currently supported,
  • Related