Using session.query("insert xxx") will stuck

[DanielMao1]

(you don't have to strictly follow this form)

Describe the situation What exactly works slower than expected?

How to reproduce

• Which ClickHouse server version to use: chdb 2.0.2 code from: https://github.com/chdb-io/chdb/blob/main/tests/test_stateful.py

  
  from chdb import session as chs

Create DB, Table, View in temp session, auto cleanup when session is deleted.

sess = chs.Session() sess.query("CREATE DATABASE IF NOT EXISTS db_xxx ENGINE = Atomic") sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_xxx (x String, y Int) ENGINE = Log;") sess.query("INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);") sess.query( "CREATE VIEW db_xxx.view_xxx AS SELECT FROM db_xxx.log_table_xxx LIMIT 4;" ) print("Select from view:\n") print(sess.query("SELECT FROM db_xxx.view_xxx", "Pretty"))

**Expected performance**
This code should work but it stucked on `sess.query("INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);")`

**Additional context**
`uname -a` shows:

Linux ip-172-xx-xx-xx 5.19.0-1029-aws #30~22.04.1-Ubuntu SMP Thu Jul 13 17:17:32 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux

[auxten]

Can't reproduce on my Linux. Please open debug log by using:

sess.query("INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);", "Debug")

and give me the log

[l1t1]

good in my environment

root@localhost:~# python3
Python 3.10.12 (main, Nov 20 2023, 15:14:05) [GCC 11.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> from chdb import session as chs
>>>
>>> ## Create DB, Table, View in temp session, auto cleanup when session is deleted.
>>> sess = chs.Session()
>>> sess.query("CREATE DATABASE IF NOT EXISTS db_xxx ENGINE = Atomic")

>>> sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_xxx (x String, y Int) ENGINE = Log;")

>>> sess.query("INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);")

>>> sess.query(
...     "CREATE VIEW db_xxx.view_xxx AS SELECT * FROM db_xxx.log_table_xxx LIMIT 4;"
... )

>>> print("Select from view:\n")
Select from view:

>>> print(sess.query("SELECT * FROM db_xxx.view_xxx", "Pretty"))
   ┏━━━┳━━━┓
   ┃ x ┃ y ┃
   ┡━━━╇━━━┩
1. │ a │ 1 │
   ├───┼───┤
2. │ b │ 3 │
   ├───┼───┤
3. │ c │ 2 │
   ├───┼───┤
4. │ d │ 5 │
   └───┴───┘

[DanielMao1]

@auxten @l1t1 Thank you for your apply! I tested it again and I found the "stuck" only appears when I using jupyter notebook in vscode (jupyter notebook in web interface is OK, strange to me):

[auxten]

Oh, I see. It's a known issue #152