[OpenSIPS-Users] postgresql

[Slava Bendersky]

Hello David, 
Yes, query runs ok for both failing queries. 

[root at aitossbc01 ~]# psql -U devmaster -W -h 10.100.101.11 -p 5235 -d opensips_prod02 -c "select domain,attrs from domain where domain='dev.ait.local'" 
Password for user devmaster: 
domain | attrs 
---------------+------- 
dev.ait.local | 0 
(1 row) 

volga629 


From: "David Villasmil" <david.villasmil.work at gmail.com> 
To: "OpenSIPS users mailling list" <users at lists.opensips.org> 
Sent: Thursday, December 27, 2018 5:54:15 PM 
Subject: Re: [OpenSIPS-Users] postgresql 

I’d you issue those sql from the proxy, do you get data back? 
On Thu, 27 Dec 2018 at 21:57, Slava Bendersky < [ mailto:volga629 at networklab.ca | volga629 at networklab.ca ] > wrote: 



Hello Everyone, 
Presence and postgresql having some problem to query database on latest master pull 
Any help thank you. 

Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:db_postgres:db_postgres_submit_query: 0x7f772a429088 PQsendQuery Error: could not receive data from server: Connection timed out#012 Query: delete from pua where expires<1545943081 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:db_postgres:db_postgres_submit_query: 0x7f772a428f98 PQsendQuery Error: could not receive data from server: Connection timed out#012 Query: delete from active_watchers where expires<1545943091 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:core:db_do_delete: error while submitting query 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:core:db_do_delete: error while submitting query 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98 - invalid query, execution aborted 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98: PGRES_FATAL_ERROR 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98: 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: WARNING:db_postgres:db_postgres_delete: unexpected result returned 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:presence:update_db_subs: deleting expired information from database 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088 - invalid query, execution aborted 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088: PGRES_FATAL_ERROR 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088: 
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: WARNING:db_postgres:db_postgres_delete: unexpected result returned 


and domain module 

Dec 27 14:38:34 aitossbc01 /usr/sbin/opensips[8867]: ERROR:core:db_do_query: error while submitting query - [select domain,attrs from domain where domain='dev.ait.local'] 
Dec 27 14:38:34 aitossbc01 /usr/sbin/opensips[8867]: ERROR:domain:is_domain_local_pvar: Error while querying database 


volga629 
_______________________________________________ 
Users mailing list 
[ mailto:Users at lists.opensips.org | Users at lists.opensips.org ] 
[ http://lists.opensips.org/cgi-bin/mailman/listinfo/users | http://lists.opensips.org/cgi-bin/mailman/listinfo/users ] 




_______________________________________________ 
Users mailing list 
Users at lists.opensips.org 
http://lists.opensips.org/cgi-bin/mailman/listinfo/users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20181227/f152f32f/attachment-0001.html>