[Bacula-users] Stopping the database during a backup job

I bounced my PostgreSQL server today, without checking to see if 
anything was using it.  For the record, this is the type of failure you 
will see.

FreeBSD 6.3-STABLE
PostgreSQL 8.2.7
FreeBSD 2.2.8

Bacula wrote:
> 02-Jun 14:00 bacula-dir JobId 0: Fatal error: sql_create.c:489 
> sql_create.c:489 query SELECT ClientId,Uname FROM Client WHERE Name='nyi-fd' 
> failed:
> FATAL:  terminating connection due to administrator command
> server closed the connection unexpectedly
>       This probably means the server terminated abnormally
>       before or while processing the request.
> 
> 02-Jun 14:00 bacula-dir JobId 0: sql_create.c:489 SELECT ClientId,Uname FROM 
> Client WHERE Name='nyi-fd'
> 02-Jun 14:02 bacula-dir JobId 0: Fatal error: sql_create.c:524 
> sql_create.c:524 insert INSERT INTO Client 
> (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES 
> ('nyi-fd','',1,5184000,15552000) failed:
> no connection to the server
> 
> 02-Jun 14:03 bacula-dir JobId 0: sql_create.c:524 INSERT INTO Client 
> (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES 
> ('nyi-fd','',1,5184000,15552000)
> 02-Jun 14:04 bacula-dir JobId 0: Error: sql_create.c:526 Create DB Client 
> record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) 
> VALUES ('nyi-fd','',1,5184000,15552000) failed. ERR=no connection to the 
> server
> 
> 02-Jun 14:05 bacula-dir JobId 0: Fatal error: Could not create Client record. 
> ERR=Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES 
> (0,'2008-06-02 14:04:10','bacula-dir JobId 0: Error: sql_create.c:526 Create 
> DB Client record INSERT INTO Client 
> (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES 
> (''nyi-fd'','''',1,5184000,15552000) failed. ERR=no connection to the server
> 
> '): ERR=no connection to the server
> 
> 


-- 
Dan Langille

BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference:     http://www.pgcon.org/

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users