MySQL Bugs: #25006: openssl_1.test fails on 'powermacg5' -max

Bug #25006	openssl_1.test fails on 'powermacg5' -max
Submitted:	12 Dec 2006 11:49	Modified:	10 Apr 2007 16:15
Reporter:	Ingo Strüwing	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S1 (Critical)
Version:	5.0.32	OS:	MacOS (OSX, Linux)
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
This blocks 5.0-engines from being pushed to main.

Excerpt from
https://intranet.mysql.com/~knielsen/pb/getlog.pl?dir=mysql-5.0-engines&entry=istruewing@c...

openssl_1                      [ fail ]

Errors are (from /Users/henry/pb/mysql-5.0-engines/64/mysql-5.0.32-pb64/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/openssl_1.result	Fri Dec  8 22:55:41 2006
--- r/openssl_1.reject	Sat Dec  9 01:50:03 2006
***************
*** 47,53 ****
  mysqltest: Could not open connection 'default': 2026 SSL connection error
  mysqltest: Could not open connection 'default': 2026 SSL connection error
  mysqltest: Could not open connection 'default': 2026 SSL connection error
! SSL error: Unable to get private key from ''
! mysqltest: Could not open connection 'default': 2026 SSL connection error
  SSL error: Unable to get certificate from ''
  mysqltest: Could not open connection 'default': 2026 SSL connection error
--- 47,52 ----
  mysqltest: Could not open connection 'default': 2026 SSL connection error
  mysqltest: Could not open connection 'default': 2026 SSL connection error
  mysqltest: Could not open connection 'default': 2026 SSL connection error
! mysqltest: Could not open connection 'default': 2013 Lost connection to MySQL server at 'reading initial communication packet', system error: 0
  SSL error: Unable to get certificate from ''
  mysqltest: Could not open connection 'default': 2026 SSL connection error
-------------------------------------------------------
Please follow the instructions outlined at

How to repeat:
See the pushbuild log.

"Packets out of order" since SSL library first sends error to client and then mysqld will also send error. The second error message should be discarded, but in some cases it's almost like the error message is in the air. But I suspect it's  left in some buffer, we receive it after first closing the socket and then opening it again. Always get the same fd could that be the cause?

Encountered this failure on G5 OSX and i686 Linux with 5.0.32. Not predictable, fails approx. 10% of runs on the two machines tested.

I believe the following test failure is caused by the same ... cause. Encountered on i686 Linux:

ssl_compress                   [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: Could not open connection 'default': 2013 Lost connection to MySQL server at 'reading initial communication packet', system error: 0
(the last lines may be the most important ones)

Fixed by patch for Bug#25203 Mysql crashes when mysql_kill() is executed in a connection using SSL