starudream commented on issue #17227:
URL: https://github.com/apache/doris/issues/17227#issuecomment-1463463860
> > 同一句 sql 执行多次，有可能会出现 `NoClassDefFoundError` 也有可能会返回结果
>
> you Doris version is? and could give more info `NoClassDefFoundError ` in
be.info or be.out
```log
I0301 10:21:52.822839 990 task_worker_pool.cpp:1519] successfully report
TASK|host=172.25.0.21|port=9020
I0301 10:21:54.783458 389 daemon.cpp:256] OS physical memory 19.29 GB.
Process memory usage 552.73 MB, limit 15.43 GB, soft limit 13.89 GB. Sys
available memory 17.39 GB, low water mark 1.60 GB, warning water mark 3.20 GB.
Refresh interval memory growth 0 B
I0301 10:21:56.704869 992 tablet_manager.cpp:899] find expired
transactions for 0 tablets
I0301 10:21:56.705021 992 tablet_manager.cpp:937] success to build all
report tablets info. tablet_count=0
I0301 10:21:56.706379 992 task_worker_pool.cpp:1519] successfully report
TABLET|host=172.25.0.21|port=9020
I0301 10:21:57.577124 909 olap_server.cpp:713] cooldown producer get
tablet num: 0
I0301 10:21:58.053421 1082 fragment_mgr.cpp:631] query_id:
96d496e9c1b14dc0-9d8bf35a1737fd3c coord_addr
TNetworkAddress(hostname=172.25.0.21, port=9020) total fragment num on current
host: 1
I0301 10:21:58.053676 1082 fragment_mgr.cpp:681] Register query/load memory
tracker, query/load id: 96d496e9c1b14dc0-9d8bf35a1737fd3c limit: 2.00 GB
I0301 10:21:58.053784 1082 plan_fragment_executor.cpp:88]
PlanFragmentExecutor::prepare|query_id=96d496e9c1b14dc0-9d8bf35a1737fd3c|instance_id=96d496e9c1b14dc0-9d8bf35a1737fd3d|backend_num=0|pthread_id=140082839266880
I0301 10:21:58.054855 593 fragment_mgr.cpp:492]
PlanFragmentExecutor::_exec_actual|query_id=96d496e9c1b14dc0-9d8bf35a1737fd3c|instance_id=96d496e9c1b14dc0-9d8bf35a1737fd3d|pthread_id=140086820935232
I0301 10:21:58.054947 593 plan_fragment_executor.cpp:235]
PlanFragmentExecutor::open|query_id=96d496e9c1b14dc0-9d8bf35a1737fd3c|instance_id=96d496e9c1b14dc0-9d8bf35a1737fd3d|mem_limit=2.00
GB
I0301 10:21:58.122128 754 vjdbc_connector.cpp:192] JdbcConnector::query
has exec success: SELECT "access_time" FROM "access"."access_record" LIMIT 10
W0301 10:21:58.122730 754 jni-util.cpp:193]
java.lang.NoClassDefFoundError:
org/postgresql/jdbc/TimestampUtils$ParsedTimestamp
at
org.postgresql.jdbc.TimestampUtils.parseBackendTimestamp(TimestampUtils.java:199)
at
org.postgresql.jdbc.TimestampUtils.toTimestamp(TimestampUtils.java:395)
at org.postgresql.jdbc.PgResultSet.getTimestamp(PgResultSet.java:637)
at
org.postgresql.jdbc.PgResultSet.internalGetObject(PgResultSet.java:241)
at org.postgresql.jdbc.PgResultSet.getObject(PgResultSet.java:2916)
at org.apache.doris.udf.JdbcExecutor.getBlock(JdbcExecutor.java:182)
W0301 10:21:58.122813 754 scanner_scheduler.cpp:253] Scan thread read
VScanner failed: Internal error: NoClassDefFoundError:
org/postgresql/jdbc/TimestampUtils$ParsedTimestamp
W0301 10:21:58.123072 593 fragment_mgr.cpp:395] report error status:
Internal error: NoClassDefFoundError:
org/postgresql/jdbc/TimestampUtils$ParsedTimestamp to coordinator:
TNetworkAddress(hostname=172.25.0.21, port=9020), query id:
96d496e9c1b14dc0-9d8bf35a1737fd3c, instance id:
96d496e9c1b14dc0-9d8bf35a1737fd3d
W0301 10:21:58.125828 593 fragment_mgr.cpp:251] Got error while opening
fragment 96d496e9c1b14dc0-9d8bf35a1737fd3d, query id:
96d496e9c1b14dc0-9d8bf35a1737fd3c: Internal error: NoClassDefFoundError:
org/postgresql/jdbc/TimestampUtils$ParsedTimestamp
I0301 10:21:58.125929 593 plan_fragment_executor.cpp:632]
PlanFragmentExecutor::cancel|query_id=96d496e9c1b14dc0-9d8bf35a1737fd3c|instance_id=96d496e9c1b14dc0-9d8bf35a1737fd3d|reason=3|error
message=PlanFragmentExecutor open failed
I0301 10:21:58.130532 593 plan_fragment_executor.cpp:704] Close()
fragment_instance_id=96d496e9c1b14dc0-9d8bf35a1737fd3d
I0301 10:21:58.130594 593 query_fragments_ctx.h:56] Deregister query/load
memory tracker, queryId=96d496e9c1b14dc0-9d8bf35a1737fd3c, Limit=2.00 GB,
CurrUsed=73.12 KB, PeakUsed=51.09 KB
I0301 10:21:59.799278 389 daemon.cpp:256] OS physical memory 19.29 GB.
Process memory usage 553.21 MB, limit 15.43 GB, soft limit 13.89 GB. Sys
available memory 17.39 GB, low water mark 1.60 GB, warning water mark 3.20 GB.
Refresh interval memory growth 0 B
I0301 10:22:04.814954 389 daemon.cpp:256] OS physical memory 19.29 GB.
Process memory usage 553.21 MB, limit 15.43 GB, soft limit 13.89 GB. Sys
available memory 17.39 GB, low water mark 1.60 GB, warning water mark 3.20 GB.
Refresh interval memory growth 0 B
I0301 10:22:04.824674 990 task_worker_pool.cpp:1519] successfully report
TASK|host=172.25.0.21|port=9020
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
