Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6360

MariaDB crashes on simple insert or alter table clauses

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Duplicate
        • Affects Version/s: 10.0.11, 10.0.12
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          Fedora release 21 (Rawhide) - updates updated to Jun 18

          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

            Gliffy Diagrams

              Attachments

                Issue Links

                duplicates

                Bug - A problem which impairs or prevents the functions of the product. MDEV-6340 Mariadb 10.0.12 fatal "Lost connection" error w/ GCC 4.9 'Release' build; workaround ~ CFLAGS="-fno-delete-null-pointer-checks"

                • Major - Major loss of function.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  mikko Mikko Tiihonen added a comment -

                  cleaned up mariadb.log

                  Show
                  mikko Mikko Tiihonen added a comment - cleaned up mariadb.log
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  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.

                  Show
                  elenst Elena Stepanova added a comment - 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.
                  Hide
                  Permalink
                  mikko Mikko Tiihonen added a comment -

                  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.

                  Show
                  mikko Mikko Tiihonen added a comment - 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.
                  Hide
                  Permalink
                  mikko Mikko Tiihonen added a comment -

                  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?

                  Show
                  mikko Mikko Tiihonen added a comment - 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?
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  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.

                  Show
                  elenst Elena Stepanova added a comment - 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.
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

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

                  Show
                  elenst Elena Stepanova added a comment - Closing as a duplicate of MDEV-6340 , please comment to re-open if needed.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      mikko Mikko Tiihonen
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Due:
                        Created:
                        Updated:
                        Resolved: