Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8572

corrupted table and stale .TMM file during optimize

        Details

          Description

          Hi,
          we migrated all db server form mysql 5.1 to mariadb 10.0.19 and now we found randomly after optimize of all dbs weekly with command
          mysqlcheck --auto-repair --flush -Ao
          we find a corrupted myisam tables (before optimize we are sure that tables are ok because no log is present in optimize log that warn about problem on table) and a relative .tmm file.
          We have to delete .tmm file and repair the table because if mysqlcheck pass skip this tables
          Thank you very much

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                elenst Elena Stepanova added a comment - - edited

                Thanks.
                Since Marc Trouwaert has already created a bug report about it (MDEV-8571), I'm adding your description as a comment there, so we could track everything in one place.

                Show
                elenst Elena Stepanova added a comment - - edited Thanks. Since Marc Trouwaert has already created a bug report about it ( MDEV-8571 ), I'm adding your description as a comment there, so we could track everything in one place.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    Alessandro Fustini
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: