since upgrading to 7.501 (from 7.4 something) I'm getting continous "Database Conversion Started" emails - every day. Interestingly enough that's only from one box...
I have the same problem, reason for getting this every day is I guess is because the conversion never gets completed out of one or another reason. When checking the HW reports I can see that the conversion attempt starts 8 PM every day and try to complete the task until 5 AM the following morning. With 100% CPU load during this time! Have read some other thread about this and that it should be connected with a corrupt database? Have you manage to solve your problem?
I have the same problem, reason for getting this every day is I guess is because the conversion never gets completed out of one or another reason. When checking the HW reports I can see that the conversion attempt starts 8 PM every day and try to complete the task until 5 AM the following morning. With 100% CPU load during this time! Have read some other thread about this and that it should be connected with a corrupt database? Have you manage to solve your problem?
Unfortunately...
a) I don't see any CPU peaks in the hardware report. I guess that box is far to big regarding the CPUs.
b) Astaro refused to help me and simply told me that "this could need a few days until completion". Bah.
I might run a script on the firewall to dump the running processes every minute and check, what's going on. Hopefully this will get me more insight into this problem.
I'm having the same issue. As far as the conversion taking a few days is concerned, I've been receiving these emails for more than a month after updating to version 7.5. I get the notion that if the conversion hasn't finished yet, then it never will. Anyone else have a possible solution?
There is likely an issue with one of the reporting / accounting databases; if you have a support contract, I'd start a case with Astaro; they can reset the databases. If not, I'd just backup the current configuration, reload from .iso, and restore the configuration; this should fix things.
CTO, Convergent Information Security Solutions, LLC
Advice given as posted on this forum does not construe a support relationship or other relationship with Convergent Information Security Solutions, LLC or its subsidiaries. Use the advice given at your own risk.
After digging in the logs, it looks like the database isn't complete. The following log lines are written 3 to 4 times a second:
2010:05:21-00:00:13 GLBFIR01 system[8776]: dataconversion_74: starting conversion for mailsec (733854)
2010:05:21-00:00:13 GLBFIR01 postgres[8796]: [287957-1] ERROR: column "srccountry" of relation "mailsec" does not exist at character 37
2010:05:21-00:00:13 GLBFIR01 postgres[8796]: [287957-2] STATEMENT: insert into mailsec (dayabs, srcip, srccountry, srcuser, srcdomain, dstip, dstuser, dstdomain, proto, type, reason,
2010:05:21-00:00:13 GLBFIR01 postgres[8796]: [287957-3] mailcount, mailsize) select dayabs, srcip, srccountry, srcuser, srcdomain, dstip, dstuser, dstdomain, proto, type, reason,
2010:05:21-00:00:13 GLBFIR01 postgres[8796]: [287957-4] sum(mailcount) as mailcount, sum(mailsize) as mailsize from mailsec_7400 where dayabs = 733854 group by dayabs, srcip,
2010:05:21-00:00:13 GLBFIR01 postgres[8796]: [287957-5] srccountry, srcuser, srcdomain, dstip, dstuser, dstdomain, proto, type, reason
2010:05:21-00:00:13 GLBFIR01 system[8776]: dataconversion_74: data conversion failed for mailsec: ERROR: column "srccountry" of relation "mailsec" does not exist LINE 1: insert into mailsec (dayabs, srcip, srccountry, srcuser, src... ^
2010:05:21-00:00:13 GLBFIR01 postgres[8796]: [287958-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2010:05:21-00:00:13 GLBFIR01 postgres[8796]: [287958-2] STATEMENT: delete from mailsec_7400 where dayabs = 733854
2010:05:21-00:00:13 GLBFIR01 system[8776]: dataconversion_74: delete from mailsec failed: ERROR: current transaction is aborted, commands ignored until end of transaction block
2010:05:21-00:00:13 GLBFIR01 system[8776]: dataconversion_74: finished conversion for mailsec (733854)
