Bug #34551 *** glibc detected *** mysqld: corrupted double-linked list: 0x0b4ae810 ***

Submitted: 14 Feb 2008 15:43 Modified: 15 Mar 2008 15:59
Reporter: saravanan krishnarajan Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S1 (Critical)
Version:5.0.51a OS:Linux (el5)
Assigned to: CPU Architecture:Any
Tags: corrupted doub linked list, corrupted double-linked list, glibc detected

[14 Feb 2008 15:43] saravanan krishnarajan
Description:
When I try to declare the handler in my procedure to exit. I just hangs and in other terminal it listed the following errors.

*** glibc detected *** /usr/local/mysql2/libexec/mysqld: corrupted double-linked list: 0x0b4ae810 ***
======= Backtrace: =========
/lib/libc.so.6[0x8949be]
/lib/libc.so.6(cfree+0x90)[0x897fc0]
/usr/lib/libstdc++.so.6(_ZdlPv+0x21)[0xb35671]
/usr/local/mysql2/libexec/mysqld(_ZN20sp_instr_jump_if_notD0Ev+0x5d)[0x82c4e0d]
/usr/local/mysql2/libexec/mysqld(_ZN7sp_head7destroyEv+0x2f)[0x82be99f]
/usr/local/mysql2/libexec/mysqld(_ZN7sp_headD0Ev+0x20)[0x82c0e10]
/usr/local/mysql2/libexec/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x286)[0x81ac6a6]
/usr/local/mysql2/libexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x4db)[0x81acc6b]
/usr/local/mysql2/libexec/mysqld(_Z10do_commandP3THD+0xa7)[0x81ae317]
/usr/local/mysql2/libexec/mysqld(handle_one_connection+0x9fa)[0x81aee5a]
/lib/libpthread.so.0[0x97b45b]
/lib/libc.so.6(clone+0x5e)[0x8fc24e]

and when I tried to execute my daemon directly i got the following error.

080213 16:37:26 [Warning] Ignoring user change to 'mysql2' because the user was set to 'mysql' earlier on the command line

080213 16:37:27  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

following is the procedure where i added the declare handler

CREATE PROCEDURE update_bounces_type(IN bounce_type INT, INOUT bounce_count INT, INOUT bad_address BIGINT)

BEGIN
	DECLARE email_var CHAR(130);
        DECLARE messageid_count INT DEFAULT 0;
        DECLARE type_permission INT DEFAULT 0;
        DECLARE users_by_permission INT DEFAULT 0;

	DECLARE c5 CURSOR FOR SELECT Email FROM Bounce1 GROUP BY Email having count(*)>5;
	DECLARE c3 CURSOR FOR SELECT Email FROM Bounce1 GROUP BY Email having count(*)>3;
	DECLARE c10 CURSOR FOR SELECT Email FROM Bounce1 GROUP BY Email having count(*)>10;
        DECLARE cnull CURSOR FOR SELECT Email FROM Bounce1 GROUP BY Email;

BEGIN
  DECLARE EXIT HANDLER FOR SQLSTATE '02000' BEGIN END;

How to repeat:
I repeated restoring datas from backup and faced the same errors
[15 Feb 2008 15:59] Susanne Ebrecht
Many thanks for writing a bug report.

Please add your my.cnf here.

Also we need to know how you installed MySQL.
[16 Mar 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.