Ubuntu-fr

oitsuki

Chaque reboot erreur mysql 5.6

Hello,

Cela commence pardevenir un chiant, à chaque reboot de mon ordinateur, j'ai mysql qui plante.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' in /home/www/clicshopping_test_ui/boutique/includes/ClicShopping/OM/Db/MySQL.php on line 52
( ! ) PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/clicshopping_test_ui/boutique/includes/ClicShopping/OM/Db/MySQL.php on line 52

je suis obligé à chaque fois de faire une réinstallation complète (avec purge) et qui fonctionne 1 fois su 2. Et lors de cette réinstallation il me marque qu'il n'a pas pu changer le mot de passe.

Je pense qu'il y a un bug quelque part.

mon log error mysql

Merci

60101 13:26:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-01-01 13:26:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-01-01 13:26:08 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-0ubuntu1) starting as process 1048 ...
2016-01-01 13:26:08 1048 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2016-01-01 13:26:08 1048 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2016-01-01 13:26:08 1048 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2016-01-01 13:26:08 1048 [Note] Plugin 'FEDERATED' is disabled.
2016-01-01 13:26:08 1048 [ERROR] Function 'innodb' already exists
2016-01-01 13:26:08 1048 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2016-01-01 13:26:08 1048 [ERROR] Function 'federated' already exists
2016-01-01 13:26:08 1048 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2016-01-01 13:26:08 1048 [ERROR] Function 'blackhole' already exists
2016-01-01 13:26:08 1048 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2016-01-01 13:26:08 1048 [ERROR] Function 'archive' already exists
2016-01-01 13:26:08 1048 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2016-01-01 13:26:08 1048 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-01 13:26:08 1048 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-01 13:26:08 1048 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-01-01 13:26:08 1048 [Note] InnoDB: Memory barrier is not used
2016-01-01 13:26:08 1048 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-01-01 13:26:08 1048 [Note] InnoDB: Using Linux native AIO
2016-01-01 13:26:08 1048 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-01 13:26:08 1048 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-01-01 13:26:08 1048 [Note] InnoDB: Completed initialization of buffer pool
2016-01-01 13:26:08 1048 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-01 13:26:08 1048 [Note] InnoDB: The log sequence numbers 1776090 and 1776090 in ibdata files do not match the log sequence number 1785566 in the ib_logfiles!
2016-01-01 13:26:08 1048 [Note] InnoDB: Database was not shutdown normally!
2016-01-01 13:26:08 1048 [Note] InnoDB: Starting crash recovery.
2016-01-01 13:26:08 1048 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-01 13:26:09 1048 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace test_vin/kfm_directories uses space ID: 23 at filepath: ./test_vin/kfm_directories.ibd. Cannot open tablespace phpmyadmin/pma__column_info which uses space ID: 23 at filepath: ./phpmyadmin/pma__column_info.ibd
2016-01-01 13:26:09 b72f7700  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./phpmyadmin/pma__column_info.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
160101 13:26:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
2016-01-01 13:52:36 9006 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2016-01-01 13:52:36 9006 [Note] Plugin 'FEDERATED' is disabled.
2016-01-01 13:52:36 9006 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-01 13:52:36 9006 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-01 13:52:36 9006 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-01-01 13:52:36 9006 [Note] InnoDB: Memory barrier is not used

un pt tail