EVOLUTION-MANAGER

Edit File: galera_flush.result

DROP TABLE IF EXISTS t1, t2; FLUSH DES_KEY_FILE; wsrep_last_committed_diff 1 FLUSH HOSTS; wsrep_last_committed_diff 1 SET GLOBAL wsrep_replicate_myisam = TRUE; INSERT INTO mysql.user VALUES('localhost','user1',PASSWORD('pass1'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','','N','N','',0); FLUSH PRIVILEGES; DELETE FROM mysql.user WHERE user = 'user1'; SET GLOBAL wsrep_replicate_myisam = FALSE; FLUSH PRIVILEGES; FLUSH QUERY CACHE; wsrep_last_committed_diff 1 FLUSH STATUS; wsrep_last_committed_diff 1 FLUSH USER_RESOURCES; wsrep_last_committed_diff 1 FLUSH TABLES; wsrep_last_committed_diff 1 CREATE TABLE t2 (f1 INTEGER); FLUSH TABLES t2; wsrep_last_committed_diff 1 FLUSH ERROR LOGS; wsrep_last_committed_diff 1 FLUSH SLOW LOGS; wsrep_last_committed_diff 1 FLUSH GENERAL LOGS; wsrep_last_committed_diff 1 FLUSH ENGINE LOGS; wsrep_last_committed_diff 1 FLUSH RELAY LOGS; wsrep_last_committed_diff 1 SET @userstat_old= @@userstat; SET GLOBAL userstat=ON; FLUSH CLIENT_STATISTICS; FLUSH INDEX_STATISTICS; FLUSH TABLE_STATISTICS; FLUSH USER_STATISTICS; wsrep_last_committed_diff 1 SET @old_thread_statistics= @@global.thread_statistics; SET GLOBAL thread_statistics= ON; FLUSH THREAD_STATISTICS; wsrep_last_committed_diff 1 FLUSH CHANGED_PAGE_BITMAPS; wsrep_last_committed_diff 1 CREATE TABLE t1 (f1 INTEGER); FLUSH LOGS; FLUSH TABLES WITH READ LOCK; UNLOCK TABLES; FLUSH TABLES t1 WITH READ LOCK; UNLOCK TABLES; FLUSH TABLES t1 FOR EXPORT; UNLOCK TABLES; wsrep_last_committed_diff 1 LOCK TABLES t1 WRITE; FLUSH TABLES t1; UNLOCK TABLES; wsrep_last_committed_diff 1 LOCK TABLES t1 READ; FLUSH TABLES t1; ERROR HY000: Table 't1' was locked with a READ lock and can't be updated UNLOCK TABLES; wsrep_last_committed_diff 1 FLUSH TABLES t1; wsrep_last_committed_diff 1 DROP TABLE t1; DROP TABLE t2; SET GLOBAL userstat= @userstat_old; SET GLOBAL thread_statistics= @old_thread_statistics;