#394: Improve index with DB consistency
--------------------------+------------------------------------
  Reporter:  andrej       |      Owner:  nobody
      Type:  enhancement  |     Status:  new
  Priority:  major        |  Milestone:  Release 6
 Component:  search       |    Version:
Resolution:               |   Keywords:  bep-0004 bep-0004-beta
--------------------------+------------------------------------
Changes (by andrej):

 * owner:   => nobody
 * keywords:   => bep-0004 bep-0004-beta
 * component:   => search
 * milestone:   => Release 6


Old description:



New description:

 * Current implementation uses ITicketChangeListener interface that is
 triggered after DB transaction is already committed. There is possiblity
 to get inconsistency between DB and search index if index update fails. In
 this case reindex is required. One of the possible solution is to contact
 Trac community with suggestion to introduce a new, within transaction,
 I<Resource>ChangingListener interface. During this event we can save
 changes into additional table and than index changes in separate thread.
    * Some ticket changes are not reflected in event interfaces e.g.
 Version and Component renaming. One of the possible solution is to contact
 Trac community to introduce new interfaces.
    * Alternative solution is triggering events from SQL proxy developed on
 multi-product branch
    * Usage of DB triggers is another alternative

--

-- 
Ticket URL: <https://issues.apache.org/bloodhound/ticket/394#comment:1>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound (incubating) issue tracker

Reply via email to