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
>>
>>
>
>
