[ opensips-Bugs-2890915 ] db_virtual no DB connection available if pool member lost

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[ opensips-Bugs-2890915 ] db_virtual no DB connection available if pool member lost

SourceForge.net
Bugs item #2890915, was opened at 2009-11-02 15:09
Message generated for change (Comment added) made by lucifuge
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2890915&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: 1.6.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Daryl G. Jurbala (lucifuge)
Assigned to: Razvan (rpistolea)
Summary: db_virtual no DB connection available if pool member lost

Initial Comment:
This is easily duplicated on 1.6.0 with postgres.  I have a pool of 5 pgsql servers that I point at for avpops, auth_db, and uri.  If any one of them becomes unavailable, I can no longer do anything with the db_virtual pool (registrations can not complete, etc.) and must remove the problem db server and restart OpenSIPS.

----------------------------------------------------------------------

>Comment By: Daryl G. Jurbala (lucifuge)
Date: 2010-02-26 12:28

Message:
Sorry all, I didn't get the notifications on this asking for more
information.

What I have seen happening with my round-robin pool of read-only PG
servers (5 of them) is that if one goes down, opensips stops with this in
the log:

b 20 15:39:04 sfsbc03 /sbin/opensips[26515]:
ERROR:db_postgres:db_postgres_store_result: 0x7af468
- invalid query, execution aborted
Feb 20 15:39:04 sfsbc03 /sbin/opensips[26515]:
ERROR:db_postgres:db_postgres_store_result: 0x7af468:
PGRES_FATAL_ERROR
Feb 20 15:39:04 sfsbc03 /sbin/opensips[26515]:
ERROR:db_postgres:db_postgres_store_result: 0x7af468:
server closed the connection unexpectedly  This probably means the server
terminated abnormally    
before or while processing the request.  
Feb 20 15:39:04 sfsbc03 /sbin/opensips[26515]: ERROR:core:db_do_query:
error while storing result
Feb 20 15:39:04 sfsbc03 kernel: opensips[26515]: segfault at
0000000000000020 rip 00002ae790c824b4 r
sp 00007fffc410a030 error 4
Feb 20 15:39:04 sfsbc03 /sbin/opensips[26508]:
ERROR:db_postgres:db_postgres_store_result: 0x7af468
- invalid query, execution aborted
Feb 20 15:39:04 sfsbc03 /sbin/opensips[26508]:
ERROR:db_postgres:db_postgres_store_result: 0x7af468:
PGRES_FATAL_ERROR
Feb 20 15:39:04 sfsbc03 /sbin/opensips[26508]:
ERROR:db_postgres:db_postgres_store_result: 0x7af468:
server closed the connection unexpectedly  This probably means the server
terminated abnormally    
before or while processing the request.  
Feb 20 15:39:04 sfsbc03 /sbin/opensips[26508]: ERROR:core:db_do_query:
error while storing result
Feb 20 15:39:04 sfsbc03 kernel: opensips[26508]: segfault at
0000000000000020 rip 00002ae790c824b4 r
sp 00007fffc410a030 error 4
Feb 20 15:39:05 sfsbc03 /sbin/opensips[26450]: NOTICE:db_virtual:destroy:
destroy module bla bla...


I then have to re start opensips manually.

----------------------------------------------------------------------

Comment By: Razvan (rpistolea)
Date: 2009-11-05 15:15

Message:
what mode are you using?
what do you mean by "pool"? fails before a query or an insert?
does the exported MI db_set/db_get work (to ignore the failed one by
hand?)?

----------------------------------------------------------------------

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-11-04 04:02

Message:
Hi Daryl,

what mode do you use for the virtual connection - parallel, failover,
round-robin ?

Also, do you have some logs/debug during the error?

Regards,
Bogdan

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2890915&group_id=232389

_______________________________________________
Devel mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel