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 + 0x28) [*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::operator()() (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=*')

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