12-14-2016, 08:40 AM | #1 |
Member
Join Date: Aug 2016
Posts: 40
|
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=*') |
12-15-2016, 06:48 AM | #2 |
ISPsystem team
Join Date: Aug 2016
Posts: 102
|
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 |
|
|