On 26 Sep 2006 at 14:17, Gabriele Bulfon wrote: > Hello, > I enabled full logging of connections/statements on Postgres to see what > happens when bconsole hangs. > Analyzing the log I can see that during startup the Director runs some > statements succesfully, then something goes wrong when I use the bconsole. > Anyone know what is the meaning of these errors from Postgres? > The IP > 192.168.222.254 is where Director is running. > Postgres is running on > 192.168.222.10. > ...I am also confused by the logs that are translated into Italian....no > other log is in Italian....maybe those messages comes from the system?.... > ===> Here I start up bacula > 2006-09-26 14:06:51 LOG: database system was shut down at 2006-09-25 > 17:13:33 ora solare Europa occidentale > 2006-09-26 14:06:51 LOG: checkpoint record is at 0/A94EF8 > 2006-09-26 14:06:51 LOG: redo record is at 0/A94EF8; undo record is at 0/0; > shutdown TRUE > 2006-09-26 14:06:51 LOG: next transaction ID: 20740; next OID: 29082 > 2006-09-26 14:06:51 LOG: next MultiXactId: 1; next MultiXactOffset: 0 > 2006-09-26 14:06:51 LOG: database system is ready > 2006-09-26 14:06:51 LOG: transaction ID wrap limit is 2147484148, limited by > database "postgres" > 2006-09-26 14:06:51 LOG: autovacuum: processing database "bacula"
There, a vacuum begins. Bacula is not doing that. > 2006-09-26 14:07:23 LOG: connection received: host=192.168.222.254 port=42477 > 2006-09-26 14:07:23 LOG: connection authorized: user=bacula database=bacula > 2006-09-26 14:07:23 LOG: statement: SELECT VersionId FROM Version > 2006-09-26 14:07:23 LOG: duration: 234.000 ms > 2006-09-26 14:07:23 LOG: statement: SELECT > PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelFormat > FROM Pool WHERE Pool.Name='Default' > 2006-09-26 14:07:23 LOG: duration: 484.000 ms > 2006-09-26 14:07:23 LOG: statement: UPDATE Pool SET > NumVols=0,MaxVols=0,UseOnce=0,UseCatalog=1,AcceptAnyVolume=1,VolRetention='31536000',VolUseDuration='0',MaxVolJobs=0,MaxVolFiles=0,MaxVolBytes=0,Recycle=1,AutoPrune=1,LabelFormat='*' > WHERE PoolId=1 > 2006-09-26 14:07:24 LOG: duration: 47.000 ms > 2006-09-26 14:07:24 LOG: statement: SELECT > PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelFormat > FROM Pool WHERE Pool.Name='Ultra20' > 2006-09-26 14:07:24 LOG: duration: 0.000 ms > 2006-09-26 14:07:24 LOG: statement: UPDATE Pool SET > NumVols=0,MaxVols=0,UseOnce=0,UseCatalog=1,AcceptAnyVolume=1,VolRetention='36000',VolUseDuration='0',MaxVolJobs=0,MaxVolFiles=0,MaxVolBytes=0,Recycle=1,AutoPrune=1,LabelFormat='*' > WHERE PoolId=2 > 2006-09-26 14:07:24 LOG: duration: 0.000 ms > 2006-09-26 14:07:24 LOG: disconnection: session time: 0:00:00.84 user=bacula > database=bacula host=192.168.222.254 port=42477 > ===> Here I ran bconsole and issued "list volumes" > 2006-09-26 14:07:29 LOG: connection received: host=192.168.222.254 port=42479 > 2006-09-26 14:07:29 LOG: could not receive data from client: Impossibile > stabilire la connessione. Rifiuto persistente del computer di destinazione. > > 2006-09-26 14:07:29 LOG: incomplete startup packet > 2006-09-26 14:07:34 LOG: connection received: host=192.168.222.254 port=42480 > 2006-09-26 14:07:34 LOG: could not receive data from client: Impossibile > stabilire la connessione. Rifiuto persistente del computer di destinazione. > > 2006-09-26 14:07:34 LOG: incomplete startup packet > 2006-09-26 14:07:39 LOG: connection received: host=192.168.222.254 port=42481 > 2006-09-26 14:07:39 LOG: could not receive data from client: Impossibile > stabilire la connessione. Rifiuto persistente del computer di destinazione. > > 2006-09-26 14:07:39 LOG: incomplete startup packet > 2006-09-26 14:07:44 LOG: connection received: host=192.168.222.254 port=42484 > 2006-09-26 14:07:44 LOG: could not receive data from client: Impossibile > stabilire la connessione. Rifiuto persistente del computer di destinazione. > > 2006-09-26 14:07:44 LOG: incomplete startup packet > 2006-09-26 14:07:49 LOG: connection received: host=192.168.222.254 port=42486 > 2006-09-26 14:07:49 LOG: could not receive data from client: Impossibile > stabilire la connessione. Rifiuto persistente del computer di destinazione. > > 2006-09-26 14:07:49 LOG: incomplete startup packet > 2006-09-26 14:07:54 LOG: connection received: host=192.168.222.254 port=42487 > 2006-09-26 14:07:54 LOG: could not receive data from client: Impossibile > stabilire la connessione. Rifiuto persistente del computer di destinazione. > > 2006-09-26 14:07:54 LOG: incomplete startup packet > 2006-09-26 14:07:55 LOG: autovacuum: processing database "webtop2" There the vacuum starts on another db. > 2006-09-26 14:08:16 LOG: received fast shutdown request > 2006-09-26 14:08:16 LOG: shutting down > 2006-09-26 14:08:16 LOG: database system is shut down > 2006-09-26 14:08:17 LOG: logger shutting down Have you tried turned autovacuum off on your PostgreSQL installation? -- Dan Langille : Software Developer looking for work my resume: http://www.freebsddiary.org/dan_langille.php ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
