- attached ExportIssue1.JPG
Exports Not Working..Cannot Export a whole month of messages
I cannot seem to export a whole month's worth of email. I can only export up to 18 days out of the month even though there are more days with email. We've been archiving email since August 12th 2014. (I downloaded a VMware OVF image that you had available in August.) I can export the partial month as long as I choose a stop date of: 2014.09.18 or earlier in the month. The VM has 2GB of RAM and I don't see any peaks in RAM or CPU usage. I've attached a screen shot of the commands I ran trying to get the full month of September exported. As you can see, I worked backwards until I got down to the 18th and the export started running. Please help. Thanks much. Jim
This does not work: /var/pilerbackups# pilerexport --start-date 2014.09.01 --stop-date 2014.09.31 This does work: pilerexport --start-date 2014.09.01 --stop-date 2014.09.18
Comments (16)
-
reporter -
reporter -
assigned issue to
-
assigned issue to
-
repo owner Can you see any errors in the logs in /var/log?
-
repo owner How many emails do you have for this September? Is t there any clue in the logs?
-
reporter I've been out sick for a few days. (Thanks for your reply.) We have several full months of email archived starting in August through today. I can search and find email for the whole month of September using the audit function in the web interface. This is really a strange problem. I'm going to try to Export the whole month of October. I'll let you know what happens. Thanks, Jim
-
reporter - attached Piler2.JPG
I tried to export the whole month of October and nothing happened. Then I tried using some different date ranges within October. As you can see there were 2 times when the export started and I hit Ctrl-C. The other tries nothing happened although the last 3 times or so I had to hit Ctrl-C after a few minutes as the program hung. If I use the command: "pilerexport -A" the export starts immediately. Do you think that there's a bug in the program or something wrong with the VM?
Would you have a newer version of the PilerExport utility that I could try? Thanks, JK -
repo owner Unfortunately pilerexport is the only way to export messages. Pilerget may be another way to get individual messages provided that you know the exact piler id. I assume no errors or warnings in maillog, right?
-
reporter Ha...I did find an error in the mail.log. Here it is: Nov 21 15:37:14 piler pilerexport[3005]: 40000000546fccae3641afc4003ca496f05c: mysql_stmt_execute error: Error writing file '/tmp/MYSn5Ies' (Errcode: 28)
Thanks, Jim
-
repo owner What could be the cause of such an error? Do you have enough space under /tmp?
-
reporter I'm attaching a file showing what the VM has for space. Thanks, Jim
-
reporter - attached ExportIssue3_DriveSpace.JPG
-
repo owner OK, I believe you :-) I think I need some on-site debugging by tweaking the utils to see what's going on. Is there a remote session possible?
-
reporter Thanks, yes I can setup a WebEx session for you. Would definitely welcome some help. I'm available today after 10:30 PST. Will be here till at least 5:00 PM PST today. (Located in Washington State USA) My contact information: 509-881-2396 jimk@dcpud.org If you need me to I can work after hours. Please let me know what works for you. Thanks much, Jim
-
repo owner Just sent you an email, let's discuss things in private, and post only the solution here.
-
repo owner - changed status to resolved
In case of a problem, always check the log files. It appeared that mysql complained that it couldn't write /tmp/XXXXX file (error 28) which means no space left on device, even though it had ~100 MB free space.
I've extended the /tmp partition (LVM is to the rescue) by +1 GB, and the issue is solved.
-
reporter Janos,
Thanks for helping us get this resolved!
Jim
- Log in to comment