[rt-users] Best practices to follow when migrating RT2 to RT3 and mysql errors

[David M Dennis]

Meant to send the error, not the full attachment.  Here it is:

.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'
[Thu Feb 19 01:35:58 2004] [crit]: Died at ./dumpfile-to-rt-3.0 line 714.
 (/opt/rt3/lib/RT.pm:254)


+-------------------------
+ Dave Dennis
+ Seattle, WA
+ dmd at speakeasy.org
+ http://www.dmdennis.com
+-------------------------

On Wed, 18 Feb 2004, David M Dennis wrote:

> Dear List,
>
> On a fresh RT-3.0.9 I have attempted to migrate our fairly substantial
> RT-2.0.15 database.  mysql-4.0.17 on both ends.
>
> When running dumpfile-to-rt-3.0 the script barfs out an mysql error,
> referring to max_allowed_packet .
>
> The attachment in question (see below) is 1155441 bytes large, the
> workstation I'm running this on is 256 MB RAM, and I increased
> max_allowed_packet in my.cnf from (no value) to 256 MB.  I also
> tried it at 128 MB.  Still same error.
>
> What would best practices be at this point to get the database migrated?
>
> I reported this to the dev list, and basically was as we used to say,
> "shone off."  Which is fine, but somebody must have run into this before.
>
> Thanks for any assistance or further suggestions for reading material.
>
>
> +-------------------------
> + Dave Dennis
> + Seattle, WA
> + dmd at speakeasy.org
> + http://www.dmdennis.com
> +-------------------------
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>