Kettleエラー:Communications link failure during commit().Transaction resolution unknown.

2020 ワード

記録Kettleエラー:Communications link failure during commit().Transaction resolution unknown.
エラーメッセージ:
2019/08/12 13:09:38 -        2.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unable to commit connection(s) :org.pentaho.di.core.exception.KettleDatabaseException: 
2019/08/12 13:09:38 -        2.0 - Error comitting connection
2019/08/12 13:09:38 -        2.0 - Communications link failure during commit(). Transaction resolution unknown.
2019/08/12 13:09:38 -       2.0 -      (I=5577, O=0, R=5577, W=5577, U=5577, E=0)
2019/08/12 13:09:38 -        2.0 -      (I=0, O=0, R=0, W=0, U=0, E=1)
2019/08/12 13:09:38 -       2 -      
2019/08/12 13:09:38 -       2 -           !
2019/08/12 13:09:38 - Switch / Case.0 -      (I=0, O=0, R=5576, W=0, U=0, E=0)
2019/08/12 13:09:38 - 999_     .0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unable to commit connection(s) :org.pentaho.di.core.exception.KettleDatabaseException: 
2019/08/12 13:09:38 - 999_     .0 - Error comitting connection
2019/08/12 13:09:38 - 999_     .0 - Communications link failure during commit(). Transaction resolution unknown.
2019/08/12 13:09:38 - 999_     .0 -      (I=0, O=0, R=0, W=0, U=0, E=1)
2019/08/12 13:09:38 -     .0 -      (I=0, O=0, R=5577, W=5576, U=0, E=0)
2019/08/12 13:09:38 -       2 -      
2019/08/12 13:09:38 -       2 -           !
2019/08/12 13:09:39 -       2 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) :       !
2019/08/12 13:09:39 - Spoon -     !!
2019/08/12 13:09:39 -       2 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) :       !
2019/08/12 13:09:39 -       2 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) :       !

実はデータベースの問題で、データベースはsqlを実行します:SHOW VARIABLES like'%timeout%'、データベースの設定のタイムアウト時間を見て、実行します
SET GLOBAL interactive_timeout = 288000;
SET GLOBAL wait_timeout = 288000;
データベースのこの2つのタイムアウト時間を大きくすればいいです.