lp:~tsarev/percona-server/5.5-processlist_rows_stats-sporadic_fails-fix

Created by Oleg Tsarev on 2011-08-03 and last modified on 2011-08-03
Get this branch:
bzr branch lp:~tsarev/percona-server/5.5-processlist_rows_stats-sporadic_fails-fix
Only Oleg Tsarev can upload to this branch. If you are Oleg Tsarev please log in for upload directions.

Branch merges

Related bugs

Related blueprints

Branch information

Recent revisions

143. By Oleg Tsarev on 2011-08-03

1) Now every time before I call SHOW PROCESSLIST or SELECT ... FROM INFORMATION_SCHEMA.PROCESSLIST I first switch threads to consistent state.
Before that connection conn1 sometime not complete run of previous query, and result of test was sporadic.
Example of fail available here:
http://jenkins.percona.com/view/Percona%20Server%205.5/job/percona-server-5.5-param/66/BUILD_TYPE=debug,Host=ubuntu-natty-32bit/consoleText
Example of fail:
 Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read
 ### root ### test Query ### ### SHOW PROCESSLIST 0 0 4
-### root ### test Sleep ### ### NULL 0 0 1
+### root ### test Query ### ### CREATE TABLE t1 (a INT) 0 0 1
 ### root ### test Query ### ### SELECT a FROM t2 WHERE a > 15 1 0 3

As you can see, conn1 not complete yet CREATE TABLE (table was created, but thread not switched to state "Sleep" yet)

2) I removed useless echo messages. This messages doesn't have any usefull information, but do noise in output

3) Also I extend test by additional queries (need for (1) - consistent state of 1)

142. By Stewart Smith on 2011-08-01

merge 5.5.12-20.3 release tree

141. By Stewart Smith on 2011-08-01

merge 5.5.13-20.4 release branch

140. By Stewart Smith on 2011-07-21

merge FEDERATED bug fix of not clearing errors on close

139. By Stewart Smith on 2011-07-21

merge bug745241

138. By Alexey Kopytov on 2011-07-14

Merge from LP.

137. By Alexey Kopytov on 2011-07-06

Bug #745241: quering global_temporary_tables causes server crash

The problem was in an insufficient locking in
fill_global_temporary_tables(). Iterating thread's temporary_tables list
could lead to race conditions, because other server code assumes that
list to only be accessed by a single (the current) thread at any time.

Fixed by introducing a new mutex in THD protecting the temporary_tables
list and acquiring that mutex when modifying the list or in
fill_global_temporary_tables().

136. By Stewart Smith on 2011-06-30

merge fdatasync() usage for innodb log files

135. By Stewart Smith on 2011-06-28

merge bug 802829 fix

134. By kinoyasu <kinoyasu@gauntlet4> on 2011-06-28

fix bug802348

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
lp:percona-server/5.5
This branch contains Public information 
Everyone can see this information.

Subscribers