Your message dated Tue, 31 Jan 2017 05:02:59 +0000 with message-id <[email protected]> and subject line Bug#853139: Removed package(s) from unstable has caused the Debian Bug report #840780, regarding mysql-server-5.6: 5.6.30 fails with request-tracker4 rt-setup-fulltext-index script to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 840780: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=840780 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---Version: 5.6.35-1+rm Dear submitter, as the package mysql-5.6 has just been removed from the Debian archive unstable we hereby close the associated bug reports. We are sorry that we couldn't deal with your issue properly. For details on the removal, please see https://bugs.debian.org/853139 The version of this package that was in Debian prior to this removal can still be found using http://snapshot.debian.org/. This message was generated automatically; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]. Debian distribution maintenance software pp. Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---
