You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@skywalking.apache.org by GitBox <gi...@apache.org> on 2020/08/26 07:45:44 UTC

[GitHub] [skywalking] DerekHQ opened a new issue #5387: SkyWalking 8.1.0, Mysql8.0, Table doesn't exist; Not to create table auto!

DerekHQ opened a new issue #5387:
URL: https://github.com/apache/skywalking/issues/5387


   Please answer these questions before submitting your issue.
   
   - Why do you submit this issue?
   - [ ] Question or discussion
   - [ * ] Bug
   - [ ] Requirement
   - [ ] Feature or performance improvement
   
   ___
   ### Question
   - What do you want to know?
   Table doesn't exist;  Not auto create table!
   
   skywalking7.0.0 mysql8.0 is work ok!
   bug when upgrade to 8.1.0, the save mysql server ,just a new database instance
   ___
   ### Bug
   - Which version of SkyWalking, OS and JRE?
   SkyWalking 8.1.0
   Linux
   JAVA8
   Mysql8.0
   driver: mysql-connector-java-8.0.21.jar
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [skywalking] wu-sheng closed issue #5387: SkyWalking 8.1.0, Mysql8.0, Table doesn't exist; Not to create table auto!

Posted by GitBox <gi...@apache.org>.
wu-sheng closed issue #5387:
URL: https://github.com/apache/skywalking/issues/5387


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [skywalking] wu-sheng commented on issue #5387: SkyWalking 8.1.0, Mysql8.0, Table doesn't exist; Not to create table auto!

Posted by GitBox <gi...@apache.org>.
wu-sheng commented on issue #5387:
URL: https://github.com/apache/skywalking/issues/5387#issuecomment-680721443


   - https://github.com/apache/skywalking/blob/master/test/e2e/e2e-test/docker/profile/docker-compose.mysql.yml
   - https://github.com/apache/skywalking/blob/master/test/e2e/e2e-test/docker/storage/docker-compose.mysql.yml
   - https://github.com/apache/skywalking/blob/master/test/e2e/e2e-test/docker/cluster/docker-compose.zk.mysql.yml


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [skywalking] wu-sheng commented on issue #5387: SkyWalking 8.1.0, Mysql8.0, Table doesn't exist; Not to create table auto!

Posted by GitBox <gi...@apache.org>.
wu-sheng commented on issue #5387:
URL: https://github.com/apache/skywalking/issues/5387#issuecomment-680720438


   We tested it in the e2e, https://github.com/apache/skywalking/blob/master/.github/workflows/e2e.storages.yaml#L39.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [skywalking] wu-sheng commented on issue #5387: SkyWalking 8.1.0, Mysql8.0, Table doesn't exist; Not to create table auto!

Posted by GitBox <gi...@apache.org>.
wu-sheng commented on issue #5387:
URL: https://github.com/apache/skywalking/issues/5387#issuecomment-680728949


   We are impossible to test on your env. I just posted all test processes. Please take a look. There could be many factors and configurations to affect the result.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [skywalking] DerekHQ commented on issue #5387: SkyWalking 8.1.0, Mysql8.0, Table doesn't exist; Not to create table auto!

Posted by GitBox <gi...@apache.org>.
DerekHQ commented on issue #5387:
URL: https://github.com/apache/skywalking/issues/5387#issuecomment-680728129


   Datasource Create is OK!
   2020-08-26 15:53:24,945 - com.zaxxer.hikari.HikariDataSource - 80 [main] INFO  [] - HikariPool-1 - Starting...
   2020-08-26 15:53:26,019 - com.zaxxer.hikari.HikariDataSource - 82 [main] INFO  [] - HikariPool-1 - Start completed.
   .......
   
   2020-08-26 16:06:06,850 - org.apache.skywalking.oap.server.core.storage.PersistenceTimer - 56 [main] INFO  [] - persistence timer start
   2020-08-26 16:06:06,863 - org.apache.skywalking.oap.server.core.cache.CacheUpdateTimer - 46 [main] INFO  [] - Cache updateServiceInventory timer start
   2020-08-26 16:06:07,101 - org.apache.skywalking.oap.server.core.analysis.worker.ManagementPersistentWorker - 45 [main] ERROR [] - Table 'skywalking_b.ui_template' doesn't exist
   java.io.IOException: Table 'skywalking_b.ui_template' doesn't exist
           at org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2ManagementDAO.insert(H2ManagementDAO.java:56) ~[storage-jdbc-hikaricp-plugin-8.1.0.jar:8.1.0]
           at org.apache.skywalking.oap.server.core.analysis.worker.ManagementPersistentWorker.in(ManagementPersistentWorker.java:43) ~[server-core-8.1.0.jar:8.1.0]
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org