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 2021/08/12 11:05:34 UTC
[GitHub] [skywalking] qiuhuanhen opened a new issue #7450: setting log storage in mysql :Index column size too large
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: notifications-unsubscribe@skywalking.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [skywalking] wu-sheng commented on issue #7450: setting log storage in mysql :Index column size too large
Posted by GitBox <gi...@apache.org>.
wu-sheng commented on issue #7450:
URL: https://github.com/apache/skywalking/issues/7450#issuecomment-897556852
> The maximum column size is 767 bytes.
This is your MySQL server setting. You need to set on your side.
--
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: notifications-unsubscribe@skywalking.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [skywalking] wu-sheng closed issue #7450: setting log storage in mysql :Index column size too large
Posted by GitBox <gi...@apache.org>.
wu-sheng closed issue #7450:
URL: https://github.com/apache/skywalking/issues/7450
--
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: notifications-unsubscribe@skywalking.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org