starudream commented on issue #17227:
URL: https://github.com/apache/doris/issues/17227#issuecomment-1463470667

   But now I can't reproduce the problem, but a similar problem occurs 
`java.lang.NoClassDefFoundError: 
org/postgresql/jdbc/PgResultSet$CursorResultHandler`, I think it's the same 
problem.
   
   
   ```log
   I0310 16:49:13.499743  1160 plan_fragment_executor.cpp:88] 
PlanFragmentExecutor::prepare|query_id=6736dececf634b08-97642053c9819ba5|instance_id=6736dececf634b08-97642053c9819ba6|backend_num=0|pthread_id=139619959707200
   I0310 16:49:13.501332   626 fragment_mgr.cpp:492] 
PlanFragmentExecutor::_exec_actual|query_id=6736dececf634b08-97642053c9819ba5|instance_id=6736dececf634b08-97642053c9819ba6|pthread_id=139624070153792
   I0310 16:49:13.501448   626 plan_fragment_executor.cpp:235] 
PlanFragmentExecutor::open|query_id=6736dececf634b08-97642053c9819ba5|instance_id=6736dececf634b08-97642053c9819ba6|mem_limit=2.00
 GB
   I0310 16:49:14.134461   681 vjdbc_connector.cpp:192] JdbcConnector::query 
has exec success: SELECT "id", "tenant_id", "created_at", "updated_at", 
"deleted_at", "event_id", "device_code", "design_code", "card_no", 
"custom_card_no", "user_account", "user_id", "user_name", "department_id", 
"department_name", "space_code", "access_time", "result", "direction", 
"comment", "building_code", "building_id", "floor_id", "floor_code" FROM 
"access"."access_record"
   I0310 16:49:14.253479   626 plan_fragment_executor.cpp:704] Close() 
fragment_instance_id=6736dececf634b08-97642053c9819ba6
   I0310 16:49:14.253562   626 query_fragments_ctx.h:56] Deregister query/load 
memory tracker, queryId=6736dececf634b08-97642053c9819ba5, Limit=2.00 GB, 
CurrUsed=118.66 KB, PeakUsed=2.11 MB
   I0310 16:49:16.032743  1062 tablet_manager.cpp:899] find expired 
transactions for 0 tablets
   I0310 16:49:16.032932  1062 tablet_manager.cpp:937] success to build all 
report tablets info. tablet_count=24
   I0310 16:49:16.035373  1062 task_worker_pool.cpp:1519] successfully report 
TABLET|host=172.25.0.21|port=9020
   I0310 16:49:16.489935   413 daemon.cpp:256] OS physical memory 31.10 GB. 
Process memory usage 789.90 MB, limit 24.88 GB, soft limit 22.39 GB. Sys 
available memory 25.46 GB, low water mark 1.60 GB, warning water mark 3.20 GB. 
Refresh interval memory growth 0 B
   I0310 16:49:17.102592  1060 task_worker_pool.cpp:1519] successfully report 
TASK|host=172.25.0.21|port=9020
   I0310 16:49:20.600450  1161 fragment_mgr.cpp:631] query_id: 
6b0329d5091d4c31-8f42078ff9907a60 coord_addr 
TNetworkAddress(hostname=172.25.0.21, port=9020) total fragment num on current 
host: 1
   I0310 16:49:20.600548  1161 fragment_mgr.cpp:681] Register query/load memory 
tracker, query/load id: 6b0329d5091d4c31-8f42078ff9907a60 limit: 2.00 GB
   I0310 16:49:20.600608  1161 plan_fragment_executor.cpp:88] 
PlanFragmentExecutor::prepare|query_id=6b0329d5091d4c31-8f42078ff9907a60|instance_id=6b0329d5091d4c31-8f42078ff9907a61|backend_num=0|pthread_id=139619951314496
   I0310 16:49:20.601651   636 fragment_mgr.cpp:492] 
PlanFragmentExecutor::_exec_actual|query_id=6b0329d5091d4c31-8f42078ff9907a60|instance_id=6b0329d5091d4c31-8f42078ff9907a61|pthread_id=139623986226752
   I0310 16:49:20.601711   636 plan_fragment_executor.cpp:235] 
PlanFragmentExecutor::open|query_id=6b0329d5091d4c31-8f42078ff9907a60|instance_id=6b0329d5091d4c31-8f42078ff9907a61|mem_limit=2.00
 GB
   W0310 16:49:20.606506   681 jni-util.cpp:193] 
java.lang.NoClassDefFoundError: 
org/postgresql/jdbc/PgResultSet$CursorResultHandler
        at org.postgresql.jdbc.PgResultSet.next(PgResultSet.java:2143)
        at org.apache.doris.udf.JdbcExecutor.hasNext(JdbcExecutor.java:203)
   W0310 16:49:20.606792   636 fragment_mgr.cpp:395] report error status: 
Internal error: NoClassDefFoundError: 
org/postgresql/jdbc/PgResultSet$CursorResultHandler to coordinator: 
TNetworkAddress(hostname=172.25.0.21, port=9020), query id: 
6b0329d5091d4c31-8f42078ff9907a60, instance id: 
6b0329d5091d4c31-8f42078ff9907a61
   W0310 16:49:20.609669   636 fragment_mgr.cpp:251] Got error while opening 
fragment 6b0329d5091d4c31-8f42078ff9907a61, query id: 
6b0329d5091d4c31-8f42078ff9907a60: Internal error: NoClassDefFoundError: 
org/postgresql/jdbc/PgResultSet$CursorResultHandler
   I0310 16:49:20.609745   636 plan_fragment_executor.cpp:632] 
PlanFragmentExecutor::cancel|query_id=6b0329d5091d4c31-8f42078ff9907a60|instance_id=6b0329d5091d4c31-8f42078ff9907a61|reason=3|error
 message=PlanFragmen
   ```


-- 
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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to