Moodle Installation Error - mysqld.exe has stopped working

Moodle Installation Error - mysqld.exe has stopped working

by Amir Mustafa -
Number of replies: 7

Hello,

I am working with Moodle 3.5.1 in local XAMPP (tried in PHP 7.0.3 and 7.2.8).

In new moodle feature moodle have pass Baracuda checker test. For that in my phpMyAdmin sql, I have executed below 3 commands:

SET GLOBAL innodb_file_format = barracuda;

SET GLOBAL innodb_file_per_table = 1;

SET GLOBAL innodb_large_prefix = 'on';


My barracuda error passed the checker, and installation started. In the middle of the installation I am getting mysqld stopped error thus failing installation. Please guide me.

Thank you for your help in advance.

Attachment Screenshot_6.png
Attachment Screenshot_7.png
Average of ratings: -
In reply to Amir Mustafa

Re: Moodle Installation Error - mysqld.exe has stopped working

by sameh naim -

Hello Amir

Could you please provide the specifications of your windows machine.

I'm guessing the ram is low.


another solution is to check Mysql config file and php.ini and increase the timeout 


Sameh

Average of ratings: -
In reply to sameh naim

Re: Moodle Installation Error - mysqld.exe has stopped working

by Amir Mustafa -

Hello Sameh,

RAM is 4 GB,

Environment - Windows 10 

I have enough space in Hard Drive.

I am not able to understand problem.

Thank you for your reply.

Attachment Screenshot_8.png
Average of ratings: -
In reply to Amir Mustafa

Re: Moodle Installation Error - mysqld.exe has stopped working

by Ken Task -
Picture of Particularly helpful Moodlers

The error ... 'Server has gone away' ... refers to MySQL server.

max_allowed_packet

Think the default for that is usually 16M.   Add a line to the config file for MySQL ... my.ini on Windows (don't ask me where, I don't use Windows) - and set it to 32M.

max_allowed_packet=32M

That setting should be under the [mysqld] section ... meaning a server/service setting.

Restart MySQL service.

And, if you are game, rather than starting over, you *might* be able to pick up where it left off by using moodlecode/admin/cli/ (command line only) and the 'install.php script there.

php install.php [ENTER] .. on Windows system, you might need to include the full paths to PHP executable and full path to the location of the install.php script.

That's worth a shot ... other wise, one has to start over with the DB.

'spirit of sharing', Ken


Average of ratings: Useful (1)
In reply to Ken Task

Re: Moodle Installation Error - mysqld.exe has stopped working

by Amir Mustafa -
Hello Ken,


Thank you for your reply. I will try and let us know for the changes you mentioned.

Thank you for your help. smile

Average of ratings: -
In reply to Amir Mustafa

Re: Moodle Installation Error - mysqld.exe has stopped working

by Amir Mustafa -

Hello Ken,

Your solution worked like a charm!

Changes I did in my xampp:

For windows

1. Configuration for path - xampp/mysql/bin/my.ini

[mysqldump]
quick
max_allowed_packet = 2048M

[mysqld]
max_allowed_packet = 2048M

2. php.ini file

max_execution_time = 600

3. Restart the apache and mysql (from XAMPP Ctrl Panel)

I have successfully installed moodle 3.5.1 and logged in smile smile

Attachment Screenshot_12.png
Average of ratings: Useful (1)
In reply to Amir Mustafa

Re: Moodle Installation Error - mysqld.exe has stopped working

by Ken Task -
Picture of Particularly helpful Moodlers

Great!  Congrats.  and thanks for sharing back the changes.

'spirit of sharing', Ken


Average of ratings: -
In reply to Ken Task

Re: Moodle Installation Error - mysqld.exe has stopped working

by Albert Ramsbottom -

Its good but your max_allowed_packet is way too high

Try not to just pump up all the values, it can have a negative impact elsewhere


It reminds me of people who set the php.ini setting of 

php_value memory_limit 2048M
And wonder why when two or more people use the site that it crashes

Albert



Average of ratings: -