I'm getting database errors very often while getting tickets on OTRS (more than 10%), but I don't have similar problems with other application on the same server (although OTRS is the only one running perl)
my database status is like: article - 470,666 records - 375 MBs article_plain - 331,985 records - 607 MBs ticket - 189,164 records - 44 MBs ticket_history - 2,309,490 records - 300 MBs I only create tickets piping to PostMaster.pl and I currently use OTRS 2.0.1 (you don't need to read the next parentheses for diagnose :)) (I wish I could update more frequently, but I have a LOT of customizations that leaves me with a hard job when upgrading... so I only upgrade it when I think I need some new feature really bad and it doesn't worth to implement it myself security issues aren't really a concern for me because I don't allow users to login to OTRS, only agents (I only need users to get their answers by E-mail) so I'm only in danger if there're some bug in a script that can be accessed without login) anyway, do you believe this is a MySQL problem caused by something else then OTRS? and can anyone suggest a solution? I know it's probably a DBI, not OTRS, "bug", but had someone already implemented something to mitigate it? or used something else then DBI? thanks, Fernando PS: DB.pm line 432 = @FetchrowArray ... my @Row = $Self->{Curser}->fetchrow_array(); line 395 = @Prepare() ... if (!$Self->{Curser}->execute()) -----/----- DBD::mysql::st execute failed: MySQL server has gone away at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 395, <STDIN> line 17. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: MySQL server has gone away, SQL: 'SELECT value0, queue_id FROM system_address WHERE valid_id in ( 1 )' Traceback (27458): Module: Kernel::System::DB::GetTableData (v1.44) Line: 601 Module: Kernel::System::PostMaster::DestQueue::GetQueueID (v1.16) Line: 46 Module: Kernel::System::PostMaster::Run (v1.52) Line: 229 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 432, <STDIN> line 17. DBD::mysql::st execute failed: MySQL server has gone away at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 395, <STDIN> line 17. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: MySQL server has gone away, SQL: 'SELECT id FROM queue WHERE name = 'Raw'' Traceback (27458): Module: Kernel::System::Queue::QueueLookup (v1.51) Line: 443 Module: Kernel::System::PostMaster::DestQueue::GetQueueID (v1.16) Line: 88 Module: Kernel::System::PostMaster::Run (v1.52) Line: 229 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 432, <STDIN> line 17. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: Found no $QueueID for Raw! Traceback (27458): Module: Kernel::System::Queue::QueueLookup (v1.51) Line: 450 Module: Kernel::System::PostMaster::DestQueue::GetQueueID (v1.16) Line: 88 Module: Kernel::System::PostMaster::Run (v1.52) Line: 229 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st execute failed: MySQL server has gone away at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 395, <STDIN> line 17. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: MySQL server has gone away, SQL: 'SELECT name FROM queue WHERE id = 1' Traceback (27458): Module: Kernel::System::Queue::QueueLookup (v1.51) Line: 443 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 62 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 432, <STDIN> line 17. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: Found no $Queue for 1! Traceback (27458): Module: Kernel::System::Queue::QueueLookup (v1.51) Line: 450 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 62 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st execute failed: MySQL server has gone away at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 395, <STDIN> line 17. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: MySQL server has gone away, SQL: 'SELECT login , first_name, last_name, email FROM customer_user WHERE LOWER(email) LIKE LOWER('cont...@mmm.com') AND valid_id in ( 1 ) LIMIT 250' Traceback (27458): Module: Kernel::System::CustomerUser::DB::CustomerSearch (v1.36) Line: 183 Module: Kernel::System::CustomerUser::CustomerSearch (v1.21) Line: 87 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 114 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 432, <STDIN> line 17. DBD::mysql::st execute failed: MySQL server has gone away at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 395. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: MySQL server has gone away, SQL: 'SELECT id FROM ticket WHERE tn = '2009062910001201' ' Traceback (27458): Module: Kernel::System::Ticket::TicketCheckNumber (v1.181) Line: 248 Module: Kernel::System::Ticket::CheckTicketNr (v1.181) Line: 232 Module: Kernel::System::Ticket::Number::DateChecksum::CreateTicketNr (v1.13) Line: 116 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 158 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 432. DBD::mysql::st execute failed: MySQL server has gone away at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 395. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: MySQL server has gone away, SQL: 'SELECT name FROM queue WHERE id = 1' Traceback (27458): Module: Kernel::System::Queue::QueueLookup (v1.51) Line: 443 Module: Kernel::System::Ticket::TicketCreate (v1.181) Line: 307 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 162 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 432. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: Found no $Queue for 1! Traceback (27458): Module: Kernel::System::Queue::QueueLookup (v1.51) Line: 450 Module: Kernel::System::Ticket::TicketCreate (v1.181) Line: 307 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 162 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 DBD::mysql::st execute failed: MySQL server has gone away at /home/XXX/domains/XXXYYY.com/public_html/otrs/Kernel/System/DB.pm line 395. ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: MySQL server has gone away, SQL: 'SELECT ts.id, ts.name, ts.valid_id, ts.comments, ts.type_id, tst.name FROM ticket_state ts, ticket_state_type tst WHERE ts.type_id = tst.id AND ts.name = 'new'' Traceback (27458): Module: Kernel::System::State::StateGet (v1.8) Line: 106 Module: Kernel::System::Ticket::TicketCreate (v1.181) Line: 319 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 162 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: No StateID for 'new'!!! Traceback (27458): Module: Kernel::System::Ticket::TicketCreate (v1.181) Line: 327 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 162 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: Need TicketID! Traceback (27458): Module: Kernel::System::Ticket::Article::ArticleCreate (v1.90) Line: 84 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 208 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: Need TicketID! Traceback (27458): Module: Kernel::System::Ticket::StateSet (v1.181) Line: 2475 Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 231 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 ERROR: OTRS-PM-10 Perl: 5.8.8 OS: freebsd Time: Mon Jun 29 21:45:10 2009 Message: Can't process email with MessageID <<e1mlrsg-00078n...@ttt.zzz.com>>! Please create a bug report with this email (var/spool/) on http://bugs.otrs.org/! Traceback (27458): Module: Kernel::System::PostMaster::NewTicket::Run (v1.52) Line: 236 Module: Kernel::System::PostMaster::Run (v1.52) Line: 239 Module: (eval) (v1.19) Line: 111 Module: /home/XXX/public_html/otrs/bin/PostMaster.pl (v1.19) Line: 85 --------------------------------------------------------------------- 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/