Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5.28a-galera
Description
Provided test case usually finishes with error 2027 (Malformed packet), and sometimes with 1356 (ER_VIEW_INVALID) or 1305 (ER_SP_DOES_NOT_EXIST), all of which are unexpected.
It doesn't happen if the test is executed with wsrep disabled.
MTR test case:
--sleep 2
|
|
--source include/have_innodb.inc
|
--source include/have_binlog_format_row.inc
|
|
SET GLOBAL lock_wait_timeout = 2; |
SET GLOBAL innodb_lock_wait_timeout = 1; |
|
CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB; |
CREATE OR REPLACE VIEW v1 AS SELECT pk FROM t1; |
CREATE FUNCTION func1() RETURNS INTEGER RETURN 4; |
CREATE FUNCTION func2() RETURNS INTEGER RETURN 4; |
CREATE PROCEDURE proc1() SELECT func1() FROM v1; |
|
|
--connect (con1,localhost,root,,test)
|
--connect (con2,localhost,root,,test)
|
|
--let $run = 100
|
|
while ($run)
|
{
|
--connection con1 |
--send |
CREATE OR REPLACE ALGORITHM = TEMPTABLE VIEW v1 AS SELECT func2() AS pk FROM t1; |
--connection con2 |
CALL proc1();
|
--connection con1 |
--reap |
--dec $run |
}
|
MTR command line:
perl ./mtr --mysqld=--innodb_autoinc_lock_mode=2 --mysqld=--innodb_locks_unsafe_for_binlog=1 --mysqld=--wsrep-provider=/home/elenst/galera/libgalera_smm.so --mysqld=--wsrep-cluster-address=gcomm:// --nocheck-testcases main.malformed_packet
|
revision-id: elenst@montyprogram.com-20130302232248-uozp6ilf7kbyfrgj
|
revno: 3388
|
branch-nick: maria-5.5-galera
|
Attachments
Issue Links
- is duplicated by
-
MDEV-13770 client/Server protocol violation caused by galera rerunning rolled back Stored Procedure call
- Closed