Comment 1 for bug 1473894

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

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;
...