connection_trace does not work with DB2 backend

[Matt Riedemann]

When setting connection_trace=True, the stack trace does not get printed for DB2 (ibm_db).

I have a patch that we've been using internally for this fix that I plan to upstream soon, and with that we can get output like this:

2013-09-11 13:07:51.985 28151 INFO sqlalchemy.engine.base.Engine [-] SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services."binary" AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.disabled_reason AS services_disabled_reason
FROM services WHERE services.deleted = ? AND services.id = ? FETCH FIRST 1 ROWS ONLY
2013-09-11 13:07:51,985 INFO sqlalchemy.engine.base.Engine (0, 3)
2013-09-11 13:07:51.985 28151 INFO sqlalchemy.engine.base.Engine [-] (0, 3)
        File /usr/lib/python2.6/site-packages/nova/servicegroup/drivers/db.py:92 _report_state() service.service_ref, state_catalog)
        File /usr/lib/python2.6/site-packages/nova/conductor/api.py:270 service_update() return self._manager.service_update(context, service, values)
        File /usr/lib/python2.6/site-packages/nova/openstack/common/rpc/common.py:420 catch_client_exception() return func(*args, **kwargs)
        File /usr/lib/python2.6/site-packages/nova/conductor/manager.py:461 service_update() svc = self.db.service_update(context, service['id'], values)
        File /usr/lib/python2.6/site-packages/nova/db/sqlalchemy/api.py:505 service_update() with_compute_node=False, session=session)
        File /usr/lib/python2.6/site-packages/nova/db/sqlalchemy/api.py:388 _service_get() result = query.first()

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/70163

[Openstack Gerrit (openstack-gerrit)]

Fix proposed to branch: master
Review: https://review.openstack.org/92182

[OpenStack Infra (hudson-openstack)]

Change abandoned by Brant Knudson (<email address hidden>) on branch: master
Review: https://review.openstack.org/92182
Reason: Taken care of by https://review.openstack.org/#/c/106406/

[Brant Knudson (blk-u)]

This was fixed in oslo.db by Michael Bayer with https://review.openstack.org/#/c/106406/

[Brant Knudson (blk-u)]

Keystone isn't affected since all we have to do is pick up an oslo.db that includes https://review.openstack.org/#/c/106406/

[Viktor Serhieiev (vsergeyev)]

Is it still affects Glace?

[Matt Riedemann (mriedem)]

This should be fixed in nova when nova starts using oslo.db:

https://review.openstack.org/#/c/101901/

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/101901
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=1b83b2f11054ddd3f72fe75c5cef496060afcb3a
Submitter: Jenkins
Branch: master

commit 1b83b2f11054ddd3f72fe75c5cef496060afcb3a
Author: Andrey Kurilin <email address hidden>
Date: Sat Jun 21 13:56:42 2014 +0300

    Move to oslo.db

    Replace common oslo code nova.openstack.common.db by usage
    of oslo.db library and remove common code.

    Replaced catching of raw sqlalchemy exceptions by catches
    of oslo.db exceptions(such as DBError, DBDuplicateEntry, etc).

    Co-Authored-By: Eugeniya Kudryashova <email address hidden>

    Closes-Bug: #1364986
    Closes-Bug: #1353131
    Closes-Bug: #1283987
    Closes-Bug: #1274523
    Change-Id: I0649539e071b2318ec85ed5d70259c949408e64b

[Viktor Serhieiev (vsergeyev)]

This was fixed in oslo.db by Michael Bayer with https://review.openstack.org/#/c/106406/

[Sean McGinnis (sean-mcginnis)]

Closing stale bug. If this is still an issue please reopen.

[Armando Migliaccio (armando-migliaccio)]

Closing stale bug. If this is still an issue please reopen.

[Markus Zoeller (markus_z) (mzoeller)]

FWIW, DB2 support got removed from Nova in Newton, see release notes of "14.0.0.0b1" http://docs.openstack.org/releasenotes/nova/index.html