Catégorie : Incident

Replication bloquée : mysql 4.1.2

Bonjour, Encore un incident mysql sur un serveur de réplication , c’est un incident courant dans ce contexte de production .   Incident:   :   show slave status\G; Replicate_Wild_Do_Table:...

by dbaexpertconsulting
Read More

ORA-12560: TNS:protocol adapter error

Un petit article afin d’apporter une touche sur l’incident de connexion sur une base oracle 11g. C:\Users\noury>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Ven. Oct. 14 14:08:46 2016...

by dbaexpertconsulting
Read More

Host ‘host_name’ is blocked because of many connection errors

Incident : Host ‘host_name’ is blocked because of many connection errors. Unblock with ‘mysqladmin flush-hosts’ The value of the max_connect_errors system variable determines how many successive interrupted connection requests are...

by dbaexpertconsulting
Read More

Lock wait timeout exceeded

Incident : 161004 18:47:32 [ERROR] /opt/mysql/product/5.1.73/bin/mysqld: Lock wait timeout exceeded; try restarting transaction 161004 18:47:32 [ERROR] /opt/mysql/product/5.1.73/bin/mysqld: Sort aborted solution: modification du parametre :  innodb_lock_wait_timeout qui passe de 50 seconds...

by dbaexpertconsulting
Read More