Hi! When populating cdrs table from timer route I get some errors:
ERROR: db_mysql [km_dbase.c:120]: driver error on query: Duplicate entry
'088827BCD0738B6F@111.11.111.11-00E0F510042319395872000014D3-6ADB' for key 2
ERROR: <core> [db_query.c:130]: error while submitting query
ERROR: sqlops [sql_api.c:217]: cannot do the query
Checking the acc table for those key I found the entries in the attachment.
Maybe it be that the stored procedure can not handle PRACK or reINVITEs
correctly?
Thanks
Klaus
mysql> select * from acc where callid LIKE '088827BCD0738B6F@%';
+----+--------+------------------------------+------------------------------+--------------------------------+----------+------------+---------------------+---------------+-----------------+---------------+--------------+------------+--------+-------------+
| id | method | from_tag | to_tag |
callid | sip_code | sip_reason | time |
src_ip | dst_user | dst_domain | src_user | src_domain |
cdr_id | caller_UUID |
+----+--------+------------------------------+------------------------------+--------------------------------+----------+------------+---------------------+---------------+-----------------+---------------+--------------+------------+--------+-------------+
| 25 | PRACK | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 |
088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:29:44 |
111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net |
5 | |
| 27 | PRACK | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 |
088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:29:45 |
111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net |
5 | |
| 29 | INVITE | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 |
088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:29:47 |
111.11.111.11 | 0049xxxxxxxxxxx | 22.222.222.22 | 23yyyyy | 3u.net |
5 | 23yyyyy |
| 31 | ACK | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:29:47 |
111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net |
5 | 23yyyyy |
| 33 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:30:48 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 35 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:30:48 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 37 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:31:15 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 39 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:31:15 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 41 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:32:25 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 43 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:32:25 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 45 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:33:28 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 47 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 |
088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:33:28 |
22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net |
7 | |
| 49 | INFO | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 |
088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:42:11 |
111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net |
5 | |
| 51 | BYE | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 |
088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:42:36 |
111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net |
5 | |
+----+--------+------------------------------+------------------------------+--------------------------------+----------+------------+---------------------+---------------+-----------------+---------------+--------------+------------+--------+-------------+
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
