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

rocksdb.add_index_inplace fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: 8.0.12-2rc1, Not 5.7.x
    • Fix Version/s: 8.0.13-3
    • Component/s: MyRocks
    • Labels:

      Description

      This is new to 8.0, pre-dates 8.0.13 merge but is know to have been passing on 8.0 in the past.

      mysqltest: At line 261: query 'ALTER TABLE t1 ADD INDEX ka(a), ALGORITHM=INPLACE' failed: 50012: MyRocks failed populating secondary key during alter.
      

      And from the error log

      2018-12-12T22:06:11.641761Z 8 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'Chunk size is too small to process merge.'
      2018-12-12T22:06:11.641789Z 8 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'Error during preparation of heap.'
      2018-12-12T22:06:11.641803Z 8 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'Error while bulk loading keys in external merge sort.'
      

      It is currently unknown if these errors in the server error log correlate with the failing query.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              george.lorch George Lorch
              Reporter:
              george.lorch George Lorch
              Votes:
              0 Vote for this issue
              Watchers:
              3 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 - 3 hours, 52 minutes
                  3h 52m

                    Smart Checklist