Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-3851

Percona Ver 5.6.39-83.1 Failing assertion: sym_node->table != NULL

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 5.7.21-20, 5.6.39-83.1
    • Fix Version/s: 5.6.41-84.1, 5.7.23-23
    • Component/s: None
    • Environment:

      Description

       

      2018-02-20 11:51:51 7f6dcd895700 InnoDB: Assertion failure in thread 140109576492800 in file pars0pars.cc line 865
      InnoDB: Failing assertion: sym_node->table != NULL
       
      Thread pointer: 0x0
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0 thread_stack 0x40000
      /usr/sbin/mysqld(my_print_stacktrace+0x3b)[0x8e8a4b]
      /usr/sbin/mysqld(handle_fatal_signal+0x471)[0x65f811]
      /lib64/libpthread.so.0(+0xf5e0)[0x7f6f81e0c5e0]
      /lib64/libc.so.6(gsignal+0x37)[0x7f6f7ff151f7]
      /lib64/libc.so.6(abort+0x148)[0x7f6f7ff168e8]
      /usr/sbin/mysqld[0xa13e76]
      /usr/sbin/mysqld(_Z7yyparsev+0x1e09)[0xb53169]
      /usr/sbin/mysqld[0xa15561]
      /usr/sbin/mysqld[0xb4eed4]
      /usr/sbin/mysqld[0xb3b632]
      /usr/sbin/mysqld[0xb3bd0e]
      /usr/sbin/mysqld(_Z23fts_optimize_sync_tablem+0x45)[0xb469c5]
      /usr/sbin/mysqld[0xb46da4]
      /lib64/libpthread.so.0(+0x7e25)[0x7f6f81e04e25]
      /lib64/libc.so.6(clone+0x6d)[0x7f6f7ffd834d]
      

       

       

      What we were doing:

      We were altering a table to add two more columns. When this is attempted, the instance can crash, and the frm file vanishes. We recover the table by re-creating it from another copy. This is repeatable, so we've been unable to modify the table any further.

       

      Since it's repeatable, I'm happy to debug more as required. Since I'm not sure what might be the cause of this crash, I'll provide what I think is helpful and I'm happy to provide more upon request.

        Smart Checklist

          Attachments

          1. alter-qa-table.sql
            0.2 kB
          2. createDatabase.sql
            0.1 kB
          3. PS3851.test
            143 kB
          4. qa_keywords.sql
            143 kB
          5. qa-table-layout.sql
            0.3 kB

            Activity

              People

              • Assignee:
                satya.bodapati Satya Bodapati
                Reporter:
                NeoThermic Ashley Pinner
              • Votes:
                3 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 27 minutes
                  27m