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
Re: DBD-pg - server closed the connection unexpectedly |
Список | 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 по дате отправления: