DB crashed?


  • | 470 points

    After restart my PC i have problem with start my maria DB:

    Service MariaDB can not start. Reason:
    [date] 13400 [Note]
    PATH to mysqld
    {mysqld 10.2.12-MariaDB-log) starting as process 13752.
    ...

    And mariadb logs are full in logs like:
    018-02-06 21:52:24 13728 [Warning] Reading of some Master_info entries failed
    2018-02-06 21:52:24 13728 [ERROR] Failed to initialize multi master structures
    2018-02-06 21:52:24 13728 [ERROR] Aborting

    Btw. Thanks for Laragon, is awsome (i leave Docker).


  • | 470 points

    I deleted folder data so new DB was created but after Laragon Stop all and Start i have this problem again :/

    Phpmyadmin error:
    mysqli_real_connect(): MySQL server has gone away
    mysqli_real_connect(): Error while reading greeting packet. PID=9480
    mysqli_real_connect(): (HY000/2006): MySQL server has gone away

    Probably DB crashed because my php script was broken and did endless loop, but how to prevent crash DB every time in future? How restore my work?


  • administrators
    | 72972 points

    @Marek-Gralikowski :
    The error ERROR] Failed to initialize multi master structures is strange to me. Laragon is not configured to use multi-master in development environment.

    How about using MySQL: https://forum.laragon.org/topic/164/tutorial-how-to-add-another-mysql-version

    If your local data makes sense to you, you should backup it as it is a best practice.


  • | 470 points

    I would to use MariaDB, as i do it in production. Interesting for me is, why so easy i can crash entire database.

    Yea, backup could be nice but i was hoping there is an any automatic dump ;)


  • | 470 points

    Eh.. Again..

    I finished my work at night, normally closed computer, and i just turned on my pc and DB can not start. How can I check what is a reason of that? It's very annoying :(

    Can i just make new db and copy/paste data to restore my work?


  • administrators
    | 72972 points

    @Marek-Gralikowski : Strange!

    018-02-06 21:52:24 13728 [Warning] Reading of some Master_info entries failed
    2018-02-06 21:52:24 13728 [ERROR] Failed to initialize multi master structures
    2018-02-06 21:52:24 13728 [ERROR] Aborting
    

    I guess the root cause is from configuration. Replication failure caused the issue.
    How about:

    1. Rename your data dir to data.bak
    2. Dump your database from production
    3. Start Laragon to have new clean data and restore your database.

  • | 470 points

    I would to try restore my local database first.

    I install newest mariadb and force to create new data folder.
    Next i copied folder with database name from old mariadb folder to new, created.
    In phpmyadmin i see now all datatables but i can't enter them so i copied also mysql-bin.x files and after this many files like:
    MarekPC-relay-bin-2018@002d02@002d14@002012@003a18@003a07@002011752@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d

    and

    master-2018@002d02@002d14@002012@003a18@003a07@002011752@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d

    is created on run and problem is back.


  • administrators
    | 72972 points

    @Marek-Gralikowski : You should dump your databases to plain SQL, then restore from the SQL.


  • | 470 points

    How can i dump not starting/working/crushed DB?


  • administrators
    | 72972 points

    There is a strange issue on your current data so you should dump from your production.


  • | 470 points

    It is not problem with data only because it never happened on production or local Docker (i have used Laradock for several months). As i said, i would to prevent crash in future and it's my main purpose to writing here. Restoring data from production is easy but it is wasting time.


Log in to reply
 

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