Dear All,
Yesterday, my OTRS box (running on Centos 5.4 , otrs ver: 2.4.7)
experienced out-of-memory. The below log was captured before the problem
occurred. After about 3 hours, oom-killer killed some application include
mysqld and httpd and the service was resumed. Have someone can help me to
find out the root cause?
Thanks a lot.
===================================================================
[Mon May 3 18:57:55 2010] -e: DBD::mysql::st execute failed: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '(LOWER(login) NOT LIKE
LOWER('%...@%') AND LOWER(first_name) NOT LIKE LOWER('%...@%') ' at line 1 at
/opt/otrs//Kernel/System/DB.pm line 559.
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Mon May 3 18:57:55 2010
Message: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'(LOWER(login) NOT LIKE LOWER('%...@%') AND LOWER(first_name) NOT LIKE
LOWER('%...@%') ' at line 1, SQL: 'SELECT login , first_name, last_name, email
FROM customer_user WHERE ((LOWER(login) NOT LIKE LOWER('%ablerainbow%') AND
LOWER(first_name) NOT LIKE LOWER('%ablerainbow%') AND LOWER(last_name) NOT
LIKE LOWER('%ablerainbow%') AND LOWER(customer_id) NOT LIKE
LOWER('%ablerainbow%')) (LOWER(login) NOT LIKE LOWER('%...@%') AND
LOWER(first_name) NOT LIKE LOWER('%...@%') AND LOWER(last_name) NOT LIKE
LOWER('%...@%') AND LOWER(customer_id) NOT LIKE LOWER('%...@%')) ) AND valid_id
IN (1) LIMIT 250'
Traceback (15009):
Module: Kernel::System::CustomerUser::DB::CustomerSearch (v1.78) Line:
274
Module: Kernel::System::CustomerUser::CustomerSearch (v1.55) Line: 178
Module: Kernel::Modules::AgentCustomerSearch::Run (v1.15.2.1) Line: 67
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
Module:
ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
(unknown version) Line: 48
Module: (eval) (v1.88) Line: 204
Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
[Mon May 3 18:57:55 2010] -e: DBD::mysql::st fetchrow_array failed: fetch()
without execute() at /opt/otrs//Kernel/System/DB.pm line 622.
=======================================================================
hpsbigcat
---------------------------------------------------------------------
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/
