Bug #35342 MySQL 5.0.24 fails to create TEMPORARY TABLE when we have 120million record.

• Submitted: 17 Mar 2008 15:38
• Modified: 8 Jun 2008 7:56
• Reporter: tejaswi gk
• Status: No Feedback
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.24a-pro
• OS: Linux (RHEL 4.0)
• Assigned to: Assigned Account
• CPU Architecture: Any

[17 Mar 2008 15:38] tejaswi gk

Description:
  MySQL on RHEL 4.0 fails to create TEMPORARY table when you have 120 million records in the database.

Server and platform details
./bin/mysqld  Ver 5.0.24a-pro for pc-linux-gnu on i686 (MySQL Pro (Commercial))

Command used:
mysql> CREATE TEMPORARY TABLE CATIBID (ibid INT NOT NULL);
ERROR 1005 (HY000): Can't create table 'CATIBID' (errno: 13)

How to repeat:
Install MySQL
give the innode data file size as 25GB
create a database and table with name like "infoitem"
publish 120 million records in to this table.
and then to try to create a TEMPORARY table as below to see the following error.
mysql> CREATE TEMPORARY TABLE CATIBID (ibid INT NOT NULL);
ERROR 1005 (HY000): Can't create table 'CATIBID' (errno: 13)

[17 Mar 2008 15:44] Sveta Smirnova

Thank you for the report.

But version 5.0.24 is quite old. Please upgrade to current verison 5.0.51a and if bug still exists provide your configuration file.

[17 Mar 2008 18:27] tejaswi gk

My.cnf file for the mysq configuration

Attachment: my.cnf (application/octet-stream, text), 1.26 KiB.

[17 Mar 2008 18:32] tejaswi gk

My Customers are running 5.0.24 and they have already 90+ million in their databases, i would like to know if is there any alternative  other than 5.0.51a.

Thanks,
Tejaswi

[18 Mar 2008 17:29] Sveta Smirnova

Thank you for the feedback.

I was not able to repeat described behavior.

Please provide output of SHOW CREATE TABLE infoitem and output of `df` and `du -sh /tmp` commands

[18 Mar 2008 17:34] Sveta Smirnova

Please also provide your error log file.

[18 Apr 2008 23: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".

[8 May 2008 7:56] Susanne Ebrecht

Many thanks for writing a bug report.

Unfortunately, we still need feedback from you:

Please provide output of SHOW CREATE TABLE infoitem and output of `df` and `du -sh /tmp` commands

Please also provide your error log file.

[8 Jun 2008 23: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".