Jump to content
Portal do Host

Processo de backup incompleto


Recommended Posts

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)
Link to comment
Share on other sites


  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.



×
×
  • Create New...