SQLAlchemy registry database connection error not logged

[Édouard Thuleau]

I tried to install Glance rev 210 on Ubuntu natty.
I had Glance trunk ppa in my source list.
I configured Glance to use a mysql server (database 'glance' created) and enabled log (verbose = True and debug = True).
When I tried to start 'glance-registry', it couldn't connect to database. But no log appeared and nothing explained that it cannot find MySQLdb library. I found the problem by started 'glance-registry' with 'strace' debugging utility.

So, Glance log must specifie it cannot load a missing library and perhaps add 'python-mysqldb' dependence with glance package.

[Jay Pipes (jaypipes)]

Hi!

What was the in your glance-registry log?

Anything at all to do with import error for Python-MySQLDb?

Thanks!
-jay

[Édouard Thuleau (ethuleau)]

I get this log output:

2011-09-07 14:50:44 DEBUG [glance-registry] ********************************************************************************
2011-09-07 14:50:44 DEBUG [glance-registry] Configuration options gathered from config file:
2011-09-07 14:50:44 DEBUG [glance-registry] /etc/glance/glance-registry.conf
2011-09-07 14:50:44 DEBUG [glance-registry] ================================================
2011-09-07 14:50:44 DEBUG [glance-registry] api_limit_max 1000
2011-09-07 14:50:44 DEBUG [glance-registry] bind_host 0.0.0.0
2011-09-07 14:50:44 DEBUG [glance-registry] bind_port 9191
2011-09-07 14:50:44 DEBUG [glance-registry] debug True
2011-09-07 14:50:44 DEBUG [glance-registry] limit_param_default 25
2011-09-07 14:50:44 DEBUG [glance-registry] log_file /var/log/glance/registry.log
2011-09-07 14:50:44 DEBUG [glance-registry] sql_connection mysql://nova:orange@192.168.254.215/glance
2011-09-07 14:50:44 DEBUG [glance-registry] sql_idle_timeout 3600
2011-09-07 14:50:44 DEBUG [glance-registry] use_syslog False
2011-09-07 14:50:44 DEBUG [glance-registry] verbose True
2011-09-07 14:50:44 DEBUG [glance-registry] ********************************************************************************

And loop on this log.

[Jay Pipes (jaypipes)]

The solution for this seems to be to add some error reporting to the registry log file output if the configure_db() registry call fails with a SQLAlchemy engine connection error.

[Jay Pipes (jaypipes)]

https://review.openstack.org/#change,863

[Openstack Gerrit (openstack-gerrit)]

Reviewed: https://review.openstack.org/863
Committed: http://github.com/openstack/glance/commit/56e15f6993e85376eb6e3fb4928b0cb8f6df1fda
Submitter: Jenkins
Branch: master

 status fixcommitted
 done

commit 56e15f6993e85376eb6e3fb4928b0cb8f6df1fda
Author: Jay Pipes <email address hidden>
Date: Thu Oct 13 11:56:19 2011 -0400

    Fixes LP Bug#844618 - SQLAlchemy errors not logged

    Logs any import errors or SQLAlchemy connection failures
    to the glance registry log so that there is some indication
    that a driver module is not installed or there is a problem
    with the sql_connection configuration string.

    Adds test case that verifies log output and error raised.

    Change-Id: Ib86c353350530d6de62e577df57602d1762879f9

[Openstack Gerrit (openstack-gerrit)]

Reviewed: https://review.openstack.org/1777
Committed: http://github.com/openstack/glance/commit/f186d3c051e118181ce52f112b8586e80a4577d9
Submitter: Jenkins
Branch: stable/diablo

 tag in-stable-diablo
 done

commit f186d3c051e118181ce52f112b8586e80a4577d9
Author: Jay Pipes <email address hidden>
Date: Thu Oct 13 11:56:19 2011 -0400

    Fixes LP Bug#844618 - SQLAlchemy errors not logged

    Logs any import errors or SQLAlchemy connection failures
    to the glance registry log so that there is some indication
    that a driver module is not installed or there is a problem
    with the sql_connection configuration string.

    Adds test case that verifies log output and error raised.

    (cherry picked from commit 56e15f6993e85376eb6e3fb4928b0cb8f6df1fda)

    Change-Id: Ib86c353350530d6de62e577df57602d1762879f9