Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.2.3
-
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]