Error " The website encountered an unexpected error. Try it again later."

By fedemos on 21 Mar 2017 at 16:06 UTC

admin/reports/updates/check?destination=admin/reports/updates Error " El sitio web encontró un error inesperado. Vuelva a intentarlo más tarde."

I can not update drupal 7 !!!

this is the information:

drush cron:

drush cron
WD cron: PDOException: SQLSTATE[HY000]: General error: 144 Table './u805957206_exdeb/batch' is marked as     [error]
crashed and last (automatic?) repair failed: SHOW CREATE VIEW `batch`; Array
(
)
 in backup_migrate_source_db_mysql->query() (line 435 of
/var/www/exdebian/public_html/sites/all/modules/backup_migrate/includes/sources.db.mysql.inc).
WD cron: PDOException: SQLSTATE[HY000]: General error: 144 Table './u805957206_exdeb/batch' is marked as     [error]
crashed and last (automatic?) repair failed: DELETE FROM {batch} 
WHERE  (timestamp < :db_condition_placeholder_0) ; Array
(
    [:db_condition_placeholder_0] => 1489244592
)
 in system_cron() (line 3102 of /var/www/exdebian/public_html/modules/system/system.module).
Cron run successful.                                                                                         [success]

drush up:

drush up
WD php: PDOException: SQLSTATE[HY000]: General error: 144 Table './u805957206_exdeb/batch' is marked as      [error]
crashed and last (automatic?) repair failed: INSERT INTO {batch} (bid, timestamp, token, batch) VALUES
(:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3);
Array
(
    [:db_insert_placeholder_0] => 746
    [:db_insert_placeholder_1] => 1490108714
    [:db_insert_placeholder_2] => tlxNUX0Au-LcrTo9wUcWv20IkYpIcPVTEaho4q4wWqw
    [:db_insert_placeholder_3] =>
a:5:{s:4:"sets";a:1:{i:0;a:15:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:0;s:5:"start";i:0;s:7:"elapsed";i:0;s:8:"finished";s:26:"update_fetch_data_finished";s:4:"file";s:31:"modules/update/update.fetch.inc";s:5:"title";s:10:"Procesando";s:12:"init_message";s:25:"Inicializando.&nbsp;";s:16:"progress_message";s:34:"Se
completaron @current de @total.";s:13:"error_message";s:21:"Ha ocurrido un
error.";s:3:"css";a:0:{}s:5:"total";i:1;s:5:"count";i:1;s:5:"queue";a:2:{s:4:"name";s:18:"drupal_batch:746:0";s:5:"class";s:10:"BatchQueue";}}}s:16:"has_form_submits";b:0;s:11:"current_set";i:0;s:2:"id";s:3:"746";s:11:"progressive";b:1;}
)
 in _drush_backend_batch_process() (line 51 of /usr/share/php/drush/commands/core/drupal/batch.inc).
PDOException: SQLSTATE[HY000]: General error: 144 Table &#039;./u805957206_exdeb/batch&#039; is marked as crashed and last (automatic?) repair failed: INSERT INTO {batch} (bid, timestamp, token, batch) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array
(
    [:db_insert_placeholder_0] => 746
    [:db_insert_placeholder_1] => 1490108714
    [:db_insert_placeholder_2] => tlxNUX0Au-LcrTo9wUcWv20IkYpIcPVTEaho4q4wWqw
    [:db_insert_placeholder_3] => a:5:{s:4:"sets";a:1:{i:0;a:15:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:0;s:5:"start";i:0;s:7:"elapsed";i:0;s:8:"finished";s:26:"update_fetch_data_finished";s:4:"file";s:31:"modules/update/update.fetch.inc";s:5:"title";s:10:"Procesando";s:12:"init_message";s:25:"Inicializando.<br/>&nbsp;";s:16:"progress_message";s:34:"Se completaron @current de @total.";s:13:"error_message";s:21:"Ha ocurrido un error.";s:3:"css";a:0:{}s:5:"total";i:1;s:5:"count";i:1;s:5:"queue";a:2:{s:4:"name";s:18:"drupal_batch:746:0";s:5:"class";s:10:"BatchQueue";}}}s:16:"has_form_submits";b:0;s:11:"current_set";i:0;s:2:"id";s:3:"746";s:11:"progressive";b:1;}
)
 en _drush_backend_batch_process() (línea 51 de /usr/share/php/drush/commands/core/drupal/batch.inc).
Drush command terminated abnormally due to an unrecoverable error.                                           [error]

drush st

drush st
 Drupal version                  :  7.54                              
 Site URI                        :  http://default                    
 Database driver                 :  mysql                             
 Database hostname               :  127.0.0.1                         
 Database username               :  u80957206_edeb                  
 Database name                   :  u80957206_edeb                  
 Database                        :  Connected                         
 Drupal bootstrap                :  Successful                        
 Drupal user                     :  Anónimo                           
 Default theme                   :  exdebian                          
 Administration theme            :  ember                             
 PHP configuration               :  /etc/php5/cli/php.ini             
 Drush version                   :  5.10.0                            
 Drush configuration             :                                    
 Drupal root                     :  /var/www/exdebian/public_html     
 Site path                       :  sites/default                     
 File directory path             :  sites/default/files/media/publico 
 Private file directory path     :  sites/default/files/media/privado 
 Temporary file directory path   :  /tmp

admin/reports/dblog

php	21/03/2017 - 11:44	PDOException: SQLSTATE[HY000]: General error: 144..
Tipo	php
Fecha	Martes, 21 Marzo, 2017 - 11:44
Usuario	fede
Ubicación	https://exdebian.org/admin/reports/updates/update
Referente	https://exdebian.org/admin/reports/updates/update
Mensaje	PDOException: SQLSTATE[HY000]: General error: 144 Table './u805957206_exdeb/batch' is marked as crashed and last (automatic?) repair failed: INSERT INTO {batch} (bid, timestamp, token, batch) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 744 [:db_insert_placeholder_1] => 1490107468 [:db_insert_placeholder_2] => Zs-IfKBtQo1t0rRNDdwWxHSlKl-JExJcyoqacC8SQA0 [:db_insert_placeholder_3] => a:13:{s:4:"sets";a:1:{i:0;a:15:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:0;s:5:"start";i:0;s:7:"elapsed";i:0;s:5:"title";s:27:"Descargando actualizaciones";s:12:"init_message";s:70:"Preparando la descarga de las actualizaciones seleccionadas<br/>&nbsp;";s:8:"finished";s:38:"update_manager_download_batch_finished";s:4:"file";s:33:"modules/update/update.manager.inc";s:16:"progress_message";s:34:"Se completaron @current de @total.";s:13:"error_message";s:21:"Ha ocurrido un error.";s:3:"css";a:0:{}s:5:"total";i:1;s:5:"count";i:1;s:5:"queue";a:2:{s:4:"name";s:18:"drupal_batch:744:0";s:5:"class";s:10:"BatchQueue";}}}s:16:"has_form_submits";b:0;s:10:"form_state";a:3:{s:10:"programmed";b:0;s:7:"rebuild";b:0;s:8:"redirect";N;}s:11:"progressive";b:1;s:11:"current_set";i:0;s:3:"url";s:5:"batch";s:11:"url_options";a:0:{}s:10:"source_url";s:28:"admin/reports/updates/update";s:8:"redirect";N;s:5:"theme";s:5:"ember";s:17:"redirect_callback";s:11:"drupal_goto";s:2:"id";s:3:"744";s:13:"error_message";s:85:"Por favor, continue a <a href="/batch?id=744&amp;op=finished">la página de error</a>";} ) en batch_process() (línea 4699 de /var/www/exdebian/public_html/includes/form.inc).
Gravedad	error
Nombre del servidor	181.165.156.44
Operaciones

System Operative: Debian jessie
Web server: Ngnix

regards...

Comments

Sounds like a problem with the database.

mmjvb commented 21 March 2017 at 18:21

Verify the database with its utilities. There is a problem with the table batch. Suggest to check others as well.

"solve" the problem!!!

fedemos commented 21 March 2017 at 19:42

thanks for your reply
With your advice I have managed to "solve" the problem!!!

Reviewing the information, on March 18 begins the problem.
That day I had a fall of the web server error 502 bad gateway

process:

mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6636
Server version: 5.5.54-0+deb8u1 (Debian)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use u80957206_edeb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> repair table batch;
+------------------------+--------+----------+----------+
| Table                  | Op     | Msg_type | Msg_text |
+------------------------+--------+----------+----------+
| u80957206_edeb.batch | repair | status   | OK       |
+------------------------+--------+----------+----------+
1 row in set (0.14 sec)

Do you recommend another procedure?

regards...