[SR-Users] Fail to reload htable

[Soltanici Ilie]

Daniel,

I need to reload a hash table to clear all records without waiting before they will expire. I can delete them all one by one with htable.delete - or make a loop with htable.dump and then delete them - but I was thinking that the same can be achieved by htable.reload command.

I didn't pay attention to this line from the documentation: "R eload hash table from database."
Thank You


>Среда, 22 августа 2018, 11:47 +01:00 от Daniel-Constantin Mierla <miconda at gmail.com>:
>
>Hello,
>then there is no database table from where to reload -- why you
>      issue a reload in this case? It should be done only when writing
>      records to database table and then you want them to be loaded in
>      memory.
>Cheers,
>Daniel
>
>On 21.08.18 19:06, Soltanici Ilie
>      wrote:
>>Hi Daniel,
>>
>>No, it is not.
>>
>>modparam("htable", "htable", "auth=>size=8;autoexpire=300;")
>>
>>
>>
>>>Вторник, 21 августа 2018, 8:07 +01:00 от
>>>        Daniel-Constantin Mierla  <miconda at gmail.com> :
>>>
>>>Hello,
>>>
>>>is the htable auth defined with dbtable attribute?
>>>
>>>Cheers,
>>>Daniel
>>>
>>>
>>>On 20.08.18 21:04, Henning Westerholt wrote:
>>>> Am Montag, 20. August 2018, 20:58:43 CEST schrieb
>>>                Soltanici Ilie:
>>>>> In the logs, I see these errors:
>>>>>
>>>>> ERROR: <core> [db.c:463]: db_use_table():
>>>                invalid parameter value
>>>>> Aug 20 19:56:41 kamailio[12716]: ERROR:
>>>                <core> [db.c:463]: db_use_table():
>>>>> invalid parameter value Aug 20 19:56:41
>>>                kamailio[12716]: ERROR: htable
>>>>> [ht_db.c:211]: ht_db_load_table(): failed to
>>>                use_table
>>>> Hi,
>>>>
>>>> please keep the list in CC.
>>>>
>>>> This error is related to a database issue. Please
>>>                double check if there are 
>>>> any issues during startup in the log. Do you see
>>>                any other error there?
>>>>
>>>> A similar (not 100% identical) issue was discussed
>>>                recently here:
>>>>
>>>>  https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html
>>>>
>>>> Maybe this helps you as well.
>>>>
>>>> Best regards,
>>>>
>>>> Henning
>>>>
>>>
>>>-- 
>>>Daniel-Constantin Mierla --  www.asipto.com
>>>www.twitter.com/miconda -- www.linkedin.com/in/miconda
>>>Kamailio World Conference --  www.kamailioworld.com
>>>
>>
>>
>>С уважением,
>>Ilie Soltanici
>>iliesh at mail.ru
>
>-- 
>Daniel-Constantin Mierla -- www.asipto.com
>www.twitter.com/miconda -- www.linkedin.com/in/miconda
>Kamailio World Conference -- www.kamailioworld.com

С уважением,
Ilie Soltanici
iliesh at mail.ru
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180822/048ff9fa/attachment.html>