[rt-users] fulltext index update failure (RT 4.2.12)

[elifree at free.fr]

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 

----- Mail original -----

| De: elifree at free.fr
| À: rt-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160122/a08e9ba8/attachment.htm>