MySQL Bugs: #493: mysql: relocation error: mysql: undefined symbol: set_all_changeable

Bug #493	mysql: relocation error: mysql: undefined symbol: set_all_changeable_vars
Submitted:	24 May 2003 13:42	Modified:	30 May 2003 4:53
Reporter:	Herve Bour Schmitt Bour	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	4.0.13	OS:	Linux (Slackware 9.0)
Assigned to:		CPU Architecture:	Any

Description:
I compiled MySql 4.0.13 (fresh install) on a test server (AMD Athlon 1.2GHz), recompiled Php 4.3.1 and everything is OK except 2 points :

- After booting I get 10 mysqld process which are running. After many test on the comand line I reached 16... I'm surprised because I got 3 with the 3.23

- Each time I run a command using the command line, I got 
"mysql: relocation error: mysql: undefined symbol: set_all_changeable_vars"

When connecting with user/pws, when writing only mysql, etc...

Note that all functionnalities are ok.

Any help will be welcome and I you could just send an email to herve@internet-fr.net I will be happy ;)

Thanks

How to repeat:
- After booting I get 10 mysqld process which are running. After many test on the comand line I reached 16... I'm surprised because I got 3 with the 3.23

- Each time I run a command using the command line, I got 
"mysql: relocation error: mysql: undefined symbol: set_all_changeable_vars"

When connecting with user/pws, when writing only mysql, etc...

Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem is not the result of a bug.
For a list of more appropriate places to ask for help using MySQL
products, please visit http://www.mysql.com/support/

Thank you for your interest in MySQL.

MySQL does not fork processes it uses PosixThreads - LinuxThreads in your case. Linux tools display threads as processes with diffrent PIDs.

Every conncection is handled by it's own thread plus some system threads MySQL use which can vary due to startup options like Replication add more threads, InnoDB if enabled and so on.

This is well docummented behaviour therefore not a bug.

"mysql: relocation error: mysql: undefined symbol: set_all_changeable_vars"

This message is symptom of linker problems. Something wrong happened when you built it or it might be some Slackware 9 specifics.

Use binary distribution from www.mysql.com