Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 5.5.33a, 10.0.7, 10.0.8
    • Fix Version/s: N/A
    • Component/s: OTHER
    • Labels:
    • Environment:
      Slackware Linux 14.1 + kernel 3.12.6

      Description

      cd /usr/mysql-test; ./mtr maria-purge
      

      (as root) gives me an error report as below. I am keeping the mysql-test directory, so please let me know if you'd like anything else from it.

      CURRENT_TEST: maria.maria-purge
      --- /usr/mysql-test/suite/maria/maria-purge.result      2013-09-20 08:34:23.000000000 +1000
      +++ /usr/mysql-test/suite/maria/maria-purge.reject      2013-10-10 15:02:41.000000000 +1100
      @@ -38,13 +38,13 @@
       set global aria_checkpoint_interval=30;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000002       in use
      +Aria   Size        16384 ; s   in use
       insert into t2 select * from t1;
       insert into t1 select * from t2;
       set global aria_checkpoint_interval=30;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000004       in use
      +Aria   Size     11247616 ; s   in use
       set global aria_log_file_size=16777216;
       select @@global.aria_log_file_size;
       @@global.aria_log_file_size
      @@ -52,7 +52,7 @@
       set global aria_checkpoint_interval=30;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000004       in use
      +Aria   Size     11247616 ; s   in use
       set global aria_log_file_size=8388608;
       select @@global.aria_log_file_size;
       @@global.aria_log_file_size
      @@ -62,32 +62,32 @@
       set global aria_checkpoint_interval=30;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000004       free
      -Aria   aria_log.00000005       free
      -Aria   aria_log.00000006       free
      -Aria   aria_log.00000007       free
      -Aria   aria_log.00000008       in use
      +Aria   Size     11247616 ; s   free
      +Aria   Size      8388608 ; 
                                  s   free
      +Aria   Size      8388608 ; s   free
      +Aria   Size      8388608 ;     free
      +Aria   Size      2539520 ; s   in use
       flush logs;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000008       in use
      +Aria   Size      2539520 ; s   in use
       set global aria_log_file_size=16777216;
       set global aria_log_purge_type=external;
       insert into t1 select * from t2;
       set global aria_checkpoint_interval=30;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000008       free
      -Aria   aria_log.00000009       in use
      +Aria   Size     16777216 ; s   free
      +Aria   Size     13443072 ; 
                                  s   in use
       flush logs;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000008       free
      -Aria   aria_log.00000009       in use
      +Aria   Size     16777216 ; s   free
      +Aria   Size     13443072 ; 
                                  s   in use
       set global aria_log_purge_type=immediate;
       insert into t1 select * from t2;
       set global aria_checkpoint_interval=30;
       SHOW ENGINE aria logs;
       Type   Name    Status
      -Aria   aria_log.00000011       in use
      +Aria   Size      7577600 ; s   in use
       drop table t1, t2;
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              duncan_roe Duncan Roe added a comment -

              Tried with 10.0.7 but still fails

              Show
              duncan_roe Duncan Roe added a comment - Tried with 10.0.7 but still fails
              Hide
              duncan_roe Duncan Roe added a comment -

              Still failing at 10.0.8

              Show
              duncan_roe Duncan Roe added a comment - Still failing at 10.0.8
              Hide
              elenst Elena Stepanova added a comment -

              Apparently, it's a duplicate of MDEV-5120 – same output is corrupted in the same way. Since we could now reproduce it (on Debian Sid), and found out that it doesn't depend on the test, but happens in a "real" server as well, I'm closing it as a duplicate.

              Show
              elenst Elena Stepanova added a comment - Apparently, it's a duplicate of MDEV-5120 – same output is corrupted in the same way. Since we could now reproduce it (on Debian Sid), and found out that it doesn't depend on the test, but happens in a "real" server as well, I'm closing it as a duplicate.

                People

                • Assignee:
                  elenst Elena Stepanova
                  Reporter:
                  duncan_roe Duncan Roe
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: