Description:
DELETE FROM TABLE LIMIT generates an erorr 499 frovi Sm the cluster engine
[/home/swanhart/scripts]: perl bug.pl
10 records inserted
DBD::mysql::db do failed: Got error 499 from storage engine at bug.pl line 28.
DBD::mysql::db do failed: Got error 499 from storage engine at bug.pl line 28.
How to repeat:
#Here is a perl script that easily demonstrates the problem:
$| = 1;
use DBI();
#please set appropriate values for your mysql instance
$dbuser = "";
$dbpass = "";
$dbname = "test";
$dbhost = "localhost";
#make the connection
$dsn = "DBI:mysql:database=$dbname;host=$dbhost";
$dbh = DBI->connect($dsn, $dbuser, $dbpass) or die ("could not connect!");
$dbh->{ 'AutoCommit' } = 1 ;
$dbh->{ 'RaiseError' } = 1 ;
#create a table to store the records in
$dbh->do("create table testtable (id int auto_increment, val int, primary key(id)) engine=NDB");
#insert some rows
for ($i=0;$i<10;$i++) {
$dbh->do("insert into testtable (val) values ($i)");
}
print "$i records inserted\n";
#this statement will generate an error
$dbh->do("delete from testtable limit 1");
Description: DELETE FROM TABLE LIMIT generates an erorr 499 frovi Sm the cluster engine [/home/swanhart/scripts]: perl bug.pl 10 records inserted DBD::mysql::db do failed: Got error 499 from storage engine at bug.pl line 28. DBD::mysql::db do failed: Got error 499 from storage engine at bug.pl line 28. How to repeat: #Here is a perl script that easily demonstrates the problem: $| = 1; use DBI(); #please set appropriate values for your mysql instance $dbuser = ""; $dbpass = ""; $dbname = "test"; $dbhost = "localhost"; #make the connection $dsn = "DBI:mysql:database=$dbname;host=$dbhost"; $dbh = DBI->connect($dsn, $dbuser, $dbpass) or die ("could not connect!"); $dbh->{ 'AutoCommit' } = 1 ; $dbh->{ 'RaiseError' } = 1 ; #create a table to store the records in $dbh->do("create table testtable (id int auto_increment, val int, primary key(id)) engine=NDB"); #insert some rows for ($i=0;$i<10;$i++) { $dbh->do("insert into testtable (val) values ($i)"); } print "$i records inserted\n"; #this statement will generate an error $dbh->do("delete from testtable limit 1");