List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 2 2011 2:21pm
Subject:Re: Two Identical Values on Primary Key Column
View as plain text  
Is it possible that someone did an alter table disable keys at some point, maybe for a
bulk load, and forgot to re-enable them ? 

----- Original Message -----

> From: "Rodrigo Ferreira" <rodrigof_silva@stripped>
> To: mysql@stripped
> Sent: Wednesday, 2 March, 2011 3:04:31 PM
> Subject: Two Identical Values on Primary Key Column

> Hi all,

> I have just experienced a strange problem with mysql production
> database. The table faqsessions have a primary key on column `Code`
> and the above select return 2 rows!

> mysql>
> mysql>
> mysql> show create table faqsessions;
>
> +-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

>
> +-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

> `Code` int(11) unsigned NOT NULL auto_increment,
> `sid` int(11) NOT NULL,
> `ip` text NOT NULL,
> `time` int(11) NOT NULL,
> PRIMARY KEY (`Code`)
> ) ENGINE=InnoDB AUTO_INCREMENT=1567573 DEFAULT CHARSET=latin1 |
>
> +-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
> 1 row in set (0.00 sec)

> mysql>
> mysql>
> mysql> select * from faqsessions where time in (1268650281,
> 1268650260);
> +--------+--------+--------------+------------+

> +--------+--------+--------------+------------+

> +--------+--------+--------------+------------+
> 2 rows in set (1.49 sec)

> mysql>
> mysql>
> mysql> select * from faqsessions where Code = 611179;
> +--------+--------+--------------+------------+

> +--------+--------+--------------+------------+

> +--------+--------+--------------+------------+
> 1 row in set (0.00 sec)

> Any idea?

> Rodrigo Ferreira
> CMDBA, CMDEV

-- 
Bier met grenadyn 
Is als mosterd by den wyn 
Sy die't drinkt, is eene kwezel 
Hy die't drinkt, is ras een ezel 

Thread
Two Identical Values on Primary Key ColumnRodrigo Ferreira2 Mar
  • Re: Two Identical Values on Primary Key ColumnJohan De Meersman2 Mar
    • Re: Two Identical Values on Primary Key ColumnRodrigo Ferreira2 Mar