Article ID: 126880, created on Nov 4, 2015, last review on Nov 4, 2015

  • Applies to:
  • Plesk 12.5 for Linux

Sintomi

  1. MySQL non può eseguire l'avvio dopo l'installazione di Plesk e il riavvio del server:

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'(2) exit status 1 
    
  2. Nel file /var/log/mysql/error.log compare il seguente errore:

    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    150902 10:33:16  InnoDB: Unable to open the first data file
    InnoDB: Error in opening ./ibdata1
    150902 10:33:16  InnoDB: Operating system error number 11 in a file operation.
    InnoDB: Error number 11 means 'Resource temporarily unavailable'.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
    150902 10:33:16 InnoDB: Could not open or create data files.
    150902 10:33:16 InnoDB: If you tried to add new data files, and it failed here,
    150902 10:33:16 InnoDB: you should now edit innodb_data_file_path in my.cnf back
    150902 10:33:16 InnoDB: to what it was, and remove the new ibdata files InnoDB created
    150902 10:33:16 InnoDB: in this failed attempt. InnoDB only wrote those files full of
    150902 10:33:16 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
    150902 10:33:16 InnoDB: remove old data files which contain your precious data!
    150902 10:33:16 [ERROR] Plugin 'InnoDB' init function returned error.
    150902 10:33:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    150902 10:33:16 [ERROR] Unknown/unsupported storage engine: InnoDB
    150902 10:33:16 [ERROR] Aborting
    

Causa

Problema relativo al software con id #PPPM-3284; si prevede che la correzione sarà inclusa in uno dei prossimi aggiornamenti di Plesk.

Soluzione

Rimuovere MySQL dallo script init:

    # mv /etc/init/mysql.conf /etc/init/mysql.conf.off  

742559b1631652fadd74764ae8be475e 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF