Bug #35999 When using the embedded server a wrong error message comes.

Submitted: 11 Apr 2008 14:53 Modified: 8 Dec 2008 23:35
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:5.1.24-rc OS:Any
Assigned to: Alexey Botchkov CPU Architecture:Any

[11 Apr 2008 14:53] Horst Hunger
Description:
The following test failed running with an embedded server:

main.slave_compressed_protocol_basic [ fail ]

mysqltest: At line 45: query 'SET @@global.slave_compressed_protocol = DEFAULT' failed: 1230: Variable 'slave_compressed_protocol' doesn't have a default value

The result from queries just before the failure was:
SET @global_start_value = @@global.slave_compressed_protocol;
SELECT @global_start_value;
@global_start_value
0
'#--------------------FN_DYNVARS_147_01------------------------#'
SET @@global.slave_compressed_protocol = 1;
SET @@global.slave_compressed_protocol = DEFAULT;

More results from queries before failure can be found in /dev/shm/var-embedded-101/log/slave_compressed_protocol_basic.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

That the variable would have no default is simply not true (see manual).

How to repeat:
execute the test mentioned above with the embedded server.

Suggested fix:
Better error message.
[11 Apr 2008 20:46] Sveta Smirnova
Thank you for the report.

Verified as described using just query:

SET @@global.slave_compressed_protocol = DEFAULT;
[21 Apr 2008 6:36] Alexey Botchkov
I don't see the slave_compressed_protocol_basic.test in the 5.1 tree - probably it's in the release tree only by now.
Still as the 'slave_compressed_protocol' only has sence with the replication (which is not available in the embedded server) i belive we have to add
--source include/have_log_bin.inc
or
--source include/not_embedded.inc

Will fix it that way when i see the code.
[16 Jun 2008 4:19] Alexey Botchkov
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/47883

 2656 Alexey Botchkov	2008-06-16
      Bug #35999 When using the embedded server a wrong message comes.
      
      HAVE_REPLICATION was on for the embedded server as the #define was in wrong place.
[8 Dec 2008 10:19] Bugs System
Pushed into 5.1.31  (revid:holyfoot@mysql.com-20080616030445-y655mczli0fb0nf5) (version source revid:patrick.crews@sun.com-20081126180318-v685u61mpgoc176x) (pib:5)
[8 Dec 2008 11:30] Bugs System
Pushed into 6.0.9-alpha  (revid:holyfoot@mysql.com-20080616030445-y655mczli0fb0nf5) (version source revid:ingo.struewing@sun.com-20081121151447-dtf2ofz2ys0zqed1) (pib:5)
[8 Dec 2008 23:35] Paul DuBois
Noted in 5.1.31, 6.0.9 changelog.

Setting the slave_compressed_protocol system variable to DEFAULT
failed in the embedded server.
[19 Jan 2009 11:24] Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090108105244-8opp3i85jw0uj5ib) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:02] Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:08] Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.043 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.