too many "Including all tenants items" printed in logs

Bug #1433869 reported by stanzgy
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Designate
Fix Released
Medium
stanzgy

Bug Description

When inserted about 13k test records data into designate, the service began to stuck, took up 100% cpu and flooded with a lot of logs.
Among those logs, there are a lot duplicated lines like:

2015-03-19 06:33:47.280 20760 DEBUG designate.sqlalchemy.base [-] Including all tenants items in query results _apply_tenant_criteria /usr/lib/python2.7/dist-packages/designate/sqlalchemy/base.py:132

$ grep "Including all tenants items" -rn designate-mdns.log|wc -l
3395425
$ wc -l designate-mdns.log
3417311 designate-mdns.log

$ grep "Including all tenants items" -rn designate-central.log|wc -l
18466754
$ wc -l designate-central.log
61192408 designate-central.log

This log message helps little when debugging and is too much redundant.
IMO it should be removed.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to designate (master)

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

Changed in designate:
assignee: nobody → stanzgy (stanzgy)
status: New → In Progress
Kiall Mac Innes (kiall)
Changed in designate:
milestone: none → kilo-rc1
importance: Undecided → Medium
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to designate (master)

Reviewed: https://review.openstack.org/165679
Committed: https://git.openstack.org/cgit/openstack/designate/commit/?id=1b80cb142199c13c65dc95fda8dc69daa5b4df3e
Submitter: Jenkins
Branch: master

commit 1b80cb142199c13c65dc95fda8dc69daa5b4df3e
Author: stanzgy <email address hidden>
Date: Thu Mar 19 11:27:05 2015 +0800

    Remove "Including all tenants items" debug log

    Change-Id: Ic27331aa2b48ddc79234b28e0ec4af98af5c0371
    Closes-bug: 1433869

Changed in designate:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in designate:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in designate:
milestone: kilo-rc1 → 2015.1.0
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.