[rt-devel] dumpfile-to-rt-3.0 failure

[Bart Bunting]

Hi all,

I'm seeing some kind of crash in the importer.

I don't think I'm doing anything wrong, but who knows.  The only thing
that is different about my RT instance is that I have added an extra
field "site" to the tickets table.  As far as I can tell this
shouldn't effect things.

Most of my tickets are imported fine but I'm seeing a couple of odd
warnings that I'm not sure should be there and the import dies on some
attachments.

The warnings look like this:

[Mon Mar  3 09:23:46 2003] [warning]: Subroutine Data redefined at rtdump/rt//t-2607 line 1.
 (/opt/rt3/lib/RT.pm:220)
Importing ticket 2607
            transaction 13244
               attachment 1
[Mon Mar  3 09:23:47 2003] [warning]: Subroutine Data redefined at rtdump/rt//t-2606 line 1.
 (/opt/rt3/lib/RT.pm:220)
Importing ticket 2606
            transaction 13243
               attachment 2


Below is the output from a ticket that failed.

Any suggestions apreciated.

Bart


[Mon Mar  3 09:24:41 2003] [warning]: Subroutine Data redefined at rtdump/rt//t-2566 line 1.
 (/opt/rt3/lib/RT.pm:220)
Importing ticket 2566
            transaction 13044
               attachment 101
            transaction 13074
               attachment 102
            transaction 13079
               attachment 103
            transaction 13080
            transaction 13081
            transaction 13086
               attachment 104
            transaction 13090
               attachment 105
               attachment 106
               attachment 107
[Mon Mar  3 09:24:43 2003] [warning]: DBD::Pg::st execute failed: ERROR:  Bad input string for type bytea at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376.
 (/opt/rt3/lib/RT.pm:220)
[Mon Mar  3 09:24:43 2003] [warning]: RT::Handle=HASH(0x8d45de0) couldn't execute the query 'INSERT INTO Attachments (ContentType, Parent, Filename, Headers, Creator, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 383.
 (/opt/rt3/lib/RT.pm:220)
               attachment 
[Mon Mar  3 09:24:43 2003] [crit]: Couldn't create attachment HASH(0x8f3e1ec) $VAR1 = {
          'ContentType' => 'application/octet-stream',
          'Filename' => 'paramrsp.acm',
          'Created' => '2003-02-24 13:46:16+00',
          'Headers' => 'Content-Type: application/octet-stream;
	name="paramrsp.acm"
Content-Transfer-Encoding: base64
Content-Description: paramrsp.acm
Content-Disposition: attachment;
	filename="paramrsp.acm"
',
          'Content' => '[Header]
Version=3
Imports=PackageDelivery,TurboInternet,Pointing,Winbicdd,ServiceInformation,DVBSI\\Programs,ConditionalAccess,Email,Support
Type=5
AdapterSerialNumber=1057166
Time={ts \'2003-02-24 17:53:23\'}
MessageSize=0
[Default]
DPCVersion=4.0.1.21
InstallInfo=10218E011057166093115
bundledisp=0
[Stack]
UserIP=144.135.67.190 
SubnetMask=255.255.255.0
DefaultGatewayIP=144.135.32.132 
HostName=dpc000
Domain=telstra.com
DomainNameServerIP=139.134.5.51,139.134.2.190 
[News]
[PackageDelivery]
ServiceEnabled=1
DialUpAreaCode=2
DialUpCountryCode=61
DialUpExtension=1800 134 064
BroadCastIPAddress=233.1.3.1:6531      
ReturnIPAddress=144.135.32.70:6599  
ReturnChannelMode=TCP
BroadCastMode=IPMC
[Pointing]
SatLongitudeEW=3
SatLongitude=105
SatPolarization=5
SatPolarizationOffset=0
SatFrequency=1300
ChannelID=1
AntennaZipCode=4000
[TurboInternet]
ServiceEnabled=1
GatewayIP=144.135.32.132 
PPPMRU=
PPPXmitAccm=
PPPRcvAccm=
AdapterIPAddress=144.135.67.190
[ConditionalAccess]
PACAU=31303231384530310c00000001000000000000009c0f36de78c5f8f6993733043abce4f400010000039051955e9eedbe0b010001e3756bcf648574590d010000f110f50f696c52670f010000f8320eabebf908ff14010002b898b9e797aec664400100002411274e351b5f8a430100000e983fc580dcad904f010000b5439f4dda0b9e27
DACAU=0100000003000000ff0000002f37c19fd958c080010100004d79b4f1e2522e1702010000f67a38eaec225232
ECAU=0500000003010000
PEB=321b000001c03f004f010000080001005e5dcc0201005e5dcc0101005e5dcc0701005e5dcc0801005e5dcc0901005e00011301005e00010b01005e00010603c03f000f010000090001005e02010401005e02020401005e02030401005e02040401005e02050401005e02070401005e02080401005e02060401005e02050504c03f004f010000010001005e00010708c03f0038010000010001005e00000e09c03f0043010000030001005e5dcc0301005e5dcc0401005e5dcc060ac03f0039010000030001005e00000a01005e00000b01005e0000090bc03f0040010000010001005e000157
CAIPAddress=237.238.239.239:6599
[ServiceInformation]
DVBProgramID=20500
ServicePlanId=30
[DVBSI\\Programs]
P1=20500
P2=20500
[WINBICDD]
ReceiveSymbolRate=4
ModulationType=1
FramingMode=0
ViterbiMode=0
ScramblerMode=1
BICDD_RX_FREQ=1300
LNBControl=0
[Support]
ProductName=BigPond broadband satellite
SupportName=Technical Support
SupportNumber=133933 (24 hours a day, 7 days a week (EST) )
SupportEmail=sathelpdesk at bigpond.com
SupportURL=www.bigpond.com/broadband
ServiceName=Billing and Sales Support
ServiceNumber=131282 (8.am to Midnight, 7 days a week (EST) )
ServiceEmail=
ServiceURL=
[EOF]
Lines=74
',
          'ContentEncoding' => 'none',
          'Creator' => '123',
          'Parent' => '7484',
          'TransactionId' => '13090'
        };
 (/opt/rt3/lib/RT.pm:226)