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.

        Smart Checklist

          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