Error Upgrading MYSQL from 3.6.3 to 3.8.9

RT Users
1

I’m trying to upgrade from RT 3.6.3 to 3.8.9 and I’m running into a
MYSQL issue:

[error] RT since version 3.8 has new schema for MySQL versions after
4.1.0\nFollow instructions in the UPGRADING.mysql file. at
/opt/rt3/bin/webmux.pl line 160.\nCompilation failed in require at (eval
2) line 1.\n

My steps so far have been:

/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action upgrade (only to 3.7.87)

rm -fr /opt/rt3/var/mason_data/obj

perl etc/upgrade/upgrade-mysql-schema.pl db user pass > queries.sql

mysql -u root -p rt3 < queries.sql

perl -I /opt/rt3/local/lib -I /opt/rt3/lib
etc/upgrade/shrink_cgm_table.pl

/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action upgrade (3.7.87 to 3.8.9)

perl -I /opt/rt3/local/lib -I /opt/rt3/lib
etc/upgrade/shrink_transactions_table.pl

Our current RT server is using MYSQL 5.0.27 and the new machine is
running MYSQL 5.0.77.

Any help is appreciated.

-Shane

This email, its contents and attachments contain information from j2 Global Communications, Inc. and/or its affiliates which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is prohibited. If you have received this email in error please notify the sender by reply e-mail and delete the original message and any copies.

2

I’m trying to upgrade from RT 3.6.3 to 3.8.9 and I’m running into a MYSQL issue:

[error] RT since version 3.8 has new schema for MySQL versions after 4.1.0\nFollow
instructions in the UPGRADING.mysql file. at /opt/rt3/bin/webmux.pl line 160.\nCompilation
failed in require at (eval 2) line 1.\n

This error message implies that your Attachments table still contains
a Blob, which implies that this step:

mysql -u root -p rt3 < queries.sql

failed in some manner.

You probably want to look at the results of show create table
Attachments;

-kevin

3

I’m trying to upgrade from RT 3.6.3 to 3.8.9 and I’m running into a MYSQL issue:

[error] RT since version 3.8 has new schema for MySQL versions after 4.1.0\nFollow
instructions in the UPGRADING.mysql file. at /opt/rt3/bin/webmux.pl line 160.\nCompilation
failed in require at (eval 2) line 1.\n

This error message implies that your Attachments table still contains
a Blob, which implies that this step:

typo, still contains a text instead of blob

mysql -u root -p rt3 < queries.sql

failed in some manner.

You probably want to look at the results of show create table
Attachments;

-kevin

Best regards, Ruslan.

4

After running ‘show create table Attachments’, I ran the alter table
statement alone and figured out my problem:

mysql> ALTER TABLE Attachments DEFAULT CHARACTER SET utf8, MODIFY
Subject VARBINARY(255) NULL DEFAULT NULL, MODIFY ContentType
VARBINARY(80) NULL DEFAULT NULL, MODIFY Filename VARBINARY(255) NULL
DEFAULT NULL, MODIFY Headers LONGBLOB NULL DEFAULT NULL, MODIFY
MessageId VARBINARY(160) NULL DEFAULT NULL, MODIFY Content LONGBLOB
NULL DEFAULT NULL, MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT
NULL;

ERROR 1114 (HY000): The table ‘#sql-3cf9_2’ is full

Time to find a bigger partition. Hopefully, that will allow the upgrade
to proceed. Thank you for your assistance.

Regards,

ShaneFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: Thursday, April 07, 2011 2:54 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Error Upgrading MYSQL from 3.6.3 to 3.8.9

I’m trying to upgrade from RT 3.6.3 to 3.8.9 and I’m running into
a MYSQL issue:

[error] RT since version 3.8 has new schema for MySQL versions
after 4.1.0\nFollow
instructions in the UPGRADING.mysql file. at
/opt/rt3/bin/webmux.pl line 160.\nCompilation
failed in require at (eval 2) line 1.\n

This error message implies that your Attachments table still contains
a Blob, which implies that this step:

typo, still contains a text instead of blob

mysql -u root -p rt3 < queries.sql

failed in some manner.

You probably want to look at the results of show create table
Attachments;

-kevin

Best regards, Ruslan.

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3555 - Release Date: 04/06/11

This email, its contents and attachments contain information from j2 Global Communications, Inc. and/or its affiliates which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is prohibited. If you have received this email in error please notify the sender by reply e-mail and delete the original message and any copies.