Question
error 28 from storage engine
Hi,
Recently we have been getting the error message below from MySQL on our Linux
based servers:
MESSAGE:
Error Executing Database Query.
DIAGNOSTICS:
Error Executing Database Query. General error: Got error 28 from storage
engine
The error occurred on line 178.
After googling this error it seems that it is to do with a server timeout, and
after speaking to our server people they said that
"When Coldfusion becomes overloaded, the server can sometimes force itself to
reset. When this happens the sessions are dropped and all queries using those
variables are invalid."
Has anyone else encountered this problem using CF7 / CF8 and MySQL on Linux
servers? We have a Windows server also and have not encountered this problem
there...
Due to this error, we are losing potential customers to our online stores due
to incomplete checkout processes and we're keen to find a solution.
Recently we have been getting the error message below from MySQL on our Linux
based servers:
MESSAGE:
Error Executing Database Query.
DIAGNOSTICS:
Error Executing Database Query. General error: Got error 28 from storage
engine
The error occurred on line 178.
After googling this error it seems that it is to do with a server timeout, and
after speaking to our server people they said that
"When Coldfusion becomes overloaded, the server can sometimes force itself to
reset. When this happens the sessions are dropped and all queries using those
variables are invalid."
Has anyone else encountered this problem using CF7 / CF8 and MySQL on Linux
servers? We have a Windows server also and have not encountered this problem
there...
Due to this error, we are losing potential customers to our online stores due
to incomplete checkout processes and we're keen to find a solution.
