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...
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)
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)
