| 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: | |
| 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 | ||
[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)
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