Processo de backup incompleto

[andregarcia]

Olá Pessoal, estou aqui a um tempo com um problema no meu processo de backup. 
Se por acaso já tiver um topico similar com solução, se alguem puder me mandar eu serei muito grato.

EU configurei um backup externo no cpanel e aparentemente está tudo ok, mas no destino só chegam backups incompletos e os logs apontam geralmente para alguma tabela marcada como trashed. Em todos os sites acontece o mesmo. 

é provável que reparando individualmente (ou não, só suponho) uma ou outra tabela isto resolva, mas são vários sites e fica complicado ficar otimizando e reparando as tabelas individualmente.

Alguém poderia dar um help?

Aqui está um log recente:
 

O processo de backup detectou o(s) seguinte(s) erros:
STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
Cpanel::Exception::ProcessFailed::Error/(XID kb835s) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
“/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
Cpanel::Exception::ProcessFailed::Error/(XID kgtjqr) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
“/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] Failed after 3 times; last error: STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] Cpanel::Exception::ProcessFailed::Error/(XID 2cgptk) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] “/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922

 

 

Consulte o log anexo “/usr/local/cpanel/logs/cpbackup/1616731203.log” para obter mais detalhes.

[2021-03-26 01:13:59 -0300] info [backup] Processing an incremental type backup for integracaoms.. [2021-03-26 01:13:59 -0300] info [backup] Queuing daily backup copy of “integracaoms” for transport of “/backup/2021-03-26/accounts/integracaoms” to “2021-03-26/accounts/integracaoms” [2021-03-26 01:13:59 -0300] info [backup] This particular transport will be queued with keep_local = 0 , based on the need to copy weekly () and/or monthly () copies as well. [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of file: /backup/2021-03-26/accounts/integracaoms [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20663 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of meta file: /backup/2021-03-26/accounts/.master.meta [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20664 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of file: /backup/2021-03-26/backup_incomplete [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20665 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] warn [backup] Pruning of backup files skipped due to errors. at /usr/local/cpanel/bin/backup line 395. bin::backup::run("bin::backup") called at /usr/local/cpanel/bin/backup line 120 [2021-03-26 01:13:59 -0300] info [backup] Executing user defined post backup script (/usr/local/cpanel/scripts/postcpbackup). CleanBackups Plug-in: Detected this script was executed by /scripts/cpbackup CleanBackups Plug-in: auto clean is DISABLED, aborting... [2021-03-26 01:13:59 -0300] info [backup] Queuing removal of staging directories since KEEPLOCAL is disabled. [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20666 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport reporter [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20667 [2021-03-26 01:14:00 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:14:00 -0300] info [backup] Completed at Fri Mar 26 01:14:00 2021 [2021-03-26 01:14:00 -0300] info [backup] Final state is Backup::PartialFailure (0)

[alisson]

4 horas atrás, andregarcia disse:

Olá Pessoal, estou aqui a um tempo com um problema no meu processo de backup. 
Se por acaso já tiver um topico similar com solução, se alguem puder me mandar eu serei muito grato.

EU configurei um backup externo no cpanel e aparentemente está tudo ok, mas no destino só chegam backups incompletos e os logs apontam geralmente para alguma tabela marcada como trashed. Em todos os sites acontece o mesmo. 

é provável que reparando individualmente (ou não, só suponho) uma ou outra tabela isto resolva, mas são vários sites e fica complicado ficar otimizando e reparando as tabelas individualmente.

Alguém poderia dar um help?

Aqui está um log recente:
 

O processo de backup detectou o(s) seguinte(s) erros:
STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
Cpanel::Exception::ProcessFailed::Error/(XID kb835s) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
“/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
Cpanel::Exception::ProcessFailed::Error/(XID kgtjqr) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
“/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] Failed after 3 times; last error: STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] Cpanel::Exception::ProcessFailed::Error/(XID 2cgptk) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] “/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922

 

 

Consulte o log anexo “/usr/local/cpanel/logs/cpbackup/1616731203.log” para obter mais detalhes.

[2021-03-26 01:13:59 -0300] info [backup] Processing an incremental type backup for integracaoms.. [2021-03-26 01:13:59 -0300] info [backup] Queuing daily backup copy of “integracaoms” for transport of “/backup/2021-03-26/accounts/integracaoms” to “2021-03-26/accounts/integracaoms” [2021-03-26 01:13:59 -0300] info [backup] This particular transport will be queued with keep_local = 0 , based on the need to copy weekly () and/or monthly () copies as well. [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of file: /backup/2021-03-26/accounts/integracaoms [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20663 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of meta file: /backup/2021-03-26/accounts/.master.meta [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20664 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of file: /backup/2021-03-26/backup_incomplete [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20665 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] warn [backup] Pruning of backup files skipped due to errors. at /usr/local/cpanel/bin/backup line 395. bin::backup::run("bin::backup") called at /usr/local/cpanel/bin/backup line 120 [2021-03-26 01:13:59 -0300] info [backup] Executing user defined post backup script (/usr/local/cpanel/scripts/postcpbackup). CleanBackups Plug-in: Detected this script was executed by /scripts/cpbackup CleanBackups Plug-in: auto clean is DISABLED, aborting... [2021-03-26 01:13:59 -0300] info [backup] Queuing removal of staging directories since KEEPLOCAL is disabled. [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20666 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport reporter [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20667 [2021-03-26 01:14:00 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:14:00 -0300] info [backup] Completed at Fri Mar 26 01:14:00 2021 [2021-03-26 01:14:00 -0300] info [backup] Final state is Backup::PartialFailure (0)

Também estou com o mesmo problema...

[DELTA SERVERS]

Bom dia,

Acredito que algo no cPanel causou isso, foi notado caso similar aqui, a DB do cliente não deixava nem acessar o phpMyAdmin da conta cPanel dele, removemos a conta, restauramos o backup e esse problema foi sanado.

[LucianoZ]

6 horas atrás, andregarcia disse:

Olá Pessoal, estou aqui a um tempo com um problema no meu processo de backup. 
Se por acaso já tiver um topico similar com solução, se alguem puder me mandar eu serei muito grato.

EU configurei um backup externo no cpanel e aparentemente está tudo ok, mas no destino só chegam backups incompletos e os logs apontam geralmente para alguma tabela marcada como trashed. Em todos os sites acontece o mesmo. 

é provável que reparando individualmente (ou não, só suponho) uma ou outra tabela isto resolva, mas são vários sites e fica complicado ficar otimizando e reparando as tabelas individualmente.

Alguém poderia dar um help?

Aqui está um log recente:
 

O processo de backup detectou o(s) seguinte(s) erros:
STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
Cpanel::Exception::ProcessFailed::Error/(XID kb835s) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
“/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
Cpanel::Exception::ProcessFailed::Error/(XID kgtjqr) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
“/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] Failed after 3 times; last error: STDERR: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] Cpanel::Exception::ProcessFailed::Error/(XID 2cgptk) “/usr/bin/mysqldump” relatou o código de erro “3” quando foi encerrado: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922
[2021-03-26 01:06:18 -0300] “/usr/bin/mysqldump” reported error code “3” when it ended: mysqldump: Error 1194: Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922

 

 

Consulte o log anexo “/usr/local/cpanel/logs/cpbackup/1616731203.log” para obter mais detalhes.

[2021-03-26 01:13:59 -0300] info [backup] Processing an incremental type backup for integracaoms.. [2021-03-26 01:13:59 -0300] info [backup] Queuing daily backup copy of “integracaoms” for transport of “/backup/2021-03-26/accounts/integracaoms” to “2021-03-26/accounts/integracaoms” [2021-03-26 01:13:59 -0300] info [backup] This particular transport will be queued with keep_local = 0 , based on the need to copy weekly () and/or monthly () copies as well. [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of file: /backup/2021-03-26/accounts/integracaoms [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20663 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of meta file: /backup/2021-03-26/accounts/.master.meta [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20664 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport of file: /backup/2021-03-26/backup_incomplete [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20665 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] warn [backup] Pruning of backup files skipped due to errors. at /usr/local/cpanel/bin/backup line 395. bin::backup::run("bin::backup") called at /usr/local/cpanel/bin/backup line 120 [2021-03-26 01:13:59 -0300] info [backup] Executing user defined post backup script (/usr/local/cpanel/scripts/postcpbackup). CleanBackups Plug-in: Detected this script was executed by /scripts/cpbackup CleanBackups Plug-in: auto clean is DISABLED, aborting... [2021-03-26 01:13:59 -0300] info [backup] Queuing removal of staging directories since KEEPLOCAL is disabled. [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20666 [2021-03-26 01:13:59 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:13:59 -0300] info [backup] Queuing transport reporter [2021-03-26 01:13:59 -0300] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:20667 [2021-03-26 01:14:00 -0300] info [backup] leaving queue_backup_transport_item [2021-03-26 01:14:00 -0300] info [backup] Completed at Fri Mar 26 01:14:00 2021 [2021-03-26 01:14:00 -0300] info [backup] Final state is Backup::PartialFailure (0)

O que esta travando seu backup é este problema:
 

Citar

Table 'wp_wsal_metadata' is marked as crashed and should be repaired when dumping table `wp_wsal_metadata` at row: 12922

Sua tabela wp_wsal_metadata esta marcada como crashed, ou seja modo manutenção, ela precisa ser reparada.
Para isso você poderá acessar seu phpmyadmin localizar a tabela e reparar, ou caso preferir, dentro do banco de dados desta tabela no campo SQL digite:
 

Citar

REPAIR TABLE wp_wsal_metadata;

Com isso seus backups voltará ao normal.

Casos comuns de ocorrer esses crashed é desligamento inesperado da VM ou de forma forçada, outras ocasiões não tão comuns pode ocasionar isso também.

[andregarcia]

Obrigado pelas ideias @LucianoZ e @DELTA SERVERS pelas sugestões. @alissonVou deixar aqui o que eu fiz como solução ainda em faze de observação, pois o próximo backup vai executar amanhã. 

comando via ssh logado como root
mysqlcheck --repair --all-databases  
ou mariadb-check --repair --all-databases

O mysql vai analisar e reparar o que for necessário em todas as tabelas de todos os bancos, sem a necessidade de correção individual.

[alisson]

2 horas atrás, andregarcia disse:

Obrigado pelas ideias @LucianoZ e @DELTA SERVERS pelas sugestões. @alissonVou deixar aqui o que eu fiz como solução ainda em faze de observação, pois o próximo backup vai executar amanhã. 

comando via ssh logado como root
mysqlcheck --repair --all-databases  
ou mariadb-check --repair --all-databases

O mysql vai analisar e reparar o que for necessário em todas as tabelas de todos os bancos, sem a necessidade de correção individual.

Muito obrigado!

[andregarcia]

14 horas atrás, alisson disse:

Muito obrigado!

deu certo ai pra ti?  aqui eu rodei um backup e não repetiu o erro.