Error messages

  • Resolved rkingisl

    (@rkingisl)


    10 months, 1 week ago

    Hello,

    I’m receiving several error messages logged to my “slow-queries.log” file every day. I’m wondering if it’s causing some of the 500 or 503 errors I’m sometimes experiencing when editing the website:

    User@Host: [db-name] @ localhost [] Id: 500 Schema: [db-name] Last_errno: 0 Killed: 0 Query_time: 4.772710 Lock_time: 0.000096 Rows_sent: 1 Rows_examined: 3108149 Rows_affected: 0 Bytes_sent: 85

    SET timestamp=1755086408;
    SELECT count( DISTINCT occasionsID )
    FROM wp_simple_history
    WHERE date >= DATE_ADD(CURDATE(), INTERVAL -14 DAY);

    Is this normal? Can anyone suggest a solution?

    Thank you in advance.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Pär Thernström

    (@eskapism)

    10 months ago

    It looks like you have a very large amount of logged data. Could you go to Simple History -> Debug and check what loggers have logged so much? It would help me to debug the reason for this.

    Thread Starter rkingisl

    (@rkingisl)

    10 months ago

    Thank you for your reply. I can’t see any debug submenu. Is it a premium-only feature? I had disabled the plugin and emptied the tables from my database, so I’m afraid that might have eliminated the logs anyway. I had 3GB of data in the wp_simple_history_contexts table and 659MB in the wp_simple_history table. I’ve re-enabled the plugin and will monitor it over the next week or so to see if I continue to get errors and if the database tables increase dramatically.

    Could you let me know what I could try if this continues to be a problem? And why would Simple History maintain almost 4GB of data in my database? Can I change the retention time or something to prevent this?

    Thank you again.

    Thread Starter rkingisl

    (@rkingisl)

    9 months, 4 weeks ago

    Hello,

    I exported the logs for the past few days, but there’s not much info. Please let me know if I can do anything else:
    https://docs.google.com/spreadsheets/d/1LNmFWMCm1eHM8kBIbyVEan35S83qDWBGv4QD7KXlsv0/edit?usp=sharing

    Thread Starter rkingisl

    (@rkingisl)

    9 months, 4 weeks ago

    And to confirm, my database has over 260,000 rows as of now. It seems like an awful lot and seems to be causing my automatic backups to behave very slowly. Would a full uninstall and reinstall help? I don’t need the past data. Any help would be very much appreciated.

    Plugin Author Pär Thernström

    (@eskapism)

    9 months, 3 weeks ago

    Thanks for the logs. It seems like there is a very large amount of login attempts to your website. Simple History does log all login attempts, both successful and failed, and also to both existing and non-existing users. Personally I’ve never had any issues with this since none of the websites I have managed never had this amount of logins logged. So in your case this large amount is causing the log to be large too.

    There are a few options I can think of to handle this:

    Thread Starter rkingisl

    (@rkingisl)

    9 months, 3 weeks ago

    Thank you very much. I’ll look into this further.

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

The topic ‘Error messages’ is closed to new replies.