I'm having trouble setting up the fulltext index on a Debian installation.  
Admittedly this is a Wheezy installation, not Jessie as we wanted to track a 
newer version of rt4, so some things may be broken.  Hopefully the freeze comes 
soon though.



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.



Anyway, here's what I see:

##########



root@mis-rt-lnx:/usr/sbin# ./rt-setup-fulltext-index --dba rtuser 
--dba-password secret

MySQL 5.6 and above support native full-text indexing; for compatibility

with earlier versions of RT, the external Sphinx indexer is still

supported.



Which indexing solution would you prefer?



[mysql]: mysql



Enter the name of a new MySQL table that will be used to store the

full-text content and indexes:

[AttachmentsIndex]: AttachmentsIndex



Going to run the following in the DB:

     CREATE TABLE AttachmentsIndex ( id INT UNSIGNED AUTO_INCREMENT NOT

NULL PRIMARY KEY,Content LONGTEXT ) ENGINE=InnoDB CHARACTER SET utf8



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.

(./rt-setup-fulltext-index:736)

[58876] [Thu Oct 13 02:23:42 2016] [critical]: DBD::mysql::db do failed:

Lost connection to MySQL server during query at

./rt-setup-fulltext-index line 736, <STDIN> line 2.

(/usr/share/request-tracker4/lib/RT.pm:389)

DBD::mysql::db do failed: Lost connection to MySQL server during query

at ./rt-setup-fulltext-index line 736, <STDIN> line 2.



##########



The "Lost connection to MySQL" error often occurs when a child kills the 
database connection for the parent, so I've tried different permutations of 
InactiveDestroy in the script itself, for example adding the third line below:



my $dbh = $RT::Handle->dbh;

$dbh->{'RaiseError'} = 1;

$dbh->{'PrintError'} = 1;

$dbh->{'InactiveDestroy'} = 1;  ##THIS LINE ADDED TO SCRIPT##

But I'm unable to find a magic fix this way.  I've also tried running the 
script as the MySQL root user without success.

This appears to be a slightly different issue than what I see in the archives.

Has anyone else seen this or can point me in the right direction to chase down 
the lost connections?

Thanks!

James
---------
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017

Reply via email to