[jira] [Assigned] (HDDS-3804) Recon start fails with SQL exception with MySQL DB.
[
https://issues.apache.org/jira/browse/HDDS-3804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aravindan Vijayan reassigned HDDS-3804:
---
Assignee: Zheng Huang-Mu (was: Prashant Pogde)
> Recon start fails with SQL exception with MySQL DB.
> ---
>
> Key: HDDS-3804
> URL: https://issues.apache.org/jira/browse/HDDS-3804
> Project: Hadoop Distributed Data Store
> Issue Type: Bug
> Components: Ozone Recon
>Affects Versions: 0.6.0
>Reporter: Aravindan Vijayan
>Assignee: Zheng Huang-Mu
>Priority: Major
>
> {code}
> org.jooq.exception.DataAccessException: SQL [create table if not exists
> `CONTAINER_HISTORY`(`container_id` bigint null, `datanode_host` varchar(1024)
> null, `first_report_timestamp` bigint null, `last_report_timestamp` bigint
> null, constraint `pk_container_id_datanode_host` primary key (`container_id`,
> `datanode_host`))]; Specified key was too long; max key length is 3072 bytes
> at org.jooq_3.11.9.MYSQL_5_7.debug(Unknown Source)
> at org.jooq.impl.Tools.translate(Tools.java:2429)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:832)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:364)
> at
> org.hadoop.ozone.recon.schema.ContainerSchemaDefinition.createContainerHistoryTable(ContainerSchemaDefinition.java:90)
> at
> org.hadoop.ozone.recon.schema.ContainerSchemaDefinition.initializeSchema(ContainerSchemaDefinition.java:72)
> at
> org.apache.hadoop.ozone.recon.ReconSchemaManager.lambda$createReconSchema$0(ReconSchemaManager.java:50)
> at java.lang.Iterable.forEach(Iterable.java:75)
> at
> org.apache.hadoop.ozone.recon.ReconSchemaManager.createReconSchema(ReconSchemaManager.java:48)
> at
> org.apache.hadoop.ozone.recon.ReconServer.call(ReconServer.java:102)
> at org.apache.hadoop.ozone.recon.ReconServer.call(ReconServer.java:53)
> at picocli.CommandLine.execute(CommandLine.java:1173)
> at picocli.CommandLine.access$800(CommandLine.java:141)
> at picocli.CommandLine$RunLast.handle(CommandLine.java:1367)
> at picocli.CommandLine$RunLast.handle(CommandLine.java:1335)
> at
> picocli.CommandLine$AbstractParseResultHandler.handleParseResult(CommandLine.java:1243)
> at picocli.CommandLine.parseWithHandlers(CommandLine.java:1526)
> at picocli.CommandLine.parseWithHandler(CommandLine.java:1465)
> at org.apache.hadoop.hdds.cli.GenericCli.execute(GenericCli.java:75)
> at org.apache.hadoop.hdds.cli.GenericCli.run(GenericCli.java:66)
> at org.apache.hadoop.ozone.recon.ReconServer.main(ReconServer.java:67)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Specified key was too long; max key length is 3072 bytes
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> at com.mysql.jdbc.Util.getInstance(Util.java:408)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
> at
> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
> at
> com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:140)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:432)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:350)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: ozone-issues-unsubscr...@hadoop.apache.org
For additional commands, e-mail: ozone-issues-h...@hadoop.apache.org
[jira] [Assigned] (HDDS-3804) Recon start fails with SQL exception with MySQL DB.
[
https://issues.apache.org/jira/browse/HDDS-3804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vivek Ratnavel Subramanian reassigned HDDS-3804:
Assignee: Prashant Pogde
> Recon start fails with SQL exception with MySQL DB.
> ---
>
> Key: HDDS-3804
> URL: https://issues.apache.org/jira/browse/HDDS-3804
> Project: Hadoop Distributed Data Store
> Issue Type: Bug
> Components: Ozone Recon
>Affects Versions: 0.6.0
>Reporter: Aravindan Vijayan
>Assignee: Prashant Pogde
>Priority: Major
>
> {code}
> org.jooq.exception.DataAccessException: SQL [create table if not exists
> `CONTAINER_HISTORY`(`container_id` bigint null, `datanode_host` varchar(1024)
> null, `first_report_timestamp` bigint null, `last_report_timestamp` bigint
> null, constraint `pk_container_id_datanode_host` primary key (`container_id`,
> `datanode_host`))]; Specified key was too long; max key length is 3072 bytes
> at org.jooq_3.11.9.MYSQL_5_7.debug(Unknown Source)
> at org.jooq.impl.Tools.translate(Tools.java:2429)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:832)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:364)
> at
> org.hadoop.ozone.recon.schema.ContainerSchemaDefinition.createContainerHistoryTable(ContainerSchemaDefinition.java:90)
> at
> org.hadoop.ozone.recon.schema.ContainerSchemaDefinition.initializeSchema(ContainerSchemaDefinition.java:72)
> at
> org.apache.hadoop.ozone.recon.ReconSchemaManager.lambda$createReconSchema$0(ReconSchemaManager.java:50)
> at java.lang.Iterable.forEach(Iterable.java:75)
> at
> org.apache.hadoop.ozone.recon.ReconSchemaManager.createReconSchema(ReconSchemaManager.java:48)
> at
> org.apache.hadoop.ozone.recon.ReconServer.call(ReconServer.java:102)
> at org.apache.hadoop.ozone.recon.ReconServer.call(ReconServer.java:53)
> at picocli.CommandLine.execute(CommandLine.java:1173)
> at picocli.CommandLine.access$800(CommandLine.java:141)
> at picocli.CommandLine$RunLast.handle(CommandLine.java:1367)
> at picocli.CommandLine$RunLast.handle(CommandLine.java:1335)
> at
> picocli.CommandLine$AbstractParseResultHandler.handleParseResult(CommandLine.java:1243)
> at picocli.CommandLine.parseWithHandlers(CommandLine.java:1526)
> at picocli.CommandLine.parseWithHandler(CommandLine.java:1465)
> at org.apache.hadoop.hdds.cli.GenericCli.execute(GenericCli.java:75)
> at org.apache.hadoop.hdds.cli.GenericCli.run(GenericCli.java:66)
> at org.apache.hadoop.ozone.recon.ReconServer.main(ReconServer.java:67)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Specified key was too long; max key length is 3072 bytes
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> at com.mysql.jdbc.Util.getInstance(Util.java:408)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
> at
> com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
> at
> com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:140)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:432)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:350)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
-
To unsubscribe, e-mail: ozone-issues-unsubscr...@hadoop.apache.org
For additional commands, e-mail: ozone-issues-h...@hadoop.apache.org
