You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "lvshaokang (via GitHub)" <gi...@apache.org> on 2023/06/08 10:05:21 UTC
[GitHub] [doris] lvshaokang opened a new issue, #20603: [Bug] Mysqlload publish timeout caused npe
lvshaokang opened a new issue, #20603:
URL: https://github.com/apache/doris/issues/20603
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
master latest
### What's Wrong?
mysql load execute regression test get null msg
```
2023-06-08 12:22:08.589 ERROR [suite-thread-1] (ScriptContext.groovy:121) - Run test_mysql_load_tiny_file in /home/work/pipline/OpenSourceDoris/clusterRegressionCenter/P0/Cluster7/regression-test/suites/load_p0/mysql_load/test_mysql_load_tiny_file.groovy failed
java.sql.SQLException: Unexpected exception: null
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
at java_sql_PreparedStatement$execute.call(Unknown Source)
at org.apache.doris.regression.util.JdbcUtils$_executeToList_closure1.doCall(JdbcUtils.groovy:31)
at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:107)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:263)
```
fe msg
```
2023-06-08 12:22:08,587 WARN (mysql-nio-pool-16|7993) [MysqlLoadManager.executeMySqlLoadJobFromStmt():193] Execute mysql load 3fdfffca-9f57-4ab2-8dcf-05fdd794363a failed
java.lang.NullPointerException: null
at org.apache.doris.load.loadv2.MysqlLoadManager.executeMySqlLoadJobFromStmt(MysqlLoadManager.java:184) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.load.loadv2.MysqlLoadManager.executeMySqlLoadJobFromStmt(MysqlLoadManager.java:152) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.handleLoadStmt(StmtExecutor.java:2080) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:718) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:438) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:409) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:432) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:579) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:817) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[?:1.8.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[?:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_131]
```
be msg
```
W0608 12:21:50.815456 17653 stream_load_executor.cpp:399] commit transaction failed, errmsg=[PUBLISH_TIMEOUT]transaction commit successfully, BUT data will be visible later, id=df41e2a512f3fc6d-c5ac0f0bd26d7490, job_id=-1, txn_id=4433, label=4d9ed0e9-3d45-4b21-903d-b2650e6f54ce, elapse(s)=8
W0608 12:22:08.514400 17646 stream_load_executor.cpp:399] commit transaction failed, errmsg=[PUBLISH_TIMEOUT]transaction commit successfully, BUT data will be visible later, id=9f499e89715d4b76-035c55637097b5bb, job_id=-1, txn_id=4435, label=10bfef75-4b56-4785-9b46-75d9dcf1ff06, elapse(s)=11
```
### What You Expected?
return err msg, instead of null
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] 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@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] dataroaring closed issue #20603: [Bug] Mysqlload publish timeout caused npe
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed issue #20603: [Bug] Mysqlload publish timeout caused npe
URL: https://github.com/apache/doris/issues/20603
--
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@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org