Parallels Virtualization and Automation Software

SYMPTOMS

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
Description:
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

CAUSE

MySQL table gets locked by a running transaction

RESOLUTION

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.