Autovacuum is never enabled on my installations, because postgres is usually version 8.0.
This log was from my personal installation of postgres on a laptop, for testing purposes, and because it is 8.1, it has autovacuum enabled by default.
I tried disabling autovacuum as you suggested anyway, but the problem persists...
----------------------------------------------------------------------------------
Da: Dan Langille <[EMAIL PROTECTED]>
A: Gabriele Bulfon <[EMAIL PROTECTED]>
Cc: bacula-users@lists.sourceforge.net
Data: 26 settembre 2006 14.48.20 CEST
Oggetto: Re: [Bacula-users] Postgres Log
This log was from my personal installation of postgres on a laptop, for testing purposes, and because it is 8.1, it has autovacuum enabled by default.
I tried disabling autovacuum as you suggested anyway, but the problem persists...
|
|
|
Gabriele Bulfon - Sonicle S.r.l. Tel +39 028246016 Int. 30 - Fax +39 028243880 Via Felice Cavallotti 16 - 20089, Rozzano - Milano - ITALY http://www.sonicle.com |
----------------------------------------------------------------------------------
Da: Dan Langille <[EMAIL PROTECTED]>
A: Gabriele Bulfon <[EMAIL PROTECTED]>
Cc: bacula-users@lists.sourceforge.net
Data: 26 settembre 2006 14.48.20 CEST
Oggetto: Re: [Bacula-users] Postgres Log
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
