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"
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"
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
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"
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"
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
------------------------------------------------------------------------- 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
