Ralf Gross schrieb:
> Hi,
>
> after updateing to 5.0.3 it checked the state of some accurate backups. I'm
> not
> sure if I fully understand why bacula is backing up some files.
>
> I'm interested in the job VUMEM008-psql-dumps.
>
>
> Terminated Jobs:
> JobId Level Files Bytes Status Finished Name
> ======================================================================
> 25963 Incr 3 4.449 G OK 02-Oct-10 05:31
> VUMEM008-psql-dumps
> 25970 Volu 635 0 OK 02-Oct-10 11:00 VerifyVUMEM008
> 25971 Volu 3 0 OK 02-Oct-10 11:01
> VerifyVUMEM008-psql-dumps
> 26008 Full 104,492 6.834 G OK 04-Oct-10 04:23 VUMEM008
> 26009 Full 25 26.62 G OK 04-Oct-10 05:37
> VUMEM008-psql-dumps
> 26014 Volu 104,492 0 OK 04-Oct-10 11:33 VerifyVUMEM008
> 26015 Volu 25 0 OK 04-Oct-10 11:38
> VerifyVUMEM008-psql-dumps
> 26026 Incr 4 22.28 G OK 04-Oct-10 21:38
> VUMEM008-psql-dumps
> 26039 Incr 16,460 8.614 G OK 05-Oct-10 04:15 VUMEM008
>
>
> There has been a full backup on 2010-10-04 and and incremental later that
> same day.
>
>
> content of the full backup:
>
> *list files jobid=26009
> +----------------------------------------------------------------------------------------------------+
> | filename
> |
> +----------------------------------------------------------------------------------------------------+
> | /postgres-backups/testdb-20101001.sql.gz
> |
> | /postgres-backups/WAL/archive_status/
> |
> | /postgres-backups/WAL/
> |
> | /postgres-backups/mysql-backups/monthly/
> |
> |
> /postgres-backups/mysql-backups/daily/information_schema/information_schema_2009-01-26_16h34m.Montag.sql.gz
> |
> | /postgres-backups/mysql-backups/daily/information_schema/
> |
> |
> /postgres-backups/mysql-backups/daily/mantis/mantis_2009-01-26_16h34m.Montag.sql.gz
> |
> | /postgres-backups/mysql-backups/daily/mantis/
> |
> |
> /postgres-backups/mysql-backups/daily/mysql/mysql_2009-01-26_16h34m.Montag.sql.gz
> |
> | /postgres-backups/mysql-backups/daily/mysql/
> |
> | /postgres-backups/mysql-backups/daily/
> |
> | /postgres-backups/mysql-backups/weekly/information_schema/
> |
> | /postgres-backups/mysql-backups/weekly/mantis/
> |
> | /postgres-backups/mysql-backups/weekly/mysql/
> |
> | /postgres-backups/mysql-backups/weekly/
> |
> | /postgres-backups/testdb-20100928.sql.gz
> |
> | /postgres-backups/testdb-20101002.sql.gz
> |
> | /postgres-backups/testdb-20100930.sql.gz
> |
> | /postgres-backups/lost+found/
> |
> | /postgres-backups/testdb-20100929.sql.gz
> |
> | /postgres-backups/all-20101003.sql.gz
> |
> | /postgres-backups/xlogs/
> |
> | /postgres-backups/basebackups/
> |
> | /postgres-backups/
> |
> | /postgres-backups/mysql-backups/
> |
> +----------------------------------------------------------------------------------------------------+
> +--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
> | jobid | name | starttime | type | level |
> jobfiles | jobbytes | jobstatus |
> +--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
> | 26,009 | VUMEM008-psql-dumps | 2010-10-04 05:30:02 | B | F |
> 25 | 26,627,699,629 | T |
> +--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
Ok, purged the volume of the incremental job and ran the inc. backup
again.
All the information about the job tells me that 3 files and a directory were
backed up. But the size of the backup (4,478,194,813 bytes) does not fit then.
I find it hard to check if accurate backups are working as they should.
Especially the bls output below is confusing...
-rw-r--r-- 1 postgres postgres 4428377463 30. Sep 20:17 testdb-20100930.sql.gz
-rw-r--r-- 1 postgres postgres 4449091993 1. Okt 20:18 testdb-20101001.sql.gz
-rw-r--r-- 1 postgres postgres 4463916388 2. Okt 20:17 testdb-20101002.sql.gz
-rw-r--r-- 1 postgres postgres 4478194813 4. Okt 20:18 testdb-20101004.sql.gz
05-Okt 09:33 VUMEM004-dir JobId 26051: Bacula VUMEM004-dir 5.0.3 (04Aug10):
05-Okt-2010 09:33:46
Build OS: x86_64-pc-linux-gnu debian 5.0.5
JobId: 26051
Job: VUMEM008-psql-dumps.2010-10-05_09.32.32_01
Backup Level: Incremental, since=2010-10-05 09:21:47
Client: "VUMEM008-fd" 5.0.2 (28Apr10)
i486-pc-linux-gnu,debian,5.0.4
FileSet: "VUMEM008-psql-dumps" 2010-01-05 05:30:00
Pool: "VUMEM008-Disk-Incremental" (From Job IncPool
override)
Catalog: "MyCatalog" (From Client resource)
Storage: "VUMEM008-DISK" (From Pool resource)
Scheduled time: 05-Okt-2010 09:32:24
Start time: 05-Okt-2010 09:32:34
End time: 05-Okt-2010 09:33:46
Elapsed time: 1 min 12 secs
Priority: 10
FD Files Written: 4
SD Files Written: 4
FD Bytes Written: 4,478,194,813 (4.478 GB)
SD Bytes Written: 4,478,195,199 (4.478 GB)
Rate: 62197.2 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: yes
Volume name(s): vumem008-inc-0663|vumem008-inc-0665
Volume Session Id: 31
Volume Session Time: 1286190654
Last Volume Bytes: 948,000,872 (948.0 MB)
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Backup OK
*list jobid=26051
+--------+---------------------+---------------------+------+-------+----------+---------------+-----------+
| jobid | name | starttime | type | level | jobfiles
| jobbytes | jobstatus |
+--------+---------------------+---------------------+------+-------+----------+---------------+-----------+
| 26,051 | VUMEM008-psql-dumps | 2010-10-05 09:32:34 | B | I | 4
| 4,478,194,813 | T |
+--------+---------------------+---------------------+------+-------+----------+---------------+-----------+
*list files jobid=26051
+------------------------------------------+
| filename |
+------------------------------------------+
| /postgres-backups/testdb-20101004.sql.gz |
| /postgres-backups/ |
| /postgres-backups/testdb-20100928.sql.gz |
| /postgres-backups/testdb-20100929.sql.gz |
+------------------------------------------+
*query
Available queries:
12: List Files for a selected JobId
choose a query (1-22): 12
Enter JobId: 26051
+--------------------+------------------------+
| path | name |
+--------------------+------------------------+
| /postgres-backups/ | |
| /postgres-backups/ | testdb-20100928.sql.gz |
| /postgres-backups/ | testdb-20100929.sql.gz |
| /postgres-backups/ | testdb-20101004.sql.gz |
+--------------------+------------------------+
$ bls -V "vumem008-inc-0663|vumem008-inc-0665" VUMEM008-DISK | grep
postgres-backups
bls JobId 26052: -rw-r--r-- 1 ntp ssl-cert 4478194813 2010-10-04
20:18:43 /postgres-backups/testdb-20101004.sql.gz
bls JobId 26052: drwxr-xr-x 7 ntp ssl-cert 4096 2010-10-04
19:10:40 /postgres-backups/
bls JobId 26052: ---------- - - - - ---------- --------
/postgres-backups/testdb-20100928.sql.gz
bls JobId 26052: ---------- - - - - ---------- --------
/postgres-backups/testdb-20100929.sql.gz
bls JobId 0: drwxr-xr-x 7 ntp ssl-cert 4096 2010-10-04 19:10:40
/postgres-backups/
bls JobId 0: ---------- - - - - ---------- --------
/postgres-backups/testdb-20100928.sql.gz
bls JobId 0: ---------- - - - - ---------- --------
/postgres-backups/testdb-20100929.sql.gz
Ralf
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|