daily pastebin goal
36%
SHARE
TWEET

Untitled

a guest Oct 21st, 2018 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Jun 19, 2012 7:06:17 PM org.apache.solr.handler.dataimport.JdbcDataSource logError
  2. WARNING: Exception while closing result set
  3. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 14 milliseconds ago.  The last packet sent successfully to the server was 654,637 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  4.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  5.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  6.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  7.     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
  8.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
  9.     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
  10.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3056)
  11.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2942)
  12.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3485)
  13.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920)
  14.     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1417)
  15.     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:422)
  16.     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:398)
  17.     at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic.java:176)
  18.     at com.mysql.jdbc.ResultSetImpl.realClose(ResultSetImpl.java:7624)
  19.     at com.mysql.jdbc.ResultSetImpl.close(ResultSetImpl.java:908)
  20.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.close(JdbcDataSource.java:347)
  21.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:338)
  22.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.access$700(JdbcDataSource.java:228)
  23.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(JdbcDataSource.java:262)
  24.     at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:78)
  25.     at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
  26.     at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237)
  27.     at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:357)
  28.     at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
  29.     at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
  30.     at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
  31.     at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
  32.     at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
  33. Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
  34.     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2503)
  35.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2953)
  36.     ... 22 more
  37. Jun 19, 2012 7:06:17 PM org.apache.solr.handler.dataimport.EntityProcessorBase getNext
  38. SEVERE: getNext() failed for query '     SELECT      r.*, rp.*, i.active AS item_active, i.approved AS item_approved,      i.id AS item_id,      GROUP_CONCAT(CAST(c.id AS CHAR)                           SEPARATOR '.') AS category_ids_concat,      GROUP_CONCAT(CONCAT(c.materialised_path, c.id, '.', i.id) SEPARATOR '.') AS path_ids_concat      FROM      content_node          r     JOIN      review_properties     rp     ON rp.id           = r.id     JOIN      content_node_position cnp_ri ON cnp_ri.child_id = r.id AND cnp_ri.is_link=0     LEFT JOIN content_node          i      ON i.id            = cnp_ri.parent_id     JOIN      content_node_position cnp_ic ON cnp_ic.child_id = cnp_ri.parent_id     JOIN      content_node          c      ON c.id            = cnp_ic.parent_id      WHERE r.type    = 'review'       AND r.deleted = 0       AND i.deleted = 0      GROUP BY r.id    '
  39. org.apache.solr.handler.dataimport.DataImportHandlerException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 13 milliseconds ago.  The last packet sent successfully to the server was 654,636 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  40.     at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:64)
  41.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:339)
  42.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.access$700(JdbcDataSource.java:228)
  43.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(JdbcDataSource.java:262)
  44.     at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:78)
  45.     at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
  46.     at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237)
  47.     at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:357)
  48.     at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
  49.     at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
  50.     at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
  51.     at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
  52.     at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
  53. Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 13 milliseconds ago.  The last packet sent successfully to the server was 654,636 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  54.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  55.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  56.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  57.     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
  58.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
  59.     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
  60.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3056)
  61.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2942)
  62.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3485)
  63.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920)
  64.     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1417)
  65.     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:422)
  66.     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:398)
  67.     at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7172)
  68.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:331)
  69.     ... 11 more
  70. Caused by: java.io.EOFException: Can not read response from server. Expected to read 780 bytes, read 726 bytes before connection was unexpectedly lost.
  71.     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2503)
  72.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
  73.     ... 19 more
  74. Jun 19, 2012 7:06:17 PM org.apache.solr.handler.dataimport.DocBuilder buildDocument
  75. SEVERE: Exception while processing: review document : SolrInputDocument[{}]
  76. org.apache.solr.handler.dataimport.DataImportHandlerException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 13 milliseconds ago.  The last packet sent successfully to the server was 654,636 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  77.     at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:64)
  78.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:339)
  79.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.access$700(JdbcDataSource.java:228)
  80.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(JdbcDataSource.java:262)
  81.     at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:78)
  82.     at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
  83.     at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237)
  84.     at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:357)
  85.     at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
  86.     at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
  87.     at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
  88.     at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
  89.     at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
  90. Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 13 milliseconds ago.  The last packet sent successfully to the server was 654,636 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  91.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  92.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  93.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  94.     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
  95.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
  96.     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
  97.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3056)
  98.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2942)
  99.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3485)
  100.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920)
  101.     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1417)
  102.     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:422)
  103.     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:398)
  104.     at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7172)
  105.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:331)
  106.     ... 11 more
  107. Caused by: java.io.EOFException: Can not read response from server. Expected to read 780 bytes, read 726 bytes before connection was unexpectedly lost.
  108.     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2503)
  109.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
  110.     ... 19 more
  111. Jun 19, 2012 7:06:17 PM org.apache.solr.handler.dataimport.DataImporter doFullImport
  112. SEVERE: Full Import failed
  113. org.apache.solr.handler.dataimport.DataImportHandlerException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 13 milliseconds ago.  The last packet sent successfully to the server was 654,636 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  114.     at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:64)
  115.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:339)
  116.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.access$700(JdbcDataSource.java:228)
  117.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(JdbcDataSource.java:262)
  118.     at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:78)
  119.     at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
  120.     at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237)
  121.     at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:357)
  122.     at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
  123.     at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
  124.     at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
  125.     at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
  126.     at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
  127. Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 13 milliseconds ago.  The last packet sent successfully to the server was 654,636 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  128.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  129.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  130.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  131.     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
  132.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
  133.     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
  134.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3056)
  135.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2942)
  136.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3485)
  137.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920)
  138.     at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1417)
  139.     at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:422)
  140.     at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:398)
  141.     at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7172)
  142.     at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:331)
  143.     ... 11 more
  144. Caused by: java.io.EOFException: Can not read response from server. Expected to read 780 bytes, read 726 bytes before connection was unexpectedly lost.
  145.     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2503)
  146.     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
  147.     ... 19 more
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top