понедельник, 10 ноября 2014 г., 15:34:44 UTC+6 пользователь Виталий Фадеев написал: > 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
I just install 14.2.1 and doing 6 full backups: 24-Nov 03:06 backup-dir JobId 3: 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 24-Nov 03:06 backup-dir JobId 3: Begin pruning Files. 24-Nov 03:06 backup-dir JobId 3: Query failed: SELECT COUNT(1) FROM Job JOIN Client USING (ClientId) JOIN Pool ON (Job.PoolId = Pool.PoolId) WHERE PurgedFiles=0 AND JobTDate < 1411639565 AND Client.Name = 'newdbs-fd' AND Pool.Name = 'full-newdbs-pool' : ERR=ERROR: current transaction is aborted, commands ignored until end of transaction block 24-Nov 03:06 backup-dir JobId 3: End auto prune. 24-Nov 03:06 backup-dir JobId 5: Fatal error: sql.c:332 sql.c:332 query SELECT count(*) from JobMedia WHERE JobId=5 failed: ERROR: current transaction is aborted, commands ignored until end of transaction block 24-Nov 03:06 backup-dir JobId 5: Fatal error: sql_create.c:143 sql_create.c:143 insert INSERT INTO JobMedia (JobId,MediaId,FirstIndex,LastIndex,StartFile,EndFile,StartBlock,EndBlock,VolIndex) VALUES (5,5,97385,97388,0,0,1999871968,2999807963,1) failed: ERROR: current transaction is aborted, commands ignored until end of transaction block 24-Nov 03:06 backup-dir JobId 5: Fatal error: Catalog error creating JobMedia record. sql_create.c:145 Create JobMedia record INSERT INTO JobMedia (JobId,MediaId,FirstIndex,LastIndex,StartFile,EndFile,StartBlock,EndBlock,VolIndex) VALUES (5,5,97385,97388,0,0,1999871968,2999807963,1) failed: ERR=ERROR: current transaction is aborted, commands ignored until end of transaction block 24-Nov 03:06 backup-sd JobId 5: Fatal error: Error creating JobMedia record: 1992 Create JobMedia error 24-Nov 03:06 backup-sd JobId 5: Fatal error: block.c:889 Could not create JobMedia record for Volume="newweb1-Full-20141124-0303" Job=Backup_of_newweb1_server.2014-11-24_03.03.01_08 24-Nov 03:06 backup-dir JobId 5: Fatal error: sql_get.c:1035 sql_get.c:1035 query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE VolumeName='newweb1-Full-20141124-0303' failed: ERROR: current transaction is aborted, commands ignored until end of transaction block 24-Nov 03:06 backup-dir JobId 5: Error: Unable to get Media record for Volume newweb1-Full-20141124-0303: ERR=Media record for Vol=newweb1-Full-20141124-0303 not found in Catalog. 24-Nov 03:06 backup-sd JobId 5: Elapsed time=00:03:01, Transfer rate=16.54 M Bytes/second 24-Nov 03:06 newweb1-fd JobId 5: Error: bsock_tcp.c:422 Write error sending 65580 bytes to Storage daemon:backup:9103: ERR=Connection reset by peer 24-Nov 03:06 newweb1-fd JobId 5: Fatal error: backup.c:984 Network send error to SD. ERR=Connection reset by peer * -- 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.
