Nutch
  1. Nutch
  2. NUTCH-1473

Column length too big for column 'text' (max = 21845); use BLOB or TEXT instead

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.1
    • Fix Version/s: 2.3
    • Component/s: None
    • Labels:
      None

      Description

      Exception in thread "main" org.apache.gora.util.GoraException: java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Column length too big for column 'text' (max = 21845); use BLOB or TEXT instead
      at org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:167)
      at org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:135)
      at org.apache.nutch.storage.StorageUtils.createWebStore(StorageUtils.java:75)
      at org.apache.nutch.crawl.InjectorJob.run(InjectorJob.java:214)
      at org.apache.nutch.crawl.Crawler.runTool(Crawler.java:62)
      at org.apache.nutch.crawl.Crawler.run(Crawler.java:133)
      at org.apache.nutch.crawl.Crawler.run(Crawler.java:246)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      at org.apache.nutch.crawl.Crawler.main(Crawler.java:253)
      Caused by: java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Column length too big for column 'text' (max = 21845); use BLOB or TEXT instead
      at org.apache.gora.sql.store.SqlStore.createSchema(SqlStore.java:226)
      at org.apache.gora.sql.store.SqlStore.initialize(SqlStore.java:172)
      at org.apache.gora.store.DataStoreFactory.initializeDataStore(DataStoreFactory.java:102)
      at org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:161)
      ... 8 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Column length too big for column 'text' (max = 21845); use BLOB or TEXT instead
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.Util.getInstance(Util.java:386)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
      at org.apache.gora.sql.store.SqlStore.createSchema(SqlStore.java:224)
      ... 11 more

        Issue Links

          Activity

          ZhaiXuepan created issue -
          Nathan Gass made changes -
          Field Original Value New Value
          Link This issue duplicates NUTCH-970 [ NUTCH-970 ]
          Lewis John McGibbney made changes -
          Fix Version/s 2.2 [ 12323285 ]
          Lewis John McGibbney made changes -
          Fix Version/s 2.3 [ 12324325 ]
          Fix Version/s 2.2 [ 12323285 ]
          Lewis John McGibbney made changes -
          Fix Version/s 2.4 [ 12324540 ]
          Fix Version/s 2.3 [ 12324325 ]
          Lewis John McGibbney made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Won't Fix [ 2 ]
          Lewis John McGibbney made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Lewis John McGibbney made changes -
          Resolution Won't Fix [ 2 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Lewis John McGibbney made changes -
          Fix Version/s 2.3 [ 12324325 ]
          Fix Version/s 2.4 [ 12324540 ]
          Lewis John McGibbney made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Won't Fix [ 2 ]
          Lewis John McGibbney made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              ZhaiXuepan
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development