Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Insert stuck in VSCode Jupyter Notebook #152

Open
Daniel-Robbins opened this issue Dec 14, 2023 · 0 comments
Open

Insert stuck in VSCode Jupyter Notebook #152

Daniel-Robbins opened this issue Dec 14, 2023 · 0 comments
Assignees
@auxten
Labels
bug Something isn't working Notebook Jupiter Notebook and others

Comments

@Daniel-Robbins
Copy link
Contributor

I got a wired problem while running chdb insert in local vscode jupyter notebook(not reproducing on Google Colab or raw python)

  1. Insert from INFILE and VALUES got stuck either.
  2. I have added some test code for this in test_insert_vector.py to comfirm raw python interpreter is not affected.
  3. I also comfirm Google Colab is also not affected.

I'll try to fix that after I finished #150 . No help needed, just open this issue in case I forget.

Code to reproduce:

print("start")
from chdb import session
print("Connecting to database")
chs = session.Session()
print("Creating database")
chs.query("CREATE DATABASE IF NOT EXISTS movie_embeddings ENGINE = Atomic")
print("Creating table")
chs.query("USE movie_embeddings")
chs.query('DROP TABLE IF EXISTS embeddings')
chs.query('DROP TABLE IF EXISTS embeddings_with_title')

print("Creating table with movie titles")

chs.query("""CREATE TABLE embeddings (
      movieId UInt32 NOT NULL,
      embedding Array(Float32) NOT NULL
  ) ENGINE = MergeTree()
  ORDER BY movieId""")

print("Inserting movie embeddings into the database")

# Insert from INFILE and VALUES got stuck either
# chs.query("INSERT INTO embeddings FROM INFILE 'movie_embeddings.csv' FORMAT CSV")
chs.query("INSERT INTO embeddings VALUES (1, [1,2,3,4,5,6,7,8,9,10])")
print(chs.query('SELECT * FROM embeddings LIMIT 5'))

Behavior

  1. Missing output on nobebook
  2. Got stuck on some INSERT sql

Some guess

  1. Clickhouse-local is using stdin as some input data src. But as this is chDB, stdin is not available for that.

Stack Trace

  1. As we can see, read is trying to read data from fd 0, but from result of lsof

lsof output:

COMMAND     PID USER   FD      TYPE             DEVICE   SIZE/OFF      NODE NAME
python  2389158 root  cwd       DIR              259,5       4096 130482722 /home/Clickhouse/examples
python  2389158 root  rtd       DIR              0,137       4096  74386116 /
python  2389158 root  txt       REG              0,137    5479736 113262762 /usr/bin/python3.9
python  2389158 root  mem       REG              259,5 2983710504 131533004 /home/Clickhouse/.venv/lib/python3.9/site-packages/chdb/_chdb.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      51696 113055693 /lib/x86_64-linux-gnu/libnss_files-2.31.so
python  2389158 root  mem       REG              259,5    4339232 130427785 /home/Clickhouse/.venv/lib/python3.9/site-packages/debugpy/_vendored/pydevd/_pydevd_bundle/pydevd_cython.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      71624 130426560 /home/Clickhouse/.venv/lib/python3.9/site-packages/psutil/_psutil_posix.abi3.so
python  2389158 root  mem       REG              0,137    1318776 113199131 /usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6
python  2389158 root  mem       REG              0,137      99840 113324781 /usr/lib/python3.9/lib-dynload/_sqlite3.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      30776 113061750 /usr/lib/x86_64-linux-gnu/libuuid.so.1.3.0
python  2389158 root  mem       REG              0,137      19272 113324798 /usr/lib/python3.9/lib-dynload/resource.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137     158400 113055681 /lib/x86_64-linux-gnu/liblzma.so.5.2.5
python  2389158 root  mem       REG              0,137      41568 113324775 /usr/lib/python3.9/lib-dynload/_lzma.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      74688 113055660 /lib/x86_64-linux-gnu/libbz2.so.1.0.4
python  2389158 root  mem       REG              0,137      14536 113324788 /usr/lib/python3.9/lib-dynload/_uuid.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      28352 113324757 /usr/lib/python3.9/lib-dynload/_bz2.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137     196296 113325234 /usr/lib/x86_64-linux-gnu/libmpdec.so.2.5.1
python  2389158 root  mem       REG              0,137     176384 113324771 /usr/lib/python3.9/lib-dynload/_decimal.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137     187792 113055719 /lib/x86_64-linux-gnu/libtinfo.so.6.2
python  2389158 root  mem       REG              0,137     235440 113197122 /lib/x86_64-linux-gnu/libncursesw.so.6.2
python  2389158 root  mem       REG              0,137      31080 113324799 /usr/lib/python3.9/lib-dynload/termios.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137     124320 113324768 /usr/lib/python3.9/lib-dynload/_curses.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5     107960 130426561 /home/Clickhouse/.venv/lib/python3.9/site-packages/psutil/_psutil_linux.abi3.so
python  2389158 root  mem       REG              0,137      31896 113324774 /usr/lib/python3.9/lib-dynload/_lsprof.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      67632 113324772 /usr/lib/python3.9/lib-dynload/_hashlib.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      19512 113324780 /usr/lib/python3.9/lib-dynload/_queue.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      70976 113324756 /usr/lib/python3.9/lib-dynload/_asyncio.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137    3076992 113061693 /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1
python  2389158 root  mem       REG              0,137     597792 113061736 /usr/lib/x86_64-linux-gnu/libssl.so.1.1
python  2389158 root  mem       REG              0,137     181408 113324782 /usr/lib/python3.9/lib-dynload/_ssl.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      64096 130425676 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/utils.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      51552 130425673 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/error.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      43168 130425663 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/_version.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      68256 130425661 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/_proxy_steerable.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      93160 130425670 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/_poll.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5     122976 130425662 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/message.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5     167456 130425667 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/socket.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      93208 130425680 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/context.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137     100736 113055675 /lib/x86_64-linux-gnu/libgcc_s.so.1
python  2389158 root  mem       REG              0,137    1870824 113061738 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.28
python  2389158 root  mem       REG              259,5    1225336 130425483 /home/Clickhouse/.venv/lib/python3.9/site-packages/pyzmq.libs/libsodium-6eb86948.so.23.3.0
python  2389158 root  mem       REG              0,137      35808 113055710 /lib/x86_64-linux-gnu/librt-2.31.so
python  2389158 root  mem       REG              259,5     992728 130425484 /home/Clickhouse/.venv/lib/python3.9/site-packages/pyzmq.libs/libzmq-bf11ef0c.so.5.2.4
python  2389158 root  mem       REG              259,5      76504 130425666 /home/Clickhouse/.venv/lib/python3.9/site-packages/zmq/backend/cython/_device.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      43496 113061698 /usr/lib/x86_64-linux-gnu/libffi.so.7.1.0
python  2389158 root  mem       REG              0,137      14376 113324764 /usr/lib/python3.9/lib-dynload/_contextvars.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137      14520 113324778 /usr/lib/python3.9/lib-dynload/_opcode.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              259,5      20832 130425300 /home/Clickhouse/.venv/lib/python3.9/site-packages/tornado/speedups.abi3.so
python  2389158 root  mem       REG              0,137      48808 113324773 /usr/lib/python3.9/lib-dynload/_json.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137     140536 113324766 /usr/lib/python3.9/lib-dynload/_ctypes.cpython-39-x86_64-linux-gnu.so
python  2389158 root  mem       REG              0,137     346132 113061383 /usr/lib/locale/C.UTF-8/LC_CTYPE
python  2389158 root  mem       REG              0,137    1905632 113055661 /lib/x86_64-linux-gnu/libc-2.31.so
python  2389158 root  mem       REG              0,137     113088 113060980 /lib/x86_64-linux-gnu/libz.so.1.2.11
python  2389158 root  mem       REG              0,137     186496 113197116 /lib/x86_64-linux-gnu/libexpat.so.1.6.12
python  2389158 root  mem       REG              0,137    1321344 113055682 /lib/x86_64-linux-gnu/libm-2.31.so
python  2389158 root  mem       REG              0,137      14720 113060977 /lib/x86_64-linux-gnu/libutil-2.31.so
python  2389158 root  mem       REG              0,137      18688 113055669 /lib/x86_64-linux-gnu/libdl-2.31.so
python  2389158 root  mem       REG              0,137     149520 113055706 /lib/x86_64-linux-gnu/libpthread-2.31.so
python  2389158 root  mem       REG              0,137      27002 113061671 /usr/lib/x86_64-linux-gnu/gconv/gconv-modules.cache
python  2389158 root  mem       REG              0,137     177928 113055649 /lib/x86_64-linux-gnu/ld-2.31.so
python  2389158 root    0u     unix 0x0000000000000000        0t0 511339874 type=STREAM
python  2389158 root    1w     FIFO               0,13        0t0 510594813 pipe
python  2389158 root    2w     FIFO               0,13        0t0 510594814 pipe
python  2389158 root    3u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root    4r      CHR                1,9        0t0        11 /dev/urandom
python  2389158 root    5u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root    6u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root    7u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root    8u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root    9u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   10u     IPv4          510594800        0t0       TCP localhost:9002 (LISTEN)
python  2389158 root   11u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   12u     IPv4          510594802        0t0       TCP localhost:9003 (LISTEN)
python  2389158 root   13u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   14u     IPv4          510594804        0t0       TCP localhost:9001 (LISTEN)
python  2389158 root   15u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   16u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   17u     IPv4          511296825        0t0       TCP localhost:43698->localhost:9002 (ESTABLISHED)
python  2389158 root   18u     IPv4          511296826        0t0       TCP localhost:9002->localhost:43698 (ESTABLISHED)
python  2389158 root   19w      REG              0,137      26299  78905723 /root/.vscode-server/data/logs/20231214T032209/remoteagent.log
python  2389158 root   20u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root   21w      REG              0,137          0  79135154 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/5-JSON Language Server.log
python  2389158 root   22u     unix 0x0000000000000000        0t0 510594805 type=STREAM
python  2389158 root   23u     unix 0x0000000000000000        0t0 510594806 type=STREAM
python  2389158 root   24w      REG              0,137      21689  79137392 /root/.vscode-server/data/logs/20231214T032209/exthost1/remoteexthost.log
python  2389158 root   25w      REG              0,137          0  78905724 /root/.vscode-server/data/logs/20231214T032209/network.log
python  2389158 root   26u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   27u     IPv4          510594808        0t0       TCP localhost:9004 (LISTEN)
python  2389158 root   28u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root   29w      REG              0,137      14631  79135149 /root/.vscode-server/data/logs/20231214T032209/exthost1/ms-python.python/Python.log
python  2389158 root   30u     unix 0x0000000000000000        0t0 510594809 type=STREAM
python  2389158 root   31w      REG              0,137          0  79135150 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/1-Python Test Log.log
python  2389158 root   32w      REG              0,137      33636  79135151 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/2-Jupyter.log
python  2389158 root   33w      REG              0,137          0  79135152 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/3-Jupyter Server Console.log
python  2389158 root   34w      REG              0,137     177026  79135157 /root/.vscode-server/data/logs/20231214T032209/exthost1/vscode.git/Git.log
python  2389158 root   35u     unix 0x0000000000000000        0t0 510594810 type=STREAM
python  2389158 root   36u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   37w      REG              0,137          0  79135153 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/4-remote-attach.log
python  2389158 root   38w      REG              0,137      87632  79135172 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/10-GitHub Copilot.log
python  2389158 root   39u     IPv4          510594812        0t0       TCP localhost:36157 (LISTEN)
python  2389158 root   40u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   41u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   42u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   43w      REG              0,137       1018  79135181 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/14-GitLens.log
python  2389158 root   44w      REG              0,137          0  79135173 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/12-Compare Folders.log
python  2389158 root   45u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root   46w      REG              0,137       2388  79135174 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/11-GitHub Copilot Chat.log
python  2389158 root   47u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   48u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root   49u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   50u     IPv4          510849692        0t0       TCP localhost:9000 (LISTEN)
python  2389158 root   51r     FIFO               0,13        0t0 510594813 pipe
python  2389158 root   52w     FIFO               0,13        0t0 510594813 pipe
python  2389158 root   53w      REG              0,137         31  79135171 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/9-CC++.log
python  2389158 root   54u     unix 0x0000000000000000        0t0 511339876 type=STREAM
python  2389158 root   55r     FIFO               0,13        0t0 510594814 pipe
python  2389158 root   56w      REG              0,137       1422  79135158 /root/.vscode-server/data/logs/20231214T032209/exthost1/vscode.github/GitHub.log
python  2389158 root   57w     FIFO               0,13        0t0 510594814 pipe
python  2389158 root   58u     unix 0x0000000000000000        0t0 511339878 type=STREAM
python  2389158 root   59u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root   60w      REG              0,137      11149  79135168 /root/.vscode-server/data/logs/20231214T032209/exthost1/ms-python.python/Python Language Server.log
python  2389158 root   61u     unix 0x0000000000000000        0t0 510594815 type=STREAM
python  2389158 root   62w      REG              0,137          0  79135175 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/13-LLDB.log
python  2389158 root   63w      REG              0,137        413  79135159 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/6-CMakeBuild.log
python  2389158 root   64w      REG              0,137         54  79135169 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/7-GitHub Actions.log
python  2389158 root   65u     unix 0x0000000000000000        0t0 510594816 type=STREAM
python  2389158 root   66w      REG              0,137      38376  79135165 /root/.vscode-server/data/logs/20231214T032209/exthost1/ms-python.flake8/Flake8.log
python  2389158 root   67u      REG              0,137     679936  19143046 /root/.ipython/profile_default/history.sqlite
python  2389158 root   68u      REG              0,137     679936  19143046 /root/.ipython/profile_default/history.sqlite
python  2389158 root   69u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   70u     IPv4          511296829        0t0       TCP localhost:9004->localhost:55722 (ESTABLISHED)
python  2389158 root   71w      REG              0,137       1431  79135170 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/8-Makefile tools.log
python  2389158 root   72u     IPv4          511296830        0t0       TCP localhost:9002->localhost:43722 (ESTABLISHED)
python  2389158 root   73u     IPv4          511296831        0t0       TCP localhost:9001->localhost:41722 (ESTABLISHED)
python  2389158 root   74u     IPv4          511296832        0t0       TCP localhost:9003->localhost:41172 (ESTABLISHED)
python  2389158 root   75u  a_inode               0,14          0     11195 [eventfd]
python  2389158 root   76r     FIFO               0,13        0t0 510594817 pipe
python  2389158 root   77wW     REG              0,137         61  75994145 /tmp/tmplks40xg_/status
python  2389158 root   78w     FIFO               0,13        0t0 510594817 pipe
python  2389158 root   79r      REG              0,180          0 510594825 /proc/2389158/task/2389158/schedstat
python  2389158 root   80r      REG              0,180          0 510594826 /proc/2389158/task/2389158/stat
python  2389158 root   81r      REG              0,180          0 510594827 /proc/2389158/task/2389158/io
python  2389158 root   82u  a_inode               0,14          0     11195 [eventpoll]
python  2389158 root   83r     FIFO               0,13        0t0 511419667 pipe
python  2389158 root   84w     FIFO               0,13        0t0 511419667 pipe
python  2389158 root   95w      REG              0,137       3729  79135164 /root/.vscode-server/data/logs/20231214T032209/exthost1/ms-python.autopep8/autopep8.log
python  2389158 root   96w      REG              0,137      40232  79135166 /root/.vscode-server/data/logs/20231214T032209/exthost1/ms-python.pylint/Pylint.log
python  2389158 root   97w      REG              0,137       3101  79135167 /root/.vscode-server/data/logs/20231214T032209/exthost1/ms-python.black-formatter/Black Formatter.log
python  2389158 root  104w      REG              0,137          0  79135182 /root/.vscode-server/data/logs/20231214T032209/exthost1/output_logging_20231214T032213/15-GitHub Copilot Log.log

gdb attach the running jupyter kernel, got this:

#0  __libc_read (nbytes=1048576, buf=0x7fd8cc400dc0, fd=0) at ../sysdeps/unix/sysv/linux/read.c:26
#1  __libc_read (fd=0, buf=0x7fd8cc400dc0, nbytes=1048576) at ../sysdeps/unix/sysv/linux/read.c:24
#2  0x00007fd8f39c24a9 in DB::ReadBufferFromFileDescriptor::readImpl (this=0x7ffc9e96f500, to=0x7fd8cc400dc0 '\245' <repeats 200 times>..., min_bytes=1, max_bytes=1048576, offset=0)
    at ./src/IO/ReadBufferFromFileDescriptor.cpp:76
#3  0x00007fd8f39c2896 in DB::ReadBufferFromFileDescriptor::nextImpl (this=0x7ffc9e96f500) at ./src/IO/ReadBufferFromFileDescriptor.cpp:124
#4  0x00007fd8ea9d139c in DB::ReadBuffer::next() () from /home/Clickhouse/.venv/lib/python3.9/site-packages/chdb/_chdb.cpython-39-x86_64-linux-gnu.so
#5  0x00007fd8fdac90c5 in DB::ReadBuffer::eof (this=0x7ffc9e96f500) at ./src/IO/ReadBuffer.h:104
#6  DB::ClientBase::sendData (this=0x7ffc9e96c1f0, sample=..., columns_description=..., parsed_query=...) at ./src/Client/ClientBase.cpp:1474
#7  0x00007fd8fdac8c95 in DB::ClientBase::processInsertQuery (this=0x7ffc9e96c1f0, query_to_execute=..., parsed_query=...) at ./src/Client/ClientBase.cpp:1452
#8  0x00007fd8fdac37e7 in DB::ClientBase::processParsedSingleQuery (this=0x7ffc9e96c1f0, full_query=..., query_to_execute=..., parsed_query=..., echo_query_=..., report_error=false)
    at ./src/Client/ClientBase.cpp:1881
#9  0x00007fd8fdacc997 in DB::ClientBase::executeMultiQuery (this=0x7ffc9e96c1f0, all_queries_text=...) at ./src/Client/ClientBase.cpp:2149
#10 0x00007fd8fdacddf6 in DB::ClientBase::processQueryText (this=0x7ffc9e96c1f0, text=...) at ./src/Client/ClientBase.cpp:2294
#11 0x00007fd8fdad0824 in DB::ClientBase::runNonInteractive (this=0x7ffc9e96c1f0) at ./src/Client/ClientBase.cpp:2594
#12 0x00007fd8f3a0b368 in DB::LocalServer::main (this=0x7ffc9e96c1f0) at ./programs/local/LocalServer.cpp:550
#13 0x00007fd9024a3dc5 in Poco::Util::Application::run (this=0x7ffc9e96c1f0) at ./base/poco/Util/src/Application.cpp:315
#14 0x00007fd8f3a15cc9 in pyEntryClickHouseLocal (argc=5, argv=0x7fd9154e5880) at ./programs/local/LocalServer.cpp:1039
#15 0x00007fd8f3a161fb in query_stable (argc=5, argv=0x7fd9154e5880) at ./programs/local/LocalServer.cpp:1074
#16 0x00007fd905b4babb in queryToBuffer (queryStr=..., output_format=..., path=..., udfPath=...) at ./programs/local/LocalChdb.cpp:54
#17 0x00007fd905b4bb5b in query (queryStr=..., output_format=..., path=..., udfPath=...) at ./programs/local/LocalChdb.cpp:65
#18 0x00007fd905b90fa8 in pybind11::detail::argument_loader<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&>::call_impl<query_result*, query_result* (*&)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), 0ul, 1ul, 2ul, 3ul, pybind11::detail::void_type>(query_result* (*&)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), std::__1::integer_sequence<unsigned long, 0ul, 1ul, 2ul, 3ul>, pybind11::detail::void_type&&) && (this=0x7ffc9e96fff8, 
    f=@0x7fd915d349b8: 0x7fd905b4bb20 <query(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>) at /usr/local/lib/python3.9/dist-packages/pybind11/include/pybind11/detail/../cast.h:1443
#19 0x00007fd905b90601 in pybind11::detail::argument_loader<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&>::call<query_result*, pybind11::detail::void_type, query_result* (*&)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)> (this=0x7ffc9e96fff8, 
    f=@0x7fd915d349b8: 0x7fd905b4bb20 <query(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>) at /usr/local/lib/python3.9/dist-packages/pybind11/include/pybind11/detail/../cast.h:1411
#20 0x00007fd905b90356 in pybind11::cpp_function::initialize<query_result* (*&)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), query_result*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, pybind11::name, pybind11::scope, pybind11::sibling, pybind11::arg, pybind11::arg_v, pybind11::kw_only, pybind11::arg_v, pybind11::arg_v, char [44]>(query_result* (*&)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), query_result* (*)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), pybind11::name const&, pybind11::scope const&, pybind11::sibling const&, pybind11::arg const&, pybind11::arg_v const&, pybind11::kw_only const&, pybind11::arg_v const&, pybind11::arg_v const&, char const (&) [44])::{lambda(pybind11::detail::function_call&)#1}::operator()(pybind11::detail::function_call&) const (this=0x7ffc9e97008f, call=...) at /usr/local/lib/python3.9/dist-packages/pybind11/include/pybind11/pybind11.h:248
#21 0x00007fd905b90239 in pybind11::cpp_function::initialize<query_result* (*&)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), query_result*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, pybind11::name, pybind11::scope, pybind11::sibling, pybind11::arg, pybind11::arg_v, pybind11::kw_only, pybind11::arg_v, pybind11::arg_v, char [44]>(query_result* (*&)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), query_result* (*)(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&), pybind11::name const&, pybind11::scope const&, pybind11::sibling const&, pybind11::arg const&, pybind11::arg_v const&, pybind11::kw_only const&, pybind11::arg_v const&, pybind11::arg_v const&, char const (&) [44])::{lambda(pybind11::detail::function_call&)#1}::__invoke(pybind11::detail::function_call&) (call=...) at /usr/local/lib/python3.9/dist-packages/pybind11/include/pybind11/pybind11.h:223
#22 0x00007fd905b60baf in pybind11::cpp_function::dispatcher (self=0x7fd92c3dea20, args_in=0x7fd92c380a00, kwargs_in=0x7fd92c3c8700)
    at /usr/local/lib/python3.9/dist-packages/pybind11/include/pybind11/pybind11.h:939
#23 0x000000000053f350 in ?? ()
#24 0x000000000051d89b in _PyObject_MakeTpCall ()
#25 0x0000000000517a0f in _PyEval_EvalFrameDefault ()
#26 0x00000000005106ed in ?? ()
#27 0x0000000000528d21 in _PyFunction_Vectorcall ()
#28 0x0000000000513456 in _PyEval_EvalFrameDefault ()
#29 0x00000000005106ed in ?? ()
#30 0x0000000000528d21 in _PyFunction_Vectorcall ()
#31 0x0000000000512192 in _PyEval_EvalFrameDefault ()
#32 0x00000000005106ed in ?? ()
#33 0x0000000000510497 in _PyEval_EvalCodeWithName ()
@Daniel-Robbins Daniel-Robbins added the bug Something isn't working label Dec 14, 2023
@Daniel-Robbins Daniel-Robbins self-assigned this Dec 14, 2023
@auxten auxten added the Notebook Jupiter Notebook and others label Mar 11, 2024
@auxten auxten mentioned this issue Aug 30, 2024
Open
@auxten auxten moved this to Done in chDB 2024 Q4 Sep 29, 2024
@auxten auxten closed this as completed by moving to Done in chDB 2024 Q4 Sep 29, 2024
@auxten auxten removed the status in chDB 2024 Q4 Sep 29, 2024
@auxten auxten moved this to Todo in chDB 2024 Q4 Sep 29, 2024
@auxten auxten reopened this Sep 29, 2024
@auxten auxten assigned auxten and unassigned Daniel-Robbins Sep 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@auxten auxten

Labels
bug Something isn't working Notebook Jupiter Notebook and others
Projects
chDB 2024 Q4
Status: Todo
Milestone
No milestone
Development

No branches or pull requests
2 participants
@auxten @Daniel-Robbins