Backups

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
Post Reply
jerryboi
Advanced member
Advanced member
Posts: 125
Joined: Fri Sep 12, 2014 10:09 pm

Backups

Post by jerryboi »

I tried to restore a mailbox on my 7.2NE and it would not work, I got this in the mailbox.log:

Error occurred: no such backup for account:

I checked the backup directory and it is empty:

[admin@zimbra backup]$ du -s *

4 accounts.xml

1956 sessions

966640 tmp



I tried to back up an account from cli:
[admin@zimbra backup]$ zmbackup -f -a a.user@domain.com

full-20120725.125254.165



which happens too quick to be true, and alas,

[admin@zimbra backup]zmbackupquery

Label: full-20120725.125254.165

Type: full

Status: completed

Started: Wed, 2012/07/25 14:52:54.165 CEST

Ended: Wed, 2012/07/25 14:52:54.382 CEST

Number of accounts: 0 out of 1 completed
Label: full-20120721.230006.505

Type: full

Status: completed

Started: Sun, 2012/07/22 01:00:06.505 CEST

Ended: Sun, 2012/07/22 01:00:06.685 CEST

Number of accounts: 0 out of 25 completed
Label: full-20120720.230005.891

Type: full

Status: completed

Started: Sat, 2012/07/21 01:00:05.891 CEST

Ended: Sat, 2012/07/21 01:00:06.038 CEST

Number of accounts: 0 out of 25 completed
Label: full-20120719.230007.240

Type: full

Status: completed

Started: Fri, 2012/07/20 01:00:07.240 CEST

Ended: Fri, 2012/07/20 01:00:07.369 CEST

Number of accounts: 0 out of 25 completed

...
After reading the fora I ended up deleting accounts.xml which only had one account listed, but that did not do the trick. The file is regenerated after every backup:

[admin@zimbra backup]$ cat accounts.xml












No accounts are listed there. I guess I need to rgenerate this file somehow. That version=7.1 is suspicious too, as
[admin@zimbra backup]$ zmcontrol -v

Release 7.2.0_GA_2669.RHEL5_20120410001958 CentOS5 NETWORK edition.


I really can't sleep without having my server backed up. Pleeeease someone advise.
jerryboi
Advanced member
Advanced member
Posts: 125
Joined: Fri Sep 12, 2014 10:09 pm

Backups

Post by jerryboi »

[SOLVED]
Resolution:

You have to make sure that no fields have a trailing space in their name should you add custom tables to the zimbra database. The backup script chokes on field names with trailing spaces.
bgodbolt
Posts: 14
Joined: Sat Sep 13, 2014 2:03 am

Backups

Post by bgodbolt »

[quote user="jerryboi"][SOLVED]
Resolution:

You have to make sure that no fields have a trailing space in their name should you add custom tables to the zimbra database. The backup script chokes on field names with trailing spaces.[/QUOTE]
I'm having this same problem where the backups are finishing almost instantly, but no accounts are actually backed up. However, I have never added custom tables. Could you maybe expand on what you did to solve this problem?
Here is an example of a "successful" backup email:
Label: full-20121116.173822.023

Type: full

Status: completed

Started: Fri, 2012/11/16 10:38:22.023 MST

Ended: Fri, 2012/11/16 10:38:22.243 MST

Redo log sequence range: -1 .. ?

Number of accounts: 9
I am currently running: Release 8.0.0.GA.5434.UBUNTU12.64 UBUNTU12_64 NETWORK edition

but I think the problem started while I was using 7.2.0.
jerryboi
Advanced member
Advanced member
Posts: 125
Joined: Fri Sep 12, 2014 10:09 pm

Backups

Post by jerryboi »

Did you double check that you have sufficient amount of disk space available?
bgodbolt
Posts: 14
Joined: Sat Sep 13, 2014 2:03 am

Backups

Post by bgodbolt »

Thanks for your reply. I have 257 GB free where I store the backups, and in the past when the backups worked a full backup would only need about 5 GB of space.
In my case I'm wondering if the problem has to do with the redo log in some way. Going back in my admin emails I found that on Sept 12 the backup ran successfully:


Label: full-20120912.060015.823

Type: full

Status: completed

Started: Wed, 2012/09/12 00:00:15.823 MDT

Ended: Wed, 2012/09/12 04:56:34.308 MDT

Redo log sequence range: 4431 .. 4431

Number of accounts: 8


Then there is no email from the 13th (a full backup is scheduled to run every night) but on the 14th I got


Label: full-20120914.060015.100

Type: full

Status: completed

Started: Fri, 2012/09/14 00:00:15.100 MDT

Ended: Fri, 2012/09/14 00:00:21.995 MDT

Redo log sequence range: -1 .. ?

Number of accounts: 8


I did not do anything to the server at this time. No upgrades, or configuration changes. I tried running zmbackup with the debug flag and got


zimbra@mail:~$ zmbackup --debug -f -a all

full-20121116.224919.281





zimbra@mail:~$ zmbackupquery

Label: full-20121116.224919.281

Type: full

Status: completed

Started: Fri, 2012/11/16 15:49:19.281 MST

Ended: Fri, 2012/11/16 15:49:19.857 MST

Number of accounts: 0 out of 9 completed


If anyone has any suggestions I would really appreciate some help with this. As the original poster said I have trouble sleeping knowing my mail isn't being backed up.
bgodbolt
Posts: 14
Joined: Sat Sep 13, 2014 2:03 am

Backups

Post by bgodbolt »

For anyone else who has this problem, the resolution is in this thread
Post Reply