[rt-users] PG to MySQL Duplicate key

[Kristian Davies]

Whilst converting my 2.6GB postgres RT database 3.6.5 to mysql i get
the following error.

[root at bogan rt-3.6.5]# mysql -u root -p rt3 --ignore < /tmp/rt.sql6
Enter password:
ERROR 1062 (23000) at line 34107989: Duplicate entry '242710-28171' for key 2

(line 34107989) INSERT INTO GroupMembers (id, groupid, memberid)
VALUES (199352, 242710, 28171);



Any ideas?



Cheers,
Kristian

mysql  Ver 14.12 Distrib 5.0.66a, for redhat-linux-gnu (x86_64) using
readline 5.1

Further grep of the previous line too:
INSERT INTO groupmembers (id, groupid, memberid) VALUES (199351, 242710, 28171);
INSERT INTO groupmembers (id, groupid, memberid) VALUES (199352, 242710, 28171);

mysql> desc GroupMembers;
+----------+---------+------+-----+---------+----------------+
| Field    | Type    | Null | Key | Default | Extra          |
+----------+---------+------+-----+---------+----------------+
| id       | int(11) | NO   | PRI | NULL    | auto_increment |
| GroupId  | int(11) | NO   | MUL | 0       |                |
| MemberId | int(11) | NO   |     | 0       |                |
+----------+---------+------+-----+---------+----------------+


>From prostgres

rt3=# select * from groupmembers where groupid='242710';
   id   | groupid | memberid
--------+---------+----------
 199351 |  242710 |    28171
 199352 |  242710 |    28171
(2 rows)

rt3=# \d groupmembers
                          Table "public.groupmembers"
  Column  |  Type   |                         Modifiers
----------+---------+-----------------------------------------------------------
 id       | integer | not null default nextval('groupmembers_id_seq'::regclass)
 groupid  | integer | not null default 0
 memberid | integer | not null default 0
Indexes:
    "groupmembers_pkey" PRIMARY KEY, btree (id)