DBD-pg - server closed the connection unexpectedly

Поиск
Список
Период
Сортировка
От Frank Bax
Тема DBD-pg - server closed the connection unexpectedly
Дата
Msg-id 5.2.1.1.0.20070307105703.009ff740@pop6.sympatico.ca
обсуждение исходный текст
Ответы Re: DBD-pg - server closed the connection unexpectedly  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: DBD-pg - server closed the connection unexpectedly  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-interfaces
OpenBSD 4.1-beta; pg 8.2.3; p5-DBI-1.53; p5-DBD-Pg-1.47

Here is a portion of my script.  The system() call executes successfully 
once, then script crashes.  Any ideas why this would happen.  This script 
has run without issue on platform where all above software was older versions.
  my $val='A B C';  my $sql="UPDATE suit_query SET head=?,neck=? WHERE username=? AND qry=?";
$sth=$dbc->prepare($sql); foreach my $h (split(' ',$val)) {    foreach my $n (split(' ',$val)) {      $sth->execute(
"$h%","$n%", $usr, $qry );      $cmd="(date;nice -15 ./suits.pl $dbx $dbn $usr $qry;date)";      print( "$cmd >
txt/$usr.$qry$h$n\n");      system( "$cmd > txt/$usr.$qry$h$n" );    }  }  $dbc->disconnect();
 

Output from script:

(date;nice -15 ./suits.pl RL fbax Combined 200;date) > txt/Combined.200AA
DBD::Pg::st execute failed: server closed the connection unexpectedlyThis probably means the server terminated
abnormallybeforeor while processing the request.
 
DBD::Pg::st execute failed: server closed the connection unexpectedlyThis probably means the server terminated
abnormallybeforeor while processing the request.
 

/suits.pl is a long running script and also accesses pg database through 
DBD-pg...

$ grep 2007 txt/Combined.200AA
Fri Mar  2 14:10:04 EST 2007
Sat Mar  3 02:29:34 EST 2007 



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: makhan
Дата:
Сообщение: Interfacing to postgresql running on an embedded processor
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DBD-pg - server closed the connection unexpectedly