[debian-mysql] Bug#840780: mysql-server-5.6: 5.6.30 fails with request-tracker4 rt-setup-fulltext-index script

[James Zuelow]

Package: mysql-server-5.6
Version: 5.6.27-2
Severity: normal

Dear Maintainer,

When attempting to setup fulltext indexes with request-tracker4 4.2.13-2
on Squeeze, the script will fail when it attempts to create a fulltext
index InnoDB table.  Running the script looks like this:

#########################################
root at 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.
##########################################

Discussing the issue on the RT User's mailing list, it appears that this problem started to occur with MySQL version 5.6.29 and as I can see still occurs with 5.6.30 as shipped by Debian.

Since 5.6.30 was the lastest version available to me, I resolved the issue by adding a Debian Snapshots entry to apt's sources config and downgrading to 5.6.27-2, at which time the script ran perfectly.

I see that the changelog for MySQL 5.6.31 includes a fix for MySQL bug #22963169, which I believe is the one responsible for the RT4 setup script failing.

I don't see any evidence that MySQL 5.6.31 is in the pipe for a Stretch release, especially with a potential freeze next month.  But I believe that sticking with 5.6.30 will render parts of the request-tracker4 package unusable.

Thanks!

James

-- System Information:
Debian Release: stretch/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.14-1-amd64 (SMP w/3 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)

Versions of packages mysql-server-5.6 depends on:
ii  adduser                3.115
ii  debconf [debconf-2.0]  1.5.59
ii  init-system-helpers    1.45
ii  initscripts            2.88dsf-59.8
ii  libaio1                0.3.110-3
ii  libc6                  2.24-3
ii  libdbi-perl            1.636-1
ii  libgcc1                1:6.1.1-11
ii  libstdc++6             6.1.1-11
ii  libwrap0               7.6.q-25
ii  lsb-base               9.20160629
ii  mysql-client-5.6       5.6.30-1
ii  mysql-common           5.8+1.0.0
ii  mysql-server-core-5.6  5.6.27-2
ii  passwd                 1:4.2-3.2
ii  perl                   5.22.2-5
ii  psmisc                 22.21-2.1+b1
ii  zlib1g                 1:1.2.8.dfsg-2+b1

Versions of packages mysql-server-5.6 recommends:
ii  libhtml-template-perl  2.95-2

Versions of packages mysql-server-5.6 suggests:
ii  s-nail [mailx]  14.8.10-1
pn  tinyca          <none>

Versions of Request-Tracker4:
ii  request-tracker4                            4.2.13-2
ii  rt4-apache2                                 4.2.13-2
ii  rt4-clients                                 4.2.13-2
ii  rt4-db-mysql                                4.2.13-2

-- debconf information:
  mysql-server/error_setting_password:
  mysql-server/password_mismatch:
  mysql-server-5.6/nis_warning:
  mysql-server-5.6/start_on_boot: true
  mysql-server-5.6/postrm_remove_databases: false
  mysql-server/no_upgrade_when_using_ndb:
  mysql-server-5.6/really_downgrade: false