[rt-devel] Problem with DBIx::SearchBuilder's cache mechanism

[Timo Hummel]

Hi,

I have some problems with the DBIx::SearchBuilder cache mechanism.

Here's my table definition:

+--------+--------------+------+-----+---------+----------------+
| Field  | Type         | Null | Key | Default | Extra          |
+--------+--------------+------+-----+---------+----------------+
| id     | int(11)      |      | PRI | NULL    | auto_increment |
| Entity | varchar(128) |      |     |         |                |
| Value  | text         | YES  |     | NULL    |                |
+--------+--------------+------+-----+---------+----------------+

And here the contents:

+----+---------------------------------+--------------------------------+
| id | Entity                          | Value                         
|
+----+---------------------------------+--------------------------------+
| 13 | QuickSearchShowStalled          | 1                             
|
| 12 | QuickSearchOpenQueueInNewWindow | 2                             
|
| 14 | IndexShowRefreshControl         | 3                             
|
| 15 | IndexComponentOrder             | MyTicketsMyHighPriorityTickets
|
| 16 | IndexShowPopup                  | 4                             
|
| 17 | HeaderLogoName                  | is-ag.jpg                     
|
+----+---------------------------------+--------------------------------+

The problem is when I query for Entity "IndexComponentOrder" (using
LoadByCol), 
DBIx::SearchBuilder::Record !sometimes! returns "4" instead of
"MyTicketsMyHighPriorityTickets" 
(which is exactly the next row). I usually query for "IndexShowPopup"
and then for
"IndexComponentOrder". I assume that DBIx::SearchBuilder::Cachable
stores the value of
"IndexShowPopup" and swaps it around with "IndexComponentOrder".


The problem does not occur when I disable the cache mechanism of
SearchBuilder in Cacheable.pm:

package __CachableDefaults;

sub _CacheConfig {
  {
     'cache_p'        => 0,
     'fast_update_p'  => 1,
     'cache_for_sec'  => 0,
  }
}

1;

Any ideas?

Best regards,
Timo

-- 

Timo A. Hummel, IT Specialist
IS Innovative Software AG               Phone:  +49 69 505030-302
Feuerbachstraße 26-32                   Fax:    +49 69 505030-505
60325 Frankfurt a.M.                    E-Mail:
mailto:timo.hummel at isg.de
GERMANY                                 WWW:    http://is.ag