Laragon 3.0.4 problem on mariadb


  • | 1018 points

    this happen and create a user and assigned a database

    2017-05-29 17:27:19 12644 [ERROR] mysqld: Index for table '.\mysql\user' is corrupt; try to repair it
    2017-05-29 17:27:19 12644 [ERROR] mysqld: Index for table 'user' is corrupt; try to repair it
    2017-05-29 17:27:19 12644 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table '.\mysql\user' is corrupt; try to repair it
    2017-05-29 17:27:19 0x20842017-05-29 17:27:19 0x14f82017-05-29 17:27:19 0x23b82017-05-29 17:27:19 0x2d902017-05-29 17:27:19 0x29c82017-05-29 17:27:19 0x1e5c  InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6495
    2017-05-29 17:27:19 0x24b8
    

    any idea how to fix this?


  • | 243 points

    @kaxias I had this same problem and found out i had mysql installed and it was causing the problem.. if you have mysql or mariadb installed uninstall or change the port on the external mysql or mariadb..
    that is what worked for me;
    hope this helps...cheers....gator


  • | 540 points

    @kaxias Restarting pc and removed "mariadb-10.2.5-winx64" also fixed it.

    "C:\laragon\bin\mysql\mariadb-10.2.5-winx64"


  • | 1018 points

    still not work. I think will back to laragon 2.2.2


  • | 540 points

    This post is deleted!

  • administrators
    | 68677 points

    @kaxias : Did you install Laragon 3.0 over Laragon 2.0?
    Laragon 3.0 has many changes in its core so you should upgrade it properly:
    https://forum.laragon.org/topic/474/how-to-upgrade-from-laragon-2-to-laragon-3

    If you did, I find this article helpful. Hope it help:
    https://medium.com/@seunmatt/moving-from-laragon-2-to-laragon-3-0-my-telltale-6a7c3a67f326

    Note: Laragon 3.0 can create Data Dir. Therefore, after hacking your current data, you can have a new clean one by rename data\mysql to another name.
    This also works with Postgres and MongoDB.


  • | 1018 points

    I it is a clean installation of laragon 3.0.4, this problem happen if I restart MariaDB server.

    2017-05-31 13:19:35 2148 [ERROR] mysqld: Index for table '.\mysql\user' is corrupt; try to repair it
    2017-05-31 13:19:35 2148 [ERROR] mysqld: Index for table 'user' is corrupt; try to repair it
    2017-05-31 13:19:35 2148 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table '.\mysql\user' is corrupt; try to repair it
    2017-05-31 13:19:35 0x24142017-05-31 13:19:35 0x2244
    2017-05-31 13:19:35 0x2b542017-05-31 13:19:35 0x26d4
    2017-05-31 13:19:35 0xe10  InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6495
    InnoDB: Failing assertion: slot
    2017-05-31 13:19:35 0x878InnoDB: We intentionally generate a memory trap.
    InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
    InnoDB: If you get repeated assertion failures or crashes, even
    InnoDB: immediately after the mysqld startup, there may be
    InnoDB: corruption in the InnoDB tablespace. Please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
    InnoDB: about forcing recovery.
    

  • | 540 points

    @kaxias Removed C:\laragon folder. Redownloaded/reinstalled laragon latest. Done, everything works just fine. Tried to restart mariaserver, everything still works fine. After that if you are doing import your old database and mariadb does fail then be sure "Do not import database named (mysql)"


  • | 1018 points

    it is clean installation of 3.0.4 this problem appear. but on laragon 2.2.2 with mariaDB 10.2.6 this problem not happen.


  • administrators
    | 68677 points

    Strange. With Laragon 3.0, I applies graceful shutdown for MySQL and have done a lot of tests on many OSes.


  • | 1018 points

    i use windows 10 64bit version 1703 os build 15063.296


  • | 540 points

    @kaxias Windows 10 64bit version 1703 os build 15063.332 here


  • | 195 points

    Hi,
    I have the same problem with a fresh install of laragon.
    Please see my log file attached, any idea?
    [0_1496236443717_mysqld.log](Uploading 100%)
    Thx


  • administrators
    | 68677 points

    @dukenst2006 : I can not see your log file. Did anyone try deleting data\mysql and click Start All again?


  • | 195 points

    @leokhoa : I deleted the data/mysql and it work, Thanks, Great !!


  • | 1018 points

    yes i did that but same think.


  • administrators
    | 68677 points

    I will make a new installer of Laragon which bundles with data dir by default (like Laragon 2). I think there is an issue with the auto create data dir feature which not work well for 100% users. @kaxias: Can you check with Postgres or MongoDB?
    https://forum.laragon.org/topic/487/tutorial-how-to-add-another-postgresql-version


  • | 540 points

    @leokhoa Creating user is successful but granting privileges are failing. Did get in his comp then checked on my computer.

    Steps :
    CREATE USER 'myuser'@'localhost' IDENTIFIED BY '123456'; (Oke)
    GRANT ALL PRIVILEGES ON database.* TO 'myuser'@'localhost'; (Fail)

    And To Fix it :

    1. Remove Laragon\data\mysql\mysql
    2. Copy mariadb-10.2.6-winx64.zip\data\mysql
    3. Paste

  • | 1018 points

    i did try that but same. maybe it is my pc.


  • | 1018 points

    i give this up . problem appear if you create new user and restart MariaDB server after few seconds it is stop work.


Log in to reply
 

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