I have the table smses_in with id and text columns (about 250 000 records), when I do the query
SELECT count(id) FROM `smses_in` group by text
I get next error:
1022 - Can't write; duplicate key in table '/tmp/#sql_3ed_0'.
Asked
Active
Viewed 80 times
0
John Conde
- 207,509
- 96
- 428
- 469
Victor Bredihin
- 1,952
- 16
- 29
-
possible duplicate http://stackoverflow.com/questions/18056786/error-1022-cant-write-duplicate-key-in-table – mamdouh alramadan Apr 29 '14 at 14:22
-
`duplcate key ..` on `select` query??? – Ravinder Reddy Apr 29 '14 at 14:22
-
Yes, exactly, it's wondering – Victor Bredihin Apr 29 '14 at 14:50
-
Can you post your schema? – Jim Apr 29 '14 at 15:31
-
http://speedy.sh/46gKf/wordpress.sql – Victor Bredihin Apr 29 '14 at 16:01
-
1@VictorBredihin Looks like maybe the table has been corrupted somehow. See here about sorting the table: http://stackoverflow.com/questions/226172/how-do-i-repair-an-innodb-table It's mentioned at that link but it's worth reiterating that you should be backing up your tables before following any instructions. Hope this helps. – Jim Apr 30 '14 at 08:30
-
thanks, but it does not solve my problem – Victor Bredihin May 01 '14 at 20:26
1 Answers
0
you cannot get that error for a select statement i did a similar query
select count(*) from supportContacts group by id
you can see at http://sqlfiddle.com/#!2/a2581/24273
possibly there is some other query in your code which is being run at thee same time...
Aamir
- 328
- 1
- 8
-
So, i created table and insert several rows, all works fine. But I need import file(about 250 000 rows), and when I imported this file, my query (SELECT count(id) FROM `smses_in` group by text) broken with erro (1022 - Can't write; duplicate key in table '/tmp/#sql_3ed_0'.) – Victor Bredihin Apr 29 '14 at 15:46
-
http://speedy.sh/46gKf/wordpress.sql link to schema, you can import it to your DB and see my error – Victor Bredihin Apr 29 '14 at 16:02