mysql - Pentaho 作业通信失败

Question

运行 Pentaho 作业时出现以下错误:

2015/03/27 19:15:44 - HistoriePersonenObject.0 - Couldn't get row from result set
2015/03/27 19:15:44 - HistoriePersonenObject.0 - Communications link failure
2015/03/27 19:15:44 - HistoriePersonenObject.0 -
2015/03/27 19:15:44 - HistoriePersonenObject.0 - The last packet successfully received from the server was 0 milliseconds ago.  The last packet sent successfully to the server was 1,580,751 milliseconds ago.
2015/03/27 19:15:44 - HistoriePersonenObject.0 -
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at org.pentaho.di.core.database.Database.getRow(Database.java:2398)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at org.pentaho.di.core.database.Database.getRow(Database.java:2368)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at java.lang.Thread.run(Thread.java:745)
2015/03/27 19:15:44 - HistoriePersonenObject.0 - Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
2015/03/27 19:15:44 - HistoriePersonenObject.0 -
2015/03/27 19:15:44 - HistoriePersonenObject.0 - The last packet successfully received from the server was 0 milliseconds ago.  The last packet sent successfully to the server was 1,580,751 milliseconds ago.
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1433)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:416)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:395)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7165)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at org.pentaho.di.core.database.Database.getRow(Database.java:2386)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        ... 4 more
2015/03/27 19:15:44 - HistoriePersonenObject.0 - Caused by: java.io.EOFException: Can not read response from server. Expected to read 209 bytes, read 160 bytes before connection was unexpectedly lost.
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3046)
2015/03/27 19:15:44 - HistoriePersonenObject.0 -        ... 12 more
2

这一步是将数据保存到 MySQL 表中。同时从同一个 MySQL 数据库中读取许多其他表。可能导致此错误的原因是什么？

Answer 1

在我的例子中，我需要在我的数据库连接上激活连接池。

转到 spoon 中的数据库连接配置。在左侧选择池并选中 Enable Connection Pooling 复选框。