Database issues related to wp_adrotate_tracker

  • Resolved codings

    (@codings)


    1 week, 5 days ago

    Pro user here. On a cloud server with the highest tier or performance, the host shut down access to the database and pointed to mysql_abuse_report logs that are filled with entries that look like this:

    Database User: database1000 
    Database: u1000_database1000 
    Time_s: 6.345343 
    Time_ms: 6345.343000 
    Query: 
    SELECT 'timer' FROM 'wp_adrotate_tracker' WHERE ipaddress = '8.222.185.10' AND 'stat' = 'i' AND 'bannerid' = 5 ORDER BY 'timer' DESC LIMIT 1

    There were other AdRotate errors as well, including entries containing “duplicate-ads” \ “adverts” \ “timeout” \ “post-000” and ‘wp_adrotate_schedule’.

    Any ideas of what could be going on?

    Thank you

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Arnan

    (@adegans)

    1 week, 5 days ago

    If you have AdRotate Pro please open a ticket through your dashboard, or via the support links on my website.

    If you have them, include the other errors so I can look into what goes wrong.
    Is the query you mentioned consistently slow? Or just the one time?

    Also, if you can, try to find out how many records your tracker table has – It shouldn’t be a lot, couple of thousand or less, usually.

    Make sure you include your order number or license key with the ticket. Thanks!

    Thread Starter codings

    (@codings)

    1 week, 5 days ago

    Sorry, I always thought you were handling support in these forums for free and pro. Probably didn’t need to mention the Pro part. Will look into the support links on your site. Thank you!

    The query is consistently slow, not just one time. I gave one sample entry in the error logs, but there are dozens of the same error, from different ipaddress and bannerid combos.

    Some examples of the times:

    • Time_s: 10.077903
      Time_ms: 10077.903000
    • Time_s: 5.853397
      Time_ms: 5853.397000
    • Time_s: 0
      Time_ms: 266.009

    The longest running banner has been shown 13,000,000 times and clicked 800 times (maybe it’s time to explore that banner’s CTR lol).

    Most of the entries are just wp_adrotate_tracker. There was one really long UPDATE wp_options SET option_value that contained the other queries mentioned above. Also one instance of wp_adrotate_schedule. I think these are not the same issue and could be related to making a lot of changes to banners a few days ago (editing, adding banner media, resetting some stats, etc.)

    Plugin Author Arnan

    (@adegans)

    1 week, 5 days ago

    The table is probably holding too much data. AdRotate should clean that up every day or so.

    Make sure the background process is working, you can see that in Settings > Maintenance. If a scheduled task is missing you can reset it from there also.
    When the task first runs the site may be sluggish during the cleanup, depending on much records you have in there, but after that it should work better.

    If you want me to investigate or advise you further please open a ticket with more information.

    Thread Starter codings

    (@codings)

    1 week, 5 days ago

    Delete expired trackerdata: Not scheduled!

    I reset background tasks. Now the current date shows up: July 13, 2026 20:05. We’ll see what happens at 20:05 tonight.

    Thank you for spending time on this. I appreciate your plugin and support.

    Plugin Author Arnan

    (@adegans)

    1 week, 4 days ago

    Aha, that should do it! 🥳

    Thread Starter codings

    (@codings)

    1 week, 4 days ago

    Delete expired tracker data: July 14, 2026 20:05

    The background tasks scheduler updated. Seems to be working. Thank you again.

    Plugin Author Arnan

    (@adegans)

    1 week, 3 days ago

    Woohoo! 😅

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.