Since upgrading to 5.5.27 (5.5.27-ndb-7.2.8-cluster-gpl-log to be exact) I have experienced problems with the query cache. I am wondering if I am the only one?
Twice I have had a core-dump (show at end of mail) on two separate servers running this version.
Now I had a complete lock, where 'SHOW PROCESSLIST' showed this for every connection:
"Waiting for query cache lock"
This resulted in connections building until the limit was hit. I could only cure this with a 'kill -9' on the mysqld process.
Are any other users experiencing this? Do any users know of a fix?
Thanks!
Ben Clewett.
Thread pointer: 0x7f6ea014cf90 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 410220e8 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x81c7f5] /usr/sbin/mysqld(handle_fatal_signal+0x403)[0x6e9383] /lib64/libpthread.so.0[0x7f6f491b2b30] /usr/sbin/mysqld(_ZN11Query_cache12unlink_tableEP23Query_cache_block_table+0x1b)[0x5bd1ab]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Oct 09
Rick James RE: Query Cache Crashing
Oct 09, 2012; 10:44
Rick James
RE: Query Cache Crashing
Oct 10
Ben Clewett Re: Query Cache Crashing
Oct 10, 2012; 10:09
Ben Clewett
Re: Query Cache Crashing
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!