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