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

[Dave Dennis]

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...3.4.5.6.7.8.9.done.
Creating users...10.12.done.
Creating queues...1.2.done.
Creating ACL...2.3.done.
Creating ScripActions...1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.done.
Creating ScripConditions...1.2.3.4.5.6.7.8.9.done.
Creating templates...1.2.3.4.5.6.7.8.9.10.11.12.done.
Creating scrips...1.2.3.4.5.6.7.8.9.10.11.12.13.done.

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
LeadsggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqqqqqqqqqqqqqImporting
tickets...t-1
.t-2
.t-3
.t-4

<snip>

.t-392
.t-393
.t-394
.t-395
Couldn't create attachment
$VAR1 = {
          'Subject' => '',
          'ContentType' => 'text/plain',
          'Filename' => 'media-inc.log',
          'Headers' => 'Content-Type: TEXT/PLAIN; charset=US-ASCII;
name="media-inc.log"
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.LNX.4.44.0306031556040.16591 at web0.speakeasy.net>
Content-Description:
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.
 (/opt/rt3/lib/RT.pm:254)


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?

Thanks,


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