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.
