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