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

rocksdb.add_index_inplace fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: Not 5.7, 8.0.12-2rc1
    • 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