3. Unable to start MariaDB

Unable to start MariaDB

  • | 2329 points

    Since a few days ago laragon refuses to launch MariaDB. I updated it to 3.1.3 but the error persists.

    This is what laragons shows:

    MariaDB Error

    And here is the log:

    10140 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
10140 [Note] InnoDB: Uses event mutexes
10140 [Note] InnoDB: Compressed tables use zlib 1.2.3
10140 [Note] InnoDB: Number of pools: 1
10140 [Note] InnoDB: Using generic crc32 instructions
10140 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
10140 [Note] InnoDB: Completed initialization of buffer pool
10140 [Note] InnoDB: Highest supported file format is Barracuda.
10140 [Note] InnoDB: 128 out of 128 rollback segments are active.
10140 [Note] InnoDB: Creating shared tablespace for temporary tables
10140 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
10140 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
10140 [Note] InnoDB: Waiting for purge to start
10140 [Note] InnoDB: 5.7.14 started; log sequence number 5403216
10124 [Note] InnoDB: Loading buffer pool(s) from C:\laragon\data\mysql\ib_buffer_pool
10140 [Note] Plugin 'FEEDBACK' is disabled.
10124 [Note] InnoDB: Buffer pool(s) load completed at 170731 19:20:06
10140 [Note] Server socket created on IP: '::'.
10140 [Note] Reading Master_info: 'master-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeded@000d.info'  Relay_info:'relay-log-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeded@000d.info'
10140 [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=BLADERUNNER-relay-bin' to avoid this problem.
10140 [Note] Initialized Master_info from 'master-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeded@000d.info'
10140 [Note] Added new Master_info '2017-07-28 19:39:49 2132 [Note] Reading of all Master_info entries succeded
' to hash table
9492 [ERROR] Master '2017-07-28 19:39:49 2132 [Note] Reading of all Master_info entries succeded
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
10140 [Note] Started replication for '2017-07-28 19:39:49 2132 [Note] Reading of all Master_info entries succeded
'
9492 [Note] Master '2017-07-28 19:39:49 2132 [Note] Reading of all Master_info entries succeded
': Slave I/O thread killed while connecting to master
10140 [Note] Reading Master_info: 'master-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
5276 [Note] Master '2017-07-28 19:39:49 2132 [Note] Reading of all Master_info entries succeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\BLADERUNNER-relay-bin-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeded@000d.000025' position: 4
9492 [Note] Master '2017-07-28 19:39:49 2132 [Note] Reading of all Master_info entries succeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4
10140 [Note] Initialized Master_info from 'master-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
10140 [Note] Added new Master_info '2017-07-28 19:39:49 2132 [Note] Added new Master_info '' to hash table
' to hash table
8932 [ERROR] Master '2017-07-28 19:39:49 2132 [Note] Added new Master_info '' to hash table
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
10140 [Note] Started replication for '2017-07-28 19:39:49 2132 [Note] Added new Master_info '' to hash table
'
8932 [Note] Master '2017-07-28 19:39:49 2132 [Note] Added new Master_info '' to hash table
': Slave I/O thread killed while connecting to master
10140 [Note] Reading Master_info: 'master-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020c@003a@005claragon@005cbin@005cmysql@005cmariadb@002d10@002e2@002e6@002dwinx64@005cbin@005cmysqld@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020c@003a@005claragon@005cbin@005cmysql@005cmariadb@002d10@002e2@002e6@002dwinx64@005cbin@005cmysqld@003a@0020ready@0020for@0020connections@002e@000d.info'
5712 [Note] Master '2017-07-28 19:39:49 2132 [Note] Added new Master_info '' to hash table
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\BLADERUNNER-relay-bin-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000025' position: 4
8932 [Note] Master '2017-07-28 19:39:49 2132 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4
10140 [ERROR] Error reading master configuration
10140 [ERROR] Initialized Master_info from 'master-2017@002d07@002d28@002019@003a39@003a49@00202132@0020@005bnote@005d@0020c@003a@005claragon@005cbin@005cmysql@005cmariadb@002d10@002e2@002e6@002dwinx64@005cbin@005cmysqld@003a@0020ready@0020for@0020connections@002e@000d.info' failed
10140 [Note] Added new Master_info '2017-07-28 19:39:49 2132 [Note] C:\laragon\bin\mysql\mariadb-10.2.6-winx64\bin\mysqld: ready for connections.
' to hash table
10140 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e2@002e6@002dmariadb@002dlog@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@002e2@002e6@002dmariadb@002dlog@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
10140 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e2@002e6@002dmariadb@002dlog@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
10140 [Note] Added new Master_info 'Version: '10.2.6-MariaDB-log'  socket: ''  port: 3306  mariadb.org binary distribution
' to hash table
3064 [ERROR] Master 'Version: '10.2.6-MariaDB-log'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
10140 [Note] Started replication for 'Version: '10.2.6-MariaDB-log'  socket: ''  port: 3306  mariadb.org binary distribution
'
3064 [Note] Master 'Version: '10.2.6-MariaDB-log'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
10140 [Warning] Reading of some Master_info entries failed
6180 [Note] Master 'Version: '10.2.6-MariaDB-log'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\BLADERUNNER-relay-bin-version@003a@0020@002710@002e2@002e6@002dmariadb@002dlog@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000025' position: 4
3064 [Note] Master 'Version: '10.2.6-MariaDB-log'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
10140 [ERROR] Failed to initialize multi master structures
10140 [ERROR] Aborting

    The log is very cryptic to me and I can't figure out what's wrong. Any help?

    0
  • administrators
    | 123015 points

    @CØRE : The error log is very strange. Can you rename data to data.bak so Laragon will create a new fresh datadir for you?

    2 Replies: 1
  • | 2329 points

    @leokhoa That fixed it. It seems that laragon loaded MariaDB but was trying to access data/mysql/ instead of data/mariadb/.

    1
  • administrators
    | 123015 points

    @CØRE : Glad to hear it's fixed :)
    F.Y.I: MySQL/MariaDB loads data from datadir directive on my.ini

    1
Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.