This problem happens only when i run multiple clients backup. If i run job for only one clients, no errors.
понедельник, 24 ноября 2014 г., 17:09:04 UTC+6 пользователь Виталий Фадеев написал: > I think that i founded the problem: > May be we need add "IF EXISTS" to "DROP TABLE DelCandidates"? > See http://www.postgresql.org/docs/9.4/static/sql-droptable.html > LOG: statement: DROP TABLE DelCandidates > ERROR: table "delcandidates" does not exist > STATEMENT: DROP TABLE DelCandidates > LOG: statement: CREATE TEMPORARY TABLE DelCandidates (JobId INTEGER NOT > NULL, PurgedFiles SMALLINT, FileSetId INTEGER, JobFiles INTEGER, JobStatus > char(1)) > ERROR: current transaction is aborted, commands ignored until end of > transaction block > STATEMENT: CREATE TEMPORARY TABLE DelCandidates (JobId INTEGER NOT NULL, > PurgedFiles SMALLINT, FileSetId INTEGER, JobFiles INTEGER, JobStatus char(1)) > LOG: statement: INSERT INTO Log (JobId, Time, LogText) VALUES > (13,'2014-11-24 04:02:44','backup-dir JobId 13: 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 > > ') > ERROR: current transaction is aborted, commands ignored until end of > transaction block > STATEMENT: INSERT INTO Log (JobId, Time, LogText) VALUES (13,'2014-11-24 > 04:02:44','backup-dir JobId 13: 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 > > ') > LOG: statement: DROP TABLE DelCandidates > ERROR: current transaction is aborted, commands ignored until end of > transaction block > STATEMENT: DROP TABLE DelCandidates > LOG: statement: INSERT INTO Log (JobId, Time, LogText) VALUES > (13,'2014-11-24 04:02:44','backup-dir JobId 13: Begin pruning Files. > ') > ERROR: current transaction is aborted, commands ignored until end of > transaction block > STATEMENT: INSERT INTO Log (JobId, Time, LogText) VALUES (13,'2014-11-24 > 04:02:44','backup-dir JobId 13: Begin pruning Files. > ') > LOG: statement: SELECT COUNT(1) FROM Job JOIN Client USING (ClientId) JOIN > Pool ON (Job.PoolId = Pool.PoolId) WHERE PurgedFiles=0 AND JobTDate < > 1411642964 AND Client.Name = 'newweb2-fd' AND Pool.Name = > 'incremental-newweb2-pool' > ERROR: current transaction is aborted, commands ignored until end of > transaction block > STATEMENT: SELECT COUNT(1) FROM Job JOIN Client USING (ClientId) JOIN Pool > ON (Job.PoolId = Pool.PoolId) WHERE PurgedFiles=0 AND JobTDate < 1411642964 > AND Client.Name = 'newweb2-fd' AND Pool.Name = 'incremental-newweb2-pool' > LOG: statement: INSERT INTO Log (JobId, Time, LogText) VALUES > (13,'2014-11-24 04:02:44','backup-dir JobId 13: Query failed: SELECT COUNT(1) > FROM Job JOIN Client USING (ClientId) JOIN Pool ON (Job.PoolId = > Pool.PoolId) WHERE PurgedFiles=0 AND JobTDate < 1411642964 AND Client.Name > = ''newweb2-fd'' AND Pool.Name = ''incremental-newweb2-pool'' : ERR=ERROR: > current transaction is aborted, commands ignored until end of transaction > block > > ') > ERROR: current transaction is aborted, commands ignored until end of > transaction block > STATEMENT: INSERT INTO Log (JobId, Time, LogText) VALUES (13,'2014-11-24 > 04:02:44','backup-dir JobId 13: Query failed: SELECT COUNT(1) FROM Job JOIN > Client USING (ClientId) JOIN Pool ON (Job.PoolId = Pool.PoolId) WHERE > PurgedFiles=0 AND JobTDate < 1411642964 AND Client.Name = ''newweb2-fd'' > AND Pool.Name = ''incremental-newweb2-pool'' : ERR=ERROR: current > transaction is aborted, commands ignored until end of transaction block > > ') > LOG: statement: INSERT INTO Log (JobId, Time, LogText) VALUES > (13,'2014-11-24 04:02:44','backup-dir JobId 13: End auto prune. > > ') > ERROR: current transaction is aborted, commands ignored until end of > transaction block > STATEMENT: INSERT INTO Log (JobId, Time, LogText) VALUES (13,'2014-11-24 > 04:02:44','backup-dir JobId 13: End auto prune. > > ') -- 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.
