US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > General technical discussion

Notices

Reply
 
Thread Tools
Old 12-14-2016, 08:40 AM   #1
Member
 
Join Date: Aug 2016
Posts: 40
NCbeasty is on a distinguished road
Default error in ISPmanager

Hello,

We have this error from time to time. It helps to run killall -9 core

Dec 12 20:49:32 [15539:18] db ERROR query error: Lock wait timeout exceeded; try restarting transaction
Dec 12 20:49:32 [15539:18] backtrace EXTINFO ??? (lib/libmysql.so.5.78.0 + 0x0) [*0x7f3d15ea74ec]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO ??? (lib/libmysql.so.5.78.0 + 0x0) [*0x7f3d1b5d56c6]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO mgr_db::Connection::Query(std::string const&) (lib/libmgrdb.so.5.78.0 + 0xa6) [*0x7f3d1b5db39b]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO mgr_db::Cache::Query(std::string const&) (lib/libmgrdb.so.5.78.0 + 0x3b) [*0x7f3d1b5ea88e]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO mgr_db::CustomTable::Post() (lib/libmgrdb.so.5.78.0 + 0x10ce) [*0x7f3d1e7775a1]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO isppriv_action_ftp_user::ActionFTPUser::BeforeRemo teSet(isp_api::Session&, std::shared_ptr<isppriv_action_ftp_user::FTPUserTa ble>&) const (lib/ispmgr.so + 0x1b1) [*0x7f3d1e7769b8]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO isp_api::RemoteTableIdListAction<isppriv_action_ft p_user::FTPUserTable>::TableSet(isp_api::Session&, std::shared_ptr<isppriv_action_ftp_user::FTPUserTa ble>&) const (lib/ispmgr.so + 0x2 [*0x7f3d1e77481d]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO isp_api::TableIdListAction<isppriv_action_ftp_user ::FTPUserTable>::New(isp_api::Session&) const (lib/ispmgr.so + 0x12d) [*0x7f3d1c6afcad]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO isp_api::FormAction::ModuleExecute(isp_api::Sessio n&) const (lib/libispapi.so.5.78.0 + 0xed) [*0x7f3d1c6b1554]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO isp_api::FormAction::Execute(isp_api::Session&) const (lib/libispapi.so.5.78.0 + 0x214) [*0x7f3d1c6baa7a]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO isp_api::Action::Run(isp_api::Session&) const (lib/libispapi.so.5.78.0 + 0xaa) [*0x7f3d1c6bc5b2]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO isp_api::InternalCall(isp_api::BaseConnection const&, isp_api::Authen const&, isp_api::Action const&) (lib/libispapi.so.5.78.0 + 0x552) [*0x7f3d1d58b545]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO ispcore::ProcessRequest:perator()() (lib/libbase.so.5.78.0 + 0x965) [*0x7f3d1d58f47d]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO mgr_thread::Handle::Impl<mgr_thread::List::Impl<is pcore::ProcessRequest> >::run() (lib/libbase.so.5.78.0 + 0x4d) [*0x7f3d1c0d898e]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO ??? (lib/libmgr.so.5.78.0 + 0x0) [*0x7f3d1f37baa1]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO ??? (/lib64/libpthread.so.0 + 0x0) [*0x7f3d1f0c8aad]
Dec 12 20:49:32 [15539:18] backtrace EXTINFO ??? (/lib64/libc.so.6 + 0x6d) [*(nil)]
Dec 12 20:49:32 [15539:18] libmgr ERROR Error: Type: 'db' Object: 'query' Value: ''
Dec 12 20:49:32 [15539:18] action EXTINFO Get message for error in action 'ftp.user.edit' for level 29
Dec 12 20:49:32 [15539:18] action EXTINFO Get message for error in action 'mgrerror_db' for level 29
Dec 12 20:49:32 [15539:18] action EXTINFO Get message for error in action 'msgerror' for level 29
Dec 12 20:49:32 [15539:18] core WARNING 0x7f3d100023a0 Restart request
Dec 12 20:49:32 [15539:18] libmgr EXTINFO Start thread
Dec 12 20:49:32 [15539:34] core_module EXTINFO Internal [][] 'func=authenticate.internal&username=asdasdby'
Dec 12 20:49:32 [15539:18] libmgr EXTINFO Thread a81fbc7395e96c7b finished
Dec 12 20:49:32 [15539:34] core_module INFO Request [178.120.200.146][admin1#asdasdby] 'clicked_button=ok&comment=test1234&confirm=*&func =ftp.user.edit&home=%2F&name=test1234&operafake=14 81564921572&passwd=*&progressid=false&sfrom=ajax'
Dec 12 20:49:32 [15539:34] rpc EXTINFO Query('clicked_button=ok&comment=test1234&confirm= *&func=ftp.user.edit&home=%2F&name=test1234&operaf ake=1481564921572&passwd=*&progressid=false&sfrom= ajax&out=devel&su=asdasdby&userexperience=expert&l ang=ru&authinfo=*')
NCbeasty is offline   Reply With Quote
Old 12-15-2016, 06:48 AM   #2
ISPsystem team
 
Join Date: Aug 2016
Posts: 102
C.Gladkov is on a distinguished road
Default

Hello,

You should check logs of your MySQL server. This error (db ERROR query error: Lock wait timeout exceeded; try restarting transaction) means that request to the database can not be performed and DB server has problems with it
C.Gladkov is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 09:53 PM.