Re: [rt-users] Full text indexing error with MySQL
Quoting Alex Vandiver on Thu, Aug 25 22:39: > > On Thu, 25 Aug 2016 20:49:48 -0700 > Omen Wild wrote: > > I activated the full text indexing under Ubuntu 16.04 (request-tracker4 > > 4.2.12-5) and (mysql-server 5.7.13-0ubuntu0.16.04.2). Both the initial > > indexing and subsequent calls to rt-fulltext-indexer have the same error: > > > > - Begin quote - > > [3159] [Fri Aug 26 03:03:08 2016] [warning]: DBD::mysql::st execute failed: > > MySQL server has gone away > > That error is almost always that RT tried to do an insert or update > of data larger that the MySQL server's max_allowed_packet. Try > increasing that setting, restarting MySQL, and indexing again. And indeed that was the problem. Bumped it from 16M to 64M and all is well. And now that I check the MySQL error logs I see it complaining there. Thanks for the tip! -- Omen Wild Systems Administrator Metro Cluster - RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017
[rt-users] Full text indexing error with MySQL
I activated the full text indexing under Ubuntu 16.04 (request-tracker4 4.2.12-5) and (mysql-server 5.7.13-0ubuntu0.16.04.2). Both the initial indexing and subsequent calls to rt-fulltext-indexer have the same error: - Begin quote - [3159] [Fri Aug 26 03:03:08 2016] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 216. (/usr/sbin/rt-fulltext-indexer:216) [3159] [Fri Aug 26 03:03:08 2016] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 222. (/usr/sbin/rt-fulltext-indexer:222) [3159] [Fri Aug 26 03:03:08 2016] [critical]: Attachment 125007 cannot be indexed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 254. (/usr/share/request-tracker4/lib/RT.pm:389) Attachment 125007 cannot be indexed: MySQL server has gone away at /usr/sbin/rt-fulltext-indexer line 254. - End quote - I saw a similar email back in January and one of the comments asked about disk space. The disk has plenty of space (only 10% full) and `systemctl status mysql` shows the mysql process is still running. Entering RT and doing searches works too, so the error is misleading or wrong. Any ideas? Thanks, Omen -- Omen Wild Systems Administrator Metro Cluster - RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017
Re: [rt-users] Send email when a ticket is deleted?
Quoting Emmanuel Lacour on Thu, Jun 09 10:50: > > You have to write a custom condition scrip like (untested): > > return 1 if ( $self->TransactionObj->Type eq 'Status' && > $self->TransactionObj->NewValue eq 'deleted' ); So ... not easy. Thanks, I'll dig into that if I get some time. -- Omen Wild Systems Administrator Physics - RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Los Angeles - September, 2016
[rt-users] Send email when a ticket is deleted?
Is there an easy way to have RT send an email when a ticket is deleted? We get some spam to our queues and it would be nice to know if someone already deleted it. Thanks, Omen -- Omen Wild Systems Administrator UC Davis - RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Los Angeles - September, 2016