[rt-users] Problem with index

[François Meehan]

Hi,

We are using RT 4.2.12. We noticed that the indexation stopped working.
When trying to run the indexer manually, I would get:

[11238] [Wed Jan 11 19:53:56 2017] [warning]: DBD::mysql::st execute
failed: MySQL server has gone away at /opt/rt4/sbin/rt-fulltext-indexer
line 216. (/opt/rt4/sbin/rt-fulltext-indexer:216)
[11238] [Wed Jan 11 19:53:56 2017] [warning]: DBD::mysql::st execute
failed: MySQL server has gone away at /opt/rt4/sbin/rt-fulltext-indexer
line 222. (/opt/rt4/sbin/rt-fulltext-indexer:222)
[11238] [Wed Jan 11 19:53:56 2017] [critical]: Attachment 32267 cannot be
indexed: MySQL server has gone away at /opt/rt4/sbin/rt-fulltext-indexer
line 254. (/opt/rt4/sbin/../lib/RT.pm:389)
Attachment 32267 cannot be indexed: MySQL server has gone away at
/opt/rt4/sbin/rt-fulltext-indexer line 254.

I re-ran the command by limiting the number of transaction:

/opt/rt4/sbin/rt-fulltext-indexer --limit 2

That ran without error and now running the command without --limit
parameter also runs with no errors. Unfortunately the index is not working
either.

Is there a way to delete and recreate the index? Or is it something else I
should try?

Thanks in advance,


-- 

*François MEEHAN*
IT Administrator | Administrateur TI
*VuWall Technology, Inc.*
<http://vuwall.com>
*Tel:* +1 514-505-4436
*Skype:* VuWall-Support


*Visit us at ISE 2017, Booth: 11-R146, February 7-10.Get your free invite
here using code: 915647 <https://vuwall.com/ise2017>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20170111/14ba8e24/attachment.htm>