[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> </DIV>
<DIV><FONT face=Arial size=2>Thank you,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </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