[debian-mysql] Bug#431030: mysql-server-5.0: (etch) segmentation fault while granting privileges

[Frederik Schueler]

Package: mysql-server-5.0
Version: 5.0.32-7etch1
Severity: important

today after issuing a simple 

grant select on lpbforum.users to 'phpbb2'@'localhost';

this happened:

Jun 29 02:18:20 defiant mysqld[31393]: mysqld got signal 11;
Jun 29 02:18:20 defiant mysqld[31393]: This could be because you hit a bug. It is also possible that this binary
Jun 29 02:18:20 defiant mysqld[31393]: or one of the libraries it was linked against is corrupt, improperly built,
Jun 29 02:18:20 defiant mysqld[31393]: or misconfigured. This error can also be caused by malfunctioning hardware.
Jun 29 02:18:20 defiant mysqld[31393]: We will try our best to scrape up some info that will hopefully help diagnose
Jun 29 02:18:20 defiant mysqld[31393]: the problem, but since we have already crashed, something is definitely wrong
Jun 29 02:18:20 defiant mysqld[31393]: and this may fail.
Jun 29 02:18:20 defiant mysqld[31393]: 
Jun 29 02:18:20 defiant mysqld[31393]: key_buffer_size=268435456
Jun 29 02:18:20 defiant mysqld[31393]: read_buffer_size=131072
Jun 29 02:18:20 defiant mysqld[31393]: max_used_connections=2
Jun 29 02:18:20 defiant mysqld[31393]: max_connections=100
Jun 29 02:18:20 defiant mysqld[31393]: threads_connected=2
Jun 29 02:18:20 defiant mysqld[31393]: It is possible that mysqld could use up to 
Jun 29 02:18:20 defiant mysqld[31393]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 479743 K
Jun 29 02:18:20 defiant mysqld[31393]: bytes of memory
Jun 29 02:18:20 defiant mysqld[31393]: Hope that's ok; if not, decrease some variables in the equation.
Jun 29 02:18:20 defiant mysqld[31393]: 
Jun 29 02:18:20 defiant mysqld[31393]: thd=0x9533560
Jun 29 02:18:20 defiant mysqld[31393]: Attempting backtrace. You can use the following information to find out
Jun 29 02:18:20 defiant mysqld[31393]: where mysqld died. If you see no messages after this, something went
Jun 29 02:18:20 defiant mysqld[31393]: terribly wrong...
Jun 29 02:18:20 defiant mysqld[31393]: Cannot determine thread, fp=0x7f2065f8, backtrace may not be correct.
Jun 29 02:18:20 defiant mysqld[31393]: Stack range sanity check OK, backtrace follows:
Jun 29 02:18:20 defiant mysqld[31393]: 0x81c0659
Jun 29 02:18:20 defiant mysqld[31393]: 0x848a2d0
Jun 29 02:18:20 defiant mysqld[31393]: 0x848acba
Jun 29 02:18:20 defiant mysqld[31393]: 0x82530b0
Jun 29 02:18:20 defiant mysqld[31393]: 0x81d919d
Jun 29 02:18:20 defiant mysqld[31393]: 0x81dba17
Jun 29 02:18:20 defiant mysqld[31393]: 0x81dbed0
Jun 29 02:18:20 defiant mysqld[31393]: 0x81dd198
Jun 29 02:18:20 defiant mysqld[31393]: 0x81ddba4
Jun 29 02:18:20 defiant mysqld[31393]: 0xb7ebe240
Jun 29 02:18:20 defiant mysqld[31393]: 0xb7cf93de
Jun 29 02:18:20 defiant mysqld[31393]: New value of fp=(nil) failed sanity check, terminating stack trace!
Jun 29 02:18:20 defiant mysqld[31393]: Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resol
ved
Jun 29 02:18:20 defiant mysqld[31393]: stack trace is much more helpful in diagnosing the problem, so please do 
Jun 29 02:18:20 defiant mysqld[31393]: resolve it
Jun 29 02:18:20 defiant mysqld[31393]: Trying to get some variables.
Jun 29 02:18:20 defiant mysqld[31393]: Some pointers may be invalid and cause the dump to abort...
Jun 29 02:18:20 defiant mysqld[31393]: thd->query at 0x95476d8 = grant select on lpbforum.users to 'phpbb2'@'localhost'
Jun 29 02:18:20 defiant mysqld[31393]: thd->thread_id=2
Jun 29 02:18:20 defiant mysqld[31393]: The manual page at http://www.mysql.com/doc/en/Crashing.html contains
Jun 29 02:18:20 defiant mysqld[31393]: information that should help you find out what is causing the crash.
Jun 29 02:18:20 defiant mysqld_safe[31424]: Number of processes running now: 0
Jun 29 02:18:20 defiant mysqld_safe[31426]: restarted

the user already has all privileges on the db lpbforum.*, I wanted to
limit the privileges for just this one table.

I upgraded to version 5.0.41a-1~bpo.1 from backports.org which allowed
me to set the privileges accordingly without any errors.

As a side note, these are the first backports packages on the system,
everything else is straight etch.

If you need any help testing patches or something, feel free to drop me
a line.

best regards
Frederik Schüler

-- 
ENOSIG
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20070629/4d8190da/attachment.pgp