Jump to content

MariaDB/MySQL deletando tabelas sozinho


the_superman

Recommended Posts

Recebi dois chamados de clientes na última semana dizendo que não consegue fazer login no painel do WordPress.

Quando abro o phpMyAdmin e olho o banco de dados vejo que a tabela "wp_users" do WordPress não existe.

É a segunda vez que isso me ocorre e me deixa muito preocupado pois se o servidor está deletando dados sozinho, imagina o estrago.

Estou usando MariaDB v10.4.21.

 

Gostaria de mandar mais dados neste tópico para ajudar a resolver este problema mas eu realmente não tenho ideia do que seja.

 

[root@hidden ~]# service mysql status
Redirecting to /bin/systemctl status mysql.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since Sat 2021-10-30 21:16:46 -03; 9h ago
  Process: 2188820 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 2188746 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] &&   systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 2188743 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 2188765 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 46 (limit: 48594)
   Memory: 1.4G
   CGroup: /system.slice/mariadb.service
           └─2188765 /usr/sbin/mysqld

Oct 31 00:12:02 example.com mysqld[2188765]: 2021-10-31  0:12:02 14169 [ERROR] mysqld: Table './forne302_wrdp2/wp_commentmeta' is marked as crashed and should be repaired
Oct 31 00:12:02 example.com mysqld[2188765]: 2021-10-31  0:12:02 14169 [Warning] Checking table:   './forne302_wrdp2/wp_commentmeta'
Oct 31 00:13:39 example.com mysqld[2188765]: 2021-10-31  0:13:39 14299 [ERROR] mysqld: Table './naturalstarcaps_main/wpum_woocommerce_sessions' is marked as crashed and should be repaired
Oct 31 00:13:39 example.com mysqld[2188765]: 2021-10-31  0:13:39 14299 [Warning] Checking table:   './naturalstarcaps_main/wpum_woocommerce_sessions'
Oct 31 00:13:46 example.com mysqld[2188765]: 2021-10-31  0:13:46 14313 [ERROR] mysqld: Table './organotron_sitetds/wppf_loginizer_logs' is marked as crashed and should be repaired
Oct 31 00:13:46 example.com mysqld[2188765]: 2021-10-31  0:13:46 14313 [Warning] Checking table:   './organotron_sitetds/wppf_loginizer_logs'
Oct 31 00:14:47 example.com mysqld[2188765]: 2021-10-31  0:14:47 14402 [ERROR] mysqld: Table './publio_EmpregosPTCcurriculos/wp_broptions' is marked as crashed and should be repaired
Oct 31 00:14:47 example.com mysqld[2188765]: 2021-10-31  0:14:47 14402 [Warning] Checking table:   './publio_EmpregosPTCcurriculos/wp_broptions'
Oct 31 02:32:32 example.com mysqld[2188765]: 2021-10-31  2:32:32 26650 [Warning] Access denied for user 'tattoocontrol_you'@'localhost' (using password: YES)
Oct 31 06:24:01 example.com mysqld[2188765]: 2021-10-31  6:24:01 49057 [Warning] Aborted connection 49057 to db: 'unconnected' user: 'unauthenticated' host: 'scanner-04.ch1.censys-scanner.com' (This connection closed normally without authentication)

 

 

Link to comment
Share on other sites

Eu estou com cliente também que os plugins dele esta consultando a tabela e apagando tudo por lá pelo cpanel, mas já informei ao cliente que poderia ser a procedência dos plugins, pelo fato de ser da hotmart que no meu entender alteram o nome e usam como se fosse autores dos mesmo.

No caso até ajudei meu cliente a refazer o site mas o problema continuou e usando os mesmo plugins e tema que lá comprou.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Do you agree with our terms?