mysql server gone away

[ultralord]

hello i make my script but days now i have that problem when i run the proc sometimes not always it says on telnet

::mysql::sel/db server: MySQL server has gone away

after .rehash is working of course does anyone now how i can fix it.. or make .rehash if that problem appear?

[thommey]

Let your mysql database handle be in the global $dbhandle variable.

Code: Select all

bind time - * checksqlalive
proc checksqlalive {} {
  mysql::ping $::dbhandle
}

That will not only check if the connection is alive every minute but also automatically reconnect if it timed out. (Alternatively, do that before every sql statement you execute). See also mysql reference manual.

[ultralord]

ahhh it was easy thanks for great help

[ultralord]

cant find the correct args

Tcl error [checksqlalive]: wrong # args: should be "checksqlalive"

:S

[thommey]

woops, sorry, should've been:

Code: Select all

bind time - * checksqlalive 
proc checksqlalive {args} { 
  mysql::ping $::dbhandle 
} 

[kenh83]

thommey ..
The checksqlalive snipplet, can you expand on it so that if it returns 1, it does nothing, if it returns NOTHING it would restart the mysql server.