Uploaded image for project: 'Hadoop Distributed Data Store'
  1. Hadoop Distributed Data Store
  2. HDDS-3804

Recon start fails with SQL exception with MySQL DB.

    XMLWordPrintableJSON

    Details

      Description

      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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                flirmnave Zheng Huang-Mu
                Reporter:
                avijayan Aravindan Vijayan
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: