Bug #12529 yassl changes connect behaviour / error message
Submitted: 11 Aug 2005 16:00 Modified: 3 Oct 2005 8:11
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.11 OS:several Unix
Assigned to: Magnus Blåudd CPU Architecture:Any

[11 Aug 2005 16:00] Joerg Bruehe
Description:
Test build with "yassl" enabled on all platforms. Test failure:

user_limits                    [ fail ]

Errors are (from PATH/mysqltest-time) :
At line 78: query 'connect (mcph3' failed with wrong errno 2026 instead of 1226...
At line 87: query 'connect (mcph3' failed with wrong errno 2026 instead of 1226...
At line 105: query 'connect (muc3' failed with wrong errno 2026 instead of 1226...
At line 119: query 'connect (muc5' failed with wrong errno 2026 instead of 1226...
At line 148: query 'connect (muca3' failed with wrong errno 2026 instead of 1203...
At line 158: query 'connect (muca4' failed with wrong errno 2026 instead of 1226...
At line 170: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/user_limits.result
--- r/user_limits.reject
***************
*** 42,52
  select * from t1;
  i
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR 42000: User 'mysqltest_1' has exceeded the 'max_connections_per_hour' resource (current value: 2)
  select * from t1;
  i
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR 42000: User 'mysqltest_1' has exceeded the 'max_connections_per_hour' resource (current value: 2)
  drop user mysqltest_1@localhost;
  flush privileges;
  grant usage on *.* to mysqltest_1@localhost with max_user_connections 2;
--- 42,52
  select * from t1;
  i
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR HY000: SSL connection error
  select * from t1;
  i
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR HY000: SSL connection error
  drop user mysqltest_1@localhost;
  flush privileges;
  grant usage on *.* to mysqltest_1@localhost with max_user_connections 2;
***************
*** 56,62
((similar for "has exceeded the 'max_user_connections' resource (current value: 2)" ))
***************
*** 64,70
((similar for "(current value: 3)" ))
***************
*** 83,96
  select * from t1;
  i
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR 42000: User mysqltest_1 already has more than 'max_user_connections' active connections
  grant usage on *.* to mysqltest_1@localhost with max_user_connections 3;
  flush user_resources;
  select @@session.max_user_connections, @@global.max_user_connections;
  @@session.max_user_connections        @@global.max_user_connections
  3     2
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR 42000: User 'mysqltest_1' has exceeded the 'max_user_connections' resource (current value: 3)
  set global max_user_connections= 0;
  drop user mysqltest_1@localhost;
  drop table t1;
--- 83,96
  select * from t1;
  i
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR HY000: SSL connection error
  grant usage on *.* to mysqltest_1@localhost with max_user_connections 3;
  flush user_resources;
  select @@session.max_user_connections, @@global.max_user_connections;
  @@session.max_user_connections        @@global.max_user_connections
  3     2
  connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
! ERROR HY000: SSL connection error
  set global max_user_connections= 0;
  drop user mysqltest_1@localhost;
  drop table t1;
-------------------------------------------------------

occurred:
etpglb0-5.0-standard.log   normal
xserve-64bit-5.0-standard.log   normal

A subset of these differences also occurred:
hp3750-5.0-standard.log   normal
hp3750-64bit-5.0-standard.log   normal
hpita2-64bit-5.0-standard.log   normal
hpux11-5.0-standard.log   normal
hpux11-64bit-5.0-standard.log   normal
sol10-sparc-a-64bit-5.0-standard.log   normal
sunfire100c-5.0-standard.log   normal

How to repeat:
Test suite failure.
[30 Aug 2005 12:49] Magnus Blåudd
Looks like this is related to bug#11286
[1 Sep 2005 12:59] Magnus Blåudd
Shoule be fixed by patch for bug#11286
[1 Oct 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[3 Oct 2005 8:11] Magnus Blåudd
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html