[SR-Users] Htable not reloading from db on expiry

[Daniel Greenwald]

I have an htable that loads from mysql. The data loads fine on startup but
disappears on expiry. If I issue kamcmd htable.reload it loads again until
expiry. It seems as if db_expires is not taking affect. I see them expiring
in the debug log but not an errors. Mysql general log does not show any
attempt to connect on expiry. Another odd thing is that if I set the
expires column in db to anything other than 0 the data doesn't load at all.
Any ideas would be appreciated.

modparam("htable", "timer_interval", 10)
modparam("htable", "htable",
"h=>size=20;autoexpire=20;dbtable=validdomains;updateexpire=0;")
modparam("htable", "db_url", AUTHDBURL)
modparam("htable", "db_expires", 1)

create or replace view validdomains as select distinct subscriber.domain as
key_name, 1 as key_value, 0 as key_type, 0 as value_type, 0 as expires from
subscriber;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190627/bf8efe3e/attachment.html>