I see too many messages in log from postgresql: Apr 10 03:11:02 opensips /usr/sbin/opensips[27715]: ERROR:db_postgres:db_postgres_submit_query: 0x85fd80 PQsendQuery Error: ERROR: duplicate key value violates unique constraint "location_account_contact_idx" DETAIL: Key (username, domain, contact)=(fourten, diacom.mangosip.ru, sip:[email protected]:5060) already exists. Query: insert into location (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,domain ) values ('client','sip:[email protected]:5060','2012-04-10 03:11:12',0.00 ,'E6BB-5B47-4717491289ED94D347BE-671@SipHost',333,0,0,'dlink 12-37-61928258-0.9.5.1.735',NULL,NULL,'udp:4.4.4.4:5060',NULL,'2012-04-10 03:11:02','opensips.org') Apr 10 03:11:02 opensips /usr/sbin/opensips[27715]: ERROR:db_postgres:db_postgres_store_result: 0x85fd80 - invalid query, execution aborted Apr 10 03:11:02 opensips /usr/sbin/opensips[27715]: ERROR:db_postgres:db_postgres_store_result: 0x85fd80: PGRES_FATAL_ERROR Apr 10 03:11:02 opensips /usr/sbin/opensips[27715]: ERROR:db_postgres:db_postgres_store_result: 0x85fd80: Apr 10 03:11:02 opensips /usr/sbin/opensips[27715]: WARNING:db_postgres:db_postgres_insert: unexpected result returned
It's when client send registration too quickly. What can I do to resolve this problem? And also there are bug, that opensips "thinks" that record there and sends updates, but there are no record. It would be helpful if it checks number of updated records and if it's equal 0, insert record. I don't know yet how to reproduce. But this problem may be enough often. -- Nick _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
