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