2013-12-06 10:31:39 |
marsxu |
bug |
|
|
added bug |
2013-12-06 10:33:24 |
marsxu |
description |
use db1
CREATE TABLE `c_uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
........1000000 rows insert into c_uid .
use db2
CREATE TABLE `uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
use db1 | | use db2
alter table c_uid add col_test int ; | At the same time | insert into uid(keycode,uid,poid,createtime) ......
Query OK, 1000000 rows affected (29.41 sec) | | Query OK, 1 row affected (28.51 sec)
Records: 1000000 Duplicates: 0 Warnings: 0 | |
db1 DDL operations blocked the db2 DML oprations . |
use db1
CREATE TABLE `c_uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
........1000000 rows insert into c_uid .
use db2
CREATE TABLE `uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
use db1
alter table c_uid add col_test int ;
Query OK, 1000000 rows affected (29.41 sec)
Records: 1000000 Duplicates: 0 Warnings: 0
++++++++ At the same time +++++++++
insert into uid(keycode,uid,poid,createtime) values("testCode","user111",111,now());
Query OK, 1 row affected (28.51 sec)
db1 DDL operations blocked the db2 DML oprations . |
|
2013-12-06 10:36:30 |
marsxu |
description |
use db1
CREATE TABLE `c_uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
........1000000 rows insert into c_uid .
use db2
CREATE TABLE `uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
use db1
alter table c_uid add col_test int ;
Query OK, 1000000 rows affected (29.41 sec)
Records: 1000000 Duplicates: 0 Warnings: 0
++++++++ At the same time +++++++++
insert into uid(keycode,uid,poid,createtime) values("testCode","user111",111,now());
Query OK, 1 row affected (28.51 sec)
db1 DDL operations blocked the db2 DML oprations . |
use db1
CREATE TABLE `c_uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
........1000000 rows insert into c_uid .
use db2
CREATE TABLE `uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
use db1
alter table c_uid add col_test int ;
Query OK, 1000000 rows affected (29.41 sec)
Records: 1000000 Duplicates: 0 Warnings: 0
++++++++ At the same time other session on same node +++++++++
insert into uid(keycode,uid,poid,createtime) values("testCode","user111",111,now());
Query OK, 1 row affected (28.51 sec)
++++++++ In the process of blocking state +++++++++
| 49522 | root | localhost | videodb | Query | 12 | copy to tmp table | alter table c_uid add col_test int | 0 | 0 | 0 |
| 49539 | root | localhost | testdb | Query | 10 | wsrep in pre-commit stage |insert into uid(keycode,uid,poid,createtime) .... | 0 | 1 | 1 |
db1 DDL operations blocked the db2 DML oprations . |
|
2013-12-06 10:41:31 |
marsxu |
description |
use db1
CREATE TABLE `c_uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
........1000000 rows insert into c_uid .
use db2
CREATE TABLE `uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
use db1
alter table c_uid add col_test int ;
Query OK, 1000000 rows affected (29.41 sec)
Records: 1000000 Duplicates: 0 Warnings: 0
++++++++ At the same time other session on same node +++++++++
insert into uid(keycode,uid,poid,createtime) values("testCode","user111",111,now());
Query OK, 1 row affected (28.51 sec)
++++++++ In the process of blocking state +++++++++
| 49522 | root | localhost | videodb | Query | 12 | copy to tmp table | alter table c_uid add col_test int | 0 | 0 | 0 |
| 49539 | root | localhost | testdb | Query | 10 | wsrep in pre-commit stage |insert into uid(keycode,uid,poid,createtime) .... | 0 | 1 | 1 |
db1 DDL operations blocked the db2 DML oprations . |
Percona XtraDB Cluster (GPL) 5.5.31-23.7.5, Revision 438, wsrep_23.7.5.r3880
use db1
CREATE TABLE `c_uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
........1000000 rows insert into c_uid .
use db2
CREATE TABLE `uid` (
`id` bigint(24) NOT NULL AUTO_INCREMENT,
`keycode` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`uid` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`poid` int(11) DEFAULT '1',
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `c_uid_index_1` (`keycode`),
KEY `c_uid_index_2` (`uid`)
) ENGINE=InnoDB
use db1
alter table c_uid add col_test int ;
Query OK, 1000000 rows affected (29.41 sec)
Records: 1000000 Duplicates: 0 Warnings: 0
++++++++ At the same time other session on same node +++++++++
insert into uid(keycode,uid,poid,createtime) values("testCode","user111",111,now());
Query OK, 1 row affected (28.51 sec)
++++++++ In the process of blocking state +++++++++
| 49522 | root | localhost | videodb | Query | 12 | copy to tmp table | alter table c_uid add col_test int | 0 | 0 | 0 |
| 49539 | root | localhost | testdb | Query | 10 | wsrep in pre-commit stage |insert into uid(keycode,uid,poid,createtime) .... | 0 | 1 | 1 |
db1 DDL operations blocked the db2 DML oprations . |
|
2013-12-06 17:13:52 |
Alex Yurchenko |
bug task added |
|
codership-mysql |
|
2013-12-07 00:49:31 |
tsubasa tanaka |
bug |
|
|
added subscriber tsubasa tanaka |
2014-01-09 08:11:17 |
joe chao |
codership-mysql: status |
New |
Opinion |
|
2014-01-09 08:11:41 |
joe chao |
codership-mysql: status |
Opinion |
New |
|
2014-09-11 09:15:53 |
Nilnandan Joshi |
percona-xtradb-cluster: status |
New |
Confirmed |
|
2014-09-11 09:15:59 |
Nilnandan Joshi |
bug |
|
|
added subscriber Nilnandan Joshi |
2014-09-17 07:46:07 |
Teemu Ollakka |
codership-mysql: status |
New |
Confirmed |
|
2014-09-17 07:46:36 |
Teemu Ollakka |
nominated for series |
|
codership-mysql/5.5 |
|
2014-09-17 07:46:36 |
Teemu Ollakka |
bug task added |
|
codership-mysql/5.5 |
|
2014-09-17 07:46:36 |
Teemu Ollakka |
nominated for series |
|
codership-mysql/5.6 |
|
2014-09-17 07:46:36 |
Teemu Ollakka |
bug task added |
|
codership-mysql/5.6 |
|
2015-11-17 09:52:15 |
Krunal Bauskar |
percona-xtradb-cluster: importance |
Undecided |
High |
|