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

[elifree at free.fr]

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/20160121/46c5fd35/attachment.htm>