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
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