List:Cluster« Previous MessageNext Message »
From:Pascal Gauthier Date:August 10 2004 8:00pm
Subject:Re: auto_increment with MySQL Cluster produce weird result in some
case
View as plain text  
On Tue, 2004-08-10 at 15:53, Pascal Gauthier wrote:
> I have seen something weird when I test MySQL Cluster with one of my
> perl script. 
> 
> Here are the table:
> CREATE TABLE log (logid bigint(20) NOT NULL auto_increment, entityid
> bigint(20) NOT NULL default 0, timestamp bigint(20) NOT NULL default 0,
> entitylogid bigint(20) NOT NULL default 0, entitylogtimestamp bigint(20)
> NOT NULL default 0, logtype bigint(20) NOT NULL default 0, PRIMARY KEY
> (logid)) ENGINE=NDB;
> 
> With this script, auto_increment doesnt work properly. 192.168.101.4 and
> 192.168.101.7 are my api node. The auto_increment jump by a factor of
> 32...
> 
> #!/usr/bin/perl
>  
> use DBI;
> use POSIX qw(strftime);
>  
> while (true) {
>  
>         if ( $server eq "192.168.101.4") {
>                 $server = "192.168.101.7";
>         }
>         else {
>                 $server = "192.168.101.4";
>         };
>  
>         my $dbh = DBI->connect("DBI:mysql:test:$server", mytest)
>                 or die "Couldn't connect to database: " . DBI->errstr;
>  
>         my $sql = qq{ INSERT INTO log VALUE ( NULL, 1, 2, 3, 4, 5) };
>         $dbh->do($sql);
>  
>         $time = strftime "%H:%M:%S", localtime;
>         print "$time :  INSERT INTO log VALUE ( NULL, 1, 2, 3, 4, 5 )
> FROM server $server\n";
>         sleep(1);
>  
>         $dbh->disconnect;
> };

------------------------------------------
http://mysql.urc.bl.ac.yu/doc/cluster/en/
------------------------------------------

Hummmm, ok this bug was present in the 4.1.2 release...
Seem still broken

-- 
Pascal Gauthier
Cel: 514-668-9966
http://www.nihilisme.ca

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Thread
auto_increment with MySQL Cluster produce weird result in some casePascal Gauthier10 Aug
  • Re: auto_increment with MySQL Cluster produce weird result in somecasePascal Gauthier10 Aug
    • Re: auto_increment with MySQL Cluster produce weird result in somecaseMartin Skold11 Aug
      • Re: auto_increment with MySQL Cluster produce weird result in somecasePascal Gauthier11 Aug