Aller au contenu | Aller au menu | Aller à la recherche


[ERROR] Failed to open the relay log [ERROR] Could not find target log during relay log initialization [ERROR] Initialized Master_info from [ERROR] Failed to create a new master info file [ERROR] Failed to initialize multi master structures - Aborting

Par PlaceOweb le mercredi, mai 27 2020, 19:30 - SQL - Lien permanent

Visiblement, suite à changement de configuration réseau DHCP et nom d'hôte, impossible de lancer le serveur MySQL MariaDB.

Puisque je n'avais pas besoin de la réplication,

en modifiant, le my.ini, et rajoutant :

slave_sql_verify_checksum = OFF

et supprimant : master-xxx.info mysql-relay-xxx.index relay-log-xxx.info

le serveur se relance :

D:\xampp_74\mysql\bin>mysqld --console
2020-05-27 19:26:30 0 [Note] mysqld (mysqld 10.4.11-MariaDB) starting as process 21108 ...
InnoDB: using atomic writes.
2020-05-27 19:26:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-05-27 19:26:30 0 [Note] InnoDB: Uses event mutexes
2020-05-27 19:26:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-27 19:26:30 0 [Note] InnoDB: Number of pools: 1
2020-05-27 19:26:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-05-27 19:26:30 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-05-27 19:26:30 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-27 19:26:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-05-27 19:26:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-05-27 19:26:31 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-05-27 19:26:31 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2020-05-27 19:26:31 0 [Note] InnoDB: Waiting for purge to start
2020-05-27 19:26:31 0 [Note] InnoDB: 10.4.11 started; log sequence number 2805295; transaction id 1240
2020-05-27 19:26:31 0 [Note] InnoDB: Loading buffer pool(s) from d:\xampp_74\mysql\data\ib_buffer_pool
2020-05-27 19:26:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-27 19:26:31 0 [Note] Server socket created on IP: '::'.
2020-05-27 19:26:31 0 [Note] Reading of all Master_info entries succeeded
2020-05-27 19:26:31 0 [Note] Added new Master_info '' to hash table
2020-05-27 19:26:31 0 [Note] mysqld: ready for connections.
Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2020-05-27 19:26:31 0 [Note] InnoDB: Buffer pool(s) load completed at 200527 19:26:31

C:\Users\ryzen>ping localhost

Envoi d’une requête 'ping' sur RYZEN [::1] avec 32 octets de données :
Réponse de ::1 : temps<1ms
Réponse de ::1 : temps<1ms
Réponse de ::1 : temps<1ms
Réponse de ::1 : temps<1ms

Statistiques Ping pour ::1:
    Paquets : envoyés = 4, reçus = 4, perdus = 0 (perte 0%),
Durée approximative des boucles en millisecondes :
    Minimum = 0ms, Maximum = 0ms, Moyenne = 0ms

C:\Users\ryzen>

Avant les modifications, j'avais les erreurs :

InnoDB: using atomic writes.
2020-05-27 18:56:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-05-27 18:56:36 0 [Note] InnoDB: Uses event mutexes
2020-05-27 18:56:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-27 18:56:36 0 [Note] InnoDB: Number of pools: 1
2020-05-27 18:56:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-05-27 18:56:36 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-05-27 18:56:36 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-27 18:56:36 0 [Note] InnoDB: Resizing redo log from 2*5242880 to 2*50331648 bytes; LSN=2803760
2020-05-27 18:56:36 0 [Note] InnoDB: Starting to delete and rewrite log files.
2020-05-27 18:56:36 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 50331648 bytes
2020-05-27 18:56:36 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 50331648 bytes
2020-05-27 18:56:37 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2020-05-27 18:56:37 0 [Note] InnoDB: New log files created, LSN=2803760
2020-05-27 18:56:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-05-27 18:56:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-05-27 18:56:37 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-05-27 18:56:37 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2020-05-27 18:56:37 0 [Note] InnoDB: Waiting for purge to start
2020-05-27 18:56:37 0 [Note] InnoDB: 10.4.11 started; log sequence number 2803760; transaction id 1214
2020-05-27 18:56:37 0 [Note] InnoDB: Loading buffer pool(s) from d:\xampp_74\mysql\data\ib_buffer_pool
2020-05-27 18:56:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-27 18:56:37 0 [Note] Server socket created on IP: '::'.
2020-05-27 18:56:37 0 [Note] InnoDB: Buffer pool(s) load completed at 200527 18:56:37
2020-05-27 18:56:37 7 [Note] Reading Master_info: 'master-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-05-27 18:56:37 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=RYZEN-relay-bin' to avoid this problem.
2020-05-27 18:56:37 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000003' (relay_log_pos 4)
2020-05-27 18:56:37 7 [ERROR] Could not find target log during relay log initialization
2020-05-27 18:56:37 7 [ERROR] Initialized Master_info from 'master-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2020-05-27 18:56:37 7 [Note] Added new Master_info '2020-05-21 10:41:45 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2020-05-27 18:56:37 7 [Note] Reading Master_info: 'master-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-05-27 18:56:37 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000003' (relay_log_pos 4)
2020-05-27 18:56:37 7 [ERROR] Could not find target log during relay log initialization
2020-05-27 18:56:37 7 [ERROR] Initialized Master_info from 'master-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
2020-05-27 18:56:37 7 [Note] Added new Master_info '2020-05-21 10:41:45 0 [Note] Added new Master_info '' to hash table
' to hash table
2020-05-27 18:56:37 7 [Note] Reading Master_info: 'master-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020d@003a@005cxampp_74@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020d@003a@005cxampp_74@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-05-27 18:56:37 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020d@003a@005cxampp_74@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000003' (relay_log_pos 4)
2020-05-27 18:56:37 7 [ERROR] Could not find target log during relay log initialization
2020-05-27 18:56:37 7 [ERROR] Initialized Master_info from 'master-2020@002d05@002d21@002010@003a41@003a45@00200@0020@005bnote@005d@0020d@003a@005cxampp_74@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2020-05-27 18:56:37 7 [Note] Added new Master_info '2020-05-21 10:41:45 0 [Note] d:\xampp_74\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2020-05-27 18:56:37 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'  Relay_info:'relay-log-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-05-27 18:56:38 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000003' (relay_log_pos 4)
2020-05-27 18:56:38 7 [ERROR] Could not find target log during relay log initialization
2020-05-27 18:56:38 7 [ERROR] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' failed
2020-05-27 18:56:38 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
' to hash table
2020-05-27 18:56:38 7 [Note] Reading Master_info: 'master-2020@002d05@002d21@002022@003a10@003a24@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027mabases@0027@0020user@003a@0020@0027mabases@0027@0020host@003a@0020@0027@0027@0020@0028got@0020timeout@0020reading@0020communication@0020packets@0029@000d.info'  Relay_info:'relay-log-2020@002d05@002d21@002022@003a10@003a24@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027mabases@0027@0020user@003a@0020@0027mabases@0027@0020host@003a@0020@0027@0027@0020@0028got@0020timeout@0020reading@0020communication@0020packets@0029@000d.info'
2020-05-27 18:56:38 7 [ERROR] Failed to create a new master info file (file 'd:\xampp_74\mysql\data\master-2020@002d05@002d21@002022@003a10@003a24@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027mabases@0027@0020user@003a@0020@0027mabases@0027@0020host@003a@0020@0027@0027@0020@0028got@0020timeout@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2020-05-27 18:56:38 7 [ERROR] Initialized Master_info from 'master-2020@002d05@002d21@002022@003a10@003a24@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027mabases@0027@0020user@003a@0020@0027mabases@0027@0020host@003a@0020@0027@0027@0020@0028got@0020timeout@0020reading@0020communication@0020packets@0029@000d.info' failed
2020-05-27 18:56:38 7 [Note] Added new Master_info '2020-05-21 22:10:24 10 [Warning] Aborted connection 10 to db: 'mabases' user: 'mabases' host: '' (Got timeout reading communication packets)
' to hash table
2020-05-27 18:56:38 0 [Warning] Reading of some Master_info entries failed
2020-05-27 18:56:38 0 [ERROR] Failed to initialize multi master structures
2020-05-27 18:56:38 0 [ERROR] Aborting

Ajouter un commentaire

Le code HTML est affiché comme du texte et les adresses web sont automatiquement transformées.

Fil des commentaires de ce billet