Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Done
-
1.0.6.1
-
None
-
CentOS release 6.5
Description
install mcs with mode multi+combined+external, with 3 PMs, using glusterfs as external storage, with replica 3, /etc/fstab is modified properly.
Reboot the machine of PM3, during the rebooting, "SELECT COUNT( * ) FROM t2" may got wrong value.
mysql> show create table t2;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t2 | CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` int(11) DEFAULT NULL, `c3` int(11) DEFAULT NULL, `c4` int(11) DEFAULT NULL, `c5` int(11) DEFAULT NULL, `c6` int(11) DEFAULT NULL, `c7` int(11) DEFAULT NULL, `c8` int(11) DEFAULT NULL, `c9` int(11) DEFAULT NULL, `c10` int(11) DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
reproduce step.
1. machine of PM3 start reboot.
2. continual execute the sql.
mysql> select count
from t2;
ERROR 1815 (HY000): Internal error: The system is not yet ready to accept queries
mysql> select count from t2;
ERROR 1815 (HY000): Internal error: The system is not yet ready to accept queries
mysql> select count from t2;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> select count from t2;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 5
Current database: test
----------
| count |
----------
| 0 |
----------
1 row in set (16.46 sec) #####wrong value returned.
mysql> select count from t2;
----------
| count |
----------
| 24000000 |
----------
1 row in set (2.53 sec) #####correct value returned.