[rt-users] Error Upgrading MYSQL from 3.6.3 to 3.8.9

[Shane Becker]

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,

 

Shane

________________________________

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

 

On Fri, Apr 8, 2011 at 12:22 AM, Kevin Falcone
<falcone at bestpractical.com> wrote:
> On Thu, Apr 07, 2011 at 12:38:35PM -0700, Shane Becker wrote:
>>    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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110407/a5ee9d73/attachment.htm>