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
signature.asc
Description: Digital signature