Mysql database stop

  • gasparo

    (@gasparo)


    11 years, 5 months ago

    Were is wrong i dont find the problem?
    Table prefix is revmisc

    Version: ‘5.5.38-0ubuntu0.12.04.1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 (Ubuntu)
    141016 7:26:54 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscaiowps_failed_logins’ is marked as crashed and should be repaired
    141016 7:26:54 [Warning] Checking table: ‘./xxx/revmiscaiowps_failed_logins’
    141016 7:26:54 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscaiowps_login_activity’ is marked as crashed and should be repaired
    141016 7:26:54 [Warning] Checking table: ‘./xxx/revmiscaiowps_login_activity’
    141016 7:26:54 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscaiowps_login_lockdown’ is marked as crashed and should be repaired
    141016 7:26:54 [Warning] Checking table: ‘./xxx/revmiscaiowps_login_lockdown’
    141016 7:26:56 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscoptions’ is marked as crashed and should be repaired
    141016 7:26:56 [Warning] Checking table: ‘./xxx/revmiscoptions’
    141016 7:26:56 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscpostmeta’ is marked as crashed and should be repaired
    141016 7:26:56 [Warning] Checking table: ‘./xxx/revmiscpostmeta’
    141016 7:26:58 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscposts’ is marked as crashed and should be repaired
    141016 7:26:58 [Warning] Checking table: ‘./xxx/revmiscposts’
    141016 7:27:01 [ERROR] /usr/sbin/mysqld: Table ‘./xxx/revmiscterm_relationships’ is marked as crashed and should be repaired
    141016 7:27:01 [Warning] Checking table: ‘./xxx/revmiscterm_relationships’

    https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/

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

    (@mbrsolution)

    11 years, 5 months ago

    Hi gasparo is the first time this happens?

    Thread Starter gasparo

    (@gasparo)

    11 years, 5 months ago

    No ,when i have a lot of visitor is crash

    Plugin Contributor mbrsolution

    (@mbrsolution)

    11 years, 5 months ago

    Have you spoken to your server administrator? Or your Host?

    Thread Starter gasparo

    (@gasparo)

    11 years, 5 months ago

    yes an he said is no problem with that, the plugin is the reson

    Plugin Contributor mbrsolution

    (@mbrsolution)

    11 years, 5 months ago

    Hi are you running the latest version? If you are then one of the developers will check this issue for you.

    Kind regards

    Plugin Contributor wpsolutions

    (@wpsolutions)

    11 years, 5 months ago

    @gasparo,
    Such errors have never occurred before due to the AIOWPS plugin which is why I’m a little puzzled at your situation.

    Can you check how many rows are in the “aiowps_events” table?

    This table can grow rather large if you have the “Enable IP Lockout For 404 Events” in the firewall menu active and if you’re being hammered by bots which are continually generating 404 events.

    If that table if it is very big you might need to manually delete the entries from phpmyadmin and also deactivate the “Enable IP Lockout For 404 Events” feature for now.
    We are applying an improvement to the next version of the plugin which will automatically ensure that this table does not get bigger than a certain size.

    Thread Starter gasparo

    (@gasparo)

    11 years, 5 months ago

    Were i look for in php my admin?
    Utilizare spațiu
    Tip Utilizare
    Date 0 octeți
    Index 1,024 octeți
    Total 1,024 octeți
    Statisticile rîndului
    Comenzi Valoare
    Format dinamic
    Interclasare utf8_general_ci
    Linie 0
    Următorul Autoindex 1
    Creare 06 Aug 2014 la 13:02
    Ultima actualizare 16 Oct 2014 la 09:03
    Ultima verficare 16 Oct 2014 la 09:03

    Plugin Contributor wpsolutions

    (@wpsolutions)

    11 years, 5 months ago

    Yes use PHPMyAdmin to check how many rows that table has.

    Thread Starter gasparo

    (@gasparo)

    11 years, 5 months ago

    9 rows
    1 id bigint(20) Nu None AUTO_INCREMENT
    2 event_type varchar(150) utf8_general_ci Nu
    3 username varchar(150) utf8_general_ci Da
    4 user_id bigint(20) Da NULL
    5 event_date datetime Nu 0000-
    6 ip_or_host varchar(100) utf8_general_ci Da
    7 referer_info varchar(255) utf8_general_ci Da
    8 url varchar(255) utf8_general_ci Da NULL
    9 event_data longtext utf8_general_ci Da

    Plugin Contributor wpsolutions

    (@wpsolutions)

    11 years, 5 months ago

    The information you’ve provided actually describes the columns of the table not how many entries there are in it.

    I meant how many rows of data have already been inserted into that table.
    When you view that table in MySQL you will see something like the following message displayed at the top:

    Showing rows 0 – 24 (779 total, Query took 0.0201 sec)

    The example above shows that there are 779 rows in the table.

    Thread Starter gasparo

    (@gasparo)

    11 years, 5 months ago

    MySQL a dat un set de rezultate gol (zero linii). ( comanda a durat 0.0005 sec )

    MySQL returned an empty result set (zero line). (Command took 0.0005 sec)

    But now is shut down

    Plugin Contributor wpsolutions

    (@wpsolutions)

    11 years, 5 months ago

    Ok thanks – looks like you do not have any entries in that table.

    I cannot see any reason for the plugin to be causing the issue.
    Did you take the recommended DB backup before you changed the DB prefix? If so, I would strongly suggest that you restore the DB backup file.

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

The topic ‘Mysql database stop’ is closed to new replies.