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@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)