Dumpfile-to-rt3.0 problem

Hi there,
I’m trying to use the RT2.0-to-RT3.0 tool to migrate an rt2
database off an old machine running postgres onto a new freebsd 6
server running mysql and a brand new ports install of rt3.6. Running
the rt2.0-to-dump script works fine except that we don’t have a pager
email field which gives me tons of warnings but doesn’t seem to break
anything.

The problem comes in when running dumpfile-to-rt3.6. The script will
run for a couple hours and then die out with the following error:

t-4781: wtatat remapped to 4781
t-4608: wtatat remapped to 4608
t-4538: wtaaAttempted to rollback a transaction with none in progress
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 747
DBIx::SearchBuilder::Handle::EndTransaction(‘RT::Handle=HASH(0x14aecb8)’,
‘Action’, ‘rollback’, ‘Force’, ‘undef’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
788
DBIx::SearchBuilder::Handle::Rollback(‘RT::Handle=HASH(0x14aecb8)’)
called at /usr/local/rt3/lib/RT.pm line 360
RT::ANON(‘no connection to syslog available\x{a}\x{9}- stream
/dev/conslog is n…’) called at /usr/local/lib/perl5/5.8.8/Carp.pm
line 269
Carp::croak(‘no connection to syslog available\x{a}\x{9}- stream
/dev/conslog is n…’) called at
/usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm line 802
Sys::Syslog::connect called at
/usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm line 709
Sys::Syslog::syslog(‘WARNING’, ‘%s’, 'RT::Handle=HASH(0x14aecb8)
couldn’t execute the query ‘INSE…’) called at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm line 77
Log::Dispatch::Syslog::log_message(‘Log::Dispatch::Syslog=HASH(0x2550548)’,
‘level’, ‘warning’, ‘name’, ‘syslog’, ‘message’,
'RT::Handle=HASH(0x14aecb8) couldn’t execute the query ‘INSE…’)
called at /usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Output.pm
line 41
Log::Dispatch::Output::log(‘undef’, ‘level’, ‘warning’, ‘name’,
‘syslog’, ‘message’, 'RT::Handle=HASH(0x14aecb8) couldn’t execute the
query ‘INSE…’) called at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm line 100
Log::Dispatch::_log_to(‘Log::Dispatch=HASH(0x1b7fce8)’, ‘level’,
‘warning’, ‘name’, ‘syslog’, ‘message’, ‘RT::Handle=HASH(0x14aecb8)
couldn’t execute the query ‘INSE…’) called at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm line 79
Log::Dispatch::log(‘undef’, ‘level’, ‘warning’, ‘message’,
‘RT::Handle=HASH(0x14aecb8) couldn’t execute the query ‘INSE…’)
called at /usr/local/lib/perl5/5.8.8/Carp.pm line 272
Carp::cluck(‘RT::Handle=HASH(0x14aecb8) couldn’t execute the query
’INSE…’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
518
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x14aecb8)’,
‘INSERT INTO Attachments (ContentType, Parent, id, Subject, Fi…’,
‘application/octet-stream’, 9413, 9417, ‘’, ‘CapWiz State.pdf’,
‘Content-Type: application/octet-stream;
name="CapWiz State.p…’, 2227, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
353
DBIx::SearchBuilder::Handle::Insert(‘RT::Handle=HASH(0x14aecb8)’,
‘Attachments’, ‘ContentType’, ‘application/octet-stream’, ‘Parent’,
9413, ‘id’, 9417, ‘Subject’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm
line 36
DBIx::SearchBuilder::Handle::mysql::Insert(‘RT::Handle=HASH(0x14aecb8)’,
‘Attachments’, ‘ContentType’, ‘application/octet-stream’, ‘Parent’,
9413, ‘id’, 9417, ‘Subject’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line
1293
DBIx::SearchBuilder::Record::Create(‘RT::Attachment=HASH(0x6b89d98)’,
‘ContentType’, ‘application/octet-stream’, ‘Parent’, 9413, ‘id’, 9417,
‘Subject’, ‘’, …) called at /usr/local/rt3/lib/RT/Record.pm line 310
RT::Record::Create(‘RT::Attachment=HASH(0x6b89d98)’, ‘Subject’, ‘’,
‘Filename’, ‘CapWiz State.pdf’, ‘ContentType’,
‘application/octet-stream’, ‘Headers’, ‘Content-Type:
application/octet-stream;
name="CapWiz State.p…’, …) called at
/usr/local/rt3/lib/RT/Attachment_Overlay.pm line 245
RT::Attachment::Import(‘RT::Attachment=HASH(0x6b89d98)’, ‘Subject’,
’’, ‘ContentType’, ‘application/octet-stream’, ‘Filename’, ‘CapWiz
State.pdf’, ‘Headers’, ‘Content-Type: application/octet-stream;
name="CapWiz State.p…’, …) called at dumpfile-to-rt-3.0 line 935
RT::import_tickets() called at dumpfile-to-rt-3.0 line 400
[Thu Mar 20 19:47:51 2008] [crit]: no connection to syslog available
- stream /dev/conslog is not writable
- console is not writable at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm line 77
(/usr/local/rt3/lib/RT.pm:361)

Stack trace:
RT::ANON() called at /usr/local/lib/perl5/5.8.8/Carp.pm:269
Carp::croak() called at /usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm:802
Sys::Syslog::connect() called at
/usr/local/lib/perl5/5.8.8/mach/Sys/Syslog.pm:709
Sys::Syslog::syslog() called at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm:77
Log::Dispatch::Syslog::log_message() called at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Output.pm:41
Log::Dispatch::Output::log() called at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm:100
Log::Dispatch::_log_to() called at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch.pm:79
Log::Dispatch::log() called at /usr/local/lib/perl5/5.8.8/Carp.pm:272
Carp::cluck() called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:518
DBIx::SearchBuilder::Handle::SimpleQuery() called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:353
DBIx::SearchBuilder::Handle::Insert() called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm:36
DBIx::SearchBuilder::Handle::mysql::Insert() called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm:1293
DBIx::SearchBuilder::Record::Create() called at
/usr/local/rt3/lib/RT/Record.pm:310
RT::Record::Create() called at /usr/local/rt3/lib/RT/Attachment_Overlay.pm:245
RT::Attachment::Import() called at dumpfile-to-rt-3.0:935
RT::import_tickets() called at dumpfile-to-rt-3.0:400
no connection to syslog available
- stream /dev/conslog is not writable
- console is not writable at
/usr/local/lib/perl5/site_perl/5.8.8/Log/Dispatch/Syslog.pm line 77

Cleary much of that has to do with syslog but the first parts don’t
seem to be. Anyways it says in the README that this is the appropriate
place for such questions so hopefully one of you can help me.

Thanks in advance!
Matt Edlefsen

Hi there,
I’m trying to use the RT2.0-to-RT3.0 tool to migrate an rt2
database off an old machine running postgres onto a new freebsd 6
server running mysql and a brand new ports install of rt3.6. Running
the rt2.0-to-dump script works fine except that we don’t have a pager
email field which gives me tons of warnings but doesn’t seem to break
anything.

Which version of the tool are you using? Hopefully the one from
CPAN.

The problem comes in when running dumpfile-to-rt3.6. The script will
run for a couple hours and then die out with the following error:

t-4781: wtatat remapped to 4781
t-4608: wtatat remapped to 4608
t-4538: wtaaAttempted to rollback a transaction with none in progress
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 747

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x14aecb8)’,
‘INSERT INTO Attachments (ContentType, Parent, id, Subject, Fi…’,
‘application/octet-stream’, 9413, 9417, ‘’, ‘CapWiz State.pdf’,
‘Content-Type: application/octet-stream;
name="CapWiz State.p…’, 2227, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
353

Its worth looking at mysql’s error log to see why that insert failed.
It may be a really large attachment and you bumped up against
the max_allowed_packet limit.

Cleary much of that has to do with syslog but the first parts don’t
seem to be. Anyways it says in the README that this is the appropriate
place for such questions so hopefully one of you can help me.

I’d start by looking at max_allowed_packet and if nothing useful is in
the logs, making sure you have RT set up to log to a file and mysql
set up
to log errors and queries and re-run the import.

-kevin

Thanks, that was exactly the problem and it worked great after I fixed
it in mysql!On Mon, Mar 31, 2008 at 1:37 PM, Kevin Falcone falcone@bestpractical.com wrote:

On Mar 31, 2008, at 11:41 AM, Matthew Edlefsen wrote:

Hi there,
I’m trying to use the RT2.0-to-RT3.0 tool to migrate an rt2
database off an old machine running postgres onto a new freebsd 6
server running mysql and a brand new ports install of rt3.6. Running
the rt2.0-to-dump script works fine except that we don’t have a pager
email field which gives me tons of warnings but doesn’t seem to break
anything.

Which version of the tool are you using? Hopefully the one from
CPAN.

The problem comes in when running dumpfile-to-rt3.6. The script will
run for a couple hours and then die out with the following error:

t-4781: wtatat remapped to 4781
t-4608: wtatat remapped to 4608
t-4538: wtaaAttempted to rollback a transaction with none in progress
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 747

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x14aecb8)’,
‘INSERT INTO Attachments (ContentType, Parent, id, Subject, Fi…’,
‘application/octet-stream’, 9413, 9417, ‘’, ‘CapWiz State.pdf’,
‘Content-Type: application/octet-stream;
name="CapWiz State.p…’, 2227, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
353

Its worth looking at mysql’s error log to see why that insert failed.
It may be a really large attachment and you bumped up against
the max_allowed_packet limit.

Cleary much of that has to do with syslog but the first parts don’t
seem to be. Anyways it says in the README that this is the appropriate
place for such questions so hopefully one of you can help me.

I’d start by looking at max_allowed_packet and if nothing useful is in
the logs, making sure you have RT set up to log to a file and mysql
set up
to log errors and queries and re-run the import.

-kevin