Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Elxis 5.5 Calypso supports 2 factor authentication login with e-mail or SMS.
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
Technical support
»
Fatal error at the site
« previous
next »
Print
Pages: [
1
]
Author
Topic: Fatal error at the site (Read 6145 times)
perseas
Jr. Member
Posts: 97
Fatal error at the site
«
on:
February 17, 2017, 11:06:07 »
Dear sir
I am getting emails about the fatal error please help me out how to solve the problem
A fatal error occured at
https://www.mysite.gr
Please inspect the site to find-out was caused this error and fix it.
The detailed error message was:
ERROR in file /var/www/.../data/www/mysite.gr/includes/libraries/elxis/database/statement.class.php line 41
Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /var/www/.../data/www/mysite.gr/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /var/www/.../data/www/mysite.gr/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /var/www/.../data/www/mysite.gr/includes/libraries/elxis/helpers/cron.helper.php(97): elxisPDOStatement->execute()
#2 /var/www/.../data/www/mysite.gr/includes/libraries/elxis/helpers/cron.helper.php(67): elxisCronHelper->pubUnpubArticles()
#3 /var/www/.../data/www/mysite.gr/includes/libraries/elxis/document.class.php(906): elxisCronHelper->run()
#4 /var/www/.../data/www/mysite.gr/includes/loader.php(245): elxisDocument->make()
#5 /var/www/.../data/www/mysite.gr/index.php(18): require('/var/www/...')
#6 {main}
thrown
This error was logged
Cron jobs are enabled
Cron jobs probability 10
Thanks in advance
Logged
datahell
Elxis Team
Hero Member
Posts: 10356
Re: Fatal error at the site
«
Reply #1 on:
February 18, 2017, 18:56:11 »
This is a mysql issue. You can try to increase the value of the "innodb_lock_wait_timeout" in mysql configuration file (my.cnf). Search google for
1205 Lock wait timeout exceeded
you will find many results with the same problem.
Logged
Elxis Team
|
Is Open Source
|
IOS Rentals | IOS AERO
perseas
Jr. Member
Posts: 97
Re: Fatal error at the site
«
Reply #2 on:
February 23, 2017, 07:30:58 »
Thank you very much datahell
I increased the value of the variable"innodb_lock_wait_timeout" in mysql configuration file, from (50) the default to 120.
After a few days of operation the error message did not appear.
But still I wonder why this happened after two years of continuous operation of servers with the default value.
Logged
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
Technical support
»
Fatal error at the site