[rt-users] Re: [rt-devel] rt2 to rt3 db conversion problems

Justin Clayton justincl at u.washington.edu
Tue May 20 16:42:45 EDT 2003


Jesse Vincent wrote:
> Why don't you try sending the dumpfiles for the two tickets you've
> referenced? Sending data illustrating a problem is often a good way to
> help track down the issue itself.

Here goes. I'm sure you will all at least get a kick out my users' 
requests :-). The ticket dumps are attached.

--Justin Clayton
justincl at u.washington.edu

> On Tue, May 20, 2003 at 12:53:21PM -0700, justin m. clayton wrote:
> 
>>So, now I'm not getting the [crit] errors, but the condition is still
>>there. It's also worth noting that I've been creating new tickets through
>>the webui since the import, and they don't seem to have this problem,
>>further pointing to the dumpfile-rt3 script as the source of this issue.
>>
>>--Justin Clayton
>>justincl at u.washington.edu
>>
>>On Tue, 20 May 2003, justin m. clayton wrote:
>>
>>
>>>I haven't gotten a response regarding my conversion problems in a week's
>>>time, and I'm just wondering if it's something simple that is so obvious
>>>to everyone else that it isn't worth a response... :-)
>>>
>>>Here's some more info that may help:
>>>
>>>* Red Hat 7.3
>>>* mysql-3.23.54a-3.73 rpm
>>>* Ticket 1069, when reply or comment is clicked in the webui, appears to
>>>have the content of ticket 1078. This happens all over the place, though
>>>sometimes the text is "This ticket appears to have no content" on reply.
>>>* The exported text forms of the tickets appear to be correct.
>>>* I've tried re-importing, with the same result.
>>>
>>>I've noticed that the [crit] error with ACE_Overlay.pm seems to be a
>>>common issue with others on the list. Any help would be appreciated.
>>>
>>>--Justin Clayton
>>>justincl at u.washington.edu
>>>
>>>On Tue, 13 May 2003, justin m. clayton wrote:
>>>
>>>
>>>>I got strange output during dump->rt3 conversion, and now it appears that
>>>>ticket content has been mixed up a bit (the ticket display page has the
>>>>correct body, but hitting "reply" indent-includes the wrong body from a
>>>>different ticket entirely). Here's the output of the conversion script:
>>>>
>>>>Importing users
>>>>............................................................................................................................................................................................................................
>>>>Importing groups
>>>>[Tue May 13 22:42:31 2003] [crit]: 1
>>>>(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:884)
>>>>[Tue May 13 22:42:31 2003] [crit]: Can't load a principal for id
>>>>(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:885)
>>>>[Tue May 13 22:42:31 2003] [crit]: 1
>>>>(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:884)
>>>>[Tue May 13 22:42:31 2003] [crit]: Can't load a principal for id
>>>>(/usr/local/pkgs/rt3/lib/RT/ACE_Overlay.pm:885)
>>>># Repeat last 2 lines 54 times each #
>>>>Importing tickets...t-1
>>>>.t-2
>>>>.t-3
>>>>.t-4
>>>>.t-5
>>>>.t-6
>>>># skip a bit, please
>>>>.t-1192
>>>>.t-1193
>>>>.t-1194
>>>>Importing links
>>>>Could not create scrip: On Status Notify AdminCcs with templateStatus Change inqueue0
>>>>Could not create scrip: On Create Autoreply To Requestors with templateV LS I  Autoreply in queue0
>>>>Could not create scrip: On Resolve Notify Requestors with templateV LS I Resolved in queue0
>>>>
>>>>Those templates should be "VLSI Resolved", and so forth. It looks like
>>>>other things that didn't get imported properly include Keywords/Custom
>>>>Fields and Templates (and perhaps other things; I haven't taken a tour
>>>>yet).
>>>>
>>>>Any help would be appreciated. Thanks,
>>>
>>>Justin Clayton
>>>VLSI Research System Administrator
>>>University of Washington
>>>Electrical Engineering Dept
>>>justincl at u.washington.edu
>>>206/543.2523  EE/CSE 307E
>>>
>>>_______________________________________________
>>>rt-users mailing list
>>>rt-users at lists.fsck.com
>>>http://lists.fsck.com/mailman/listinfo/rt-users
>>>
>>>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>>>
>>
>>Justin Clayton
>>VLSI Research System Administrator
>>University of Washington
>>Electrical Engineering Dept
>>justincl at u.washington.edu
>>206/543.2523  EE/CSE 307E
>>
>>_______________________________________________
>>rt-users mailing list
>>rt-users at lists.fsck.com
>>http://lists.fsck.com/mailman/listinfo/rt-users
>>
>>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 
> 


-- 
Justin Clayton
VLSI Research System Administrator
University of Washington
Electrical Engineering Dept
justincl at u.washington.edu
206/543.2523  EE/CSE 307E
-------------- next part --------------
no warnings qw/redefine/; 
 sub Data {
$VAR1 = {
          'Creator' => '4',
          'Due' => '1970-01-01 00:00:00',
          'Told' => '2003-04-23 22:23:15',
          'Watchers' => [
                          {
                            'Id' => '1296',
                            'Email' => 'towen at ee.washington.edu',
                            'Type' => 'Requestor'
                          }
                        ],
          'Status' => 'open',
          'EffectiveId' => '1069',
          'LastUpdatedBy' => '4',
          'LastUpdated' => '2003-05-09 19:25:33',
          'Subject' => 'Install Xilinx ISE in Nikola space',
          'FinalPriority' => '90',
          'Queue' => 'VLSI',
          'CustomFields' => {
                              '5' => [
                                       'ACME'
                                     ]
                            },
          'id' => '1069',
          'Owner' => '4',
          'InitialPriority' => '50',
          'Created' => '2003-03-13 23:22:07',
          'Transaction' => [
                             {
                               'Creator' => '4',
                               'Attachment' => [
                                                 {
                                                   'Creator' => '4',
                                                   'ContentType' => 'multipart/mixed',
                                                   'Subject' => 'Install Xilinx ISE in Nikola space',
                                                   'TransactionId' => '6242',
                                                   'Created' => '2003-03-13 23:22:09',
                                                   'Headers' => 'MIME-Version: 1.0
X-Mailer: MIME-tools 5.411 (Entity 5.404)
Subject: Install Xilinx ISE in Nikola space
Content-Type: multipart/mixed; boundary="----------=_1047597727-25344-6"
'
                                                 },
                                                 {
                                                   'Creator' => '4',
                                                   'ContentEncoding' => 'none',
                                                   'ContentType' => 'text/plain',
                                                   'TransactionId' => '6242',
                                                   'Created' => '2003-03-13 23:22:09',
                                                   'Headers' => 'Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
',
                                                   'Parent' => '5997'
                                                 },
                                                 {
                                                   'Creator' => '4',
                                                   'ContentEncoding' => 'none',
                                                   'ContentType' => 'text/plain',
                                                   'TransactionId' => '6242',
                                                   'Created' => '2003-03-13 23:22:09',
                                                   'Headers' => 'Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
',
                                                   'Parent' => '5997'
                                                 }
                                               ],
                               'Ticket' => '1069',
                               'id' => '6242',
                               'Type' => 'Create',
                               'Created' => '2003-03-13 23:22:08'
                             },
                             {
                               'Creator' => '7',
                               'Attachment' => [
                                                 {
                                                   'Creator' => '7',
                                                   'ContentEncoding' => 'none',
                                                   'Content' => 'Scott,

The info you gave me didn\'t seem to contain the magic number I need. We\'ll
have to delay the installation of this software until Todd gets back. Let
me know if this is a problem.

Justin Clayton
VLSI Research System Administrator
University of Washington
Electrical Engineering Dept
justincl at u.washington.edu
206/543.2523  EE/CSE 307E

',
                                                   'ContentType' => 'text/plain',
                                                   'Subject' => '[UW/EE Research Computing #1069] ISE Alliance installation',
                                                   'TransactionId' => '6295',
                                                   'Created' => '2003-03-19 20:46:46',
                                                   'Headers' => 'Received: from maxwell-a.ee.washington.edu (maxwell-a.ee.washington.edu [128.95.42.91])
	by brak.ee.washington.edu (8.11.6/8.11.6) with ESMTP id h2JKkWE02125
	for <vlsi-rt at brak.ee.washington.edu>; Wed, 19 Mar 2003 12:46:32 -0800
Received: from doppler.ee.washington.edu (doppler.ee.washington.edu [128.95.42.39])
	by maxwell-a.ee.washington.edu (8.12.8/8.12.8) with ESMTP id h2JKkVBC028794
	(version=TLSv1/SSLv3 cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=NO);
	Wed, 19 Mar 2003 12:46:31 -0800
Received: from mxout2.cac.washington.edu (mxout2.cac.washington.edu [140.142.33.4])
	by doppler.ee.washington.edu (8.12.8/8.12.8) with ESMTP id h2JKkQrn000352
	(version=TLSv1/SSLv3 cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=NO);
	Wed, 19 Mar 2003 12:46:26 -0800
Received: from mailhost2.u.washington.edu (mailhost2.u.washington.edu [140.142.33.2])
	by mxout2.cac.washington.edu (8.12.1+UW03.03/8.12.1+UW02.12) with ESMTP id h2JKkPva011691;
	Wed, 19 Mar 2003 12:46:25 -0800
Received: from homer09.u.washington.edu (homer09.u.washington.edu [140.142.15.47])
	by mailhost2.u.washington.edu (8.12.1+UW03.03/8.12.1+UW02.12) with ESMTP id h2JKkP4h017568;
	Wed, 19 Mar 2003 12:46:25 -0800
Date: Wed, 19 Mar 2003 12:46:25 -0800 (PST)
From: "justin m. clayton" <justincl at u.washington.edu>
To: vlsihelp at ee.washington.edu
Cc: Kenneth H Eguro <eguro at ee.washington.edu>,
   Scott Hauck <hauck at ee.washington.edu>
Subject: [UW/EE Research Computing #1069] ISE Alliance installation
Message-Id: <Pine.A41.4.44.0303191238480.120976-100000 at homer09.u.washington.edu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Ee-Scanned: by amavisd-milter
'
                                                 }
                                               ],
                               'Ticket' => '1069',
                               'id' => '6295',
                               'Type' => 'Correspond',
                               'Created' => '2003-03-19 20:46:45',
                               'Data' => '[UW/EE Research Computing #1069] ISE Alliance installation
'
                             },
                             {
                               'Creator' => '4',
                               'OldValue' => 'open',
                               'Ticket' => '1069',
                               'NewValue' => 'stalled',
                               'id' => '6296',
                               'Field' => 'Status',
                               'Type' => 'Status',
                               'Created' => '2003-03-19 21:47:57'
                             },
                             {
                               'Creator' => '4',
                               'Ticket' => '1069',
                               'NewValue' => 'ACME',
                               'id' => '6297',
                               'Field' => '5',
                               'Type' => 'Keyword',
                               'Created' => '2003-03-19 21:48:05'
                             },
                             {
                               'Creator' => '4',
                               'OldValue' => 'stalled',
                               'Ticket' => '1069',
                               'NewValue' => 'open',
                               'id' => '6634',
                               'Field' => 'Status',
                               'Type' => 'Status',
                               'Created' => '2003-04-23 16:51:32'
                             },
                             {
                               'Creator' => '4',
                               'Attachment' => [
                                                 {
                                                   'Creator' => '4',
                                                   'ContentType' => 'multipart/mixed',
                                                   'TransactionId' => '6658',
                                                   'Created' => '2003-04-23 22:23:02',
                                                   'Headers' => 'MIME-Version: 1.0
X-Mailer: MIME-tools 5.411 (Entity 5.404)
Content-Type: multipart/mixed; boundary="----------=_1051136582-1247-12"
'
                                                 },
                                                 {
                                                   'Creator' => '4',
                                                   'ContentEncoding' => 'none',
                                                   'Content' => 'Todd,

I don\'t seem to have the media. Do you have it?

-- 
Justin Clayton
VLSI Research System Administrator
University of Washington
Electrical Engineering Dept
justincl at u.washington.edu
206/543.2523  EE/CSE 307E',
                                                   'ContentType' => 'text/plain',
                                                   'TransactionId' => '6658',
                                                   'Created' => '2003-04-23 22:23:02',
                                                   'Headers' => 'Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
',
                                                   'Parent' => '6356'
                                                 },
                                                 {
                                                   'Creator' => '4',
                                                   'ContentEncoding' => 'none',
                                                   'ContentType' => 'text/plain',
                                                   'TransactionId' => '6658',
                                                   'Created' => '2003-04-23 22:23:02',
                                                   'Headers' => 'Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
',
                                                   'Parent' => '6356'
                                                 }
                                               ],
                               'Ticket' => '1069',
                               'id' => '6658',
                               'Type' => 'Correspond',
                               'Created' => '2003-04-23 22:23:02',
                               'Data' => 'No Subject'
                             },
                             {
                               'Creator' => '4',
                               'OldValue' => 'open',
                               'Ticket' => '1069',
                               'NewValue' => 'stalled',
                               'id' => '6659',
                               'Field' => 'Status',
                               'Type' => 'Status',
                               'Created' => '2003-04-23 22:23:15'
                             },
                             {
                               'Creator' => '4',
                               'OldValue' => 'stalled',
                               'Ticket' => '1069',
                               'NewValue' => 'open',
                               'id' => '6902',
                               'Field' => 'Status',
                               'Type' => 'Status',
                               'Created' => '2003-05-09 19:25:18'
                             }
                           ],
          'Priority' => '50',
          'Starts' => '1970-01-01 00:00:00'
        };
}
1;
-------------- next part --------------
no warnings qw/redefine/; 
 sub Data {
$VAR1 = {
          'Creator' => '200',
          'Due' => '2003-03-19 17:43:53',
          'Told' => '2003-03-19 18:03:21',
          'Watchers' => [
                          {
                            'Id' => '1306',
                            'Email' => 'andreik at ee.washington.edu',
                            'Type' => 'Requestor'
                          }
                        ],
          'Status' => 'resolved',
          'EffectiveId' => '1078',
          'LastUpdatedBy' => '4',
          'Started' => '2003-03-19 18:11:32',
          'Resolved' => '2003-03-19 18:11:32',
          'LastUpdated' => '2003-03-19 18:11:48',
          'Subject' => '[no subject]',
          'FinalPriority' => '90',
          'Queue' => 'VLSI',
          'id' => '1078',
          'Owner' => '4',
          'InitialPriority' => '50',
          'Created' => '2003-03-19 17:43:54',
          'Transaction' => [
                             {
                               'Creator' => '200',
                               'Attachment' => [
                                                 {
                                                   'Creator' => '200',
                                                   'ContentType' => 'multipart/alternative',
                                                   'TransactionId' => '6284',
                                                   'Created' => '2003-03-19 17:43:55',
                                                   'Headers' => 'Received: from maxwell-a.ee.washington.edu (maxwell-a.ee.washington.edu [128.95.42.91])
	by brak.ee.washington.edu (8.11.6/8.11.6) with ESMTP id h2JHhiE14287
	for <vlsi-rt at brak.ee.washington.edu>; Wed, 19 Mar 2003 09:43:45 -0800
Received: from bobcat (localhost.localdomain [127.0.0.1])
	by maxwell-a.ee.washington.edu (8.12.8/8.12.8) with SMTP id h2JHhhBB008732
	for <vlsi-rt at brak.ee.washington.edu>; Wed, 19 Mar 2003 09:43:43 -0800
Message-Id: <0c2e01c2ee3f$16059490$be1e5f80 at ee.washington.edu>
From: "Andrei B Khlopotine" <andreik at ee.washington.edu>
To: <vlsi-rt at brak.ee.washington.edu>
Subject: 
Date: Wed, 19 Mar 2003 09:43:43 -0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0C2B_01C2EDFC.07C09BC0"
X-Priority: 3
X-Msmail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2720.3000
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Ee-Scanned: by amavisd-milter
'
                                                 },
                                                 {
                                                   'Creator' => '200',
                                                   'ContentEncoding' => 'none',
                                                   'Content' => 'the servers are slow . i ned them working . have a deadline. can we do somtihng about this?

Thank you,


Andrei B Khlopotine
VLSI/CAD Lab Research Assistant
Electrical Engineering Department
University of Washington
ph: +1 (206) 685-8678
',
                                                   'ContentType' => 'text/plain',
                                                   'TransactionId' => '6284',
                                                   'Created' => '2003-03-19 17:43:55',
                                                   'Headers' => 'Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
',
                                                   'Parent' => '6026'
                                                 },
                                                 {
                                                   'Creator' => '200',
                                                   'ContentEncoding' => 'none',
                                                   'Content' => '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>the servers are slow . i ned them working . have a 
deadline. can we do somtihng about this?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Thank you,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Andrei B Khlopotine<BR>VLSI/CAD Lab Research 
Assistant<BR>Electrical Engineering Department<BR>University of 
Washington<BR>ph: +1 (206) 685-8678</FONT></FONT></DIV></DIV></BODY></HTML>
',
                                                   'ContentType' => 'text/html',
                                                   'TransactionId' => '6284',
                                                   'Created' => '2003-03-19 17:43:55',
                                                   'Headers' => 'Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
',
                                                   'Parent' => '6026'
                                                 }
                                               ],
                               'Ticket' => '1078',
                               'id' => '6284',
                               'Type' => 'Create',
                               'Created' => '2003-03-19 17:43:54'
                             },
                             {
                               'Creator' => '7',
                               'Attachment' => [
                                                 {
                                                   'Creator' => '7',
                                                   'ContentEncoding' => 'none',
                                                   'Content' => 'I\'m looking into it now. They seem to be only slow on login, so please be
patient while we\'re trying to pin down the problem.

--Justin

On Wed, 19 Mar 2003, andreik at ee.washington.edu via RT wrote:

>
>
> the servers are slow . i ned them working . have a deadline. can we do somtihng about this?
>
> Thank you,
>
>
> Andrei B Khlopotine
> VLSI/CAD Lab Research Assistant
> Electrical Engineering Department
> University of Washington
> ph: +1 (206) 685-8678
>

Justin Clayton
VLSI Research System Administrator
University of Washington
Electrical Engineering Dept
justincl at u.washington.edu
206/543.2523  EE/CSE 307E

',
                                                   'ContentType' => 'text/plain',
                                                   'Subject' => 'Re: [UW/EE Research Computing #1078]',
                                                   'TransactionId' => '6286',
                                                   'Created' => '2003-03-19 18:03:15',
                                                   'Headers' => 'Received: from mxout4.cac.washington.edu (mxout4.cac.washington.edu [140.142.33.19])
	by brak.ee.washington.edu (8.11.6/8.11.6) with ESMTP id h2JI34E26326
	for <vlsi-rt at brak.ee.washington.edu>; Wed, 19 Mar 2003 10:03:04 -0800
Received: from mailhost2.u.washington.edu (mailhost2.u.washington.edu [140.142.33.2])
	by mxout4.cac.washington.edu (8.12.1+UW03.03/8.12.1+UW02.12) with ESMTP id h2JI33Lv004907
	for <vlsi-rt at brak.ee.washington.edu>; Wed, 19 Mar 2003 10:03:03 -0800
Received: from homer09.u.washington.edu (homer09.u.washington.edu [140.142.15.47])
	by mailhost2.u.washington.edu (8.12.1+UW03.03/8.12.1+UW02.12) with ESMTP id h2JI334h014584
	for <vlsi-rt at brak.ee.washington.edu>; Wed, 19 Mar 2003 10:03:03 -0800
Date: Wed, 19 Mar 2003 10:03:03 -0800 (PST)
From: "justin m. clayton" <justincl at u.washington.edu>
To: "andreik at ee.washington.edu via RT" <vlsi-rt at brak.ee.washington.edu>
Subject: Re: [UW/EE Research Computing #1078]
In-Reply-To: <rt-1078-6284.16.5659521383676 at UW/EE Research Computing>
Message-Id: <Pine.A41.4.44.0303191001240.120976-100000 at homer09.u.washington.edu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
'
                                                 }
                                               ],
                               'Ticket' => '1078',
                               'id' => '6286',
                               'Type' => 'Correspond',
                               'Created' => '2003-03-19 18:03:15',
                               'Data' => 'Re: [UW/EE Research Computing #1078]
'
                             },
                             {
                               'Creator' => '4',
                               'OldValue' => '2',
                               'Ticket' => '1078',
                               'NewValue' => '4',
                               'id' => '6288',
                               'Field' => 'Owner',
                               'Type' => 'Take',
                               'Created' => '2003-03-19 18:05:07'
                             },
                             {
                               'Creator' => '4',
                               'OldValue' => 'new',
                               'Ticket' => '1078',
                               'NewValue' => 'resolved',
                               'id' => '6291',
                               'Field' => 'Status',
                               'Type' => 'Status',
                               'Created' => '2003-03-19 18:11:33'
                             }
                           ],
          'Priority' => '50',
          'Starts' => '1970-01-01 00:00:00'
        };
}
1;


More information about the Rt-devel mailing list