whenever I try to edit a smartfeed I get the following MySQL ODBC error
[MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]MySQL server has gone away
whenever I try to edit a smartfeed I get the following MySQL ODBC error
[MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]MySQL server has gone away
Greetings,
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
"By default, the server closes the connection after eight hours if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld. See Section 5.1.3, “System Variables”."
Does this happens every time or only then, when FR has been running more then eight hours ? There is one connection opened only for specific FR operations.
I'll perform additional tests.
Ingmar
------
FR dev
I just stopped and started FR and I no longer get the error. I find it interesting that my feeds were updating the whole time it was up thus it must have been connected to MySQL.
Greetings,
how long FR runned in hours, there could be case, as I described. One connection is reserved for special operations, directory creating, smartfeed editing and some more. Other connections are used always by updater threads.
Ingmar
------
FR dev
I've increased the value of
I've increased the value of wait_timeout and I haven't seen the problem since.