[rt-users] rt2-to-rt3 postgres issue

Drew Barnes barnesaw at ucrwcu.rwc.uc.edu
Tue Jun 28 15:58:01 EDT 2005



Law Mitchell wrote:

>used rt-2.0-to-dumpfile on data from a rt2.0.15 system. then after a
>fresh install of rt3.4.2, i get the error below when i try to use
>dumpfile-to-rt-3.0 to import the dump of the 2.0.15 system.
>anyone know how to handle the error below?...
>Importing groups
>gggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqImporting
>tickets...t-1
>[Tue Jun 28 18:48:10 2005] [crit]: Couldn't create a ticket: Internal
>Error: Couldn't execute the query 'INSERT INTO Tickets (Status, Queue,
>Started, Type, Starts, id, LastUpdated, Subject, Creator, Owner,
>LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?, ?,
>?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'ERROR:  duplicate key violates unique
>constraint "tickets_pkey"
>  
>
Do the following, then re-import:
# sbin/rt-setup-database --action drop
# sbin/rt-setup-database --action init

It sounds like you already have tickets in the database.

> (/opt/rt3/lib/RT/Ticket_Overlay.pm:590)
>Couldn't create ticket HASH(0x986c434) $VAR1 = {
>          'Status' => 'resolved',
>          'Queue' => 'kerberos-test',
>          'Started' => '2002-04-17 19:18:21+00',
>          'Starts' => '1970-01-01 00:00:00+00',
>          '_RecordTransaction' => '0',
>          'id' => 1,
>          'LastUpdated' => '2003-02-06 00:01:26+00',
>          'Requestor' => [
>                           'xxx at yyy.net'
>                         ],
>          'Subject' => 'test from home',
>          'Creator' => '1896',
>          'Owner' => '1896',
>          'EffectiveId' => '1',
>          'LastUpdatedBy' => '2512',
>          'Resolved' => '2002-04-17 19:18:39+00',
>          'Created' => '2002-04-17 19:16:21+00',
>          'Due' => '2002-04-19 19:16:21+00'
>        };
>Couldn't create trans  1
>$VAR1 = {
>          'Type' => 'Create',
>          'Ticket' => '1',
>          'Created' => '2002-04-17 19:16:22+00',
>          'id' => 1,
>          'Creator' => '1896',
>          'ActivateScrips' => '0'
>        };
>rt_mig at zoolo$ 
>
>help much appreciated,
>mitchell
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>  
>

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati




More information about the rt-users mailing list