16601746291 opened a new issue, #18837: URL: https://github.com/apache/doris/issues/18837
### 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 Doris version doris-1.2.3 java version "11.0.15.1" 2022-04-22 LTS postgresql-42.6.0.jar ### What's Wrong? doris version Doris-1.2.3-rc02-unknown Place postgresql-42.6.0.jar in the jdbc_drivers directory of the fe, be node The dim_date table in the postgresql library has the following DDL, with no special attribute fields, and is the most common varchar type: create table dim_date ( yyyymmdd varchar ); Next I tried to read the dim_date table in postgresql from the doris library (I encrypted the information to create the CATALOG). mysql> CREATE CATALOG jdbc_pg PROPERTIES ( "type"="jdbc", "user"="***", "password"="******", "jdbc_url" = "jdbc:postgresql://******:5432/test_pg", "driver_url" = "postgresql-42.6.0.jar", "driver_class" = "org.postgresql.Driver" ); mysql> SHOW CATALOGS; +-----------+-------------+----------+-----------+ | CatalogId | CatalogName | Type | IsCurrent | +-----------+-------------+----------+-----------+ | 0 | internal | internal | yes | | 102015 | jdbc_pg | jdbc | | +-----------+-------------+----------+-----------+ 2 rows in set (0.02 sec) mysql> SWITCH jdbc_pg; Query OK, 0 rows affected (0.01 sec) mysql> use public; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +------------------------------------+ | Tables_in_public | +------------------------------------+ | bak_table | | base_camb_reservation | | camb_channel_reservation | | camb_channel_reservation_daily | | camb_channel_reservation_daily_1 | | camb_channel_reservation_summary | | camb_channel_reservation_summary_1 | | camb_reservation_forcast_summary | | camb_snapshot_reservations_details | | dim_date | +------------------------------------+ mysql> select * from jdbc_pg.public.dim_date limit 5; ERROR 1105 (HY000): RpcException, msg: org.apache.doris.rpc.RpcException: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason mysql> select * from jdbc_pg.public.dim_date limit 5; ERROR 1105 (HY000): errCode = 2, detailMessage = There is no scanNode Backend available.[11001: not alive, 11002: not alive] At this point, the be node has been suspended, and the loginfo at the end of the be.out file is as follows: WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance. *** Query id: 0-0 *** *** Aborted at 1681919404 (unix time) try "date -d @1681919404" if you are using GNU date *** *** Current BE git commitID: Unknown *** *** SIGSEGV address not mapped to object (@0x100000) received by PID 1188 (TID 0x7f02968a0700) from PID 1048576; stack trace: *** 0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /root/doris/be/src/common/signal_handler.h:420 1# os::Linux::chained_handler(int, siginfo*, void*) in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 2# JVM_handle_linux_signal in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 3# signalHandler(int, siginfo*, void*) in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 4# 0x00007F02C34744C0 in /lib/x86_64-linux-gnu/libc.so.6 5# jemalloc_usable_size at ../src/jemalloc.c:3740 6# free at /root/doris/be/src/runtime/memory/jemalloc_hook.cpp:43 7# __pthread_create_2_1 at /build/glibc-e6zv40/glibc-2.23/nptl/pthread_create.c:539 8# os::create_thread(Thread*, os::ThreadType, unsigned long) in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 9# CompilerThread::CompilerThread(CompileQueue*, CompilerCounters*) in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 10# CompileBroker::make_thread(_jobject*, CompileQueue*, AbstractCompiler*, Thread*) in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 11# CompileBroker::possibly_add_compiler_threads() in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 12# CompileBroker::compiler_thread_loop() in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 13# JavaThread::run() in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 14# Thread::call_run() in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 15# thread_native_entry(Thread*) in /usr/jvm/jdk-11.0.15.1/lib/server/libjvm.so 16# start_thread at /build/glibc-e6zv40/glibc-2.23/nptl/pthread_create.c:333 17# clone in /lib/x86_64-linux-gnu/libc.so.6 ### What You Expected? What happened? Why just hang the node without specifying the reason? I also tried different jdbc jars, such as postgresql-42.5.1.jar, postgresql-42.3.4.jar, and they all had the same error ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### 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-unsubscr...@doris.apache.org.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
