<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Re: [rt-users] Error Upgrading MYSQL from 3.6.3 to 3.8.9</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
p.avgcert, li.avgcert, div.avgcert
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>After running ‘show create table
Attachments’, I ran the alter table statement alone and figured out my
problem:<br>
<br>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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;<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>ERROR 1114 (HY000): The table
'#sql-3cf9_2' is full<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Time to find a bigger partition.
Hopefully, that will allow the upgrade to proceed. Thank you for your assistance.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Shane</span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b><span style='font-weight:
bold'>On Behalf Of </span></b>Ruslan Zakirov<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, April 07, 2011
2:54 PM<br>
<b><span style='font-weight:bold'>To:</span></b>
rt-users@lists.bestpractical.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [rt-users] Error
Upgrading MYSQL from 3.6.3 to 3.8.9</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face="Times New Roman"><span style='font-size:10.0pt'>On Fri,
Apr 8, 2011 at 12:22 AM, Kevin Falcone<br>
<falcone@bestpractical.com> wrote:<br>
> On Thu, Apr 07, 2011 at 12:38:35PM -0700, Shane Becker wrote:<br>
>> I'm trying to upgrade from RT 3.6.3 to 3.8.9 and I'm
running into a MYSQL issue:<br>
>><br>
>> [error] RT since version 3.8 has new schema for MySQL
versions after 4.1.0\nFollow<br>
>> instructions in the UPGRADING.mysql file. at
/opt/rt3/bin/webmux.pl line 160.\nCompilation<br>
>> failed in require at (eval 2) line 1.\n<br>
><br>
> This error message implies that your Attachments table still contains<br>
> a Blob, which implies that this step:<br>
<br>
typo, *still contains a text instead of blob*<br>
<br>
<br>
><br>
>> mysql -u root -p rt3 < queries.sql<br>
><br>
> failed in some manner.<br>
><br>
> You probably want to look at the results of show create table<br>
> Attachments;<br>
><br>
> -kevin<br>
><br>
<br>
<br>
<br>
--<br>
Best regards, Ruslan.</span></font><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=1 width="100%" noshade color="#aca899" align=center>
</span></font></div>
<p class=avgcert color="#000000"><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>No virus found in this message.<br>
Checked by AVG - <a href="http://www.avg.com">www.avg.com</a><br>
Version: 10.0.1204 / Virus Database: 1435/3555 - Release Date: 04/06/11<o:p></o:p></span></font></p>
</div>
<p></p><p>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. </body>
</html>