1 (edited by lymkin 2016-08-23 21:20:25)

Topic: SOLVED: iredapd SQL query issue after upgrade

==== Required information ====
- iRedMail version (check /etc/iredmail-release):  0.9.5-1
- Linux/BSD distribution name and version: Ubuntu 14.04.5 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue:  iredapd.log
====

I just upgraded from version 0.9.4 to 0.9.5 to 0.9.5-1 and I am now seeing a double query to the SQL database in the iredapd.log file (see log below).  I'm not sure what is making these calls or I could potentially fix it myself.  I know it wasn't doing this before the upgrade.  Any idea how to fix this?

Thanks in advance.

2016-08-22 12:30:01 INFO * Query SQL server to get mail domain names.
2016-08-22 12:30:01 INFO * Query SQL server to get mail domain names.
2016-08-22 12:30:01 INFO * Parsing domains, 36 in total.
2016-08-22 12:30:01 INFO        + [amazon.com]
2016-08-22 12:30:01 INFO * Parsing domains, 36 in total.
2016-08-22 12:30:01 INFO        + [amazon.com]
2016-08-22 12:30:01 INFO        + [aol.com]
2016-08-22 12:30:01 INFO        + [aol.com]
2016-08-22 12:30:01 INFO        + [constantcontact.com]
2016-08-22 12:30:01 INFO        + [constantcontact.com]
2016-08-22 12:30:02 INFO        + [craigslist.org]
2016-08-22 12:30:02 INFO        + [craigslist.org]
2016-08-22 12:30:02 INFO        + [cust-spf.exacttarget.com]
2016-08-22 12:30:02 INFO        + [cust-spf.exacttarget.com]
2016-08-22 12:30:02 INFO        + [ebay.com]
2016-08-22 12:30:02 INFO        + [ebay.com]
2016-08-22 12:30:02 INFO        + [exacttarget.com]
2016-08-22 12:30:02 INFO        + [exacttarget.com]
2016-08-22 12:30:02 INFO        + [facebook.com]
2016-08-22 12:30:02 INFO        + [facebook.com]
2016-08-22 12:30:02 INFO        + [fbmta.com]
2016-08-22 12:30:02 INFO        + [fbmta.com]
2016-08-22 12:30:02 INFO        + [fishbowl.com]
2016-08-22 12:30:02 INFO        + [fishbowl.com]
2016-08-22 12:30:02 INFO        + [github.com]
2016-08-22 12:30:02 INFO        + [github.com]
2016-08-22 12:30:02 INFO        + [gmx.com]
2016-08-22 12:30:02 INFO        + [gmx.com]
2016-08-22 12:30:02 INFO        + [google.com]
2016-08-22 12:30:02 INFO        + [google.com]
2016-08-22 12:30:02 INFO        + [hotmail.com]
2016-08-22 12:30:02 INFO        + [hotmail.com]
2016-08-22 12:30:02 INFO        + [icloud.com]
2016-08-22 12:30:02 INFO        + [icloud.com]
2016-08-22 12:30:02 INFO        + [icontact.com]
2016-08-22 12:30:02 INFO        + [icontact.com]
2016-08-22 12:30:02 INFO        + [inbox.com]
2016-08-22 12:30:02 INFO        + [inbox.com]
2016-08-22 12:30:03 INFO        + [instagram.com]
2016-08-22 12:30:03 INFO        + [instagram.com]
2016-08-22 12:30:03 INFO        + [linkedin.com]
2016-08-22 12:30:03 INFO        + [linkedin.com]
2016-08-22 12:30:03 INFO        + [mail.com]
2016-08-22 12:30:03 INFO        + [mail.com]
2016-08-22 12:30:03 INFO        + [mailchimp.com]
2016-08-22 12:30:03 INFO        + [mailchimp.com]
2016-08-22 12:30:03 INFO        + [mailgun.com]
2016-08-22 12:30:03 INFO        + [mailgun.com]
2016-08-22 12:30:03 INFO        + [mailjet.com]
2016-08-22 12:30:03 INFO        + [mailjet.com]
2016-08-22 12:30:03 INFO        + [microsoft.com]
2016-08-22 12:30:03 INFO        + [microsoft.com]
2016-08-22 12:30:03 INFO        + [outlook.com]
2016-08-22 12:30:03 INFO        + [paypal.com]
2016-08-22 12:30:03 INFO        + [outlook.com]
2016-08-22 12:30:03 INFO        + [paypal.com]
2016-08-22 12:30:03 INFO        + [pinterest.com]
2016-08-22 12:30:03 INFO        + [pinterest.com]
2016-08-22 12:30:03 INFO        + [reddit.com]
2016-08-22 12:30:03 INFO        + [reddit.com]
2016-08-22 12:30:03 INFO        + [sendgrid.com]
2016-08-22 12:30:03 INFO        + [sendgrid.com]
2016-08-22 12:30:03 INFO        + [tumblr.com]
2016-08-22 12:30:03 INFO        + [tumblr.com]
2016-08-22 12:30:03 INFO        + [twitter.com]
2016-08-22 12:30:03 INFO        + [twitter.com]
2016-08-22 12:30:03 INFO        + [yahoo.com]
2016-08-22 12:30:03 INFO        + [yahoo.com]
2016-08-22 12:30:03 INFO        + [yandex.ru]
2016-08-22 12:30:03 INFO        + [yandex.ru]
2016-08-22 12:30:03 INFO        + [zendesk.com]
2016-08-22 12:30:03 INFO        + [zendesk.com]
2016-08-22 12:30:03 INFO        + [zoho.com]
2016-08-22 12:30:03 INFO        + [zoho.com]

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: SOLVED: iredapd SQL query issue after upgrade

Please check root user's cron job, there's a duplicate job.

3

Re: SOLVED: iredapd SQL query issue after upgrade

That was it.  I had looked at the daily/weekly/etc cron jobs but totally forgot about the user specific jobs since I'm not a Linux expert.  Thanks for the help!!!