From duarterocha91@gmail.com Wed Jun 24 17:58:53 2020
From: Duarte Rocha <duarterocha91@gmail.com>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] Sql_result_free() not cleaning properly
Date: Wed, 24 Jun 2020 16:58:39 +0100
Message-ID:
 <CAAJJHZgmMimqCKN4p7uTtEM=GEj6oFpTkqVw-c+RC3bg99RpRA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1537491401=="

--===============1537491401==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

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,



--===============1537491401==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGRpdiBkaXI9ImF1dG8iPkdyZWV0aW5ncyzCoDxkaXYgZGlyPSJhdXRvIj48YnI+PC9kaXY+PGRp
diBkaXI9ImF1dG8iPkkmIzM5O20gdHJ5aW5nIHRvIGNsZWFuIGEgU1FMIHJlc3VsdCB1c2luZyAm
cXVvdDtzcWxfcmVzdWx0X2ZyZWUoKSZxdW90OyBidXQgaSYjMzk7bSBub3QgaGF2aW5nIHN1Y2Nl
c3MuwqA8L2Rpdj48ZGl2IGRpcj0iYXV0byI+PGJyPjwvZGl2PjxkaXYgZGlyPSJhdXRvIj5DYW4g
eW91IHBsZWFzZSB2ZXJpZnkgaWYgaSYjMzk7bSBkb2luZyBhbnl0aGluZyB3cm9uZyBoZXJlPzwv
ZGl2PjxkaXYgZGlyPSJhdXRvIj48YnI+PC9kaXY+PGRpdiBkaXI9ImF1dG8iPlRoaXMgaXMgbXkg
Y29kZSA6wqA8L2Rpdj48ZGl2IGRpcj0iYXV0byI+PGJyPjwvZGl2PjxkaXYgZGlyPSJhdXRvIj7C
oCDCoCDCoCDCoCDCoCDCoCB4ZXJyKCZxdW90O1ByZSBjbGVhbiBbMF0gID0gIEl0ZXJhdG9yIDAg
PSAkeGF2cChDbGlfUElDS0VSX0RlZmF1bHRfU2VhcmNoX1Jlc3VsdFswXT0mZ3Q7Q29kZSkmcXVv
dDspOzwvZGl2PjxkaXYgZGlyPSJhdXRvIj7CoCDCoCDCoCDCoCDCoCDCoCBzcWxfcmVzdWx0X2Zy
ZWUoJnF1b3Q7Q2xpX1BJQ0tFUl9EZWZhdWx0X1NlYXJjaF9SZXN1bHQmcXVvdDspO8KgIMKgwqA8
L2Rpdj48ZGl2IGRpcj0iYXV0byI+wqAgwqAgwqAgwqAgwqAgwqAgeGVycigmcXVvdDtQb3MgY2xl
YW4gWzBdICA9ICBJdGVyYXRvciAwID0gJHhhdnAoQ2xpX1BJQ0tFUl9EZWZhdWx0X1NlYXJjaF9S
ZXN1bHRbMF09Jmd0O0NvZGUpJnF1b3Q7KTs8L2Rpdj48ZGl2IGRpcj0iYXV0byI+wqAgwqAgwqAg
wqAgwqAgwqDCoDwvZGl2PjxkaXYgZGlyPSJhdXRvIj5UaGUgcmVzdWx0IGlzIHRoZSBmb2xsb3dp
bmcgOsKgPC9kaXY+PGRpdiBkaXI9ImF1dG8iPjxicj48L2Rpdj48ZGl2IGRpcj0iYXV0byI+wqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgRVJST1I6ICZsdDtzY3JpcHQmZ3Q7OlByZSBjbGVhbiBbMF0g
ID0gIEl0ZXJhdG9yIDAgPSAxMTExMTExMTExMTE8L2Rpdj48ZGl2IGRpcj0iYXV0byI+wqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgRVJST1I6ICZsdDtzY3JpcHQmZ3Q7OlBvcyBjbGVhbiBbMF0gID0g
IEl0ZXJhdG9yIDAgPSAxMTExMTExMTExMTE8L2Rpdj48ZGl2IGRpcj0iYXV0byI+wqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqDCoDwvZGl2PjxkaXYgZGlyPSJhdXRvIj5BbSBpIHVzaW5nIHNxbF9yZXN1
bHRfZnJlZSBjb3JyZWN0bHkgb3IgZG9pbmcgc29tZXRoaW5nIHdyb25nPzwvZGl2PjxkaXYgZGly
PSJhdXRvIj48YnI+PC9kaXY+PGRpdiBkaXI9ImF1dG8iPkJlc3QgUmVnYXJkcyw8L2Rpdj48L2Rp
dj4K

--===============1537491401==--


From hw@skalatan.de Mon Jun 29 22:28:02 2020
From: Henning Westerholt <hw@skalatan.de>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] Sql_result_free() not cleaning properly
Date: Mon, 29 Jun 2020 20:27:59 +0000
Message-ID: <AM0PR05MB65955B110AD20FECA46886FAC56E0@AM0PR05MB6595.eurprd05.prod.outlook.com>
In-Reply-To:
 <CAAJJHZgmMimqCKN4p7uTtEM=GEj6oFpTkqVw-c+RC3bg99RpRA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1960759275=="

--===============1960759275==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

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 =E2=80=93 https://skalatan.de/blog/
Kamailio services =E2=80=93 https://gilawa.com<https://gilawa.com/>

From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Duarte Ro=
cha
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] =3D Iterator 0 =3D $xavp(Cli_PICKER_Default_S=
earch_Result[0]=3D>Code)");
            sql_result_free("Cli_PICKER_Default_Search_Result");
            xerr("Pos clean [0] =3D Iterator 0 =3D $xavp(Cli_PICKER_Default_S=
earch_Result[0]=3D>Code)");

The result is the following :

                ERROR: <script>:Pre clean [0] =3D Iterator 0 =3D 111111111111
                ERROR: <script>:Pos clean [0] =3D Iterator 0 =3D 111111111111

Am i using sql_result_free correctly or doing something wrong?

Best Regards,



--===============1960759275==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg
Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv
ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl
PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6
IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m
YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy
IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws
IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBjbTsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ
Zm9udC1zaXplOjExLjBwdDsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQpz
cGFuLkUtTWFpbEZvcm1hdHZvcmxhZ2UxOA0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBs
eTsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjsNCgljb2xvcjp3aW5kb3d0ZXh0
O30NCi5Nc29DaHBEZWZhdWx0DQoJe21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQt
ZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlmOw0KCW1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVT
O30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjYxMi4wcHQgNzkyLjBwdDsNCgltYXJnaW46
NzAuODVwdCA3MC44NXB0IDIuMGNtIDcwLjg1cHQ7fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtwYWdl
OldvcmRTZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86
c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwhW2Vu
ZGlmXS0tPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVk
aXQiPg0KPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlvdXQ+
PC94bWw+PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJERSIgbGluaz0iIzA1NjND
MSIgdmxpbms9IiM5NTRGNzIiPg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rpb24xIj4NCjxwIGNsYXNz
PSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJtc28tZmFyZWFzdC1sYW5ndWFnZTpFTi1VUyI+SGVs
bG8sPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5
bGU9Im1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48
L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1HQiIgc3R5bGU9Im1zby1m
YXJlYXN0LWxhbmd1YWdlOkVOLVVTIj5JIGd1ZXNzIHlvdSBhcmUgdXNpbmcgc3FsX3hxdWVyeT8g
VGhlIHNxbF9mcmVlX3Jlc3VsdCB3aWxsIG9ubHkgZnJlZSBhIG5hdGl2ZSBzcWwgcmVzdWx0IGlu
IHNjcmlwdCwgbm90IHRoZSB4YXZwLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJN
c29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLUdCIiBzdHlsZT0ibXNvLWZhcmVhc3QtbGFuZ3VhZ2U6
RU4tVVMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi
PjxzcGFuIGxhbmc9IkVOLUdCIiBzdHlsZT0ibXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVMiPkNo
ZWVycyw8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBs
YW5nPSJFTi1HQiIgc3R5bGU9Im1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48bzpwPiZuYnNw
OzwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1H
QiIgc3R5bGU9Im1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj5IZW5uaW5nPG86cD48L286cD48
L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tR0IiIHN0eWxl
PSJtc28tZmFyZWFzdC1sYW5ndWFnZTpFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9w
Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tR0IiIHN0eWxlPSJtc28tZmFy
ZWFzdC1sYW5ndWFnZTpFTi1VUyI+LS0gPG86cD4NCjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1HQiIgc3R5bGU9Im1zby1mYXJlYXN0LWxhbmd1
YWdlOkVOLVVTIj5IZW5uaW5nIFdlc3RlcmhvbHQg4oCTDQo8L3NwYW4+PHNwYW4gc3R5bGU9Im1z
by1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48YSBocmVmPSJodHRwczovL3NrYWxhdGFuLmRlL2Js
b2cvIj48c3BhbiBsYW5nPSJFTi1HQiIgc3R5bGU9ImNvbG9yOiMwNTYzQzEiPmh0dHBzOi8vc2th
bGF0YW4uZGUvYmxvZy88L3NwYW4+PC9hPjwvc3Bhbj48c3BhbiBsYW5nPSJFTi1HQiIgc3R5bGU9
Im1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj
bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1HQiIgc3R5bGU9Im1zby1mYXJlYXN0LWxh
bmd1YWdlOkVOLVVTIj5LYW1haWxpbyBzZXJ2aWNlcyDigJMNCjwvc3Bhbj48c3BhbiBzdHlsZT0i
bXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVMiPjxhIGhyZWY9Imh0dHBzOi8vZ2lsYXdhLmNvbS8i
PjxzcGFuIGxhbmc9IkVOLUdCIiBzdHlsZT0iY29sb3I6IzA1NjNDMSI+aHR0cHM6Ly9naWxhd2Eu
Y29tPC9zcGFuPjwvYT48L3NwYW4+PHNwYW4gc3R5bGU9Im1zby1mYXJlYXN0LWxhbmd1YWdlOkVO
LVVTIj4NCjxzcGFuIGxhbmc9IkVOLUdCIj48bzpwPjwvbzpwPjwvc3Bhbj48L3NwYW4+PC9wPg0K
PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tR0IiIHN0eWxlPSJtc28tZmFyZWFz
dC1sYW5ndWFnZTpFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPGRpdiBzdHls
ZT0iYm9yZGVyOm5vbmU7Ym9yZGVyLXRvcDpzb2xpZCAjRTFFMUUxIDEuMHB0O3BhZGRpbmc6My4w
cHQgMGNtIDBjbSAwY20iPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdpbi1sZWZ0
OjM1LjRwdCI+PGI+RnJvbTo8L2I+IHNyLXVzZXJzICZsdDtzci11c2Vycy1ib3VuY2VzQGxpc3Rz
LmthbWFpbGlvLm9yZyZndDsNCjxiPk9uIEJlaGFsZiBPZiA8L2I+RHVhcnRlIFJvY2hhPGJyPg0K
PGI+U2VudDo8L2I+IFdlZG5lc2RheSwgSnVuZSAyNCwgMjAyMCA1OjU5IFBNPGJyPg0KPGI+VG86
PC9iPiBLYW1haWxpbyAoU0VSKSAtIFVzZXJzIE1haWxpbmcgTGlzdCAmbHQ7c3ItdXNlcnNAbGlz
dHMua2FtYWlsaW8ub3JnJmd0Ozxicj4NCjxiPlN1YmplY3Q6PC9iPiBbU1ItVXNlcnNdIFNxbF9y
ZXN1bHRfZnJlZSgpIG5vdCBjbGVhbmluZyBwcm9wZXJseTxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+
DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2luLWxlZnQ6MzUuNHB0Ij48bzpwPiZu
YnNwOzwvbzpwPjwvcD4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2lu
LWxlZnQ6MzUuNHB0Ij5HcmVldGluZ3MsJm5ic3A7PG86cD48L286cD48L3A+DQo8ZGl2Pg0KPHAg
Y2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdpbi1sZWZ0OjM1LjRwdCI+PG86cD4mbmJzcDs8
L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFy
Z2luLWxlZnQ6MzUuNHB0Ij5JJ20gdHJ5aW5nIHRvIGNsZWFuIGEgU1FMIHJlc3VsdCB1c2luZyAm
cXVvdDtzcWxfcmVzdWx0X2ZyZWUoKSZxdW90OyBidXQgaSdtIG5vdCBoYXZpbmcgc3VjY2Vzcy4m
bmJzcDs8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi
IHN0eWxlPSJtYXJnaW4tbGVmdDozNS40cHQiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPC9kaXY+
DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdpbi1sZWZ0OjM1LjRwdCI+
Q2FuIHlvdSBwbGVhc2UgdmVyaWZ5IGlmIGknbSBkb2luZyBhbnl0aGluZyB3cm9uZyBoZXJlPzxv
OnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9
Im1hcmdpbi1sZWZ0OjM1LjRwdCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+
DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2luLWxlZnQ6MzUuNHB0Ij5UaGlzIGlz
IG15IGNvZGUgOiZuYnNwOzxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9
Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdpbi1sZWZ0OjM1LjRwdCI+PG86cD4mbmJzcDs8L286cD48
L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2luLWxl
ZnQ6MzUuNHB0Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyB4ZXJy
KCZxdW90O1ByZSBjbGVhbiBbMF0gPSBJdGVyYXRvciAwID0gJHhhdnAoQ2xpX1BJQ0tFUl9EZWZh
dWx0X1NlYXJjaF9SZXN1bHRbMF09Jmd0O0NvZGUpJnF1b3Q7KTs8bzpwPjwvbzpwPjwvcD4NCjwv
ZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtYXJnaW4tbGVmdDozNS40
cHQiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IHNxbF9yZXN1bHRf
ZnJlZSgmcXVvdDtDbGlfUElDS0VSX0RlZmF1bHRfU2VhcmNoX1Jlc3VsdCZxdW90Oyk7Jm5ic3A7
ICZuYnNwOyZuYnNwOzxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1z
b05vcm1hbCIgc3R5bGU9Im1hcmdpbi1sZWZ0OjM1LjRwdCI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsg
Jm5ic3A7ICZuYnNwOyAmbmJzcDsgeGVycigmcXVvdDtQb3MgY2xlYW4gWzBdID0gSXRlcmF0b3Ig
MCA9ICR4YXZwKENsaV9QSUNLRVJfRGVmYXVsdF9TZWFyY2hfUmVzdWx0WzBdPSZndDtDb2RlKSZx
dW90Oyk7PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFs
IiBzdHlsZT0ibWFyZ2luLWxlZnQ6MzUuNHB0Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsg
Jm5ic3A7ICZuYnNwOyZuYnNwOzxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xh
c3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdpbi1sZWZ0OjM1LjRwdCI+VGhlIHJlc3VsdCBpcyB0
aGUgZm9sbG93aW5nIDombmJzcDs8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNs
YXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtYXJnaW4tbGVmdDozNS40cHQiPjxvOnA+Jm5ic3A7PC9v
OnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdp
bi1sZWZ0OjM1LjRwdCI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsg
Jm5ic3A7ICZuYnNwOyBFUlJPUjogJmx0O3NjcmlwdCZndDs6UHJlIGNsZWFuIFswXSA9IEl0ZXJh
dG9yIDAgPSAxMTExMTExMTExMTE8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNs
YXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtYXJnaW4tbGVmdDozNS40cHQiPiZuYnNwOyAmbmJzcDsg
Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgRVJST1I6ICZsdDtzY3Jp
cHQmZ3Q7OlBvcyBjbGVhbiBbMF0gPSBJdGVyYXRvciAwID0gMTExMTExMTExMTExPG86cD48L286
cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2lu
LWxlZnQ6MzUuNHB0Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAm
bmJzcDsgJm5ic3A7Jm5ic3A7PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2luLWxlZnQ6MzUuNHB0Ij5BbSBpIHVzaW5nIHNxbF9y
ZXN1bHRfZnJlZSBjb3JyZWN0bHkgb3IgZG9pbmcgc29tZXRoaW5nIHdyb25nPzxvOnA+PC9vOnA+
PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1hcmdpbi1s
ZWZ0OjM1LjRwdCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIiBzdHlsZT0ibWFyZ2luLWxlZnQ6MzUuNHB0Ij5CZXN0IFJlZ2FyZHMsPG86
cD48L286cD48L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo=

--===============1960759275==--


From abalashov@evaristesys.com Mon Jun 29 22:30:40 2020
From: Alex Balashov <abalashov@evaristesys.com>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] Sql_result_free() not cleaning properly
Date: Mon, 29 Jun 2020 16:30:36 -0400
Message-ID: <c32b1753-92e5-2101-f492-cf720b3a3753@evaristesys.com>
In-Reply-To: =?utf-8?q?=3CAM0PR05MB65955B110AD20FECA46886FAC56E0=40AM0PR05MB?=
 =?utf-8?q?6595=2Eeurprd05=2Eprod=2Eoutlook=2Ecom=3E?=
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0627203135=="

--===============0627203135==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

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/


--===============0627203135==--


From hw@skalatan.de Mon Jun 29 22:40:25 2020
From: Henning Westerholt <hw@skalatan.de>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] Sql_result_free() not cleaning properly
Date: Mon, 29 Jun 2020 20:40:20 +0000
Message-ID: <AM0PR05MB659564E8C58E73EAA77581DAC56E0@AM0PR05MB6595.eurprd05.prod.outlook.com>
In-Reply-To: <c32b1753-92e5-2101-f492-cf720b3a3753@evaristesys.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1043872721=="

--===============1043872721==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Yes, $xavp(s) are bound to the transaction, like the $avp.

About the memory fragmentation - the memory manager should re-use fitting mem=
ory blocks, but this depends on the overall traffic to the server. In general=
, if you use a recent kamailio version, we activated the memory defragmentati=
on 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

--=20
Henning Westerholt =E2=80=93 https://skalatan.de/blog/
Kamailio services =E2=80=93 https://gilawa.com=20

-----Original Message-----
From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Alex Bala=
shov
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=20
> native sql result in script, not the xavp.

But the XAVP goes out of scope once the transaction to which it pertains expi=
res, right? And accordingly should be freed?

(This also leads one to wonder: if the same XAVP name is referenced in a subs=
equent sql_xquery() call in the course of processing the same message, will i=
t free and re-allocate memory for a new PV, perhaps contributing to unnecessa=
ry fragmentation? Or will it simply reuse the SHM block for the previously al=
located 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

--===============1043872721==--


From miconda@gmail.com Wed Jul  1 09:43:45 2020
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] Sql_result_free() not cleaning properly
Date: Wed, 01 Jul 2020 09:43:39 +0200
Message-ID: <cbae2472-50a8-9889-6105-4ce67ba49e2e@gmail.com>
In-Reply-To: <c32b1753-92e5-2101-f492-cf720b3a3753@evaristesys.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2035422186=="

--===============2035422186==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Hello,

On 29.06.20 22:30, Alex Balashov wrote:
> 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?)

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



--===============2035422186==--