Bug #31183 Tablespace full problems not reported in error log, error message unclear
Submitted: 25 Sep 2007 9:50 Modified: 20 Jun 2010 1:15
Reporter: Kristian Koehntopp Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.0.46, 4.1, 5.0, 5.1 BK OS:Any
Assigned to: CPU Architecture:Any

[25 Sep 2007 9:50] Kristian Koehntopp
Description:
When an InnoDB tablespace fills up, an error is logged to the client, but not the error log. Also, the error message is misleading and not pointing to the real source of the problem.

How to repeat:
Create a server instance with an innodb table space that is not autoextending.

innodb_data_file_path = ibdata1:10M
innodb_file_per_table = 0

Create a schema and a table, with some dummy data:

root@localhost [kris]> show create table t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `d` char(100) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2828 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

and

insert into t (d) values ("blablablablablablablablabla");

Now duplicate that data as long as needed to overflow the tablespace:

insert into t (d) select d from t; # repeat about 10-12 times

root@localhost [kris]> insert into t (d) select d from t;
ERROR 1114 (HY000): The table 't' is full

Check the mysqld.err file. Nothing is logged.
Check the text of the error message. It should say "tablespace (tablespacename) full" if the tablespace is not autoextending, it should say "disk (devicename) full, if the tablespace cannot longer autoextend because the disk is full, it should say "quota for user (username) exceeded", if an EQUOTA is returned from the autoextend.

Suggested fix:
See "how to repeat".
[25 Sep 2007 11:58] Sveta Smirnova
Thank you for the report.

Verified as described.
[22 Nov 2007 12:29] Heikki Tuuri
Assigning this to Inaam.
[28 Nov 2007 6:53] Inaam Rana
Kristian,

For any error returned by the OS, InnoDB will print a message. Specifically if ENOSPC is returned a 'disk full' message is printed by the InnoDB. In other cases, InnoDB may print a detailed message but at the very least it will print the errno returned by the OS.

The case of non auto-extending datafile is different in that it is not an OS error. However, your suggestion that InnoDB should print a message to that effect is a reasonable feature request.

Since 5.1 is already in code freeze state, we can attempt to include your suggestion in 6.x time frame.

Thanks for pointing this out.

regards,
inaam
[11 Mar 2009 22:09] Timothy Smith
Queued in 6.0-bugteam
[8 Apr 2009 19:58] Timothy Smith
Docs team,

This is fixed in 6.0.11 (not yet released).

Timothy
[8 Apr 2009 23:32] Paul DuBois
Noted in 6.0.11 changelog.

When an InnoDB tablespace filled up, an error was logged to the
client, but not to the error log. Also, the error message was 
misleading and did not indicate the real source of the problem.
[14 Oct 2009 14:39] Bugs System
Pushed into 5.1.41 (revid:joro@sun.com-20091014143611-cphb0enjlx6lpat1) (version source revid:satya.bn@sun.com-20091009133747-iq5nu042j74xc32c) (merge vers: 5.1.40) (pib:13)
[14 Oct 2009 16:58] Paul DuBois
Noted in 5.1.41 changelog.

Setting report to NDI pending push into 5.5.x.
[22 Oct 2009 6:33] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091022063126-l0qzirh9xyhp0bpc) (version source revid:alik@sun.com-20091019135554-s1pvptt6i750lfhv) (merge vers: 6.0.14-alpha) (pib:13)
[22 Oct 2009 7:05] Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091022060553-znkmxm0g0gm6ckvw) (version source revid:alik@sun.com-20091019131022-2o2ymjfjjoraq833) (merge vers: 5.5.0-beta) (pib:13)
[22 Oct 2009 20:09] Paul DuBois
Noted in 5.5.0 changelog.

For 6.0.x, already fixed in 6.0.11.
[18 Dec 2009 10:28] Bugs System
Pushed into 5.1.41-ndb-7.1.0 (revid:jonas@mysql.com-20091218102229-64tk47xonu3dv6r6) (version source revid:jonas@mysql.com-20091218095730-26gwjidfsdw45dto) (merge vers: 5.1.41-ndb-7.1.0) (pib:15)
[18 Dec 2009 10:44] Bugs System
Pushed into 5.1.41-ndb-6.2.19 (revid:jonas@mysql.com-20091218100224-vtzr0fahhsuhjsmt) (version source revid:jonas@mysql.com-20091217101452-qwzyaig50w74xmye) (merge vers: 5.1.41-ndb-6.2.19) (pib:15)
[18 Dec 2009 10:59] Bugs System
Pushed into 5.1.41-ndb-6.3.31 (revid:jonas@mysql.com-20091218100616-75d9tek96o6ob6k0) (version source revid:jonas@mysql.com-20091217154335-290no45qdins5bwo) (merge vers: 5.1.41-ndb-6.3.31) (pib:15)
[18 Dec 2009 11:13] Bugs System
Pushed into 5.1.41-ndb-7.0.11 (revid:jonas@mysql.com-20091218101303-ga32mrnr15jsa606) (version source revid:jonas@mysql.com-20091218064304-ezreonykd9f4kelk) (merge vers: 5.1.41-ndb-7.0.11) (pib:15)
[5 May 2010 15:06] Bugs System
Pushed into 5.1.47 (revid:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[6 May 2010 3:06] Paul DuBois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug. Re-closing.
[28 May 2010 6:00] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:29] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 6:56] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[29 May 2010 23:16] Paul DuBois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[15 Jun 2010 8:10] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100615080459-smuswd9ooeywcxuc) (version source revid:mmakela@bk-internal.mysql.com-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:16)
[15 Jun 2010 8:26] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100615080558-cw01bzdqr1bdmmec) (version source revid:mmakela@bk-internal.mysql.com-20100415070122-1nxji8ym4mao13ao) (pib:16)
[17 Jun 2010 12:03] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:46] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:30] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)