[OpenSIPS-Users] postgresql

[David Villasmil]

I’d you issue those sql from the proxy, do you get data back?
On Thu, 27 Dec 2018 at 21:57, Slava Bendersky <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
> 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/01addc9f/attachment.html>