Issue with backup

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
armitage318
Advanced member
Advanced member
Posts: 88
Joined: Sat Sep 13, 2014 2:01 am

Issue with backup

Postby armitage318 » Fri Apr 10, 2015 4:29 am

Hi,


I am using a very old version of ZCS:


$ zmcontrol -v
Release 6.0.6_GA_2324.DEBIAN4.0 DEBIAN4.0 FOSS edition.


I use bash script to make backup of my accounts every night:


/opt/zimbra/bin/zmmailbox -z -m username1@domain.it getRestURL "//?fmt=tgz" > /var/backups/username1.tgz
/opt/zimbra/bin/zmmailbox -z -m username2@domain.it getRestURL "//?fmt=tgz" > /var/backups/username2.tgz


..


and so on.


I noticed that size of backup files is changing every day, I mean: generally username1 takes 9 GB, while sometimes I see username1.tgz with 1 GB size.


Same occours for other accounts.


I suspect that backup process fails due to some memory issue (I have 3 GB on this server, 32bit).


What can I do to make this working properly?



User avatar
cayaraa
Outstanding Member
Outstanding Member
Posts: 333
Joined: Sat Sep 13, 2014 12:33 am
ZCS/ZD Version: ZCS 8.7 NE & ZCS 8.7 FOSS

Issue with backup

Postby cayaraa » Fri Apr 10, 2015 7:51 am

I think I remember there being an issue with rest exports timing out on older versions of zimbra....its been many years though so I don't remember many details. I recall a vague memory of trying to find a way to verify if a .tar file was valid without having to do a full extract though.
armitage318
Advanced member
Advanced member
Posts: 88
Joined: Sat Sep 13, 2014 2:01 am

Issue with backup

Postby armitage318 » Mon Apr 13, 2015 2:58 am

Hi cayaraa, thank you for your reply.

I added -t 0 option to my backup script:



/opt/zimbra/bin/zmmailbox -z -t 0 -m username1@domain.it getRestURL "//?fmt=tgz" > /var/backups/username1.tgz



anyway, I got same problem.

According to file timestamp, tgz archive is completed 1 minute after cronjob.

I noticed thoose message in /opt/zimbra/log/mailbox.log:





# MESSAGE1

2015-04-13 00:01:43,804 WARN [btpool0-1://zimbraserver.domain.it/home/username1@domain.it/?fmt=tgz] [name=username1@domain.it;mid=22;ip=aa.xx.yy.zz;] misc - Archive For

matter warning: com.zimbra.common.service.ServiceException: system failure: archive error

ExceptionId:btpool0-1://zimbraserver.domain.it/home/username1@domain.it/?fmt=tgz:1428876103803:2aa585f44eea0abb

Code:service.FAILURE: java.io.IOException: data error: com.zimbra.cs.mailbox.MailServiceException$NoSuchItemException: no such folder id: 2

ExceptionId:btpool0-1://zimbraserver.domain.it/home/username1@domain.it/?fmt=tgz:1428876103803:2aa585f44eea0abb

Code:mail.NO_SUCH_FOLDER Arg:(itemId, IID, "2")



# MESSAGE2

2015-04-13 00:01:43,786 INFO [LmtpServer-545] [name=username1@domain.it;mid=22;ip=aaa.xx.yy.zz;] filter - Unable to file message to Progetti. Filing to /Inbox instead.

com.zimbra.common.service.ServiceException: system failure: writing new object of type 5

ExceptionId:LmtpServer-545:1428876103781:2aa585f44eea0abb

Code:service.FAILURE

at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:248)

at com.zimbra.cs.db.DbMailItem.create(DbMailItem.java:190)

at com.zimbra.cs.mailbox.Message.createInternal(Message.java:432)

at com.zimbra.cs.mailbox.Message.create(Message.java:360)

at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:4504)

at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4351)

at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4284)

at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4231)

at com.zimbra.cs.filter.FilterUtil.addMessage(FilterUtil.java:279)

at com.zimbra.cs.filter.IncomingMessageHandler.fileInto(IncomingMessageHandler.java:83)

at com.zimbra.cs.filter.ZimbraMailAdapter.fileInto(ZimbraMailAdapter.java:321)

at com.zimbra.cs.filter.ZimbraMailAdapter.executeActions(ZimbraMailAdapter.java:198)

at org.apache.jsieve.SieveFactory.evaluate(SieveFactory.java:164)

at com.zimbra.cs.filter.RuleManager.applyRulesToIncomingMessage(RuleManager.java:348)

at com.zimbra.cs.filter.RuleManager.applyRulesToIncomingMessage(RuleManager.java:311)

at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliverMessageToLocalMailboxes(ZimbraLmtpBackend.java:447)

at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliverMessageToLocalMailboxes(ZimbraLmtpBackend.java:279)

at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver(ZimbraLmtpBackend.java:169)

at com.zimbra.cs.lmtpserver.LmtpHandler.processMessageData(LmtpHandler.java:365)

at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDATA(TcpLmtpHandler.java:72)

at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHandler.java:350)

at com.zimbra.cs.lmtpserver.LmtpHandler.processCommand(LmtpHandler.java:170)

at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCommand(TcpLmtpHandler.java:66)

at com.zimbra.cs.tcpserver.ProtocolHandler.processConnection(ProtocolHandler.java:175)

at com.zimbra.cs.tcpserver.ProtocolHandler.run(ProtocolHandler.java:132)

at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Thread.java:619)

Caused by: java.sql.SQLException: Incorrect string value: 'xF0x9Fx8Cx85xF0x9F...' for column 'metadata' at row 1



Query being executed when exception was thrown:



INSERT INTO mboxgroup22.mail_item(mailbox_id, id, type, parent_id, folder_id, index_id, imap_id, date, size, volume_id, blob_digest, unread, flags, tags, sender, subj

ect, name, metadata, mod_metadata, change_date, mod_content) VALUES (22, 1581457, 5, null, 1000624, '1581457', 1581457, 1428876103, 42717, '1', 'wt97hULHnX0ZG1ueO6bD2

sNXuzg=', 1, 0, 0, 'Ryanair', '?????? da 9,99???', null, 'd1:f148:Prenota ora e risparmia: [Ryanair - 30 anni di low cost] [Family] Prenota ora e risparmia! Alghero -

Ancona da 9,99??? Perugia - Brindisi da 9,99??? ...1:r16:?????? da 9,99??? ????????1:s35:"Ryanair" <webster@ryanairmail.com>1:vi10ee', 2861591, 1428876103, 2861591)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)





Do you have any suggestion?

Thankyou very much

Regards
armitage318
Advanced member
Advanced member
Posts: 88
Joined: Sat Sep 13, 2014 2:01 am

Issue with backup

Postby armitage318 » Tue Apr 14, 2015 12:09 pm

Hi,

I noticed that with fmt=zip I have no problem at all:



/opt/zimbra/bin/zmmailbox -z -m username@domain.it getRestURL "//?fmt=zip" > /var/backups/username.zip

Return to “Administrators”

Who is online

Users browsing this forum: No registered users and 8 guests