Also with that commit added, it is not working. The log line `no stored record
for INVITE` is triggered. So I was looking what's currently in the database and
which query it is doing. I've filtered out the IP addresses of course:
```sql
select * from topos_t;
+------+---------------------+-----------+-----------+--------+--------------------------------------+----------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------+-------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------+-------+--------------------------------------------------------------------------------+-------------------------------------------------------------------------+------------------------------------------------+------------------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------+-----------+----------+----------+
| id | rectime | x_context | s_method | s_cseq | a_callid
| a_uuid | b_uuid | direction
| x_via
| x_vbranch
| x_rr
| y_rr
| s_rr | x_uri | a_contact
|
b_contact |
as_contact | bs_contact
| x_tag | a_tag
| b_tag | a_srcaddr | b_srcaddr |
a_socket | b_socket |
+------+---------------------+-----------+-----------+--------+--------------------------------------+----------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------+-------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------+-------+--------------------------------------------------------------------------------+-------------------------------------------------------------------------+------------------------------------------------+------------------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------+-----------+----------+----------+
| 5231 | 2023-11-21 19:41:23 | | SUBSCRIBE | 17719 |
0d46940de2e2d6fc | atpsh-655cef84-73c-5 |
btpsh-655cef84-73c-5 | 0 | SIP/2.0/UDP
123.456.78.910:43233;received=123.456.78.910;branch=z9hG4bKaf32841f6b079d99;rport=43233
| z9hG4bKc39b.b929a632c72af688f3322f3a1dfab19a.0 |
|
| <sip:123.456.78.910:8060;lr> | |
sip:phone_533129_0-360870417@123.456.78.910:43233;alias=123.456.78.910~43233~1
| |
<sip:atpsh-655cef84-73c-5@123.456.78.910:8060> |
<sip:btpsh-655cef84-73c-5@123.456.78.910:8060> | 1352a62f28284315
| 1352a62f28284315 |
| | | | |
| 5234 | 2023-11-21 19:41:23 | | SUBSCRIBE | 17720 |
0d46940de2e2d6fc | atpsh-655cef84-738-7 |
btpsh-655cef84-738-7 | 0 | SIP/2.0/UDP
123.456.78.910:43233;received=123.456.78.910;branch=z9hG4bKb9f6e728e390e8e6;rport=43233
| z9hG4bK139b.c13bf8f8fdb01c081f3f5daedb12c454.0 |
|
| <sip:123.456.78.910:8060;lr> | |
sip:phone_533129_0-360870417@123.456.78.910:43233;alias=123.456.78.910~43233~1
| |
<sip:atpsh-655cef84-738-7@123.456.78.910:8060> |
<sip:btpsh-655cef84-738-7@123.456.78.910:8060> | 1352a62f28284315
| 1352a62f28284315 |
| | | | |
| 5237 | 2023-11-21 19:41:24 | | INVITE | 9439 |
63c77fbe-d2ab-4a9e-a6fd-aec68122603e | atpsh-655cef84-733-5 |
btpsh-655cef84-733-5 | 0 | SIP/2.0/UDP
123.456.78.910:38449;received=123.456.78.910;rport=38449;branch=z9hG4bKPjd7ab7540-9887-4b47-9aef-c14aba9ba3ac
| z9hG4bK49ca.e04110c580aa0c2dde9013b0214d69e3.0 |
|
|
<sip:123.456.78.910:8060;lr> | |
sip:phone_533129_0@123.456.78.910:38449;ob;alias=123.456.78.910~38449~1
| |
<sip:atpsh-655cef84-733-5@123.456.78.910:8060> |
<sip:btpsh-655cef84-733-5@123.456.78.910:8060> |
7da593a3-fb4e-4689-8c8e-b5c942a61939 | 7da593a3-fb4e-4689-8c8e-b5c942a61939 |
| | | |
|
| 5240 | 2023-11-21 19:41:24 | | INVITE | 9440 |
63c77fbe-d2ab-4a9e-a6fd-aec68122603e | atpsh-655cef84-73b-7 |
btpsh-655cef84-73b-7 | 0 | SIP/2.0/UDP
123.456.78.910:38449;received=123.456.78.910;rport=38449;branch=z9hG4bKPj567f3f03-b450-4165-958a-a065ccf7302f
| z9hG4bKce9a.8524a50fa147c71567722224647bb9dd.0 |
|
<sip:123.456.78.910:8065;lr;ftag=7da593a3-fb4e-4689-8c8e-b5c942a61939;did=dc3.87c1>
| <sip:123.456.78.910:8060;lr> | |
sip:phone_533129_0@123.456.78.910:38449;ob;alias=123.456.78.910~38449~1
| sip:123.456.78.910:8066 |
<sip:atpsh-655cef84-73b-7@123.456.78.910:8060> |
<sip:btpsh-655cef84-73b-7@123.456.78.910:8060> |
7da593a3-fb4e-4689-8c8e-b5c942a61939 | 7da593a3-fb4e-4689-8c8e-b5c942a61939 |
7cbea23b-a500-4301-be2d-b1e768cb79a8 | | | |
|
| 5243 | 2023-11-21 19:41:25 | | INVITE | 17887 |
580087e3-b220-4377-b6af-ee02578be7ee | atpsh-655cef84-732-7 |
btpsh-655cef84-732-7 | 0 | SIP/2.0/UDP
987.654.3.210:8065;branch=z9hG4bKd459.dba4940fca90c84e875f37cb94d2eb46.0,SIP/2.0/UDP
123.456.78.910:8066;received=123.456.78.910;rport=8066;branch=z9hG4bKPj97d1606d-0f56-4e7f-a469-195304ecfe2b
| z9hG4bKd459.507dc49c8d948c0da2c4d8a7f04f9bd4.0 |
<sip:987.654.3.210:8065;lr;ftag=d78d0bd2-28f9-42aa-ad43-6993814e92e5;did=4aa.47b2>
|
| <sip:123.456.78.910:8060;lr> | | sip:201@123.456.78.910:8066
|
sip:phone_533132_0@123.456.78.910:38449;ob;alias=123.456.78.910~38449~1 |
<sip:atpsh-655cef84-732-7@123.456.78.910:8060> |
<sip:btpsh-655cef84-732-7@123.456.78.910:8060> |
d78d0bd2-28f9-42aa-ad43-6993814e92e5 | d78d0bd2-28f9-42aa-ad43-6993814e92e5 |
4adc36cc-4335-4ce9-93bd-8b6eb226e046 | | | |
|
| 5246 | 2023-11-21 19:41:25 | | INVITE | 16441 |
055fa0d5-a5a8-401f-ae56-86663cbbaaa9 | atpsh-655cef84-738-8 |
btpsh-655cef84-738-8 | 0 | SIP/2.0/UDP
123.456.78.910:8065;branch=z9hG4bK0da1.3ee7af44b4af377d2ff5d1ad75eb4825.0,SIP/2.0/UDP
123.456.78.910:8066;received=123.456.78.910;rport=8066;branch=z9hG4bKPjc88d1489-8c01-49a3-a82c-6d91a4df383c
| z9hG4bK0da1.4aab292eba10ffc58ddf5c5e3723906b.0 |
<sip:123.456.78.910:8065;lr;ftag=39fddff3-2fd6-477e-8c03-e9bcc932e91b;did=4dc.e301>
|
| <sip:123.456.78.910:8060;lr> | | sip:201@123.456.78.910:8066
|
sip:phone_533135_0@123.456.78.910:38449;ob;alias=123.456.78.910~38449~1 |
<sip:atpsh-655cef84-738-8@123.456.78.910:8060> |
<sip:btpsh-655cef84-738-8@123.456.78.910:8060> |
39fddff3-2fd6-477e-8c03-e9bcc932e91b | 39fddff3-2fd6-477e-8c03-e9bcc932e91b |
1e2a697d-6ee1-44f5-95f8-b13d81511873 | | | |
|
+------+---------------------+-----------+-----------+--------+--------------------------------------+----------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------+-------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------+-------+--------------------------------------------------------------------------------+-------------------------------------------------------------------------+------------------------------------------------+------------------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------+-----------+----------+----------+
```
```sql
select * from topos_d;
+------+---------------------+-----------+-----------+--------+--------------------------------------+-------------------------+-------------------------+---------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------------------------+---------------------------------------------------+--------------------------------------+-------------------------------------------+-------------------------------------------------------------------------------------+------+-------------------------------------------------------------------------------------+--------+-------+-------+-------+-----------+-----------+----------+----------+
| id | rectime | x_context | s_method | s_cseq | a_callid
| a_uuid | b_uuid |
a_contact
| b_contact | as_contact
| bs_contact
| a_tag | b_tag
| a_rr
| b_rr | s_rr
| iflags | a_uri | b_uri | r_uri | a_srcaddr |
b_srcaddr | a_socket | b_socket |
+------+---------------------+-----------+-----------+--------+--------------------------------------+-------------------------+-------------------------+---------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------------------------+---------------------------------------------------+--------------------------------------+-------------------------------------------+-------------------------------------------------------------------------------------+------+-------------------------------------------------------------------------------------+--------+-------+-------+-------+-----------+-----------+----------+----------+
| 1571 | 2023-11-21 19:41:23 | | SUBSCRIBE | 17719 |
0d46940de2e2d6fc | atpsh-655cef84-73c-5 |
btpsh-655cef84-73c-5 |
sip:phone_533129_0-360870417@123.456.78.910:43233;alias=123.456.78.910~43233~1
| |
<sip:atpsh-655cef84-73c-5@123.456.78.910:8060> |
<sip:btpsh-655cef84-73c-5@123.456.78.910:8060> | 1352a62f28284315
| |
| |
<sip:123.456.78.910:8060;lr>
| 0 | | | | | | |
|
| 1574 | 2023-11-21 19:41:55 | | SUBSCRIBE | 17720 |
0d46940de2e2d6fc | atpsh-655cef84-738-7 |
btpsh-655cef84-738-7 |
sip:phone_533129_0-360870417@123.456.78.910:43233;alias=123.456.78.910~43233~1
| sip:123.456.78.910:8067 |
<sip:atpsh-655cef84-738-7@123.456.78.910:8060> |
<sip:btpsh-655cef84-738-7@123.456.78.910:8060> | 1352a62f28284315
| 01ed138498061afc1be350944aa9ed96-25adc4a2 |
| |
<sip:123.456.78.910:8060;lr>
| 0 | | | | | | |
|
| 1577 | 2023-11-21 19:41:24 | | INVITE | 9439 |
63c77fbe-d2ab-4a9e-a6fd-aec68122603e | atpsh-655cef84-733-5 |
btpsh-655cef84-733-5 |
sip:phone_533129_0@123.456.78.910:38449;ob;alias=123.456.78.910~38449~1
| |
<sip:atpsh-655cef84-733-5@123.456.78.910:8060> |
<sip:btpsh-655cef84-733-5@123.456.78.910:8060> |
7da593a3-fb4e-4689-8c8e-b5c942a61939 |
|
| | <sip:123.456.78.910:8060;lr>
| 0 | | | | | |
| |
| 1580 | 2023-11-21 19:41:24 | | INVITE | 9440 |
63c77fbe-d2ab-4a9e-a6fd-aec68122603e | atpsh-655cef84-73b-7 |
btpsh-655cef84-73b-7 |
sip:phone_533129_0@123.456.78.910:38449;ob;alias=123.456.78.910~38449~1
| |
<sip:atpsh-655cef84-73b-7@123.456.78.910:8060> |
<sip:btpsh-655cef84-73b-7@123.456.78.910:8060> |
7da593a3-fb4e-4689-8c8e-b5c942a61939 |
|
| | <sip:123.456.78.910:8060;lr>
| 0 | | | | | |
| |
| 1583 | 2023-11-21 19:41:25 | | INVITE | 17887 |
580087e3-b220-4377-b6af-ee02578be7ee | atpsh-655cef84-732-7 |
btpsh-655cef84-732-7 | sip:201@123.456.78.910:8066
| |
<sip:atpsh-655cef84-732-7@123.456.78.910:8060> |
<sip:btpsh-655cef84-732-7@123.456.78.910:8060> |
d78d0bd2-28f9-42aa-ad43-6993814e92e5 |
|
<sip:987.654.3.210:8065;lr;ftag=d78d0bd2-28f9-42aa-ad43-6993814e92e5;did=4aa.47b2>
| | <sip:123.456.78.910:8060;lr>
| 0 | | | | | |
| |
| 1586 | 2023-11-21 19:41:25 | | INVITE | 16441 |
055fa0d5-a5a8-401f-ae56-86663cbbaaa9 | atpsh-655cef84-738-8 |
btpsh-655cef84-738-8 | sip:201@123.456.78.910:8066
| |
<sip:atpsh-655cef84-738-8@123.456.78.910:8060> |
<sip:btpsh-655cef84-738-8@123.456.78.910:8060> |
39fddff3-2fd6-477e-8c03-e9bcc932e91b |
|
<sip:123.456.78.910:8065;lr;ftag=39fddff3-2fd6-477e-8c03-e9bcc932e91b;did=4dc.e301>
| | <sip:123.456.78.910:8060;lr>
| 0 | | | | | |
| |
+------+---------------------+-----------+-----------+--------+--------------------------------------+-------------------------+-------------------------+---------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------------------------+---------------------------------------------------+--------------------------------------+-------------------------------------------+-------------------------------------------------------------------------------------+------+-------------------------------------------------------------------------------------+--------+-------+-------+-------+-----------+-----------+----------+----------+
```
The query that goes wrong is:
```sql
select
`rectime`,`a_callid`,`a_uuid`,`b_uuid`,`direction`,`x_via`,`x_vbranch`,`x_rr`,`y_rr`,`s_rr`,`x_uri`,`x_tag`,`s_method`,`s_cseq`,`a_contact`,`b_contact`,`as_contact`,`bs_contact`,`a_tag`,`b_tag`
from `topos_t` where `a_callid`='0d46940de2e2d6fc' AND
`b_tag`='01ed138498061afc1be350944aa9ed96-25adc4a2' AND
`b_uuid`='btpsh-655cef84-738-7';
```
For as far as I could figure out, it is looking for a subscribe in the
transaction table, with a certain `b_tag`, but the `SUBSCRIBE` rows in the
transaction table do not have a value in their `b_tag` columns. But the dialog
table has a subscribe with that exact `b_tag`.
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/pull/3627#issuecomment-1821514596
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/pull/3627/c1821514...@github.com>_______________________________________________
Kamailio (SER) - Development Mailing List
To unsubscribe send an email to sr-dev-le...@lists.kamailio.org
