[rt-users] Full text indexing error with MySQL

Omen Wild omen at ucdavis.edu
Thu Aug 25 23:49:48 EDT 2016


I activated the full text indexing under Ubuntu 16.04 (request-tracker4
4.2.12-5) and (mysql-server 5.7.13-0ubuntu0.16.04.2). Both the initial
indexing and subsequent calls to rt-fulltext-indexer have the same error:

----- Begin quote -----
[3159] [Fri Aug 26 03:03:08 2016] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 216. (/usr/sbin/rt-fulltext-indexer:216)
[3159] [Fri Aug 26 03:03:08 2016] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 222. (/usr/sbin/rt-fulltext-indexer:222)
[3159] [Fri Aug 26 03:03:08 2016] [critical]: Attachment 125007 cannot be indexed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 254. (/usr/share/request-tracker4/lib/RT.pm:389)
Attachment 125007 cannot be indexed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 254.
----- End quote -----

I saw a similar email back in January and one of the comments asked about
disk space. The disk has plenty of space (only 10% full) and `systemctl
status mysql` shows the mysql process is still running. Entering RT
and doing searches works too, so the error is misleading or wrong.

Any ideas?

Thanks,
   Omen

-- 
Omen Wild
Systems Administrator
Metro Cluster



More information about the rt-users mailing list