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.

        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