Dear All,<div><br></div><div>    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?  </div>
<div><br></div><div>   Thanks a lot.</div><div>    </div><div>===================================================================</div><div><div>[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 &#39;(LOWER(login) NOT LIKE LOWER(&#39;%@%&#39;) AND LOWER(first_name) NOT LIKE LOWER(&#39;%@%&#39;) &#39; at line 1 at /opt/otrs//Kernel/System/DB.pm line 559.</div>
<div>ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Mon May  3 18:57:55 2010</div><div><br></div><div> 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 &#39;(LOWER(login) NOT LIKE LOWER(&#39;%@%&#39;) AND LOWER(first_name) NOT LIKE LOWER(&#39;%@%&#39;) &#39; at line 1, SQL: &#39;SELECT login , first_name, last_name, email FROM customer_user WHERE ((LOWER(login) NOT LIKE LOWER(&#39;%ablerainbow%&#39;) AND LOWER(first_name) NOT LIKE LOWER(&#39;%ablerainbow%&#39;) AND LOWER(last_name) NOT LIKE LOWER(&#39;%ablerainbow%&#39;) AND LOWER(customer_id) NOT LIKE LOWER(&#39;%ablerainbow%&#39;)) (LOWER(login) NOT LIKE LOWER(&#39;%@%&#39;) AND LOWER(first_name) NOT LIKE LOWER(&#39;%@%&#39;) AND LOWER(last_name) NOT LIKE LOWER(&#39;%@%&#39;) AND LOWER(customer_id) NOT LIKE LOWER(&#39;%@%&#39;)) )  AND valid_id IN (1)  LIMIT 250&#39;</div>
<div><br></div><div> Traceback (15009):</div><div>   Module: Kernel::System::CustomerUser::DB::CustomerSearch (v1.78) Line: 274</div><div>   Module: Kernel::System::CustomerUser::CustomerSearch (v1.55) Line: 178</div><div>
   Module: Kernel::Modules::AgentCustomerSearch::Run (v1.15.2.1) Line: 67</div><div>   Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819</div><div>   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48</div>
<div>   Module: (eval) (v1.88) Line: 204</div><div>   Module: ModPerl::RegistryCooker::run (v1.88) Line: 204</div><div>   Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170</div><div>   Module: ModPerl::Registry::handler (v1.99) Line: 31</div>
<div><br></div><div>[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.</div><div>=======================================================================</div>
<div><br></div><div>hpsbigcat</div></div>