Long Response Time Due to Missing Calender_Event Table
Hello Everyone, A while back I asked why, after I upgraded our OTRS install from version 1.2.3 to 2.2.6, I was getting response times in the 1 minute, 20 second range. Most of the responses I got back were about optimizing my MySQL install using the tuning-primer.sh script. I am grateful for those responses and did indeed use the script to help optimize my MySQL database install. Unfortunately, this did not resolve my response time issue. I finally checked my logs (something I should have done in the first place) and I found the following error message: [Wed Jul 23 09:54:25 2008][Error][Kernel::System::CalendarEvent::Events][686] Table 'otrs .calendar_event' doesn't exist, SQL: 'SELECT e.id, e.sequence_type, e.title, e.content, e .start_time, e.end_time, e.event_status FROM calendar_event e , calendar_event_involved ei WHERE ((e.start_time >= '2008-7-30 00:00:00' AND e.sequence_end_time <= '2008-7-30 23:59:59') OR (e.start_time >= '2008-7-30 00:00:00' AND e.start_time <= '2008-7-30 23:5 9:59') OR (e.sequence_end_time >= '2008-7-30 00:00:00' AND e.sequence_end_time <= '2008 -7-30 23:59:59') OR (e.start_time <= '2008-7-30 00:00:00' AND e.sequence_end_time >= '2 008-7-30 23:59:59')) AND e.id = ei.event_id AND ei.user_id IN (48) ORDER BY e.start_time' This message occurs exactly 16 times whenever I try to log in or view my ticket queue. Neither the OTRS 1.2.3 nor the OTRS 2.2.6 database has a calendar_event table so I don't know why OTRS is looking for one. I'm thinking this is what is causing my response time issues. Should I create a dummy calendar_event table in MySQL database or is there a way to remove some entry that is making OTRS look for this table? I would be grateful for any and all advice on this issue. Regards, David Buice ITIL Foundations Certified EDS - PSIC 7000 Chicago Road Warren, MI 48092 ( Phone:+1-586-575-4525 + mailto:david.buice@eds.com cell: 248-249-9122
Buice, David R wrote:
Neither the OTRS 1.2.3 nor the OTRS 2.2.6 database has a calendar_event table so I don't know why OTRS is looking for one. I'm thinking this is what is causing my response time issues.
Our OTRS 2.2.7 installation does have this table. It is empty in our database though. And there is also a table called calendar_event_involved. They may be there because we had the Calendar package installed at some point. See Admin > Package Manager to see if you maybe have extra packages installed. Nils Breunese.
Thank you for the response Nils. I downloaded and installed the calendar package and that cleared up the error messages I was getting in the log. Sadly, that did not fix my response time issue. I can click on any of the items in the toolbar (e.g. FAQ, Admin, Stats, Preferences, Customer, Logout, etc.) and get reasonable response time (like 1/2 a second). But when I first log on or if I click on QueueView or Locked Tickets or do anything that invokes "Action=TicketQueue" or "Action=TicketMailbox", there is a 1 minute, 20 second response time. There don't appear to be any meaningful data or errors in the logs of OTRS, Apache, or MySQL. I can't find a way to capture whatever is going on between the moment I click on, say, QueueView, and when the actual page comes up. I would appreciate any help that anyone might be able to give. Regards, David Buice ITIL Foundations Certified EDS - PSIC 7000 Chicago Road Warren, MI 48092 ( Phone:+1-586-575-4525 + mailto:david.buice@eds.com cell: 248-249-9122 -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nils Breunese (Lemonbit) Sent: Wednesday, July 23, 2008 11:23 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Long Response Time Due to Missing Calender_Event Table Buice, David R wrote:
Neither the OTRS 1.2.3 nor the OTRS 2.2.6 database has a calendar_event table so I don't know why OTRS is looking for one. I'm thinking this is what is causing my response time issues.
Our OTRS 2.2.7 installation does have this table. It is empty in our database though. And there is also a table called calendar_event_involved. They may be there because we had the Calendar package installed at some point. See Admin > Package Manager to see if you maybe have extra packages installed. Nils Breunese. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
Neither the OTRS 1.2.3 nor the OTRS 2.2.6 database has a calendar_event table so I don't know why OTRS is looking for one. I'm thinking this is what is causing my response time issues.
Our OTRS 2.2.7 installation does have this table. It is empty in our database though. And there is also a table called calendar_event_involved. They may be there because we had the Calendar package installed at some point. See Admin > Package Manager to see if you maybe have extra packages installed.
My vanilla OTRS 2.2.7 does not have this table. It must come from some extra package, then. -- Lars
Lars Jørgensen wrote:
Neither the OTRS 1.2.3 nor the OTRS 2.2.6 database has a calendar_event table so I don't know why OTRS is looking for one. I'm thinking this is what is causing my response time issues.
Our OTRS 2.2.7 installation does have this table. It is empty in our database though. And there is also a table called calendar_event_involved. They may be there because we had the Calendar package installed at some point. See Admin > Package Manager to see if you maybe have extra packages installed.
My vanilla OTRS 2.2.7 does not have this table. It must come from some extra package, then.
Our installation had a partially installed Calendar module. After uninstalling it the calendar_event table was also gone. Nils Breunese.
participants (3)
-
Buice, David R -
Lars Jørgensen -
Nils Breunese (Lemonbit)