20 Aug
2018
20 Aug
'18
10:04 p.m.
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
--
Henning Westerholt
https://skalatan.de/blog/
21 Aug
21 Aug
10:07 a.m.
New subject: Fail to reload htable
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:
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
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
8:06 p.m.
New subject: Fail to reload htable
Hi Daniel,
No, it is not.
modparam("htable", "htable",
"auth=>size=8;autoexpire=300;")
Вторник, 21 августа 2018, 8:07 +01:00 от
Daniel-Constantin Mierla <miconda(a)gmail.com>om>:
Hello,
is the htable auth defined with dbtable attribute?
Cheers,
Daniel
On 20.08.18 21:04, Henning Westerholt wrote:
С уважением,
Ilie Soltanici
iliesh(a)mail.ru
Am Montag, 20. August 2018, 20:58:43 CEST schrieb
Soltanici Ilie:
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
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
22 Aug
22 Aug
1:46 p.m.
New subject: Fail to reload htable
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(a)gmail.com>om>:
Hello,
is the htable auth defined with dbtable attribute?
Cheers,
Daniel
On 20.08.18 21:04, Henning Westerholt wrote:
if there are
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
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 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 <http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com
<http://www.kamailioworld.com>
С уважением,
Ilie Soltanici
iliesh(a)mail.ru
2:52 p.m.
New subject: Fail to reload htable
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(a)gmail.com>om>:
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:
С уважением,
Ilie Soltanici
iliesh(a)mail.ru
Hi Daniel,
No, it is not.
modparam("htable", "htable",
"auth=>size=8;autoexpire=300;")
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com Вторник, 21 августа 2018, 8:07 +01:00 от
Daniel-Constantin Mierla <miconda(a)gmail.com> :
Hello,
is the htable auth defined with dbtable attribute?
Cheers,
Daniel
On 20.08.18 21:04, Henning Westerholt wrote:
С уважением,
Ilie Soltanici
iliesh(a)mail.ru 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
23 Aug
23 Aug
5:07 p.m.
New subject: Fail to reload htable
Hi Daniel,
May I ask you some questions about the htable reload problem ?
I reported a similar case that Henning and I have discussed
(https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html). I solved it by
adding a symlink as follows:
mkdir /var/lib/mysql
ln -s /myqdata/mysiprdb/data/mysiprdb.sock /var/lib/mysql/mysql.sock
Here, you pointed about the htable auth defined with dbtable attribute in the config
file.
I was looking at the documentation for the 5.0.7 level but I don’t find the reference of
this settings. Can you show me where it is documented?
And do you think it could also fix my case ?
Thanks in advance for the help.
Cordialement.
Patrick GINHOUX
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74 | patrick.ginhoux(a)unisys.com
De : sr-users <sr-users-bounces(a)lists.kamailio.org> De la part de Soltanici Ilie
Envoyé : mercredi 22 août 2018 13:52
À : miconda(a)gmail.com
Cc : Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Objet : Re: [SR-Users] Fail to reload htable
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: "Reload hash table
from database."
Thank You
Среда, 22 августа 2018, 11:47 +01:00 от Daniel-Constantin Mierla <miconda(a)gmail.com
<mailto:miconda@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
<file://e.mail.ru/compose/%3fmailto=mailto%253amiconda@gmail.com>
<miconda(a)gmail.com>om>:
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:
--
Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
С уважением,
Ilie Soltanici
iliesh(a)mail.ru <file://e.mail.ru/compose/%3fmailto=mailto%253ailiesh@mail.ru>
--
Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
С уважением,
Ilie Soltanici
iliesh(a)mail.ru <mailto:iliesh@mail.ru>
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
5:20 p.m.
New subject: Fail to reload htable
Hello,
in your email you have htable defined with dbtable attribute, like one
pasted next, which I grabbed from the link you provided:
modparam("htable", "htable",
"mbxrangeHash=>size=4;dbtable=mbxrange;")
So it is not the same case.
The dbtable attribute should be listed in the section documenting htable
parameter. Or, were you asking something else?
Cheers,
Daniel
On 23.08.18 16:07, Ginhoux, Patrick wrote:
Hi Daniel,
May I ask you some questions about the htable reload problem ?
I reported a similar case that Henning and I have discussed
(https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html).
I solved it by adding a symlink as follows:
mkdir /var/lib/mysql
ln -s /myqdata/mysiprdb/data/mysiprdb.sock /var/lib/mysql/mysql.sock
Here, you pointed about the htable auth defined with dbtable attribute
in the config file.
I was looking at the documentation for the 5.0.7 level but I don’t
find the reference of this settings. Can you show me where it is
documented?
And do you think it could also fix my case ?
Thanks in advance for the help.
*Cordialement.*
*Patrick GINHOUX***
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74| patrick.ginhoux(a)unisys.com
*De :*sr-users <sr-users-bounces(a)lists.kamailio.org> *De la part de*
Soltanici Ilie
*Envoyé :* mercredi 22 août 2018 13:52
*À :* miconda(a)gmail.com
*Cc :* Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
*Objet :* Re: [SR-Users] Fail to reload htable
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: "Reload
hash table from database."
Thank You
Среда, 22 августа 2018, 11:47 +01:00 от Daniel-Constantin Mierla
<miconda(a)gmail.com <mailto:miconda@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(a)gmail.com>
<file://e.mail.ru/compose/%3fmailto=mailto%253amiconda@gmail.com>:
Hello,
is the htable auth defined with dbtable attribute?
Cheers,
Daniel
On 20.08.18 21:04, Henning Westerholt wrote:
check if
there are
https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.com
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 any issues during startup in the log. Do you see
any
other error there?
A similar (not 100% identical) issue was discussed
recently here:
Maybe this helps you as well.
Best regards,
Henning
--
Daniel-Constantin Mierla -- www.asipto.com
<http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda>
-- www.linkedin.com/in/miconda
<http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com
<http://www.kamailioworld.com>
С уважением,
Ilie Soltanici
iliesh(a)mail.ru
<file://e.mail.ru/compose/%3fmailto=mailto%253ailiesh@mail.ru>
--
Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com
<http://www.kamailioworld.com>
С уважением,
Ilie Soltanici
iliesh(a)mail.ru <mailto:iliesh@mail.ru>
5:30 p.m.
New subject: Fail to reload htable
Hi,
Well, my mistake, I thought it was the ‘auth’ attribute that you mentioned .
Cordialement.
Patrick GINHOUX
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74 | patrick.ginhoux(a)unisys.com
De : Daniel-Constantin Mierla <miconda(a)gmail.com>
Envoyé : jeudi 23 août 2018 16:20
À : Ginhoux, Patrick <patrick.ginhoux(a)fr.unisys.com>
Cc : Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>rg>; Soltanici
Ilie <iliesh(a)mail.ru>ru>; Henning Westerholt <hw(a)kamailio.org>
Objet : Re: [SR-Users] Fail to reload htable
Hello,
in your email you have htable defined with dbtable attribute, like one pasted next, which
I grabbed from the link you provided:
modparam("htable", "htable",
"mbxrangeHash=>size=4;dbtable=mbxrange;")
So it is not the same case.
The dbtable attribute should be listed in the section documenting htable parameter. Or,
were you asking something else?
Cheers,
Daniel
On 23.08.18 16:07, Ginhoux, Patrick wrote:
Hi Daniel,
May I ask you some questions about the htable reload problem ?
I reported a similar case that Henning and I have discussed
(https://lists.kamailio.org/pipermail/sr-users/2018-August/102393.html). I solved it by
adding a symlink as follows:
mkdir /var/lib/mysql
ln -s /myqdata/mysiprdb/data/mysiprdb.sock /var/lib/mysql/mysql.sock
Here, you pointed about the htable auth defined with dbtable attribute in the config
file.
I was looking at the documentation for the 5.0.7 level but I don’t find the reference of
this settings. Can you show me where it is documented?
And do you think it could also fix my case ?
Thanks in advance for the help.
Cordialement.
Patrick GINHOUX
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74 | patrick.ginhoux(a)unisys.com
<mailto:patrick.ginhoux@unisys.com>
De : sr-users <mailto:sr-users-bounces@lists.kamailio.org>
<sr-users-bounces(a)lists.kamailio.org> De la part de Soltanici Ilie
Envoyé : mercredi 22 août 2018 13:52
À : miconda(a)gmail.com <mailto:miconda@gmail.com>
Cc : Kamailio (SER) - Users Mailing List <mailto:sr-users@lists.kamailio.org>
<sr-users(a)lists.kamailio.org>
Objet : Re: [SR-Users] Fail to reload htable
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: "Reload hash table
from database."
Thank You
Среда, 22 августа 2018, 11:47 +01:00 от Daniel-Constantin Mierla <miconda(a)gmail.com
<mailto:miconda@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
<file://e.mail.ru/compose/%3fmailto=mailto%253amiconda@gmail.com>
<miconda(a)gmail.com>om>:
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:
--
Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
С уважением,
Ilie Soltanici
iliesh(a)mail.ru <file://e.mail.ru/compose/%3fmailto=mailto%253ailiesh@mail.ru>
--
Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
С уважением,
Ilie Soltanici
iliesh(a)mail.ru <mailto:iliesh@mail.ru>
--
Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
www.twitter.com/miconda <http://www.twitter.com/miconda> --
www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>
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
2283
days inactive
2286
days old
7 comments
4 participants
participants (4)
-
Daniel-Constantin Mierla -
Ginhoux, Patrick -
Henning Westerholt -
Soltanici Ilie