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@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