pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18225: chdb's s3 table function crashes postgresql with plpython3
2+ messages / 2 participants
[nested] [flat]
* BUG #18225: chdb's s3 table function crashes postgresql with plpython3
@ 2023-12-04 13:47 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2023-12-04 13:47 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: subi.the.dream.walker@gmail.com
The following bug has been logged on the website:
Bug reference: 18225
Logged by: Bing Sun
Email address: subi.the.dream.walker@gmail.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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18225: chdb's s3 table function crashes postgresql with plpython3
@ 2023-12-04 14:53 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2023-12-04 14:53 UTC (permalink / raw)
To: subi.the.dream.walker@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> 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
The useful details would have appeared *before* this message.
Look for TRAP: lines, or possibly python-generated messages.
(This could easily have been a python-internal abort, rather
than anything Postgres did.) Also there might be a stack trace.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-12-04 14:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-12-04 13:47 BUG #18225: chdb's s3 table function crashes postgresql with plpython3 PG Bug reporting form <noreply@postgresql.org>
2023-12-04 14:53 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox