[MCOL-3560] reporting queries causing CS to use up significant memory until mariadb service restarts Created: 2019-10-14  Updated: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2.3
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Isaac Venn (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Client is running large reports on the weekends (and occasionally during the week. Sometimes when these reports run, the columnstore instance appears to use up all available memory in the system and the mariadb instance shuts down with a sig 11 and restarts. Here is the stacktrace discovered:

/usr/local/mariadb/columnstore/mysql//bin/mysqld(handle_fatal_signal+0x33f)[0x55987f6b06ff]
/lib64/libpthread.so.0(+0xf5d0)[0x7f66903fb5d0]
/usr/local/mariadb/columnstore/mysql/lib/plugin/libcalmysql.so(_Z32ha_calpont_impl_write_batch_row_PhP5TABLERN11cal_impl_if19cal_connection_infoE+0x11e9)[0x7f6667d516b9]
/usr/local/mariadb/columnstore/mysql/lib/plugin/libcalmysql.so(_Z25ha_calpont_impl_write_rowPhP5TABLE+0x1c8)[0x7f6667d2a948]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN7handler12ha_write_rowEPh+0x1a7)[0x55987f6bafd7]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x66)[0x55987f4d7f26]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN13select_insert9send_dataER4ListI4ItemE+0xe5)[0x55987f4d8aa5]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(+0x5d40af)[0x55987f5490af]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(+0x5b9917)[0x55987f52e917]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x17e)[0x55987f53827e]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN4JOIN10exec_innerEv+0xa86)[0x55987f558856]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN4JOIN4execEv+0x29)[0x55987f558a79]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1ce)[0x55987f558c8e]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1bb)[0x55987f55983b]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z21mysql_execute_commandP3THD+0x6c04)[0x55987f509154]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x1d2)[0x55987f509fa2]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z18idb_vtable_processP3THDyP9Statement+0x231a)[0x55987f50ceba]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x12c5)[0x55987f50e905]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z10do_commandP3THD+0xd8)[0x55987f50ff28]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z11tp_callbackP13TP_connection+0xbf)[0x55987f60a8cf]
/usr/local/mariadb/columnstore/mysql//bin/mysqld(+0x7137be)[0x55987f6887be]
/lib64/libpthread.so.0(+0x7dd5)[0x7f66903f3dd5]
/lib64/libc.so.6(clone+0x6d)[0x7f668e39fead]



 Comments   
Comment by Isaac Venn (Inactive) [ 2019-10-14 ]

Going to attempt to get the client to send us the queries that are running when the restarts happen.

Generated at Thu Feb 08 02:43:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.