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