Обсуждение: Pg7.1beta3: connect failed: The DB System is starting up.
With Apache Mod Perl, Apache::DBI, stress test with apache bench (ab -n 100000 -c 4) in apache error_log i've got: [Pg7.1beta3 with standard conf files.] .......... [Fri Jan 12 07:48:58 2001] [error] DBI->connect(dbname=mydb) failed: The Data Base System is starting up ............ Architecture: Linux 2.2.17 #3 Mon Oct 2 23:11:04 UTC 2000 i686 unknown Also messages: "DB in recovery ...". What is the problem? In pg7.0.2 it's all ok. valter _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> With Apache Mod Perl, Apache::DBI, stress test with apache bench (ab -n > 100000 -c 4) in apache error_log i've got: > > [Pg7.1beta3 with standard conf files.] And how many simult connections you did? > .......... > [Fri Jan 12 07:48:58 2001] [error] DBI->connect(dbname=mydb) failed: The > Data Base System is starting up > ............ > > Also messages: "DB in recovery ...". Looks like server was crashed and now is in recovery. Vadim
>From: "Vadim Mikheev" To: "Valter Mazzola" , Subject: Re: [HACKERS] >Pg7.1beta3: connect failed: The DB System is starting up. Date: Fri, 12 Jan >2001 00:36:55 -0800 > > > With Apache Mod Perl, Apache::DBI, stress test with apache bench (ab -n > > 100000 -c 4) in apache error_log i've got: > > [Pg7.1beta3 with standard >conf files.] > >And how many simult connections you did? about 10 connections valter > > > .......... > [Fri Jan 12 07:48:58 2001] [error] >DBI->connect(dbname=mydb) failed: The > Data Base System is starting up > >............ > > Also messages: "DB in recovery ...". > >Looks like server was crashed and now is in recovery. > >Vadim > > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
On Fri, 12 Jan 2001, Vadim Mikheev wrote: > > With Apache Mod Perl, Apache::DBI, stress test with apache bench (ab -n > > 100000 -c 4) in apache error_log i've got: > > > > [Pg7.1beta3 with standard conf files.] > > And how many simult connections you did? > > > .......... > > [Fri Jan 12 07:48:58 2001] [error] DBI->connect(dbname=mydb) failed: The > > Data Base System is starting up > > ............ > > > > Also messages: "DB in recovery ...". > > Looks like server was crashed and now is in recovery. I'm confused about this "recovery" thing ... is it supposed to eventually start working again? I've had it happen in the past, and the only way to get things started again is to kill off the postmaster and restart it :(