Error Kernel::System::Ticket::TicketNumberLookup ERROR Database disconnected
Hi, I get a lot of these errors in the log file, but all seem to be running fine: [Wed Sep 30 14:35:24 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] ERROR Database disconnected, SQL: 'SELECT tn FROM ticket WHERE id = ?' Any idea of what is the problem? Bastien.
Hi Bastien, I've got a problem that looks a bit like yours. My error message: [Wed Sep 30 08:28:54 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' I haven't found any hints to solve this issue, yet. Are you using MSQL, too? Timo Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Bastien Leblanc Gesendet: Mittwoch, 30. September 2009 14:37 An: User questions and discussions about OTRS. Betreff: [otrs] Error Kernel::System::Ticket::TicketNumberLookup ERROR Database disconnected Hi, I get a lot of these errors in the log file, but all seem to be running fine: [Wed Sep 30 14:35:24 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] ERROR Database disconnected, SQL: 'SELECT tn FROM ticket WHERE id = ?' Any idea of what is the problem? Bastien.
No we are using Oracle, but maybe this is an error only reproductible on
other DBMS than mysql?
But my problem is that I can't track it to reproduce the problem. If only I
knew from which process this error comes up (Ticket Search, Queue View,
PostmasterFetching,....)
2009/9/30 Rupp Timo
Hi Bastien,
I’ve got a problem that looks a bit like yours. My error message:
[Wed Sep 30 08:28:54 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?'
I haven’t found any hints to solve this issue, yet. Are you using MSQL, too?
Timo
*Von:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *Im Auftrag von *Bastien Leblanc *Gesendet:* Mittwoch, 30. September 2009 14:37 *An:* User questions and discussions about OTRS. *Betreff:* [otrs] Error Kernel::System::Ticket::TicketNumberLookup ERROR Database disconnected
Hi,
I get a lot of these errors in the log file, but all seem to be running fine:
[Wed Sep 30 14:35:24 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] ERROR Database disconnected, SQL: 'SELECT tn FROM ticket WHERE id = ?'
Any idea of what is the problem?
Bastien.
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Ok, I've played around a bit on my testing server. The error message appears each time a generic agent is added or is running. Before I added generic agents I was not able to reproduce the error on the teting server. Maybe this helps us to get one step closer to the solution :) - Timo Wed Sep 30 16:26:10 2009][Notice][Kernel::System::GenericAgent::JobAdd] New GenericAgent job 'Auto-Close Junk' added (UserID=6). [Wed Sep 30 16:26:22 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:26:22 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:26:22 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:26:29 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:26:29 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:26:29 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:06 2009][Notice][Kernel::System::GenericAgent::JobRun] Run GenericAgent Job 'Auto-Close Junk' from db. [Wed Sep 30 16:27:08 2009][Notice][Kernel::System::Ticket::Article::SendAgentNotification] Sent agent 'AddNote' notification to 'Rupp@huberverlag.de'. [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?' [Wed Sep 30 16:27:09 2009][Error][Kernel::System::Ticket::TicketNumberLookup][637] Cannot allocate statement when disconnected from the database, SQL: 'SELECT tn FROM ticket WHERE id = ?'
I posted this issue in OTRS bugzilla. See also http://bugs.otrs.org/show_bug.cgi?id=4367 - Timo
Hi, On 01.10.2009, at 10:29, Rupp Timo wrote:
I posted this issue in OTRS bugzilla. See also http://bugs.otrs.org/show_bug.cgi?id=4367
Just for all others with the same problem. Bug is fixed now. See also http://bugs.otrs.org/show_bug.cgi?id=4367
- Timo
-Martin
participants (3)
-
Bastien Leblanc -
Martin Edenhofer -
Rupp Timo