Bug #4644 Err Out of fragment operations

• Submitted: 20 Jul 2004 9:48
• Modified: 19 Nov 2004 11:24
• Reporter: Johan Andersson
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S1 (Critical)
• Version: mysql 4.1 src bk
• OS: Linux (RH9)
• Assigned to: Pekka Nousiainen
• CPU Architecture: Any

[20 Jul 2004 9:48] Johan Andersson

Description:
Err 
code 830 is thrown to the mysqld (830= Out of fragment operations). A 
 number of failed "alter tables" caused this. 

How to repeat:
fail a lot of alter tables!!!

[15 Aug 2004 14:07] Jonas Oreland

Hi,

I tried a bunch of failing create/alter tables.
I did not however manage to get 830.

Please give more info.

[14 Sep 2004 8:45] Thomas Lußnig

First i tryied couple of times create an table with error 4336.
When i try to fix this i removed rows and recreate the table couple of times with more an more rows.
When i hit the error again i removed the last row and got error 830 too.

INFO:
Restating the DB-Nodes in the cluster solve the error 830 !!!

15 * Create and Delete Tables with and failed create table behind and than Error 830

     12 HashIndexTrigger
     62 IndexTrigger
     62 OrderedIndex
      2 SystemTable
      4 UniqueHashIndex
     41 UserTable
62+2+4+41= 109 (Counted Tables from Maximum 128)
109 + 1 Table + 2 Index + (15 droped table) == 127

Maybe the result of counted table + droped table + new created table is not independed from the max number 128.
Is it possible that the drop table's stay in the ndbd process counted as aktive table ?

a) Is there any way to get more than 128 Tables supported ? (hosting multiple databases for webfronteds, like forum's)

[14 Sep 2004 8:46] Thomas Lußnig

The Version for the Comment above is "mysql-4.1.4a-gamma"

[14 Sep 2004 9:16] Pekka Nousiainen

Theoretically possible, set to Open.
Need to handle REF signals from TUP and TUX better.

[4 Oct 2004 13:53] Jonas Oreland

I lowered the prio as there is no reproducable way to get this bug.
It's however a bug...

[6 Oct 2004 11:48] Jonas Oreland

Can't repeat wo/ writing error insert...

[11 Nov 2004 8:19] Tomas Ulin

How to repeat

MaxNoOfOrderedIndexes= 2

mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 800)
mysql> create table ttt (a int primary key);
ERROR 1005 (HY000): Can't create table './test/ttt.frm' (errno: 830)

[19 Nov 2004 11:24] Tomas Ulin

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/