Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you are subscribed to this thread.
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:
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 | | | | |
+------+---------------------+-----------+-----------+--------+--------------------------------------+----------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------+-------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------+-------+--------------------------------------------------------------------------------+-------------------------------------------------------------------------+------------------------------------------------+------------------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------+-----------+----------+----------+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:
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, view it on GitHub, or unsubscribe.
You are receiving this because you are subscribed to this thread.