enterprise-support team mailing list archive

[Valerii Kravchuk <valerii.kravchuk@xxxxxxxxxxx>]

This is easy to confirm with the test from upstream bug:

[openxs@centos mysql-test]$ ./mtr --mysqld=--myisam-recover=FORCE bug65786
Logging: ./mtr  --mysqld=--myisam-recover=FORCE bug65786
2015-07-13 16:17:50 2793 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2015-07-13 16:17:50 2793 [Warning] Buffered warning: Changed limits:
table_cache: 431 (requested 2000)

2015-07-13 16:17:50 2793 [Note] Plugin 'FEDERATED' is disabled.
2015-07-13 16:17:50 2793 [Note] Binlog end
2015-07-13 16:17:50 2793 [Note] Shutting down plugin 'CSV'
2015-07-13 16:17:50 2793 [Note] Shutting down plugin 'MyISAM'
MySQL Version 5.6.23
Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/openxs/dbs/p5.6/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.bug65786                            [ fail ]
        Test ended at 2015-07-13 16:18:06

CURRENT_TEST: main.bug65786
--- /home/openxs/dbs/p5.6/mysql-test/r/bug65786.result  2015-07-13 16:13:43.855440703 +0300
+++ /home/openxs/dbs/p5.6/mysql-test/var/log/bug65786.reject    2015-07-13 16:18:06.248440679 +0300
@@ -0,0 +1,19 @@
+CREATE PROCEDURE p1() BEGIN END;
+# Crash and restart server
+# Succeeds with warnings on 5.1, but fails on 5.5:
+CREATE PROCEDURE p2() BEGIN END;
+ERROR HY000: Table './mysql/proc' is marked as crashed and should be repaired
+# Fails on 5.5:
+CREATE PROCEDURE p2() BEGIN END;
+ERROR HY000: Table './mysql/proc' is marked as crashed and should be repaired
+# Throws warnings:
+SELECT 1 FROM mysql.proc WHERE 0;
+1
+Warnings:
+Error  145     Table './mysql/proc' is marked as crashed and should be repaired
+Error  1194    Table 'proc' is marked as crashed and should be repaired
+Error  1034    1 client is using or hasn't closed the table properly
+# Succeeds:
+CREATE PROCEDURE p2() BEGIN END;
+DROP PROCEDURE p1;
+DROP PROCEDURE p2;
...

** Tags added: upstream

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Changed in: percona-server/5.6
       Status: New => Confirmed

** Changed in: percona-server/5.5
       Status: New => Confirmed

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1473894

Title:
  myisam-repair-options does not work for mysql.proc table

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1473894/+subscriptions