Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries
You are a star ☺ Thank you Torsten From: Brumm, Torsten / Kuehne + Nagel / Ham GI-ID [mailto:torsten.br...@kuehne-nagel.com] Sent: 19 January 2015 12:07 To: Atif Mehboob; rt-users@lists.bestpractical.com Subject: AW: RT hangs with 'SELECT GET_LOCK' slow query log entries And again, try out this: http://search.cpan.org/~chorny/Apache-Session-1.93/lib/Apache/Session/MySQL/NoLock.pm Think it is the better solution. Torsten Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Atif Mehboob Gesendet: Montag, 19. Januar 2015 10:38 An: rt-users@lists.bestpractical.com<mailto:rt-users@lists.bestpractical.com> Betreff: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries Hi All, RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please? Cheers, Atif -- Atif Mehboob Linux Administrator Eckoh UK Limited Telford House, Corner Hall Hemel Hempstead, Hertfordshire HP3 9HN T 01442 458336 M n/a W www.eckoh.com<http://www.eckoh.com> [cid:image001.png@01D033E1.83DCACC0]<http://www.linkedin.com/company/eckoh-plc>[cid:image002.png@01D033E1.83DCACC0]<http://twitter.com/Eckoh> US Headquarters: Eckoh, Inc. 11811 N. Tatum Blvd., Suite 3031 Phoenix, AZ 85028 This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s) only. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete it. Opinions expressed in this message are those of the author, and are not binding on the company. Registered in England and Wales, No. 2796531 Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire HP3 9HN A member of the Eckoh Plc group of companies. Kühne + Nagel (AG & Co.) KG Rechtsform: Kommanditgesellschaft, Bremen HRA 21928, USt-IdNr.: DE 812773878. Geschäftsleitung Kühne + Nagel (AG & Co.) KG: Reiner Heiken (Vors.), Dirk Blesius, Martin Brinkmann, Holger Ketz, Jan-Hendrik Köstergarten, Christian Solf, Lars Wedel, Jens Wollesen. Persönlich haftende Gesellschafterin: Kühne & Nagel A.G., Rechtsform: Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 18745, Geschäftsführendes Verwaltungsratsmitglied: Karl Gernandt. Geschäftsleitung Region Westeuropa: Yngve Ruud (Vors.), Hans-Georg Brinkmann (Stellv.), Richard Huhn, Björn Johansson, Bruno Mang, Stefan Paul, Tim Scharwath, Dominic Edmonds. Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen insbesondere auf die vom Gesetz abweichenden Haftungsbeschränkungen von Ziffer 23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf Anfrage und können Sie auch unter http://www.kuehne-nagel.com einsehen. Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an Bord oder Mängel des Schiffes haften.
Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries
Thank you Torsten, I already changed Set($WebSessionClass, "Apache::Session::File"); and its fixed the issue. I am not sure what will be the impact for a longer run. Cheers, Atif From: Brumm, Torsten / Kuehne + Nagel / Ham GI-ID [mailto:torsten.br...@kuehne-nagel.com] Sent: 19 January 2015 11:29 To: Atif Mehboob; rt-users@lists.bestpractical.com Subject: AW: RT hangs with 'SELECT GET_LOCK' slow query log entries Hi Atif, i remember this problem some years ago with RT 3.6.5 we fixed it (fast solution) to change the: Set($WebSessionClass, "Apache::Session::File"); to File. I remember (not 100% sure) that we later changed a File from Apache:Session (think MySQL.pm) and disabled locking there, then it was fine. Hope someone can help more in detail torsten Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Atif Mehboob Gesendet: Montag, 19. Januar 2015 10:38 An: rt-users@lists.bestpractical.com<mailto:rt-users@lists.bestpractical.com> Betreff: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries Hi All, RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please? Cheers, Atif -- Atif Mehboob Linux Administrator Eckoh UK Limited Telford House, Corner Hall Hemel Hempstead, Hertfordshire HP3 9HN T 01442 458336 M n/a W www.eckoh.com<http://www.eckoh.com> [cid:image001.png@01D033DB.F32643D0]<http://www.linkedin.com/company/eckoh-plc>[cid:image002.png@01D033DB.F32643D0]<http://twitter.com/Eckoh> US Headquarters: Eckoh, Inc. 11811 N. Tatum Blvd., Suite 3031 Phoenix, AZ 85028 This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s) only. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete it. Opinions expressed in this message are those of the author, and are not binding on the company. Registered in England and Wales, No. 2796531 Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire HP3 9HN A member of the Eckoh Plc group of companies. Kühne + Nagel (AG & Co.) KG Rechtsform: Kommanditgesellschaft, Bremen HRA 21928, USt-IdNr.: DE 812773878. Geschäftsleitung Kühne + Nagel (AG & Co.) KG: Reiner Heiken (Vors.), Dirk Blesius, Martin Brinkmann, Holger Ketz, Jan-Hendrik Köstergarten, Christian Solf, Lars Wedel, Jens Wollesen. Persönlich haftende Gesellschafterin: Kühne & Nagel A.G., Rechtsform: Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 18745, Geschäftsführendes Verwaltungsratsmitglied: Karl Gernandt. Geschäftsleitung Region Westeuropa: Yngve Ruud (Vors.), Hans-Georg Brinkmann (Stellv.), Richard Huhn, Björn Johansson, Bruno Mang, Stefan Paul, Tim Scharwath, Dominic Edmonds. Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen insbesondere auf die vom Gesetz abweichenden Haftungsbeschränkungen von Ziffer 23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf Anfrage und können Sie auch unter http://www.kuehne-nagel.com einsehen. Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an Bord oder Mängel des Schiffes haften.
[rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries
Hi All, RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please? Cheers, Atif -- Atif Mehboob Linux Administrator Eckoh UK Limited Telford House, Corner Hall Hemel Hempstead, Hertfordshire HP3 9HN T 01442 458336 M n/a W www.eckoh.com [cid:imagee8b468.PNG@edf863b6.47b0bc12]<http://www.linkedin.com/company/eckoh-plc> [cid:image597fe6.PNG@4d915fd5.478baf49] <http://twitter.com/Eckoh> US Headquarters: Eckoh, Inc. 11811 N. Tatum Blvd., Suite 3031 Phoenix, AZ 85028 This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s) only. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete it. Opinions expressed in this message are those of the author, and are not binding on the company. Registered in England and Wales, No. 2796531 Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire HP3 9HN A member of the Eckoh Plc group of companies.
[rt-users] RT problem with validation
Hi All, We are trying to use validation” (?#Digits)^[\d.]+$ “in RT 4.2.1. But this validation is not accepting 0 as a digit. It only accepts 1-9 as a digit. Is there any possible way to change the behaviour and make it to accept 0 as a digit? Cheers, Atif -- Atif Mehboob Linux Administrator Eckoh UK Limited Telford House, Corner Hall Hemel Hempstead, Hertfordshire HP3 9HN T 01442 458336 M n/a W www.eckoh.com [cid:imagefb1b2b.PNG@0ea3c77b.479d8e17]<http://www.linkedin.com/company/eckoh-plc> [cid:imagebfc84c.PNG@c008d30f.45918e66] <http://twitter.com/Eckoh> US Headquarters: Eckoh, Inc. 11811 N. Tatum Blvd., Suite 3031 Phoenix, AZ 85028 This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s) only. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete it. Opinions expressed in this message are those of the author, and are not binding on the company. Registered in England and Wales, No. 2796531 Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire HP3 9HN A member of the Eckoh Plc group of companies.
[rt-users] Memory issue
Hi All, All of sudden we are having memory issue on our RT host. I already added 1G of memory on the host but still can see it is using all the memory on host. Any suggestions please? Cheers, Atif -- Atif Mehboob Linux Administrator Eckoh UK Limited Telford House, Corner Hall Hemel Hempstead, Hertfordshire HP3 9HN T 01442 458336 M n/a W www.eckoh.com [cid:imagebd38bc.PNG@6a1a96c2.47b4658f]<http://www.linkedin.com/company/eckoh-plc> [cid:image02e72d.PNG@64e7620f.44a0c1b5] <http://twitter.com/Eckoh> US Headquarters: Eckoh, Inc. 11811 N. Tatum Blvd., Suite 3031 Phoenix, AZ 85028 This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s) only. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete it. Opinions expressed in this message are those of the author, and are not binding on the company. Registered in England and Wales, No. 2796531 Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire HP3 9HN A member of the Eckoh Plc group of companies.
Re: [rt-users] how to allow update subject line if update is from specific email address
Hi Landon, Thank you for your reply. I have created the scrip as you suggested but there is no impact and subject line is still the same. Any suggestions please? Cheers, Atif From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Landon Stewart Sent: 13 November 2014 16:51 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] how to allow subject line if update is from specific email address On Nov 13, 2014, at 5:06 AM, Atif Mehboob mailto:atif.mehb...@eckoh.com>> wrote: Hi All, We are using RT 4.2.1. How can we allow a specific email address to update the subject line of ticket in any queue. Any suggestions please? Regards, Atif Hi Atif, We do this using a scrip (in this case it'd be a global scrip). Update it with the email address in question. Description: Update the subject for theem...@address.com<mailto:theem...@address.com> Condition: On Correspond Action: (User defined) my $attachments = $self->TransactionObj->Attachments; $attachments->Columns( qw(id Headers Subject) ); my $attachment = $attachments->First; return 0 unless $attachment; return 0 unless $self->TicketObj->IsWatcher( Type => 'Requestor', Email => 'theem...@address.com<mailto:theem...@address.com>' ); my $subject = $attachment->GetHeader('Subject'); return 0 unless $subject; $self->TicketObj->SetSubject($subject); return 1; Template: Global template: Blank Stage: TransactionCreate -- Atif Mehboob Linux Administrator Eckoh UK Limited Telford House, Corner Hall Hemel Hempstead, Hertfordshire HP3 9HN T 01442 458336 M n/a W www.eckoh.com [cid:image0a7d02.PNG@f5b61b57.4f86ce8d]<http://www.linkedin.com/company/eckoh-plc> [cid:imageb2cf0a.PNG@4f359902.46a5a5c0] <http://twitter.com/Eckoh> US Headquarters: Eckoh, Inc. 11811 N. Tatum Blvd., Suite 3031 Phoenix, AZ 85028 This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s) only. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete it. Opinions expressed in this message are those of the author, and are not binding on the company. Registered in England and Wales, No. 2796531 Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire HP3 9HN A member of the Eckoh Plc group of companies.
[rt-users] how to allow subject line if update is from specific email address
Hi All, We are using RT 4.2.1. How can we allow a specific email address to update the subject line of ticket in any queue. Any suggestions please? Regards, Atif -- Atif Mehboob Linux Administrator Eckoh UK Limited Telford House, Corner Hall Hemel Hempstead, Hertfordshire HP3 9HN T 01442 458336 M n/a W www.eckoh.com [cid:imagecf0774.PNG@215692f3.4985e0a0]<http://www.linkedin.com/company/eckoh-plc> [cid:image5f15e2.PNG@1a44cfc5.49b9bc28] <http://twitter.com/Eckoh> US Headquarters: Eckoh, Inc. 11811 N. Tatum Blvd., Suite 3031 Phoenix, AZ 85028 This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s) only. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete it. Opinions expressed in this message are those of the author, and are not binding on the company. Registered in England and Wales, No. 2796531 Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire HP3 9HN A member of the Eckoh Plc group of companies.