Hello,I am currently having continuous DB Error #1205 notifications in my mail from OS ticket. Currently we cant open tickets again from the webpage. Please see examples below:
Lock wait timeout exceeded; try restarting
transaction<br /> <br />
---- Backtrace ----<br />
#0 C:\xampp\htdocs\support\include\mysqli.php(182):
osTicket->logDBError('DB Error #1205', '[UPDATE ost_ema...')<br />
#1 C:\xampp\htdocs\support\include\class.mailfetch.php(860):
db_query('UPDATE ost_emai...')<br />
#2 C:\xampp\htdocs\support\include\class.cron.php(25):
MailFetcher:()<br />
#3 C:\xampp\htdocs\support\scp\autocron.php(48):
Cron:()<br />
#4 {main}
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">and......
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">
Lock wait timeout exceeded; try restarting
transaction<br /> <br />
---- Backtrace ----<br />
#0 C:\xampp\htdocs\support\include\mysqli.php(182):
osTicket->logDBError('DB Error #1205', '[DELETE FROM os...')<br />
#1 C:\xampp\htdocs\support\include\class.lock.php(153):
db_query('DELETE FROM ost...')<br />
#2 C:\xampp\htdocs\support\include\class.cron.php(32):
TicketLock:()<br />
#3 C:\xampp\htdocs\support\scp\autocron.php(46): Cron:()<br
/>
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">#4 {main}
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">Please help
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">Regards
minor-latin;mso-fareast-font-family;mso-fareast-theme-font-latin;
mso-hansi-theme-font-latin;mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font-bidi;mso-ansi-language-US;mso-fareast-language:
EN-US;mso-bidi-language-SA">