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('contact@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 <