BUG #18225: chdb's s3 table function crashes postgresql with plpython3

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18225: chdb's s3 table function crashes postgresql with plpython3
Дата
Msg-id 18225-9acc648b45a1a6a2@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18225: chdb's s3 table function crashes postgresql with plpython3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Orlov Aleksej
Дата:
Сообщение: RE: BUG #18223: There is a confusing result where an update statement can reference itself and execute successfully.
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: BUG #18222: Unexpected Error--Cannot delete from scalar