List:Cluster« Previous MessageNext Message »
From:Tomas Ulin Date:November 11 2004 8:52am
Subject:Re: perror 800 ?
View as plain text  
perror --ndb 830
Error code 830:  Out of add fragment operation records: Temporary error: 
Temporary Resource error

800 means that you have to increase MaxNoOfOrderedIndexes, this code has 
not been put into perror yet, but will come in 4.1.8:

./perror --ndb 800
Error code 800:  Too many ordered indexes (increase 
MaxNoOfOrderedIndexes): Permanent error: Insufficient space


the 830 problem turns up every now and then and we're chasing it.  If 
you have a reproducable test we would be greatful.

T

Olivier Kaloudoff wrote:

> Hmmm.
>
>
>     seems that perror 155 and perror 830 are friends of perror 800 ...
> I'm trying to strip the fields one by one to find out the cause of the 
> error, but no success;
>
>
> mysql> CREATE TABLE MMyCache (
>     ->   date date,
>     ->   url varchar(255),
>     ->   file_name varchar(64),
>     ->   PRIMARY KEY (file_name)
>     -> ) ;
> ERROR 1005 (HY000): Can't create table './beta6/MMyCache.frm' (errno: 
> 830)
>
>
> mysql> CREATE TABLE MMyCache (   date date,   url varchar(255), 
> file_name varchar(64) );
> ERROR 1005 (HY000): Can't create table './beta6/MMyCache.frm' (errno: 
> 155)
>
>
> On Wed, 10 Nov 2004, Olivier Kaloudoff wrote:
>
>> Hi,
>>
>>
>>     Still trying to import my datas from a mysql 4.0.16 / MyISAM;
>> After reading Error-handling.html, I did not find the code 720 ...
>>
>>
>> root@mapi0:/# mysql "beta6"
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 13 to server version: 4.1.7-max
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> CREATE TABLE MMyCache (
>>    ->   date date NOT NULL default '0000-00-00',
>>    ->   url varchar(255) NOT NULL default '',
>>    ->   file_name varchar(64) NOT NULL default '',
>>    ->   PRIMARY KEY  (file_name)
>>    -> ) ;
>> ERROR 1005 (HY000): Can't create table './beta6/MMyCache.frm' (errno: 
>> 800)
>> mysql> Bye
>>
>> root@mapi0:/# perror 800
>> Illegal error code: 800
>>
>> root@mapi0:/# type perror
>> perror is hashed (/var/lib/mysql-cluster/bin/perror)
>>
>>
>>
>> Olivier
>>
>>
>>
>> http://dev.mysql.com/doc/mysql/en/Error-handling.html
>> http://bugs.mysql.com/bug.php?id=531
>>
>>
>
>

Thread
perror 800 ?Olivier Kaloudoff10 Nov
  • Re: perror 800 ?Olivier Kaloudoff10 Nov
    • Re: perror 800 ?Chad Martin11 Nov
      • Re: perror 800 ?Tomas Ulin11 Nov
    • Re: perror 800 ?Tomas Ulin11 Nov