<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
How much free disk space do you have? You can often get the "server
gone away" message when MySQL runs out of disk space.<br>
<br>
<div class="moz-cite-prefix">On 1/22/16 5:22 AM, <a class="moz-txt-link-abbreviated" href="mailto:elifree@free.fr">elifree@free.fr</a>
wrote:<br>
</div>
<blockquote
cite="mid:1498804810.3181273.1453458153300.JavaMail.root@zimbra61-e11.priv.proxad.net"
type="cite">
<style type="text/css">p { margin: 0; }</style>
<div style="font-family: arial,helvetica,sans-serif; font-size:
12pt; color: #000000">Good morning,<br>
<br>
This is a follow-up of my problem :<br>
<br>
This morning I decided to shred the attachment 602620.<br>
But after execution of rt-fulltext-indexer it fails again at the
next number of attachment : 602621 !<br>
<br>
So this was clearly not the solution. But now I have not idea of
what is the problem.<br>
<br>
Any clue or help is greatly appreciated.<br>
Thanks and have a good day,<br>
Elisabeth<br>
<br>
<hr id="zwchr">
<blockquote style="border-left:2px solid rgb(16, 16,
255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>De:
</b><a class="moz-txt-link-abbreviated" href="mailto:elifree@free.fr">elifree@free.fr</a><br>
<b>À: </b><a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<b>Envoyé: </b>Jeudi 21 Janvier 2016 15:57:08<br>
<b>Objet: </b>fulltext index update failure (RT 4.2.12)<br>
<br>
<style>p { margin: 0; }</style>
<div style="font-family: arial,helvetica,sans-serif;
font-size: 12pt; color: #000000">Hello,<br>
<br>
We have juste upgraded our RT this morning to version 4.2.12
(from 4.2.6) and MySQL to 5.6 (from 5.5) in order to
implement the full text indexing.<br>
<br>
It works, but when running
/appli/rt4/sbin/rt-fulltext-indexer to update the table
AttachmentsIndex, it stops with an error :<br>
<br>
extract from the log file : <br>
<br>
<span style="white-space:pre"> </span>Jan 21 14:50:01
helpdesk.inria.fr CRON[9668]: (root) CMD
(/appli/rt4/sbin/rt-fulltext-indexer --quiet)<br>
<br>
<span style="white-space:pre"> </span>Jan 21 14:50:03
helpdesk.inria.fr RT: [9669] DBD::mysql::st execute failed:
MySQL server has gone away at
/appli/rt4/sbin/rt-fulltext-indexer line 216.<br>
<span style="white-space:pre"> </span>Jan 21 14:50:03
helpdesk.inria.fr RT: [9669] DBD::mysql::st execute failed:
MySQL server has gone away at
/appli/rt4/sbin/rt-fulltext-indexer line 222.<br>
<span style="white-space:pre"> </span>Jan 21 14:50:03
helpdesk.inria.fr RT: [9669] Attachment 602620 cannot be
indexed: MySQL server has gone away at
/appli/rt4/sbin/rt-fulltext-indexer line 254.<br>
<br>
The result is that new attachments are not indexed.<br>
<br>
I don't know what to do : should I just shred the attachment
602620 ? Is this at risk ?<br>
<br>
Thanks a lot for your help, <br>
Elisabeth<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</div>
</blockquote>
<br>
</div>
</blockquote>
<br>
</body>
</html>