<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">HI everyone,<div class=""><br class=""><div class="">I decided to setup homer sip capture with opensips as the program that inserts into my homer database because I use opensips everywhere else so it makes sense.</div><div class=""><br class=""></div><div class="">I use postgres as the backend.</div><div class=""><br class=""></div><div class="">I am experiencing a problem where many sip messages are not getting inserted into the database due to key violations.</div><div class=""><br class=""></div><div class="">I do get some rows in my tables, all with id 0 since the primary key is id + date (but as we know sip message happen very fast and can be exactly the same including timestamp)</div><div class=""><br class=""></div><div class="">I made a test of the database auto increment by manually inserting a row without specifying the id field (ie. insert into sip_capture_rest_20170821 (date, ... ) values (’2017-08… and it correctly put the id as 1 (auto incremented it as all the others were 0)</div><div class=""><br class=""></div><div class="">I am using opensips.cfg from <a href="https://github.com/sipcapture/homer-api/blob/da13a87b8eda55d4c597ce32270521249ab21dc4/examples/sipcapture/sipcapture.opensips" class="">https://github.com/sipcapture/homer-api/blob/da13a87b8eda55d4c597ce32270521249ab21dc4/examples/sipcapture/sipcapture.opensips</a></div><div class=""><br class=""></div><div class="">(I put … for the non valid information)</div><div class=""><br class=""></div><div class="">from my opensips log file:</div><div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span> 2017-08-21 14:26:15) already exists.#012 Query: insert into sip_capture_rest_20170821 (id,date, ... ) values (0,’2017-08...</div><div class=""><div class=""><br class=""></div><div class="">my database is defined as:</div><div class=""><br class=""></div><div class=""><div class="">CREATE TABLE public.sip_capture_call_20170821 (</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>id int8 NOT NULL DEFAULT nextval('sip_capture_call_20170821_id_seq'::regclass),</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>"date" timestamp NOT NULL DEFAULT now(),</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>micro_ts int8 NOT NULL DEFAULT 0::bigint,</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>...</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>CONSTRAINT sip_capture_call_20170821_pkey PRIMARY KEY (id,"date")</div><div class="">)</div><div class="">WITH (</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>OIDS=FALSE</div><div class="">) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_auth_user ON public.sip_capture_call_20170821 (auth_user) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_callid ON public.sip_capture_call_20170821 (callid) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_callid_aleg ON public.sip_capture_call_20170821 (callid_aleg) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_date ON public.sip_capture_call_20170821 (date) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_from_user ON public.sip_capture_call_20170821 (from_user) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_pid_user ON public.sip_capture_call_20170821 (pid_user) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_ruri_user ON public.sip_capture_call_20170821 (ruri_user) ;</div><div class="">CREATE INDEX sip_capture_call_20170821_to_user ON public.sip_capture_call_20170821 (to_user) ;</div></div><div class=""><br class=""></div><div class=""><div class=""><br class=""></div><div class="">CREATE SEQUENCE public.sip_capture_call_20170821_id_seq</div><div class="">INCREMENT BY 1</div><div class="">MINVALUE 1</div><div class="">MAXVALUE 9223372036854775807</div><div class="">START 1;</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Thanks,</div><div class="">Jennifer</div><div class="">
<div class=""><span style="orphans: 2; widows: 2;" class="">---------------------------------------------------</span><br style="orphans: 2; widows: 2;" class=""><span style="orphans: 2; widows: 2;" class="">Jennifer Akemi Hashimoto</span><br style="orphans: 2; widows: 2;" class=""><span style="orphans: 2; widows: 2;" class="">Caztel Communications</span><br style="orphans: 2; widows: 2;" class=""><a href="mailto:jennifer.hashimoto@caztel.com" style="orphans: 2; widows: 2;" class="">jennifer.hashimoto@caztel.com</a><br style="orphans: 2; widows: 2;" class=""><span style="orphans: 2; widows: 2;" class="">905-836-5445 </span></div>
</div>
<br class=""></div></div></body></html>