IRC logs of #tryton for Friday, 2012-09-28

chat.freenode.net #tryton log beginning Fri Sep 28 00:00:02 CEST 2012
-!- ciupicri(~ciupicri@unaffiliated/ciupicri) has left #tryton04:15
shomonI keep getting "connection pool exhausted" - any setting that might help?11:12
bechamelshomon: this means, that something is opening connection to postregsql but does not close them11:16
adeb6600in trytond.conf there is option for multiserver instance does that imply a server instance managing more than one tryton client connection?11:20
bechameladeb6600: the tryton server can always handle more than one client. the multiserver option is to have several tryton server in front on the same postregsql server11:25
adeb6600bechamel: what is the recommended number of client connecting to one tryton server11:27
shomonbechamel, do you think I can set up something to automatically close connections that are left open?11:27
shomonall we have been doing is connecting via our client11:27
shomonmaybe it's not getting the message through.. it does hang a lot11:27
bechameladeb6600: by default here is a limit of 64 connections, but it can be changed11:30
bechamelshomon: you acces postgres only through the tryton server ? is there any script or crons ?11:31
shomonno11:34
shomonno scripts or crons. I just installed the newest trytond and some modules11:35
shomonand 2 people have been connecting11:35
shomonin 4 days.. too many connections11:35
bechamelshomon: are the clients closed correctly ?11:35
shomonno, they tend to hang11:39
bechamelshomon: they always hang ? or only since the pool exhausted error ?11:40
shomonusually, it depends how long i stay logged in11:45
shomonalso the connection was cutting a lot, so the client might just have lost contact with the server11:46
bechamelshomon: this may explain your issue. Anyway, you can try to restart the tryton server, this should solve (at least temporally) the pool exhausted error11:47
shomonyeah I guess.. what can I do for a more permanent solution?11:48
shomonapart from a cron to kill and restart each night11:48
nicoeI don't see how hanging clients might exhaust the connection pool to postgresql they are not connected11:54
shomonmmm.. wierd11:57
shomonit's got psycopg.. I thought that would handle it11:57
cedkshomon: how many connection to postgresql do you see?11:58
shomonhow do I see them cedk?11:58
shomonI just restarted though11:58
cedkshomon: ps11:59
shomonalso no scroll on this term so I can't go back to the error11:59
shomonbut I'll see if in the logs it said how many it had open12:00
-!- the_ant(~asep@180.248.45.184) has left #tryton21:40
crisyelithola a todos22:23
crisyelithi everybody22:23
-!- crisyelit(~jhuliana@200-71-184-83.static.telcel.net.ve) has left #tryton23:06

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!