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

Attachment: signature.asc
Description: Digital signature

Reply via email to