You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "16601746291 (via GitHub)" <gi...@apache.org> on 2023/04/19 16:10:49 UTC
[GitHub] [doris] 16601746291 opened a new issue, #18837: [Bug] postgresql - CATALOG cannot get data
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-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] 16601746291 commented on issue #18837: [Bug] postgresql - CATALOG cannot get data
Posted by "16601746291 (via GitHub)" <gi...@apache.org>.
16601746291 commented on issue #18837:
URL: https://github.com/apache/doris/issues/18837#issuecomment-1528804488
that OK,Thanks
--
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
[GitHub] [doris] 16601746291 commented on issue #18837: [Bug] postgresql - CATALOG cannot get data
Posted by "16601746291 (via GitHub)" <gi...@apache.org>.
16601746291 commented on issue #18837:
URL: https://github.com/apache/doris/issues/18837#issuecomment-1515738331
> Try using jdk8
Thanks, which I'll try later, by the way, Are you in the same situation? Since my initial installation was doris1.0.0, which was based on source code compilation, I had to be java11 to start the node, which led me to use java11
--
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
[GitHub] [doris] liujiwen-up commented on issue #18837: [Bug] postgresql - CATALOG cannot get data
Posted by "liujiwen-up (via GitHub)" <gi...@apache.org>.
liujiwen-up commented on issue #18837:
URL: https://github.com/apache/doris/issues/18837#issuecomment-1515633714
Try using jdk8
--
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
[GitHub] [doris] liujiwen-up commented on issue #18837: [Bug] postgresql - CATALOG cannot get data
Posted by "liujiwen-up (via GitHub)" <gi...@apache.org>.
liujiwen-up commented on issue #18837:
URL: https://github.com/apache/doris/issues/18837#issuecomment-1515747577
>
had a similar situation
--
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
[GitHub] [doris] zy-kkk closed issue #18837: [Bug] postgresql - CATALOG cannot get data
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk closed issue #18837: [Bug] postgresql - CATALOG cannot get data
URL: https://github.com/apache/doris/issues/18837
--
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