[MDEV-15187] MariaDB crashes when running a stored procedure Created: 2018-02-03  Updated: 2018-02-03  Resolved: 2018-02-03

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Insert, Data Manipulation - Update, Stored routines
Affects Version/s: 10.1.30, 10.2.12
Fix Version/s: 10.1.31, 10.2.13

Type: Bug Priority: Critical
Reporter: Bryce Lowe Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS Linux release 7.4.1708 (Core)
MariaDB 10.2.12 installed using the MariaDB YUM repositories (machine # 1)
MariaDB 10.1.30 installed using the MariaDB YUM repositories (machine # 2)


Attachments: Text File mysql-error.log    
Issue Links:
Duplicate
duplicates MDEV-14857 problem with 10.2.11 server crashing ... Closed

 Description   

I am in the process of testing our dataset for a migration from MariaDB 10.0.33 to MariaDB 10.2.12.

During this testing I have run into a problem blocking me from upgrading to the 10.2 branch (I am also seeing the same behavior on the 10.1 branch as well).

When I run my stored procedure (this procedure is quite long and takes over an hour to run even when it is successful) the mysqld process crashes and restarts itself. I have noted this behavior on MariaDB 10.1.30 and 10.2.12.

My procedure works correctly on MariaDB 10.0.33 on CentOS 7 (my production environment) and I have been able to get it to work correctly on MariaDB 10.2.8 on Windows 10 (a development environment).

I am attaching some of the instances of what is being put into the mysql-error.log file. Please let me know if you require any additional information.



 Comments   
Comment by Elena Stepanova [ 2018-02-03 ]

This is the same problem as MDEV-14857. The bug fix will be released in 10.1.31 and 10.2.13.

Generated at Thu Feb 08 08:19:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.