Hi Jennifer,
Thanks for the awesome report! Would you mind testing out this patch [1]
to see if it makes Postgres happy?
[1]: http://chunk.io/liviuc/d64d605a335144709667f4647f4a7369
Best regards,
Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com
On 21.08.2017 23:25, Jennifer Hashimoto wrote:
HI everyone,
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.
I use postgres as the backend.
I am experiencing a problem where many sip messages are not getting
inserted into the database due to key violations.
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)
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)
I am using opensips.cfg from
https://github.com/sipcapture/homer-api/blob/da13a87b8eda55d4c597ce32270521249ab21dc4/examples/sipcapture/sipcapture.opensips
(I put … for the non valid information)
from my opensips log file:
2017-08-21 14:26:15) already exists.#012 Query: insert into
sip_capture_rest_20170821 (id,date, ... ) values (0,’2017-08...
my database is defined as:
CREATE TABLE public.sip_capture_call_20170821 (
id int8 NOT NULL DEFAULT
nextval('sip_capture_call_20170821_id_seq'::regclass),
"date" timestamp NOT NULL DEFAULT now(),
micro_ts int8 NOT NULL DEFAULT 0::bigint,
...
CONSTRAINT sip_capture_call_20170821_pkey PRIMARY KEY (id,"date")
)
WITH (
OIDS=FALSE
) ;
CREATE INDEX sip_capture_call_20170821_auth_user ON
public.sip_capture_call_20170821 (auth_user) ;
CREATE INDEX sip_capture_call_20170821_callid ON
public.sip_capture_call_20170821 (callid) ;
CREATE INDEX sip_capture_call_20170821_callid_aleg ON
public.sip_capture_call_20170821 (callid_aleg) ;
CREATE INDEX sip_capture_call_20170821_date ON
public.sip_capture_call_20170821 (date) ;
CREATE INDEX sip_capture_call_20170821_from_user ON
public.sip_capture_call_20170821 (from_user) ;
CREATE INDEX sip_capture_call_20170821_pid_user ON
public.sip_capture_call_20170821 (pid_user) ;
CREATE INDEX sip_capture_call_20170821_ruri_user ON
public.sip_capture_call_20170821 (ruri_user) ;
CREATE INDEX sip_capture_call_20170821_to_user ON
public.sip_capture_call_20170821 (to_user) ;
CREATE SEQUENCE public.sip_capture_call_20170821_id_seq
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1;
Thanks,
Jennifer
---------------------------------------------------
Jennifer Akemi Hashimoto
Caztel Communications
[email protected] <mailto:[email protected]>
905-836-5445
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
