Article ID: 1648, created on Oct 6, 2008, last review on May 4, 2014

  • Applies to:
  • Plesk 8.1 for Windows
  • Plesk 7.6 for Windows
  • Plesk 7.5 for Windows


Such problem can occur sometimes, for example during statistics execution. It fails with error in event log Event Type:

Error Event Source: statistics.exe
Event Category: None
Event ID: 1
Date: 10/19/2006
Time: 3:25:38 PM
User: N/A
Computer: PLESK
Can't execute update DomainsTraffic set http_in=42790, http_out=1195034 where date='2006-10-18' and dom_id='10': MySql error 1205:Lock wait timeout exceeded; try restarting transaction
 at (MySQL::execute line 354)
 at execute statistics.exe(vconsoleapp::run line 138) Execute file name: C:\Program Files\SWsoft\Plesk\admin\bin\statistics.exe


MySQL table gets locked by a running transaction


Disable locking. To disable locking add a startup parameter innodb_table_locks=0 into MySQL configuration file "%plesk_dir%MySQL\Data\my.ini". Then restart Plesk MySQL server.

c0c38d2367acfa8909699e0b34b01dea 7000fbc03a7e92b93bc676a7c04a4ce6 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c eeda7e5e81623f3acf0bdb69fa51d540 e115c1a9652baf38f4af4f18d5b7ac6e c45acecf540ecd42a4bbfb242ce02b1d 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF