J'avais des problèmes d'insertion : certains champs non appelés dans mes queries requéraient une valeur... J'ai trouvé plusieurs discussions à ce sujet sur StackOverFlow lesquelles pointaient toutes vers une solution qui disait de mettre sql-mode="" ou sql-mode= "NO_ENGINE_SUBSTITUTION" dans le my.ini/ Ce que je fis.
Depuis le service ne démarre plus; même si je remets le fichier dans son état d'origine.
Quand je vais sur phpMyAdmin, j'ai l'erreur suivante : mysqli_real_connect(): (HY000/2002): Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée. J Merci
Modifie 1 fois. Derniere modification le 21/09/2020 à 09:11 par webmar.
Voici ce que j'ai actuellement dans my.ini, à la ligne sql-mode : ; Set the SQL mode ;sql-mode="" ;sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER" ;sql-mode="NO_ENGINE_SUBSTITUTION"
Dans le journal d'événements, j'ai effectivement des erreurs : Le service wampmariadb64 s’est terminé de façon inattendue pour la 3ème fois.
J'y trouve aussi des "informations" pouvant concorder avec l'heure à laquelle j'ai voulu changer le sql-mode, mais je n'ai aucune idée de ce que ça veut dire et de si ça a le moindre rapport
"L’historique des accès de la ruche \SystemRoot\System32\config\DRIVERS a été effacé, mettant à jour 22148 clés et créant 1000 pages modifiées."
Voici un tronçon du log :
2020-09-13 12:27:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2020-09-13 12:27:11 0 [Note] InnoDB: Uses event mutexes 2020-09-13 12:27:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-09-13 12:27:11 0 [Note] InnoDB: Number of pools: 1 2020-09-13 12:27:11 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-09-13 12:27:11 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2020-09-13 12:27:11 0 [Note] InnoDB: Completed initialization of buffer pool 2020-09-13 12:27:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=600432091 2020-09-13 12:27:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-09-13 12:27:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-09-13 12:27:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-09-13 12:27:12 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-09-13 12:27:12 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2020-09-13 12:27:12 0 [Note] InnoDB: Waiting for purge to start 2020-09-13 12:27:12 0 [Note] InnoDB: 10.4.10 started; log sequence number 600432100; transaction id 594846 2020-09-13 12:27:12 0 [Note] InnoDB: Loading buffer pool(s) from c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-13 12:27:12 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-09-13 12:27:12 0 [Note] Server socket created on IP: '::'. 2020-09-13 12:27:12 0 [Note] InnoDB: Buffer pool(s) load completed at 200913 12:27:12 2020-09-13 12:27:12 0 [Note] Reading of all Master_info entries succeeded 2020-09-13 12:27:12 0 [Note] Added new Master_info '' to hash table 2020-09-13 12:27:12 0 [Note] wampmariadb64: ready for connections. Version: '10.4.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2020-09-13 12:27:15 9 [ERROR] mysqld.exe: La table '.\ecom\cart' est marquée 'crashed' et devrait être réparée 2020-09-13 12:27:15 9 [Warning] Checking table: '.\ecom\cart' 2020-09-13 12:27:20 10 [ERROR] mysqld.exe: La table '.\ecom\customers' est marquée 'crashed' et devrait être réparée 2020-09-13 12:27:20 10 [Warning] Checking table: '.\ecom\customers' 2020-09-14 18:16:14 169 [ERROR] mysqld.exe: La table '.\ecom\pays' est marquée 'crashed' et devrait être réparée 2020-09-14 18:16:14 169 [Warning] Checking table: '.\ecom\pays' 2020-09-20 21:13:43 0 [Note] wampmariadb64 (unknown): Arrêt normal du serveur 2020-09-20 21:13:43 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-09-20 21:13:43 0 [Note] InnoDB: FTS optimize thread exiting. 2020-09-20 21:13:43 0 [Note] InnoDB: Starting shutdown... 2020-09-20 21:13:43 0 [Note] InnoDB: Dumping buffer pool(s) to c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-20 21:13:43 0 [Note] InnoDB: Buffer pool(s) dump completed at 200920 21:13:43 2020-09-20 21:13:44 0 [Note] InnoDB: Shutdown completed; log sequence number 600432118; transaction id 594848 2020-09-20 21:13:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-09-20 21:13:44 0 [Note] wampmariadb64: Arrêt du serveur terminé
InnoDB: using atomic writes. 2020-09-20 21:13:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2020-09-20 21:13:46 0 [Note] InnoDB: Uses event mutexes 2020-09-20 21:13:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-09-20 21:13:46 0 [Note] InnoDB: Number of pools: 1 2020-09-20 21:13:46 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-09-20 21:13:46 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2020-09-20 21:13:46 0 [Note] InnoDB: Completed initialization of buffer pool 2020-09-20 21:13:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-09-20 21:13:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-09-20 21:13:46 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-09-20 21:13:46 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2020-09-20 21:13:46 0 [Note] InnoDB: Waiting for purge to start 2020-09-20 21:13:46 0 [Note] InnoDB: 10.4.10 started; log sequence number 600432118; transaction id 594846 2020-09-20 21:13:46 0 [Note] InnoDB: Loading buffer pool(s) from c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-20 21:13:46 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-09-20 21:13:46 0 [Note] Server socket created on IP: '::'. 2020-09-20 21:13:46 0 [Note] InnoDB: Buffer pool(s) load completed at 200920 21:13:46 2020-09-20 21:13:46 0 [Note] Reading of all Master_info entries succeeded 2020-09-20 21:13:46 0 [Note] Added new Master_info '' to hash table 2020-09-20 21:13:46 0 [Note] wampmariadb64: ready for connections. Version: '10.4.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2020-09-20 22:22:51 0 [Note] wampmariadb64 (unknown): Arrêt normal du serveur 2020-09-20 22:22:51 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-09-20 22:22:51 0 [Note] InnoDB: FTS optimize thread exiting. 2020-09-20 22:22:52 0 [Note] InnoDB: Starting shutdown... 2020-09-20 22:22:52 0 [Note] InnoDB: Dumping buffer pool(s) to c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-20 22:22:52 0 [Note] InnoDB: Buffer pool(s) dump completed at 200920 22:22:52 2020-09-20 22:22:52 0 [Note] InnoDB: Shutdown completed; log sequence number 600432152; transaction id 594847 2020-09-20 22:22:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-09-20 22:22:52 0 [Note] wampmariadb64: Arrêt du serveur terminé
InnoDB: using atomic writes. 2020-09-20 22:22:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2020-09-20 22:22:53 0 [Note] InnoDB: Uses event mutexes 2020-09-20 22:22:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-09-20 22:22:53 0 [Note] InnoDB: Number of pools: 1 2020-09-20 22:22:53 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-09-20 22:22:53 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2020-09-20 22:22:53 0 [Note] InnoDB: Completed initialization of buffer pool 2020-09-20 22:22:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-09-20 22:22:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-09-20 22:22:53 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-09-20 22:22:53 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2020-09-20 22:22:53 0 [Note] InnoDB: 10.4.10 started; log sequence number 600432152; transaction id 594846 2020-09-20 22:22:53 0 [Note] InnoDB: Loading buffer pool(s) from c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-20 22:22:53 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-09-20 22:22:53 0 [Note] Server socket created on IP: '::'. 2020-09-20 22:22:53 0 [Note] Reading of all Master_info entries succeeded 2020-09-20 22:22:53 0 [Note] Added new Master_info '' to hash table 2020-09-20 22:22:53 0 [Note] wampmariadb64: ready for connections. Version: '10.4.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2020-09-20 22:22:53 0 [Note] InnoDB: Buffer pool(s) load completed at 200920 22:22:53 2020-09-21 7:46:06 0 [Note] wampmariadb64 (unknown): Arrêt normal du serveur 2020-09-21 7:46:06 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-09-21 7:46:06 0 [Note] InnoDB: FTS optimize thread exiting. 2020-09-21 7:46:06 0 [Note] InnoDB: Starting shutdown... 2020-09-21 7:46:06 0 [Note] InnoDB: Dumping buffer pool(s) to c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-21 7:46:07 0 [Note] InnoDB: Buffer pool(s) dump completed at 200921 7:46:07 2020-09-21 7:46:08 0 [Note] InnoDB: Shutdown completed; log sequence number 600432161; transaction id 594847 2020-09-21 7:46:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-09-21 7:46:08 0 [Note] wampmariadb64: Arrêt du serveur terminé
InnoDB: using atomic writes. 2020-09-21 7:46:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2020-09-21 7:46:09 0 [Note] InnoDB: Uses event mutexes 2020-09-21 7:46:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-09-21 7:46:09 0 [Note] InnoDB: Number of pools: 1 2020-09-21 7:46:09 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-09-21 7:46:09 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2020-09-21 7:46:09 0 [Note] InnoDB: Completed initialization of buffer pool 2020-09-21 7:46:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-09-21 7:46:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-09-21 7:46:09 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-09-21 7:46:09 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2020-09-21 7:46:09 0 [Note] InnoDB: Waiting for purge to start 2020-09-21 7:46:09 0 [Note] InnoDB: 10.4.10 started; log sequence number 600432161; transaction id 594846 2020-09-21 7:46:09 0 [Note] InnoDB: Loading buffer pool(s) from c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-21 7:46:09 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-09-21 7:46:09 0 [Note] Server socket created on IP: '::'. 2020-09-21 7:46:10 0 [Note] InnoDB: Buffer pool(s) load completed at 200921 7:46:10 2020-09-21 7:46:10 0 [Note] Reading of all Master_info entries succeeded 2020-09-21 7:46:10 0 [Note] Added new Master_info '' to hash table 2020-09-21 7:46:10 0 [Note] wampmariadb64: ready for connections. Version: '10.4.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2020-09-21 7:53:31 0 [Note] wampmariadb64 (unknown): Arrêt normal du serveur 2020-09-21 7:53:31 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-09-21 7:53:31 0 [Note] InnoDB: FTS optimize thread exiting. 2020-09-21 7:53:31 0 [Note] InnoDB: Starting shutdown... 2020-09-21 7:53:31 0 [Note] InnoDB: Dumping buffer pool(s) to c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool 2020-09-21 7:53:31 0 [Note] InnoDB: Buffer pool(s) dump completed at 200921 7:53:31 2020-09-21 7:53:32 0 [Note] InnoDB: Shutdown completed; log sequence number 600432170; transaction id 594847 2020-09-21 7:53:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-09-21 7:53:32 0 [Note] wampmariadb64: Arrêt du serveur terminé
Trois de vos tables sont "crashed" : 2020-09-13 12:27:15 9 [ERROR] mysqld.exe: La table '.\ecom\cart' est marquée 'crashed' et devrait être réparée 2020-09-13 12:27:15 9 [Warning] Checking table: '.\ecom\cart' 2020-09-13 12:27:20 10 [ERROR] mysqld.exe: La table '.\ecom\customers' est marquée 'crashed' et devrait être réparée 2020-09-13 12:27:20 10 [Warning] Checking table: '.\ecom\customers' 2020-09-14 18:16:14 169 [ERROR] mysqld.exe: La table '.\ecom\pays' est marquée 'crashed' et devrait être réparée 2020-09-14 18:16:14 169 [Warning] Checking table: '.\ecom\pays'
ce qui empêche le démarrage de MariaDB.
Vous utilisez MariaDB 10.4.10 et, vu que le service ne démarre pas, vous ne pourrez ni réparer ni restaurer vos tables. Une solution peut être d'installer l'addon MariaDB 10.4.14 [wampserver.aviatechno.net], puis de basculer sur cette version de MariaDB et alors de restaurer vos bases de données.
Par rapport aux crashs de ces tables, la date indiquée est le 14 Septembre. Depuis cette date je suppose, je n'ai plus touché à ces tables. Or, j'ai pu bosser sur MariaDB jusqu'à ce matin, tout démarrait sans problème..