Hi,
i am so sorry, i just found the reason in my app ;)
Thank you for your time
Wanja
> Hi,
>
> The debug message of replication server may help to solve your problem.
> You can see it when start replication server with "-vn" option.
>
> Please try it.
>
> And would you let us know your language environment in each server.
>
> Thank you,
> ----------------
> At.Mitani
>
>
> > i am using pgcluster 1.5 since 3 days in my production environment.
> > unfortunateli i have the following problem:
> >
> > My application is a php script, using pg_ functions to use the database.
> > Connection (tryed pg_connect and pg_pconnect) allways works, but in some
> > cases the handle seems to get lost.
> > If i fire a query directly after making the connect, it works... a few
> lines
> > later in script, the handle isnエt recognized as handle anymore.
> > If load goes higher, it happens more often. It seems like the connection
> > to the database is get lost ~ every "n" times.
> >
> > I checked my script, disabled load balancing (i dont use pgcluster load
> > balancer, i use ldirectord with LVS instead), switched from lighttpd with
> > php-fastcgi to apache with mod_php.... changed nothing
> >
> > so could it be the replicator that kicks the connection sometimes? i
> searche
> > d for defunctエs but i donエt see any.
> >
> > I let my script check the connection now and reconnect on this error, but
> > this is okay a dirty hack, of course :(
> > Perhaps someone has an idea on this problem?
> >
> > Thank you all in advance
> > Wanja
> >
> >
> > _______________________________________________________________________
> > Viren-Scan f? Ihren PC! Jetzt f? jeden. Sofort, online und kostenlos.
> > Gleich testen! http://www.pc-sicherheit.web.de/freescan/?mc=022222
> >
> > _______________________________________________
> > Pgcluster-general mailing list
> > Pgcluster-general@xxxxxxxxxxxxx
> > http://pgfoundry.org/mailman/listinfo/pgcluster-general
> >
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general@xxxxxxxxxxxxx
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
__________________________________________________________________________
Erweitern Sie FreeMail zu einem noch leistungsstärkeren E-Mail-Postfach!
Mehr Infos unter http://freemail.web.de/home/landingpad/?mc=021131
|