Things to check: - aborted_clients and aborted_connections in the mysql 'show status' output - anything in the mysql error log about 'too many clients'? - default connect_timeout is 10, so you could try bumping that up if it seems like the client is timing out trying to get a connection
--jay On Thu, Aug 19, 2010 at 10:50 AM, Henning Weiler <[email protected]> wrote: > Dear all, > > currently, I'm facing trouble with Bibsched/Bibtask. > > The machine I'm running it on is an Intel Atom 1.60GHz w/ 1GB of memory. > The process run is bibauthor, which performs flawlessly on three other > machines. > > The message I randomly get is this: > > ---- 8< ---- > 2010-08-19 03:13:17 --> Updating task progress to Cur Dir: job531 (339/581).. > 2010-08-19 03:13:19 --> Updating task status to ERROR. > 2010-08-19 03:13:19 --> Unexpected error occurred: (2002, "Can't connect to > local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)"). > 2010-08-19 03:13:19 --> Traceback is: > 2010-08-19 03:13:19 --> File > "/opt/cds-invenio/lib/python/invenio/bibtask.py", line 331, in task_init > 2010-08-19 03:13:19 --> ret = _task_run(task_run_fnc) > 2010-08-19 03:13:19 --> File > "/opt/cds-invenio/lib/python/invenio/bibtask.py", line 807, in _task_run > 2010-08-19 03:13:19 --> task_status = task_read_status() > 2010-08-19 03:13:19 --> File > "/opt/cds-invenio/lib/python/invenio/bibtask.py", line 474, in > task_read_status > 2010-08-19 03:13:19 --> (_task_params['task_id'],), 1) > 2010-08-19 03:13:19 --> File > "/usr/lib/python2.6/dist-packages/invenio/dbquery.py", line 236, in run_sql > 2010-08-19 03:13:19 --> db = _db_login(relogin=1) > 2010-08-19 03:13:19 --> File > "/usr/lib/python2.6/dist-packages/invenio/dbquery.py", line 109, in _db_login > 2010-08-19 03:13:19 --> use_unicode=False, charset='utf8') > 2010-08-19 03:13:19 --> File > "/usr/lib/pymodules/python2.6/MySQLdb/__init__.py", line 81, in Connect > 2010-08-19 03:13:19 --> return Connection(*args, **kwargs) > 2010-08-19 03:13:19 --> File > "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 170, in __init__ > 2010-08-19 03:13:19 --> super(Connection, self).__init__(*args, **kwargs2) > 2010-08-19 03:13:19 --> Exiting. > 2010-08-19 03:13:19 --> Updating task status to ERROR. > ---- >8 ---- > > Somehow it looks like the mysql server took a coffee break; or took too long > to respond. The load on the mysql server is very high, since all the results > coming from the grid shall be loaded into the database. > > Did you ever experience something similar? Any suggestions? > > Thanks, > Henning > -- > Henning Weiler > CERN - Open Access Section > Postbox C24300 > > Tel: +41-22-767-7835 > eMail: [email protected] > > -- ****************************************************** Jay Luker Astrophysics Data System (ADS) [email protected] Center for Astrophysics 617-495-4588 60 Garden Street MS 67 617-495-7356 fax Cambridge, MA 02138 ******************************************************
