From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | subi(dot)the(dot)dream(dot)walker(at)gmail(dot)com |
Subject: | BUG #18225: chdb's s3 table function crashes postgresql with plpython3 |
Date: | 2023-12-04 13:47:24 |
Message-ID: | 18225-9acc648b45a1a6a2@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18225
Logged by: Bing Sun
Email address: subi(dot)the(dot)dream(dot)walker(at)gmail(dot)com
PostgreSQL version: 16.0
Operating system: AlmaLinux-9.2
Description:
Hi,
I am playing around chdb (https://github.com/chdb-io/chdb) which is an
embedded clickhouse engine. The python binding of chdb enables the usage
with plpython3.
The following anonymous block causes a server termination:
=======
do language plpython3u $$
import chdb
chdb.query(sql='''select * from
s3('https://datasets-documentation.s3.eu-west-3.amazonaws.com/aapl_stock.csv')
limit 10''')
$$
=======
The related logs:
=======
2023-12-04 13:36:28.086 UTC [3202531] LOG: server process (PID 3216826) was
terminated by signal 6: Aborted
2023-12-04 13:36:28.086 UTC [3202531] DETAIL: Failed process was running:
do language plpython3u $$
import chdb
chdb.query(sql='''select * from
s3('https://datasets-documentation.s3.eu-west-3.amazonaws.com/aapl_stock.csv')
limit 10''')
$$
2023-12-04 13:36:28.086 UTC [3202531] LOG: terminating any other active
server processes
2023-12-04 13:36:28.087 UTC [3202531] LOG: all server processes terminated;
reinitializing
=======
I've experimented just fine with several other features, e.g., queries &
file table function.
I am not sure if here is the right place to raise the issue. I've reported
on the github repo (https://github.com/chdb-io/chdb/issues/139) but it seems
not a chdb issue because the query runs fine within a chdb python session.
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-12-04 13:50:16 | Re: BUG #18222: Unexpected Error--Cannot delete from scalar |
Previous Message | Orlov Aleksej | 2023-12-04 12:51:22 | RE: BUG #18223: There is a confusing result where an update statement can reference itself and execute successfully. |