[rt-users] rt-setup-fulltext-index dropped DB connections with MySQL

[Alex Vandiver]

On Thu, 13 Oct 2016 20:32:36 +0000
James Zuelow <James.Zuelow at juneau.org> wrote:
> Package versions at the moment are MySQL 5.6.30, Perl 5.2.22, and
> request-tracker 4.2.13.  There is a Perl 5.4 upgrade available, but
> that breaks my rt4 installation.

For reference, your perl versions are not comprehensible.  Wheezy ships
perl 5.14.2, per https://packages.debian.org/wheezy/perl, and there has
never been a perl version 5.2 or 5.4 -- 5.002 was released in 1996,
5.004 in 1997, and 5.6 in 2000.


> Indexing existing data...
> Going to run the following in the DB:
>      CREATE FULLTEXT INDEX AttachmentsIndex ON AttachmentsIndex(Content)
> 
> [58876] [Thu Oct 13 02:23:42 2016] [warning]: DBD::mysql::db do failed:
> Lost connection to MySQL server during query at
> ./rt-setup-fulltext-index line 736, <STDIN> line 2.

Check your "max_allowed_packet" setting in mysqld.  The most common
cause is the MySQL client (here, rt-fulltext-indexer) sending something
in the MySQL wire protocol which is larger than that limit, which
causes the server to unceremoniously drop the connection.

Raise that limit and restart mysql, and it should resolve the issue.

 - Alex