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_si...@yahoo.com> > To: mysql@lists.mysql.com > 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
