On Monday 10 November 2014 01.34:44 Виталий Фадеев wrote: > Hi! > All works like good, but there is a lot of this messages in bconsole: > > 10-Nov 02:00 backup-dir JobId 333: Query failed: CREATE TEMPORARY TABLE > DelCandidates (JobId INTEGER NOT NULL, PurgedFiles SMALLINT, FileSetId > INTEGER, JobFiles INTEGER, JobStatus char(1)): ERR=ERROR: current > transaction is aborted, commands ignored until end of transaction block > > 10-Nov 02:00 backup-dir JobId 333: Begin pruning Files. > 10-Nov 02:00 backup-dir JobId 333: Query failed: SELECT COUNT(1) FROM Job > JOIN Client USING (ClientId) JOIN Pool ON (Job.PoolId = Pool.PoolId) WHERE > PurgedFiles=0 AND JobTDate < 1410426007 AND Client.Name = 'newweb1-fd' AND > Pool.Name = 'newweb1-pool' : ERR=ERROR: current transaction is aborted, > commands ignored until end of transaction block > > > 09-Nov 02:01 backup-dir JobId 327: Query failed: CREATE TEMPORARY TABLE > DelCandidates (JobId INTEGER NOT NULL, PurgedFiles SMALLINT, FileSetId > INTEGER, JobFiles INTEGER, JobStatus char(1)): ERR=ERROR: current > transaction is aborted, commands ignored until end of transaction block > > 09-Nov 02:01 backup-dir JobId 327: Begin pruning Files. > 09-Nov 02:01 backup-dir JobId 327: Query failed: SELECT COUNT(1) FROM Job > JOIN Client USING (ClientId) JOIN Pool ON (Job.PoolId = Pool.PoolId) WHERE > PurgedFiles=0 AND JobTDate < 1410339671 AND Client.Name = 'newweb1-fd' AND > Pool.Name = 'newweb1-pool' : ERR=ERROR: current transaction is aborted, > commands ignored until end of transaction block > > 09-Nov 02:00 backup-dir JobId 328: Query failed: CREATE TEMPORARY TABLE > DelCandidates (JobId INTEGER NOT NULL, PurgedFiles SMALLINT, FileSetId > INTEGER, JobFiles INTEGER, JobStatus char(1)): ERR=ERROR: current > transaction is aborted, commands ignored until end of transaction block > > 09-Nov 02:00 backup-dir JobId 328: Begin pruning Files. > 09-Nov 02:00 backup-dir JobId 328: Query failed: SELECT COUNT(1) FROM Job > JOIN Client USING (ClientId) JOIN Pool ON (Job.PoolId = Pool.PoolId) WHERE > PurgedFiles=0 AND JobTDate < 1410339619 AND Client.Name = 'newweb2-fd' AND > Pool.Name = 'newweb2-pool' : ERR=ERROR: current transaction is aborted, > commands ignored until end of transaction block > > 09-Nov 02:00 backup-dir JobId 325: Query failed: CREATE TEMPORARY TABLE > DelCandidates (JobId INTEGER NOT NULL, PurgedFiles SMALLINT, FileSetId > INTEGER, JobFiles INTEGER, JobStatus char(1)): ERR=ERROR: current > transaction is aborted, commands ignored until end of transaction block > > 09-Nov 02:00 backup-dir JobId 325: Begin pruning Files. > 09-Nov 02:00 backup-dir JobId 325: Query failed: SELECT COUNT(1) FROM Job > JOIN Client USING (ClientId) JOIN Pool ON (Job.PoolId = Pool.PoolId) WHERE > PurgedFiles=0 AND JobTDate < 1410339609 AND Client.Name = 'newdbs-fd' AND > Pool.Name = 'newdbs-pool' : ERR=ERROR: current transaction is aborted, > commands ignored until end of transaction block > >
Would be useful to have also the postgresql log too. -- Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch openSUSE Member & Board, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
