pentaho mysql存储库连接错误(conn:4584)

vfh0ocws  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(313)

我将carteserverv.8.1配置为在专用服务器中启用自动任务调度器。此点菜已连接到mariadb存储库，并且在服务器启动超过24小时后遇到连接套接字错误。
有人知道有没有我可以在jdbc中为mariadb配置mysql超时的文件吗？
pdi.log文件如下：

  1. 2018-10-04 08:01:02.569 INFO  <Thread-906> []  Starting entry [EXTRAE SEMANA CAMBIOS]
  2. 2018-10-04 08:01:02.685 INFO  <Thread-906> []  exec(1, 0, EXTRAE SEMANA CAMBIOS.0)
  3. 2018-10-04 08:01:02.685 INFO  <Thread-906> []  Starting job entry
  4. 2018-10-04 08:01:02.685 INFO  <Thread-906> []  Opening transformation: [null] in directory [/CONTROL CAMBIOS]
  5. 2018-10-04 08:01:02.686 INFO  <Thread-906> []  Loading transformation from repository [EXTRAE SEMANA CAMBIOS] in directory [/CONTROL CAMBIOS]
  6. 2018-10-04 08:01:02.725 ERROR <Thread-906> []  Unable to run job CONTROL CAMBIOS. The EXTRAE SEMANA CAMBIOS has an error. An error occured loading the directory tree from the repository
  8. ERROR executing query
  9. (conn:4584) Could not send query: Connection reset by peer: socket write error
  10. 2018-10-04 08:01:02.726 ERROR <Thread-906> []  org.pentaho.di.core.exception.KettleException: 
  11. An error occured loading the directory tree from the repository
  13. ERROR executing query
  14. (conn:4584) Could not send query: Connection reset by peer: socket write error
  16.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree(KettleDatabaseRepositoryDirectoryDelegate.java:108)
  17.     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadRepositoryDirectoryTree(KettleDatabaseRepository.java:608)
  18.     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.findDirectory(KettleDatabaseRepository.java:620)
  19.     at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1324)
  20.     at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:704)
  21.     at org.pentaho.di.job.Job.execute(Job.java:676)
  22.     at org.pentaho.di.job.Job.execute(Job.java:817)
  23.     at org.pentaho.di.job.Job.execute(Job.java:493)
  24.     at org.pentaho.di.job.Job.run(Job.java:380)
  25. Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
  26. ERROR executing query
  27. (conn:4584) Could not send query: Connection reset by peer: socket write error
  29.     at org.pentaho.di.core.database.Database.openQuery(Database.java:1823)
  30.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call(KettleDatabaseRepositoryConnectionDelegate.java:1599)
  31.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call(KettleDatabaseRepositoryConnectionDelegate.java:1597)
  32.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.callRead(KettleDatabaseRepositoryConnectionDelegate.java:1992)
  33.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDs(KettleDatabaseRepositoryConnectionDelegate.java:1597)
  34.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.getSubDirectoryIDs(KettleDatabaseRepositoryDirectoryDelegate.java:290)
  35.     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getSubDirectoryIDs(KettleDatabaseRepository.java:684)
  36.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree(KettleDatabaseRepositoryDirectoryDelegate.java:98)
  37.     ... 8 more
  38. Caused by: java.sql.SQLNonTransientConnectionException: (conn:4584) Could not send query: Connection reset by peer: socket write error
  39.     at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:156)
  40.     at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
  41.     at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:250)
  42.     at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
  43.     at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
  44.     at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:173)
  45.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  46.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  47.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  48.     at org.pentaho.di.core.database.Database.openQuery(Database.java:1811)
  49.     ... 15 more
  50. Caused by: java.sql.SQLException: Could not send query: Connection reset by peer: socket write error
  51.     at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:1726)
  52.     at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:223)
  53.     at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
  54.     ... 21 more
  55. Caused by: java.net.SocketException: Connection reset by peer: socket write error
  56.     at java.net.SocketOutputStream.socketWrite0(Native Method)
  57.     at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
  58.     at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
  59.     at org.mariadb.jdbc.internal.io.output.StandardPacketOutputStream.flushBuffer(StandardPacketOutputStream.java:107)
  60.     at org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream.flush(AbstractPacketOutputStream.java:175)
  61.     at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:216)
  62.     ... 22 more
  64. 2018-10-04 08:01:02.727 INFO  <Thread-906> []  Starting entry [INFORME CAMBIOS EXTRAE MAQUINAS DESCRIPCION]
  65. 2018-10-04 08:01:02.727 INFO  <Thread-906> []  exec(2, 0, INFORME CAMBIOS EXTRAE MAQUINAS DESCRIPCION.0)
  66. 2018-10-04 08:01:02.727 INFO  <Thread-906> []  Starting job entry
  67. 2018-10-04 08:01:02.727 INFO  <Thread-906> []  Opening transformation: [null] in directory [/CONTROL CAMBIOS]
  68. 2018-10-04 08:01:02.727 INFO  <Thread-906> []  Loading transformation from repository [INFORME CAMBIOS EXTRAE MAQUINAS DESCRIPCION] in directory [/CONTROL CAMBIOS]
  69. 2018-10-04 08:01:02.728 ERROR <Thread-906> []  Unable to run job CONTROL CAMBIOS. The INFORME CAMBIOS EXTRAE MAQUINAS DESCRIPCION has an error. An error occured loading the directory tree from the repository
  71. ERROR executing query
  72. execute() is called on closed statement
  73. 2018-10-04 08:01:02.728 ERROR <Thread-906> []  org.pentaho.di.core.exception.KettleException: 
  74. An error occured loading the directory tree from the repository
  76. ERROR executing query
  77. execute() is called on closed statement
  79.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree(KettleDatabaseRepositoryDirectoryDelegate.java:108)
  80.     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadRepositoryDirectoryTree(KettleDatabaseRepository.java:608)
  81.     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.findDirectory(KettleDatabaseRepository.java:620)
  82.     at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1324)
  83.     at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:704)
  84.     at org.pentaho.di.job.Job.execute(Job.java:676)
  85.     at org.pentaho.di.job.Job.execute(Job.java:817)
  86.     at org.pentaho.di.job.Job.execute(Job.java:817)
  87.     at org.pentaho.di.job.Job.execute(Job.java:493)
  88.     at org.pentaho.di.job.Job.run(Job.java:380)
  89. Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
  90. ERROR executing query
  91. execute() is called on closed statement
  93.     at org.pentaho.di.core.database.Database.openQuery(Database.java:1823)
  94.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call(KettleDatabaseRepositoryConnectionDelegate.java:1599)
  95.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call(KettleDatabaseRepositoryConnectionDelegate.java:1597)
  96.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.callRead(KettleDatabaseRepositoryConnectionDelegate.java:1992)
  97.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDs(KettleDatabaseRepositoryConnectionDelegate.java:1597)
  98.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.getSubDirectoryIDs(KettleDatabaseRepositoryDirectoryDelegate.java:290)
  99.     at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getSubDirectoryIDs(KettleDatabaseRepository.java:684)
  100.     at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree(KettleDatabaseRepositoryDirectoryDelegate.java:98)
  101.     ... 9 more
  102. Caused by: java.sql.SQLException: execute() is called on closed statement
  103.     at org.mariadb.jdbc.MariaDbStatement.executeQueryPrologue(MariaDbStatement.java:203)
  104.     at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:211)
  105.     at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
  106.     at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:173)
  107.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  108.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  109.     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  110.     at org.pentaho.di.core.database.Database.openQuery(Database.java:1811)
  111.     ... 16 more
  113. 2018-10-04 08:01:02.729 INFO  <Thread-906> []  Starting entry [COPIAR FICHEROS A REMOTO]
  114. 2018-10-04 08:01:02.729 INFO  <Thread-906> []  exec(3, 0, COPIAR FICHEROS A REMOTO.0)
  115. 2018-10-04 08:01:02.729 INFO  <Thread-906> []  Starting job entry
  116. 2018-10-04 08:01:02.730 ERROR <Thread-906> []  We can not find folder [\\tsclient\C\InformesSpoon\CAMBIOS\] !
  117. 2018-10-04 08:01:02.732 ERROR <Thread-906> []  We can not create folder [\\tsclient\C\InformesSpoon\CAMBIOS\]. Exception : org.apache.commons.vfs2.FileSystemException: Could not create folder "file:////tsclient/C/". 
  118. 2018-10-04 08:01:02.732 INFO  <Thread-906> []  Finished job entry [COPIAR FICHEROS A REMOTO] (result=[false])
  119. 2018-10-04 08:01:02.732 INFO  <Thread-906> []  Finished job entry [INFORME CAMBIOS EXTRAE MAQUINAS DESCRIPCION] (result=[false])
  120. 2018-10-04 08:01:02.732 INFO  <Thread-906> []  Finished job entry [EXTRAE SEMANA CAMBIOS] (result=[false])
  121. 2018-10-04 08:01:02.732 INFO  <Thread-906> []  exec(0, 0, START.0)
  122. 2018-10-04 08:01:02.732 INFO  <Thread-906> []  Starting job entry
  123. 2018-10-04 08:01:02.732 INFO  <Thread-906> []  CONTROL CAMBIOS
  124. 2018-10-04 10:14:43.171 WARN  <Thread-906> []  Job execution finished

提前谢谢。

mysqlpentaho-data-integration

1条答案

按热度按时间
m2xkgtsf

m2xkgtsf1#

这个错误似乎是因为文件夹名中有空格，甚至事务/作业名中也有空格。使用spoon并连接到repo，重命名trans/job（不带空格），然后移动到另一个不带空格的文件夹。

赞(0）分享  回复(0）举报  2021-06-21
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com