qiuhuanhen opened a new issue #7450:
URL: https://github.com/apache/skywalking/issues/7450
Please answer these questions before submitting your issue.
- Why do you submit this issue?
- [ ] Question or discussion
- [ ] Bug
- [ √] Requirement
- [ ] Feature or performance improvement
___
### Question
when I set log-storage in mysql (version 5.5) , and the database also set
global innodb_large_prefix = ON, but the error still occurred when I startup
the oapService
___
### Bug
- Which version of SkyWalking, OS, and JRE?
version:8.5
- Which company or project?
oap-service
- What happened?
org.apache.skywalking.oap.server.library.module.ModuleStartException: Index
column size too large. The maximum column size is 767 bytes.
at
org.apache.skywalking.oap.server.storage.plugin.jdbc.mysql.MySQLStorageProvider.start(MySQLStorageProvider.java:181)
~[storage-jdbc-hikaricp-plugin-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.library.module.BootstrapFlow.start(BootstrapFlow.java:49)
~[library-module-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.library.module.ModuleManager.init(ModuleManager.java:60)
~[library-module-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.starter.OAPServerBootstrap.start(OAPServerBootstrap.java:43)
[server-bootstrap-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.starter.OAPServerStartUp.main(OAPServerStartUp.java:27)
[server-starter-es7-8.5.0.jar:8.5.0]
Caused by: org.apache.skywalking.oap.server.core.storage.StorageException:
Index column size too large. The maximum column size is 767 bytes.
at
org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2TableInstaller.createTable(H2TableInstaller.java:91)
~[storage-jdbc-hikaricp-plugin-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.core.storage.model.ModelInstaller.whenCreating(ModelInstaller.java:56)
~[server-core-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.core.storage.model.StorageModels.addModelListener(StorageModels.java:90)
~[server-core-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.storage.plugin.jdbc.mysql.MySQLStorageProvider.start(MySQLStorageProvider.java:179)
~[storage-jdbc-hikaricp-plugin-8.5.0.jar:8.5.0]
... 4 more
Caused by:
org.apache.skywalking.oap.server.library.client.jdbc.JDBCClientException: Index
column size too large. The maximum column size is 767 bytes.
at
org.apache.skywalking.oap.server.library.client.jdbc.hikaricp.JDBCHikariCPClient.execute(JDBCHikariCPClient.java:89)
~[library-client-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2TableInstaller.createTable(H2TableInstaller.java:87)
~[storage-jdbc-hikaricp-plugin-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.core.storage.model.ModelInstaller.whenCreating(ModelInstaller.java:56)
~[server-core-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.core.storage.model.StorageModels.addModelListener(StorageModels.java:90)
~[server-core-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.storage.plugin.jdbc.mysql.MySQLStorageProvider.start(MySQLStorageProvider.java:179)
~[storage-jdbc-hikaricp-plugin-8.5.0.jar:8.5.0]
... 4 more
Caused by: java.sql.SQLException: Index column size too large. The maximum
column size is 767 bytes.
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
~[mysql-connector-java-8.0.21.jar:8.0.21]
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
~[mysql-connector-java-8.0.21.jar:8.0.21]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
~[mysql-connector-java-8.0.21.jar:8.0.21]
at
com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
~[mysql-connector-java-8.0.21.jar:8.0.21]
at
com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
~[HikariCP-3.1.0.jar:?]
at
com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
~[HikariCP-3.1.0.jar:?]
at
org.apache.skywalking.oap.server.library.client.jdbc.hikaricp.JDBCHikariCPClient.execute(JDBCHikariCPClient.java:85)
~[library-client-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.storage.plugin.jdbc.h2.dao.H2TableInstaller.createTable(H2TableInstaller.java:87)
~[storage-jdbc-hikaricp-plugin-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.core.storage.model.ModelInstaller.whenCreating(ModelInstaller.java:56)
~[server-core-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.core.storage.model.StorageModels.addModelListener(StorageModels.java:90)
~[server-core-8.5.0.jar:8.5.0]
at
org.apache.skywalking.oap.server.storage.plugin.jdbc.mysql.MySQLStorageProvider.start(MySQLStorageProvider.java:179)
~[storage-jdbc-hikaricp-plugin-8.5.0.jar:8.5.0]
... 4 more
2021-08-12 18:14:40,308 - com.alibaba.nacos.common.http.HttpClientManager -
108 [Thread-1] WARN [] - [HttpClientBeanFactory] Start destroying
NacosRestTemplate
2021-08-12 18:14:40,308 - com.alibaba.nacos.common.http.HttpClientManager -
116 [Thread-1] WARN [] - [HttpClientBeanFactory] Destruction of the end
___
### Requirement or improvement
- could you pls open the sql of creating table as a config file then we
edit the sql by ourselves?
- or give other advice pls (don't change the version of database)
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
