[Rt-devel] dumpfile-to-rt3.0 problem

[Matthew 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.

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