File log errors – what do I do?

  • Resolved baldarch

    (@baldarch)


    11 years ago

    Yesterday I did a number of WP and plugin updates.

    Checking the site today I see a sequence of identical (except for the time stamp) error messages in both log files. The first ones in each file are:
    [05/06/2015 6:24 PM] – SUCCESS : Cronjob_Handler – Hourly cron handler got fired
    [05/06/2015 8:52 PM] – FAILURE : Error inserting record into wp_xxx_aiowps_login_activity

    Please advise what I should do to resolve these problems.

    thanks

    baldarch

    https://ww.wp.xz.cn/plugins/all-in-one-wp-security-and-firewall/

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    11 years ago

    Hi baldarch deactivate all your other plugins except this one. Then enable one by one and at the same time carry out some test.

    Regards

    Thread Starter baldarch

    (@baldarch)

    11 years ago

    Thanks for your reply mbrsolution.

    What test or tests would that be?

    One problem looks like it relates to user logins. Would that be right? (I can’t be sure as there is no other history recorded.)

    But how do I test the other? I don’t know what the cron job is.

    thanks

    baldarch

    Plugin Contributor mbrsolution

    (@mbrsolution)

    11 years ago

    Hi can you check to see if the aiowps log file exist? If it does what permission is the file set to.

    Regards

    Plugin Contributor wpsolutions

    (@wpsolutions)

    11 years ago

    The first log (SUCCESS : Cronjob_Handler – Hourly cron handler got fired) is normal and is nothing to worry about and means that the cron job got triggered correctly.

    The second one could mean that an attempted insertion operation into the database failed. I recommend that you check your server log files – they will show more info regarding any DB errors. (Ask you host provider if you don’t know how to find the server logs files)

    Thread Starter baldarch

    (@baldarch)

    11 years ago

    @wpsolutions

    thanks for the reply.

    I have access to the traffic log file and some of these have no active traffic.

    On the other hand some have POSTS, cron jobs or caching actions immediately before. Some are while admin user is logged in, but not all.

    My concern is that aiowps is trying to post something to the DB and it’s not happening.

    I would appreciate any further advice you could give me.

    thanks

    baldarch

    Plugin Contributor wpsolutions

    (@wpsolutions)

    11 years ago

    Hi,
    I was referring to the server log file not traffic logs.
    Ask your host support people to tell you where you can view general server php errors and database logs.

    Thread Starter baldarch

    (@baldarch)

    11 years ago

    I have checked with the provider and the logs are not publicly accessible. They did a check of their logs.

    They advised that there are no log entries which correspond with any of the aiows log times. They recommended that I direct a support request to you.

    Any further assistance would be appreciated

    thanks

    baldarch

    Plugin Contributor wpsolutions

    (@wpsolutions)

    11 years ago

    How often is the following log being produced and is it still currently being generated?
    FAILURE : Error inserting record into wp_xxx_aiowps_login_activity

    Also, using PHPMyAdmin, can you take a look at the “aiowps_login_activity” table? Are there any entries in that table?

    Thread Starter baldarch

    (@baldarch)

    11 years ago

    Thank you for the reply.

    There are 30 entries in the table, with 26 during the same period as the log entries. There are no suspicious details.

    There are 18 entries in the aiowps log. Below is a list of them, security log details on the left, my comments on the right about what I saw in the DB table.

    The first entry probably commences after WP and several plugins were updated.

    [05/06/2015 8:52 PM] – no login around this time
    [05/07/2015 9:11 AM] – admin logged in 1 min after
    [05/07/2015 9:54 AM] – no login around this time
    [05/07/2015 10:16 AM] – user A
    [05/07/2015 5:59 PM] – admin 1 min later
    [05/07/2015 9:00 PM] – user A single login
    [05/07/2015 9:00 PM] – see above (same time)
    [05/08/2015 9:21 AM] – admin 1 min later
    [05/08/2015 9:26 AM] – user B 1 min later
    [05/08/2015 10:45 AM] – no login around this time
    [05/08/2015 10:50 AM] – user A
    [05/08/2015 3:39 PM] – no login around this time
    [05/08/2015 5:40 PM] – admin
    [05/11/2015 8:31 AM] – no login around this time
    [05/11/2015 8:31 AM] – no login around this time
    [05/11/2015 9:42 AM] – user A
    [05/11/2015 10:16 AM] – no login around this time
    [05/11/2015 4:02 PM] – user B

    In some cases the DB records logins after the log file records them. The DB

    thanks

    baldarch

    Blamedutchie

    (@blamedutchie)

    11 years ago

    Have the same

    “FAILURE : Error inserting record into” notice in my wp-security-log.txt

    PhpMyAdmin : CHECK TABLE gives status OK

    Table contains data from the same day, no corresponding times.
    It appears that sometimes, for some reason, the table is locked when the plugin attempts to write to it…

    No PHP errors.

    Thread Starter baldarch

    (@baldarch)

    11 years ago

    I am now seeing the same error on another site.
    Updated WP and plugins.
    Needed to log back in.
    Checked log: the one and only entry was that very login
    [05/13/2015 7:28 AM] – FAILURE : Error inserting record into wpXXXX_aiowps_login_activity

    A second login had same error as well.

    Thread Starter baldarch

    (@baldarch)

    11 years ago

    Thanks for the 3.9.6 update.

    Issue now resolved on all sites.

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

The topic ‘File log errors – what do I do?’ is closed to new replies.

Tags