Problem with DBIx::SearchBuilder's cache mechanism

RT Developers
1

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@isg.de
GERMANY WWW: http://is.ag