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.
It works, but when running /appli/rt4/sbin/rt-fulltext-indexer to update the table AttachmentsIndex, it stops with an error :
extract from the log file :
Jan 21 14:50:01 helpdesk.inria.fr CRON[9668]: (root) CMD (/appli/rt4/sbin/rt-fulltext-indexer --quiet)
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.
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.
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.
The result is that new attachments are not indexed.
I don’t know what to do : should I just shred the attachment 602620 ? Is this at risk ?
This morning I decided to shred the attachment 602620.
But after execution of rt-fulltext-indexer it fails again at the next number of attachment : 602621 !
So this was clearly not the solution. But now I have not idea of what is the problem.
Any clue or help is greatly appreciated.
Thanks and have a good day,
Elisabeth
| 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.
| It works, but when running /appli/rt4/sbin/rt-fulltext-indexer to
| update the table AttachmentsIndex, it stops with an error :
| 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.
| 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.
| 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.
| The result is that new attachments are not indexed.
| I don’t know what to do : should I just shred the attachment 602620 ?
| Is this at risk ?
How much free disk space do you have? You can often get the “server gone
away” message when MySQL runs out of disk space.On 1/22/16 5:22 AM, elifree@free.fr wrote:
Good morning,
This is a follow-up of my problem :
This morning I decided to shred the attachment 602620.
But after execution of rt-fulltext-indexer it fails again at the next
number of attachment : 602621 !
So this was clearly not the solution. But now I have not idea of what
is the problem.
Any clue or help is greatly appreciated.
Thanks and have a good day,
Elisabeth
*De: *elifree@free.fr
*À: *rt-users@lists.bestpractical.com
*Envoyé: *Jeudi 21 Janvier 2016 15:57:08
*Objet: *fulltext index update failure (RT 4.2.12)
Hello,
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.
It works, but when running /appli/rt4/sbin/rt-fulltext-indexer to
update the table AttachmentsIndex, it stops with an error :
extract from the log file :
Jan 21 14:50:01 helpdesk.inria.fr CRON[9668]: (root) CMD
(/appli/rt4/sbin/rt-fulltext-indexer --quiet)
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.
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.
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.
The result is that new attachments are not indexed.
I don't know what to do : should I just shred the attachment
602620 ? Is this at risk ?
Thanks a lot for your help,
Elisabeth