понедельник, 10 ноября 2014 г., 23:05:26 UTC+6 пользователь Bruno Friedmann написал: > 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
There is a lot of: WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress What i should change in postgresql.conf to produce more info that you need? -- 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.
