[MCOL-4911] The second call to the stored procedure causes the Mariadb to crash Created: 2021-11-02  Updated: 2021-12-09

Status: Open
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 5.6.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: kevin Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: crash
Environment:

VM ubuntu 20.0.4 Mariadb 10.5.12
CPU-64 core, Memory-256 GB


Attachments: Text File err_log.txt     Text File my.cnf.txt    

 Description   

We have a store procedure run in sql_mode=oracle. And with the follow steps.
1. delete data form columnstore table
2. insert select into the above columnstore table
the select sql join with innodb tables
But found it always failed at the second time execution with the following error message.
-----------------------------------
211025 13:14:37 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
------------------------------------------------------

Details log and the my.cnf as the attachment..



 Comments   
Comment by Roman [ 2021-12-09 ]

kevinknjiang Could I ask you to share a simplified example of a procedure that you run with sql_mode=oracle?

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