[rt-users] Can't create tickets after migration

[Christian Theune]

Hi,

I just migrated from 2.0.15 to 3.4.3. Now I can't create any tickets
anymore. Neither via mail-gate nor via web-interface.
This is the error from the apache error_log:

[Thu Oct 06 10:16:47 2005] [error] [client 82.141.44.36<http://82.141.44.36>]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::Pg::st
execute failed: ERROR: duplicate key violates unique co nstraint
"attachments_pkey"
[Thu Oct 06 10:16:47 2005] [error] [client 82.141.44.36<http://82.141.44.36>]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr:
RT::Handle=HASH(0x27f03e0) couldn't execute the query 'INSERT INTO A
ttachments (ContentType, Parent, Subject, Headers, MessageId, Creator,
Created, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Ha
ndle.pm<http://ndle.pm>line 507.
[Thu Oct 06 10:16:47 2005] [error] [client 82.141.44.36<http://82.141.44.36>]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr: [Thu Oct 6
08:16:47 2005] [crit]: Attachment insert failed - ERROR: duplicate key
violates unique constraint "attachments_pkey"
[Thu Oct 06 10:16:47 2005] [error] [client 82.141.44.36<http://82.141.44.36>]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr:
(/opt/rt3/lib/RT/Attachment_Overlay.pm:186)
[Thu Oct 06 10:16:47 2005] [error] [client 82.141.44.36<http://82.141.44.36>]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::Pg::st
execute failed: ERROR: duplicate key violates unique co nstraint
"attachments_pkey"
[Thu Oct 06 10:16:47 2005] [error] [client 82.141.44.36<http://82.141.44.36>]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr:
RT::Handle=HASH(0x27f03e0) couldn't execute the query 'INSERT INTO A
ttachments (ContentType, Parent, Subject, Filename, Headers, MessageId,
Creator, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?)' at /usr/li
b/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 507.
[Thu Oct 06 10:16:47 2005] [error] [client 82.141.44.36<http://82.141.44.36>]
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr: [Thu Oct 6
08:16:47 2005] [crit]: Attachment insert failed - ERROR: duplicate key
violates unique constraint "attachments_pkey"


I'm using postgres as database.

Thanks in advance,
Christian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051006/d4b60141/attachment.htm>