Error updating batch
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:
2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt
atement.java:1129)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
Statement.java:681)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :
1368)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :
1283)
at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedSta
tement.java:602)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(Table
Output.java:301)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOu
tput.java:116)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Thread.java:636)


** END NESTED EXCEPTION **



Last packet sent to the server was 6 ms ago.

org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput..java :
390)
org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:
1 16)
org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
java.lang.Thread.run(Thread.java:636)

ERROR 11-05 20:15:13,455 - Insertion dans table historique prospection
- Unexpec ted error
committing the database connection.
ERROR 11-05 20:15:13,455 - chargementFichier - Erreurs détectées!
ERROR 11-05 20:15:13,455 - Insertion dans table historique prospection
- java.la
ng.NullPointerException
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement..java :
541)
org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:
1443)
org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:
625)
org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
java.lang.Thread.run(Thread.java:636)

ERROR 11-05 20:15:13,456 - chargementFichier - Erreurs détectées!
ERROR 11-05 20:15:13,456 - Insertion dans table historique prospection
- java.la
ng.NullPointerException
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement..java :
541)
org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:
1443)
org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:
625)
org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
java.lang.Thread.run(Thread.java:636)

ERROR 11-05 20:15:13,456 - Insertion dans table historique prospection
- Unexpec ted error
rolling back the database connection.
ERROR 11-05 20:15:13,457 - Insertion dans table historique prospection
- org.pen
taho.di.core.exception.KettleDatabaseException:
Error performing rollback on connection
No operations allowed after connection closed.Connection was
implicitly closed d ue to
underlying exception/error:


** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:
153)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:
82 )
at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:
4913)
at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
at
org.pentaho.di.core.database.Database.rollback(Database.java:707)
at
org.pentaho.di.core.database.Database.rollback(Database.java:692)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(Table
Output.java:381)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOu
tput.java:116)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Thread.java:636)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure
due to under lying
exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:
153)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:
82 )
at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:
4913)
at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
at
org.pentaho.di.core.database.Database.rollback(Database.java:707)
at
org.pentaho.di.core.database.Database.rollback(Database.java:692)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(Table
Output.java:381)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOu
tput.java:116)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Thread.java:636)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2757)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:
4913)
at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
at
org.pentaho.di.core.database.Database.rollback(Database.java:707)
at
org.pentaho.di.core.database.Database.rollback(Database.java:692)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(Table
Output.java:381)
at
org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOu
tput.java:116)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Thread.java:636)


** END NESTED EXCEPTION **


org.pentaho.di.core.database.Database.rollback(Database.java:718)
org.pentaho.di.core.database.Database.rollback(Database.java:692)
org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:
675)
org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
java.lang.Thread.run(Thread.java:636)

--
You received this message because you are subscribed to the Google Groups "kettle-developers" group.
To post to this group, send email to kettle-developers (AT) googlegroups (DOT) com.
To unsubscribe from this group, send email to kettle-developers+unsubscribe (AT) g...oups (DOT) com.
For more options, visit this group at http://groups.google.com/group/kettle-developers?hl=en.