Re: [rt-users] Attachment size issue?
Am 04.12.2014 um 21:32 schrieb Alex Vandiver: > Thus, in addition to setting max_allowed_packet, you will need to > increase innodb_log_file_size, or you'll only be able to insert files > which are < 5M (or, on 5.6.22 or higher, < 10M). Note that increasing > innodb_log_file_size is slightly complex: > > http://www.percona.com/blog/2011/07/09/how-to-change-innodb_log_file_size-safely/ MySQL 5.6.8 resize the log files automatically: http://dev.mysql.com/doc/refman/5.6/en/innodb-data-log-reconfiguration.html Chris
Re: [rt-users] unordered mismash of upgrade instructions
On 11/26/2014 05:32 PM, Jo Rhett wrote: > I’m doing an upgrade from 3.8.5 to 4.2. It seems to be going well. I’m > liking the changes. Glad to see RTFM integrated. My one big question > here that I think the documentation could definitely improve upon, is > what order to do the changes in? There are changes in every one of > these pages and there’s no clear outline for which ones go first. > > https://www.bestpractical.com/docs/rt/4.2/README.html Step (2) and (6b) of this address the other files. The top of UPGRADING.mysql even tells you to start there. A bug in the POD -> html (now fixed) causes it to not show up in the website, but it's in the shipped docs/UPGRADING.mysql in the source tarball. > I’m thinking that perhaps step 8 should have been done before 6 and 7, > but it seems to have worked and it displays the tickets and seems to > operate properly. We recommend doing the 'make upgrade-database' steps before running the various cleanups in docs/UPGRADING-* Patches accepted of updates that you think would clarify the issue. - Alex
Re: [rt-users] Attachment size issue?
On 12/04/2014 02:16 PM, Karres, Dean wrote: > I was looking in my RT log file for a different issue and found the > following [snip] > > I thought I raised the attachment size limit when I installed RT. Do I > need to do that again? We provide a few specialized, internal services > and our customers insist on emailing us super giant attachments. This is caused by changes in MySQL 5.6 (see the first IMPORTANT CHANGE): http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html Thus, in addition to setting max_allowed_packet, you will need to increase innodb_log_file_size, or you'll only be able to insert files which are < 5M (or, on 5.6.22 or higher, < 10M). Note that increasing innodb_log_file_size is slightly complex: http://www.percona.com/blog/2011/07/09/how-to-change-innodb_log_file_size-safely/ - Alex
[rt-users] Attachment size issue?
Hi, RT 4.2.6 RHEL 6.6 MySQL 5.6 I was looking in my RT log file for a different issue and found the following. eval {...} called at -e line 0 (/usr/local/share/perl5/Carp.pm:169) [3523] [Thu Dec 4 18:24:43 2014] [critical]: Attachment insert failed: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=D YNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. (/opt/rt-4.2.6/sbin/../lib/RT/Attachment.pm:221) [3523] [Thu Dec 4 18:24:43 2014] [critical]: Attachment insert failed: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=D YNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. (/opt/rt-4.2.6/sbin/../lib/RT/Attachment.pm:191) I thought I raised the attachment size limit when I installed RT. Do I need to do that again? We provide a few specialized, internal services and our customers insist on emailing us super giant attachments. Dean...K...
Re: [rt-users] Complex search for users, as for tickets
Does the absence of answers means that the answer is "no way to do complex searches on users list" ? I someone knows for sure that it is not possible, please tell me. Thanks. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Complex-search-for-users-as-for-tickets-tp59054p59111.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Is it possible to change the date format for some specific searches
Is it possible to change the date format for some specific searches (eg. just the date without the time)? I don't want to change the general option (in user General preferences). '__id__/TITLE:#', '__Subject__/TITLE:Subject', Owner, *'__LastUpdated__/TITLE:MAJ'* Gaston 514.823-7202
[rt-users] rt-validator questions!
hello! I'm in the process to migrate from 3.8.7. to 4.2.9 and I change the Server at the same time. Till now the tests worked like a charm Now I want to test if we could clean up the data in this procedure. We want to use - shrink_cgm_table.pl - shrink_transactions_table.pl - rt-validator My first question is could I start these tools on my old 3.8.7 instance, before I migrate or should I run them on the new host. My second question I started on my RT4.2.9 test instance (filled with my 30GB production db) the rt-validator and first It proceed quickly but now it slows down (in progress, runtime now 20h) In mysql-slow.log I see .. # Time: 141204 11:52:51 # User@Host: rt_user[rt_user] @ localhost [] # Query_time: 642.958995 Lock_time: 0.79 Rows_sent: 0 Rows_examined: 2573918 SET timestamp=1417690371; UPDATE Attachments SET Creator = '9976' WHERE Creator = '9977'; # Time: 141204 12:02:17 # User@Host: rt_user[rt_user] @ localhost [] # Query_time: 565.100590 Lock_time: 0.74 Rows_sent: 0 Rows_examined: 2573918 SET timestamp=1417690937; UPDATE Attachments SET Creator = '6214' WHERE Creator = '6215'; .. My VM has only has 16GB and innodb_buffer_pool_size is only 3GB. - Is it harmful to run rt-validator while we are in production? - Could I speedup the process (make an index on Creator?) best regards! Sven
[rt-users] Default Configuration RT
Hi Guys, I'd like to know if it is possible to install the default configuration on Request -TRacker. The reason I'm asking this is because I made a change on the system and a lots of things stopped working and I want to install the default config again and restart doing my changes. Thanks -- View this message in context: http://requesttracker.8502.n7.nabble.com/Default-Configuration-RT-tp59108.html Sent from the Request Tracker - User mailing list archive at Nabble.com.