You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/09/30 06:18:37 UTC
[GitHub] [dolphinscheduler] siriume opened a new issue, #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
siriume opened a new issue, #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
### What happened
doris (1.0, 1,1.x, 1.2-dev), execute sql query job failed.
```
[ERROR] 2022-09-30 14:00:00.749 +0800 [taskAppId=TASK-20220930-6742655646304_15-13157-516059] TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[211] - execute sql error: Communications link failure
The last packet successfully received from the server was 108 milliseconds ago. The last packet sent successfully to the server was 108 milliseconds ago.
[ERROR] 2022-09-30 14:00:00.750 +0800 [taskAppId=TASK-20220930-6742655646304_15-13157-516059] TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[164] - sql task error
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 108 milliseconds ago. The last packet sent successfully to the server was 108 milliseconds ago.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeUpdate(SqlTask.java:305)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:202)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.handle(SqlTask.java:158)
at org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:208)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)
at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:57)
at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet successfully received from the server was 108 milliseconds ago. The last packet sent successfully to the server was 108 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
at com.mysql.cj.NativeSession.execSQL(NativeSession.java:665)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:893)
... 17 common frames omitted
Caused by: java.net.SocketException: Socket closed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
at java.io.FilterInputStream.read(FilterInputStream.java:133)
at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
... 22 common frames omitted
```
### What you expected to happen
execute SQL query job succeed every time.
### How to reproduce
doris insert odbc table to doris inner table, every 2 hour report an error. mysql 5.6, doris1.0~1.2(dev).
### Anything else
_No response_
### Version
3.0.x
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version. [dolphinscheduler]
Posted by "VanYue (via GitHub)" <gi...@apache.org>.
VanYue commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1909937868
> This bug has been fixed since version 3.1.8 #14670
Thanks
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version. [dolphinscheduler]
Posted by "VanYue (via GitHub)" <gi...@apache.org>.
VanYue commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1902855914
遇到同样的问题啊，不定期出现 Communications link failure，请问是否修复？ @siriume
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version. [dolphinscheduler]
Posted by "limuziyyds (via GitHub)" <gi...@apache.org>.
limuziyyds commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1784416164
遇到同样的问题，ds-3.1.3版本，每2h稳定触发
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] martialma commented on issue #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
Posted by "martialma (via GitHub)" <gi...@apache.org>.
martialma commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1486183164
same issue,seems to be the connection pool's configration problem,but dont know where to config.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version. [dolphinscheduler]
Posted by "Toms1999 (via GitHub)" <gi...@apache.org>.
Toms1999 commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1760713131
Has it been fixed? I also encountered the same situation in 3.0. x @siriume
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1263152635
Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
* In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
* If you haven't received a reply for a long time, you can [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] TurboWay commented on issue #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
Posted by "TurboWay (via GitHub)" <gi...@apache.org>.
TurboWay commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1406368841
Has it been fixed? I also encountered the same situation in 3.0. x @siriume
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] siriume commented on issue #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
Posted by GitBox <gi...@apache.org>.
siriume commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1272510734
> @siriume doris use proxy to connect?
proxy or not, it always errors.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] siriume closed issue #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
Posted by GitBox <gi...@apache.org>.
siriume closed issue #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
URL: https://github.com/apache/dolphinscheduler/issues/12229
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] stalary commented on issue #12229: [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version.
Posted by GitBox <gi...@apache.org>.
stalary commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1272328307
@siriume doris use proxy to connect?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version. [dolphinscheduler]
Posted by "limuziyyds (via GitHub)" <gi...@apache.org>.
limuziyyds commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1784545329
遇到同样的问题啊，2h一次，请问是否修复？@siriume
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [Worker] SQL query Error when executequery in doris after every interval, what ever jdbc version. [dolphinscheduler]
Posted by "TurboWay (via GitHub)" <gi...@apache.org>.
TurboWay commented on issue #12229:
URL: https://github.com/apache/dolphinscheduler/issues/12229#issuecomment-1909712860
This bug has been fixed since version 3.1.8 https://github.com/apache/dolphinscheduler/pull/14670
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org