JSON ingester repeatedly creates redundant index

Bug #1819987 reported by Eric K
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
congress
Fix Released
High
Eric K

Bug Description

JSON ingester repeatedly creates redundant indexes each time Congress restarts. Severe performance problems can ultimately result.

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

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

Changed in congress:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to congress (master)

Reviewed: https://review.openstack.org/643491
Committed: https://git.openstack.org/cgit/openstack/congress/commit/?id=a1dfbdec00c66748f0be3a6a0fccacf5e15eaf25
Submitter: Zuul
Branch: master

commit a1dfbdec00c66748f0be3a6a0fccacf5e15eaf25
Author: Eric K <email address hidden>
Date: Wed Mar 13 17:48:49 2019 -0700

    Fix redundant index, unindexable, wrong isolation in JSON ingester

    Fixes a bug where json ingester repeatedly creates redundant indexes
    each time Congress restarts.

    Mitigates a problem where indexing fails when a field exceeds the
    postgres indexable limit of 2712 bytes. Indexing is made optional.

    Fixes a bug where unexpected behavior occurs when the backend DB
    default isolation level is not the expected read_committed. The
    isolation level is now set explicitly per connection.

    Change-Id: I514aa9b96e4efbffe8880cce775dc2259eca4648
    Closes-bug: 1819987
    Closes-bug: 1819988
    Closes-bug: 1819985

Changed in congress:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/congress 9.0.0.0rc1

This issue was fixed in the openstack/congress 9.0.0.0rc1 release candidate.

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.