[rt-devel] reporting a rt2.0.15 to rt3.0.9 mysql migrate failure

Dave Dennis dennis at speakeasy.net
Wed Feb 18 17:25:31 EST 2004

Dear Jesse / Bestpractical,

Attempting to migrate RT-2.0.15 into RT-3.0.9 .
Checked user list first for references to failure.
Platform source: mysql-4.17, platform target mysql-4.17,
both on debian linux.

using RT-3.0.9 / mysql / mod_perl1 target.

First initialized db was created:

Creating mysql database rt3.
Now populating database schema.
Creating database schema.
schema sucessfully inserted
Now inserting database ACLs
Now inserting RT core system objects
Checking for existing system user (RT::CurrentUser=HASH(0x8d5ba14))...not
found.  This appears to be a new installation.
Creating system user...done.
Now inserting RT data
Creating Superuser  ACL...Creating groups...
Creating users...10.12.done.
Creating queues...1.2.done.
Creating ACL...2.3.done.
Creating ScripActions...
Creating ScripConditions...
Creating templates...
Creating scrips...

Then dump dir from rt2 was attempted to be imported:

The first non-successful result was this:

Importing groups
ggCouldn't find user with RT2 userid  - not adding to CS RepsgggCouldn't
find user with RT2 userid  - not adding to


Couldn't create attachment
$VAR1 = {
          'Subject' => '',
          'ContentType' => 'text/plain',
          'Filename' => 'media-inc.log',
          'Headers' => 'Content-Type: TEXT/PLAIN; charset=US-ASCII;
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.LNX.4.44.0306031556040.16591 at web0.speakeasy.net>
Content-Disposition: attachment; filename="media-inc.log"
X-RT-Original-Encoding: us-ascii
          'Creator' => '4',
          'Parent' => '1501',
          'Created' => '2003-06-03 22:45:31',
          'ContentEncoding' => 'none',
          'id' => '1503',
          'TransactionId' => '2238'

Got a packet bigger than 'max_allowed_packet'
[Wed Feb 18 22:26:55 2004] [crit]: Died at ./dumpfile-to-rt-3.0 line 714.

Checking the lists.bestpractical.com archive lists there are some
references to attachments but none matching this that I found, so
here is the report.  Hope it helps.

are migrated attachments, or version 2.0.15 to 3.0.9 not supported?


Dave Dennis
dennis at speakeasy.net
(w) 206-971-5134
(m) 206-769-3546

More information about the Rt-devel mailing list