Bug #38077 rpl_incident At line 22: query 'SELECT * ...' Table 'test.t1' doesn't exist
Submitted: 12 Jul 2008 19:46 Modified: 28 May 2009 12:14
Reporter: Andrei Elkin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:5.1-bugteam OS:Any
Assigned to: Serge Kozlov CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[12 Jul 2008 19:46] Andrei Elkin
Description:
        tfl_name: rpl.rpl_incident 'row'
    tfl_tst_type: rpl_binlog_row
        psh_tree: bzr_mysql-5.1-bugteam
       psh_order: 57
tfl_bld_platform: pb-valgrind
        tfl_text: rpl.rpl_incident 'row'         [ fail ]

mysqltest: At line 22: query 'SELECT * FROM t1' failed: 1146: Table 'test.t1' doesn't exist

The result from queries just before the failure was:
< snip >
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
**** On Master ****
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1),(2),(3);
SELECT * FROM t1;
a
1
2
3
REPLACE INTO t1 VALUES (4);
SELECT * FROM t1;
a
1
2
3
4
**** On Slave ****
SELECT * FROM t1;

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=pb-valgr...
    https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-bugteam&order=57
[16 Jul 2008 10:20] Sven Sandberg
xref finds:

http://tinyurl.com/678g67
http://tinyurl.com/5cdcfp
[17 Jul 2008 13:10] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/49920

2703 Sven Sandberg	2008-07-17
      BUG#38077: rpl_incident At line 22: query 'SELECT * ...' Table 'test.t1' doesn't exist
      This is not a fix to the bug. It only adds debug info, so
      that we can analyze the bug better next time it happens.
      Please revert the patch after the bug is fixed.
[18 Jul 2008 13:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50033

2705 Sven Sandberg	2008-07-18
      BUG#38077: rpl_incident At line 22: query 'SELECT * ...' Table 'test.t1' doesn't exist
      This is not a fix to the bug. It only adds debug info, so
      that we can analyze the bug better next time it happens.
      Please revert the patch after the bug is fixed.
[18 Jul 2008 13:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50034

2705 Sven Sandberg	2008-07-18
      BUG#38077: rpl_incident At line 22: query 'SELECT * ...' Table 'test.t1' doesn't exist
      This is not a fix to the bug. It only adds debug info, so
      that we can analyze the bug better next time it happens.
      Please revert the patch after the bug is fixed.
[18 Jul 2008 13:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50035

2705 Sven Sandberg	2008-07-18
      BUG#38077: rpl_incident At line 22: query 'SELECT * ...' Table 'test.t1' doesn't exist
      This is not a fix to the bug. It only adds debug info, so
      that we can analyze the bug better next time it happens.
      Please revert the patch after the bug is fixed.
[23 Jul 2008 10:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50286

2706 Sven Sandberg	2008-07-23
      BUG#37493: rpl_trunc_temp.test nondeterministic
      Problem: the test waits for a 'DROP TEMPORARY TABLE' event to
      appear in the master's binlog, then checks on the slave whether
      the number of temporary tables has decreased. The slave does
      not sync, causing a race.
      Fix: check for the 'DROP TEMPORARY TABLE' event on slave
      instead of on master.
[23 Jul 2008 10:21] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50287

2706 Sven Sandberg	2008-07-23
      BUG#37493: rpl_trunc_temp.test nondeterministic
      Problem: the test waits for a 'DROP TEMPORARY TABLE' event to
      appear in the master's binlog, then checks on the slave whether
      the number of temporary tables has decreased. The slave does
      not sync, causing a race.
      Fix: check for the 'DROP TEMPORARY TABLE' event on slave
      instead of on master.
[14 Aug 2008 7:17] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51600

2677 He Zhenxing	2008-08-14 [merge]
      Merge with mysql-5.1-rpl-testfixes
[15 Aug 2008 2:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51688

2769 He Zhenxing	2008-08-15 [merge]
      Merge 6.0-rpl-testfixes -> 6.0
[19 Aug 2008 19:55] Bugs System
Pushed into 6.0.7-alpha  (revid:sven@mysql.com-20080718130714-8bnlos2nsebah3gw) (version source revid:sven@mysql.com-20080818175803-c1nutd5773r6b4gd) (pib:3)
[28 Aug 2008 20:17] Bugs System
Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)
[14 Sep 2008 1:55] Bugs System
Pushed into 6.0.6-alpha  (revid:sven@mysql.com-20080718130714-8bnlos2nsebah3gw) (version source revid:hakan@mysql.com-20080716160034-sdexuyp3qow7zlc6) (pib:3)
[10 Oct 2008 10:35] Georgi Kodinov
Putting link as requested : https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=bzr_mysql-5.1-5.1.29-rc&entry=Gl...
[15 Oct 2008 15:13] Sven Sandberg
failure with debug info from pushbuild

Attachment: failure (application/octet-stream, text), 11.68 KiB.

[15 Oct 2008 15:14] Sven Sandberg
Thanks Joro! With this new debug info, we can reopen the bug.
[8 Jan 2009 19:46] Timothy Smith
Another failure in Pushbuild:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-bugteam&order=35...

This is in mysql-5.1-bugteam, on the pb-valgrind host during ps_stm run.
[8 Jan 2009 19:47] Timothy Smith
failure info copied from the previous Pushbuild URL

Attachment: b38077-dbg.txt (text/plain), 11.61 KiB.

[29 Mar 2009 18:52] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/70776

2837 Serge Kozlov	2009-03-29
      Bug#38077. 
      Sync slave with master before inserting an incident event and 
      avoid cases when slave has not received data yet.
      modified:
        mysql-test/suite/rpl/t/rpl_incident.test
[2 Apr 2009 19:33] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/71243

2853 Serge Kozlov	2009-04-02
      Bug#38077.
      1. Replace waiting of SQL thread stop by waiting of SQL error on slave and stopped SQL thread.
      2. Remove debug code because it already implemented in MTR2.
      modified:
        mysql-test/suite/rpl/t/rpl_incident.test
[2 May 2009 19:18] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/73261

2890 Serge Kozlov	2009-05-02
      Bug#38077
      1. Replace waiting of SQL thread stop by waiting of SQL error on slave and stopped
      SQL thread.
      2. Remove debug code because it already implemented in MTR2.
      modified:
        mysql-test/suite/rpl/t/rpl_incident.test
[2 May 2009 19:29] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/73262

2890 Serge Kozlov	2009-05-02
      Bug#38077.
      1. Replace waiting of SQL thread stop by waiting of SQL error on slave and stopped
      SQL thread.
      2. Remove debug code because it already implemented in MTR2.
      modified:
        mysql-test/suite/rpl/t/rpl_incident.test
[2 May 2009 19:33] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/73263

3252 Serge Kozlov	2009-05-02 [merge]
      Bug#38077.
      1. Replace waiting of SQL thread stop by waiting of SQL error on slave and stopped
      SQL thread.
      2. Remove debug code because it already implemented in MTR2.
      modified:
        mysql-test/suite/rpl/t/rpl_incident.test
[28 May 2009 8:15] Bugs System
Pushed into 5.1.36 (revid:joro@sun.com-20090528073639-yohsb4q1jzg7ycws) (version source revid:mats@sun.com-20090511132802-nnkiyb2huih1tklz) (merge vers: 5.1.35) (pib:6)
[28 May 2009 12:14] Jon Stephens
Testing only; no end-user changes to document. Closed.
[17 Jun 2009 19:26] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090616183122-chjzbaa30qopdra9) (version source revid:serge.kozlov@sun.com-20090502193200-hwoblxspuchqh4vb) (merge vers: 6.0.12-alpha) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:32] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)