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

rocksdb.add_index_inplace fails

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Fixed
    • 8.0.12-2rc1, Not 5.7.x
    • 8.0.13-3
    • MyRocks

    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

              george.lorch George Lorch (Inactive)
              george.lorch George Lorch (Inactive)
              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