Hi all,
We have a pool of 8 MySQL servers where the first one is the
master and the others 7 are slave. Yesterday we have a hard time where the
server begin with too many lag ( 1 hour ) and then slaves start to fail with
messages like this one
thd=0x38f18130
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...
Cannot determine thread, fp=0x418ac0a8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
(nil)
New value of fp=0x38f18130 failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and
follow instructions on how to resolve the stack tr
ace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x3a4d2c13 = UPDATE t_items i, site_items_195_16 pc SET
i.item_type = CASE pc.item_type WHEN '0' THEN 2 WHEN '
1' THEN 2 WHEN '2' THEN 1 END, i.optional_field_6 = CASE pc.item_type WHEN
'0' THEN '' WHEN '1' THEN 1 WHEN '2' THEN '' END
, i.email = pc.email, i.optional_field_19 = pc.lang_id, i.optional_field_16
= pc.ip, i.optional_field_9 = (SELECT COUNT(*)
FROM geodesic_auctions_bids ab WHERE ab.auction_id = i.item_id), i.title =
pc.title, i.date = pc.date, i.description = pc.d
escription, i.image = pc.image, i.price = pc.price, i.optional_field_8 =
pc.deleted_type, i.optional_field_13 = pc.bloqued_
type WHERE i.item_id = pc.id AND i.item_id = 113347296
thd->thread_id=7
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
t is a temporal table. More strange was that Slave's failed with more or
less 2 hours of difference. MySQL version is 5.0.x
Any help is welcome,
Thanks.
--
Infrastructure Team
OLX Inc.
Buenos Aires - Argentina
Phone : 54.11.4775.6696
Mobile : 54.911.50436059
Email: alejand...@olx.com
