24 Jun
2020
24 Jun
'20
6:58 p.m.
Greetings,
I'm trying to clean a SQL result using "sql_result_free()" but i'm not
having success.
Can you please verify if i'm doing anything wrong here?
This is my code :
xerr("Pre clean [0] = Iterator 0 =
$xavp(Cli_PICKER_Default_Search_Result[0]=>Code)");
sql_result_free("Cli_PICKER_Default_Search_Result");
xerr("Pos clean [0] = Iterator 0 =
$xavp(Cli_PICKER_Default_Search_Result[0]=>Code)");
The result is the following :
ERROR: <script>:Pre clean [0] = Iterator 0 = 111111111111
ERROR: <script>:Pos clean [0] = Iterator 0 = 111111111111
Am i using sql_result_free correctly or doing something wrong?
Best Regards,
29 Jun
29 Jun
11:27 p.m.
Hello,
I guess you are using sql_xquery? The sql_free_result will only free a native sql result
in script, not the xavp.
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com<https://gilawa.com/>
From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Duarte Rocha
Sent: Wednesday, June 24, 2020 5:59 PM
To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Subject: [SR-Users] Sql_result_free() not cleaning properly
Greetings,
I'm trying to clean a SQL result using "sql_result_free()" but i'm not
having success.
Can you please verify if i'm doing anything wrong here?
This is my code :
xerr("Pre clean [0] = Iterator 0 =
$xavp(Cli_PICKER_Default_Search_Result[0]=>Code)");
sql_result_free("Cli_PICKER_Default_Search_Result");
xerr("Pos clean [0] = Iterator 0 =
$xavp(Cli_PICKER_Default_Search_Result[0]=>Code)");
The result is the following :
ERROR: <script>:Pre clean [0] = Iterator 0 = 111111111111
ERROR: <script>:Pos clean [0] = Iterator 0 = 111111111111
Am i using sql_result_free correctly or doing something wrong?
Best Regards,
11:30 p.m.
On 6/29/20 4:27 PM, Henning Westerholt wrote:
I guess you are using sql_xquery? The sql_free_result
will only free a
native sql result in script, not the xavp.
But the XAVP goes out of scope once the transaction to which it pertains
expires, right? And accordingly should be freed?
(This also leads one to wonder: if the same XAVP name is referenced in a
subsequent sql_xquery() call in the course of processing the same
message, will it free and re-allocate memory for a new PV, perhaps
contributing to unnecessary fragmentation? Or will it simply reuse the
SHM block for the previously allocated PV?)
-- Alex
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
11:40 p.m.
Yes, $xavp(s) are bound to the transaction, like the $avp.
About the memory fragmentation - the memory manager should re-use fitting memory blocks,
but this depends on the overall traffic to the server. In general, if you use a recent
kamailio version, we activated the memory defragmentation some time ago. This should
reduce the number of fragements. You can check with the shm stats. On old servers you can
activate with a core parameter.
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com
-----Original Message-----
From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Alex Balashov
Sent: Monday, June 29, 2020 10:31 PM
To: sr-users(a)lists.kamailio.org
Subject: Re: [SR-Users] Sql_result_free() not cleaning properly
On 6/29/20 4:27 PM, Henning Westerholt wrote:
I guess you are using sql_xquery? The sql_free_result
will only free a
native sql result in script, not the xavp.
But the XAVP goes out of scope once the transaction to which it pertains expires, right?
And accordingly should be freed?
(This also leads one to wonder: if the same XAVP name is referenced in a subsequent
sql_xquery() call in the course of processing the same message, will it free and
re-allocate memory for a new PV, perhaps contributing to unnecessary fragmentation? Or
will it simply reuse the SHM block for the previously allocated PV?)
-- Alex
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
1 Jul
1 Jul
10:43 a.m.
Hello,
On 29.06.20 22:30, Alex Balashov wrote:
On 6/29/20 4:27 PM, Henning Westerholt wrote:
The xavps are destroyed automatically only at the end of transaction (or
end of processing the message, when the transaction is not created), so
if you do the sql_xquery() many times for the same message, then it adds
to the list of xavps (i.e., after the second xquery, you have xavps with
values from the 2nd and 1st xquery). If you want to clean it up in the
config, just assign $null to xavps.
Cheers,
Daniel
--
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Funding: https://www.paypal.me/dcmierla
I guess you are using sql_xquery? The
sql_free_result will only free
a native sql result in script, not the xavp.
But the XAVP goes out of scope once the transaction to which it
pertains expires, right? And accordingly should be freed?
(This also leads one to wonder: if the same XAVP name is referenced in
a subsequent sql_xquery() call in the course of processing the same
message, will it free and re-allocate memory for a new PV, perhaps
contributing to unnecessary fragmentation? Or will it simply reuse the
SHM block for the previously allocated PV?)
1608
days inactive
1615
days old
4 comments
4 participants
participants (4)
-
Alex Balashov -
Daniel-Constantin Mierla -
Duarte Rocha -
Henning Westerholt