# InnoDB: Error - Is this bug? **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [October 1, 2012, 11:04am UTC](https://forums.percona.com/t/innodb-error-is-this-bug/1905 "2012-10-01T11:04:20Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![quanta](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/quanta/32/892_2.png) [@quanta](https://forums.percona.com/u/quanta)\ **Post date:** [October 1, 2012, 11:04am UTC](https://forums.percona.com/t/innodb-error-is-this-bug/1905/1 "2012-10-01T11:04:20Z")
Server version: 5.5.27-log Percona XtraDB Cluster (GPL), wsrep\_23.6.r356 mysqld.log 121001 15:37:47 InnoDB: Error; possible reasons:InnoDB: 1) Table rename would cause two FOREIGN KEY constraintsInnoDB: to have the same internal name in case-insensitive comparison.InnoDB: 2) table `db`.`v3_cam_ip_plus` /\* Partition `p00` \*/ exists in the InnoDB internal dataInnoDB: dictionary though MySQL is trying to rename table 08:37:47 UTC - mysqld got signal 11 ;This could be because you hit a bug. It is also possible that this binaryor one of the libraries it was linked against is corrupt, improperly built,or misconfigured. This error can also be caused by malfunctioning hardware.We will try our best to scrape up some info that will hopefully helpdiagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.Please help us make Percona Server better by reporting anybugs at [Projects - Percona JIRA](http://bugs.percona.com/key_buffer_size=2147483648read_buffer_size=67108864max_used_connections=106max_threads=301thread_count=39connection_count=38It) is possible that mysqld could use up to key\_buffer\_size + (read\_buffer\_size + sort\_buffer\_size)\*max\_threads = 22443738 K bytes of memoryHope that’s ok; if not, decrease some variables in the equation.Thread pointer: 0x2aad6424ea20Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong…stack\_bottom = 401f40c8 thread\_stack 0x40000/usr/sbin/mysqld(my\_print\_stacktrace+0x35)[0x7c14a5]/usr/sbin/mysqld(handle\_fatal\_signal+0x4a4)[0x69b6c4]/lib64/libpthread.so.0[0x3b64c0eb10]/usr/sbin/mysqld[0x5ecda6]/usr/sbin/mysqld(\_Z16explain\_filenameP3THDPKcPcj26enum\_explain\_filename\_mode+0x370)[0x5ed320]/usr/sbin/mysqld[0x7cce17]/usr/sbin/mysqld[0x7ce2c9]/usr/sbin/mysqld[0x83885d]/usr/sbin/mysqld[0x7faf0f]/usr/sbin/mysqld[0x7d9889]/usr/sbin/mysqld(\_ZN12ha\_partition17del\_ren\_cre\_tableEPKcS1\_P5TABLEP24st\_ha\_create\_information+0x13d)[0x97b68d]/usr/sbin/mysqld(\_Z18mysql\_rename\_tableP10handlertonPKcS2\_S2\_S2\_j+0x115)[0x5edec5]/usr/sbin/mysqld(\_Z17mysql\_alter\_tableP3THDPcS1\_P24st\_ha\_create\_informationP10TABLE\_LISTP10Alter\_infojP8st\_orderb+0x2286)[0x5f7576]/usr/sbin/mysqld(\_ZN21Alter\_table\_statement7executeEP3THD+0x4ec)[0x7a35bc]/usr/sbin/mysqld(\_Z21mysql\_execute\_commandP3THD+0x3049)[0x5935e9]/usr/sbin/mysqld(\_Z11mysql\_parseP3THDPcjP12Parser\_state+0x333)[0x595b23]/usr/sbin/mysqld(\_Z16dispatch\_command19enum\_server\_commandP3THDPcj+0x21ff)[0x5985ff]/usr/sbin/mysqld(\_Z10do\_commandP3THD+0x169)[0x598db9]/usr/sbin/mysqld(\_Z24do\_handle\_one\_connectionP3THD+0x15f)[0x63364f]/usr/sbin/mysqld(handle\_one\_connection+0x51)[0x633811]/lib64/libpthread.so.0[0x3b64c0673d]/lib64/libc.so.6(clone+0x6d)[0x3b644d3d1d]Trying to get some variables.Some pointers may be invalid and cause the dump to abort.Query (3364fa70): ALTER TABLE `v3_cam_ip_plus` PARTITION BY RANGE(TO\_DAYS(dt))( PARTITION p00 VALUES LESS THAN (0) ENGINE = InnoDB, PARTITION p01 VALUES LESS THAN (734653) ENGINE = InnoDB, PARTITION p02 VALUES LESS THAN (734745) ENGINE = InnoDB, PARTITION p04 VALUES LESS THAN (734867) ENGINE = InnoDB, PARTITION p05 VALUES LESS THAN (734965) ENGINE = InnoDB, PARTITION MERGER\_2012628 VALUES LESS THAN (735047) ENGINE = InnoDB, PARTITION pcurrent\_2012628 VALUES LESS THAN (735048) ENGINE = InnoDB, PARTITION pcurrent\_2012629 VALUES LESS THAN (735049) ENGINE = InnoDB)Connection ID (thread ID): 645329Status: NOT\_KILLEDYou may download the Percona Server operations manual by visitinghttp://www.percona.com/software/percona-server/. You may find informationin the manual which will help you identify the cause of the crash.121001 15:40:58 InnoDB: Error: table 121001 15:40:58 [Warning] Invalid (old?) table or database name '#sql5534\_1\_2’`tmp`.\ does not exist in the InnoDB internalInnoDB: data dictionary though MySQL is trying to drop it.InnoDB: Have you copied the .frm file of the table to theInnoDB: MySQL database directory from another database?InnoDB: You can look for further help fromInnoDB: [http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html](http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html) mysqld got signal 11 # perror 11OS error code 11: Resource temporarily unavailable My server has 32GB RAM. innodb settings: innodb\_max\_dirty\_pages\_pct=0innodb\_log\_file\_size = 1Ginnodb\_buffer\_pool\_size = 8Ginnodb\_additional\_mem\_pool\_size = 4M #global bufferinnodb\_status\_file #extra reportinginnodb\_file\_per\_table #enable alwaysinnodb\_flush\_log\_at\_trx\_commit = 2 #2/0 = perf, 1 = ACIDinnodb\_table\_locks = 0 #preserve table locksinnodb\_log\_buffer\_size = 128M #global bufferinnodb\_lock\_wait\_timeout = 60innodb\_thread\_concurrency = 16 #recommend 2x core quantityinnodb\_commit\_concurrency = 16 #recommend 4x num disksinnodb\_flush\_method = O\_DIRECT #