[MDEV-6360] MariaDB crashes on simple insert or alter table clauses Created: 2014-06-18  Updated: 2014-06-19  Due: 2014-07-02  Resolved: 2014-06-19

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.11, 10.0.12
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Mikko Tiihonen Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Fedora release 21 (Rawhide) - updates updated to Jun 18

Attachments: Text File gdb.backtrace.allthreads.txt     Text File gdb.backtrace.txt     File mariadb.log    
Issue Links:
Duplicate
duplicates MDEV-6340 Mariadb 10.0.12 fatal "Lost connectio... Closed

 Description   

When using software that do automatic DDL changes they keep crashing always after a few alter table statements. Although I have seen crashes also in insert clauses.

Example crash for which I have provided gdb backtrace executed this statement:

ALTER TABLE paymenttransactions ADD COLUMN p_debtcollectableamount DECIMAL(30,8) AFTER p_refund

 Comments   
Comment by Mikko Tiihonen [ 2014-06-18 ]

cleaned up mariadb.log

Comment by Elena Stepanova [ 2014-06-18 ]

Is it a binary provided by Fedora, or do you build it on your own?
Either way, do you happen to know which compiler was used (which gcc version)?
We've had a complaint about MariaDB built with gcc 4.9 which looks similar, crashes in seemingly random places, see MDEV-6340.
If you're building from sources, you could check if the suggested workaround works for you.

Comment by Mikko Tiihonen [ 2014-06-18 ]

Rawhide provided 10.0.11, I build my own rpm for 10.0.12 by downloading the sources and modifying the .spec file.

I'll try to add the gcc 4.9 workaroud and report back if it works.

Comment by Mikko Tiihonen [ 2014-06-18 ]

Thank you for your help. Adding -fno-delete-null-pointer-checks to the build fixed the crashes.

I'll submit a request for Fedora to enable the switch for the build.
Or are you releasing 10.0.12 anytime soon with the workaround or proper fixes?

Comment by Elena Stepanova [ 2014-06-18 ]

We have already released 10.0.12 and it doesn't contain a workaround/fix for this. I can't say right now whether 10.0.13 will, so maybe asking Fedora to consider using the workaround is a good idea.

Comment by Elena Stepanova [ 2014-06-19 ]

Closing as a duplicate of MDEV-6340, please comment to re-open if needed.

Generated at Thu Feb 08 07:11:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.