[G12] MySQL server has gone away

[Mukesh Saini]

I had a similar problem when I used the latest version *.so.16 of mysql. Try pointing mysql variables where you have libmysql*.so.15.

That fixed it for me. If this is at npgrid, then point it to /usr/lib/.

MYSQL_ROOT_PATH=/usr/
MYSQL_INCLUDE_PATH=/usr/include/mysql
MYSQL_LIB_PATH=/usr/lib/mysql
MYSQLINC=/usr/include/mysql
MYSQLLIB=/usr/lib/mysql


----- Original Message -----
From: Paul Eugenio <eugenio at fsu.edu>
Date: Tuesday, March 30, 2010 12:19 am
Subject: [G12] MySQL server has gone away
To: g12 at jlab.org

> Anyone know how to fix this problem?
> 
> 
> 
> 
> file[ 0]->56550.A00<-
> calib_connect: RunIndex_table = "calib_user.RunIndexg12"
> calib_connect: using server=clasdb.jlab.org (default)
> calib_connect: using latest constants
> calib_connect: connecting as user=clasuser
> calib_connect: connection error. Can't connect to MySQL server on 
> 'clasdb.jlab.org' (111)
> calib_get_float SQL_ERR: MySQL server has gone away
> calib_get_float SQL_ERR: query error SELECT systemId FROM System 
> WHERE System.systemName='GEOMETRY'
> 
> *** Break *** segmentation violation
> Segmentation fault
> 
> 
> _______________________________________________
> G12 mailing list
> G12 at jlab.org
> https://mailman.jlab.org/mailman/listinfo/g12
> 

Graduate Student,
Florida State University.