Page 1 of 1

[fix available] eXpansion not stable

Posted: 23 Dec 2016, 23:44
by wazerti
Hello,

I use eXpansion to manage my servers.
But since few days my eXpansion becomed not stable.
It always crashs few hours after the launch...

I share the manialive-error.log :

Code: Select all

[2016-12-29T03:21:26+02:00]
    Occured on 29.12.2016 at 03:21:26 at process with ID #30181
    ---------------------------------
 -> ManiaLive\Application\ErrorLimitReached with code 0
    Reached error limit of 16. ManiaLive is shutting down
  - in /root/Nascar/h/eXpansion-1.0.1.2/vendor/maniaplanet/manialive-lib/ManiaLive/Application/ErrorHandling.php on line 37
  - Stack: #0 /root/Nascar/h/eXpansion-1.0.1.2/vendor/maniaplanet/manialive-lib/ManiaLive/Application/ErrorHandling.php(103): ManiaLive\Applicatiion\ErrorHandling::increaseErrorCount()
           #1 /root/Nascar/h/eXpansion-1.0.1.2/vendor/maniaplanet/manialive-lib/ManiaLive/Event/Dispatcher.php(139): ManiaLive\Application\ErrorHandling::processModuleException(Object(ManiaLive\Database\QueryException))
           #2 /root/Nascar/h/eXpansion-1.0.1.2/vendor/maniaplanet/manialive-lib/ManiaLive/Application/Application.php(125): ManiaLive\Event\Dispatcher::dispatch(Object(ManiaLive\DedicatedApi\Callback\Event))
           #3 /root/Nascar/h/eXpansion-1.0.1.2/bootstrapper.php(79): ManiaLive\Application\Application->run()
           #4 {main}
Tell me if you want the others error files
I don't know why this problem occurs...
At the start of eXpansion, it says MySQL isn't activate.

Thanks

Re: eXpansion not stable

Posted: 31 Dec 2016, 15:57
by wazerti
Nobody has an idea ? :(

Re: eXpansion not stable

Posted: 03 Jan 2017, 08:55
by oliverde8
Hi,

Can you please send us the list of the last few errors? The last error is caused by other errors.

Re: eXpansion not stable

Posted: 04 Jan 2017, 22:54
by wazerti
Thanks for your answer :)
Here is the logfile : http://download938.mediafire.com/brcc2s ... -error.log

Re: eXpansion not stable

Posted: 12 Jan 2017, 07:34
by oliverde8
Hi,

There is a temporary fix here : https://forum.maniaplanet.com/viewtopic ... 18&t=38505

I will look into why the error is still around in 1.0.1

Re: eXpansion not stable

Posted: 21 Jan 2017, 20:37
by wazerti
Hello,

Sorry for the last answer, I had exams this week :/

Thank you for your answer, put the lines in my.cnf it seems to work. :D

I recontact you if an issue occurs again.

Re: eXpansion not stable

Posted: 22 Jan 2017, 19:15
by wazerti
Hi,

Today my eXpansion crashed again...
Maybe I did an error in my.cnf

Here is my my.cnf :

Code: Select all

# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
sql_mode =
"STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
I send you the log files :
http://download1643.mediafire.com/kc2ql ... -error.log
http://download1639.mediafire.com/ifcqr ... onsole.log
http://download1649.mediafire.com/w40s6 ... untime.log
http://www.mediafire.com/file/bwgedb174 ... e-info.log

Thanks

Re: eXpansion not stable

Posted: 24 Jan 2017, 08:25
by reaby
wazerti wrote: Today my eXpansion crashed again...
I did my best to fix the error with new mysql and group by clauses.
It should work without editing mysql config files now.
Fix is available at dev, hopefully I didn't break the the rank calculation... :roflol:

To test - switch to dev, instructions here:
https://forum.maniaplanet.com/viewtopic ... 18&t=38544

Re: [fix available] eXpansion not stable

Posted: 27 Jan 2017, 19:00
by wazerti
Thanks reaby :D

For the moment it seems to work !

Ask you if there is another issue.

Re: [fix available] eXpansion not stable

Posted: 01 Feb 2017, 19:03
by wazerti
Hello,

I got another eXpansion crash... But this time I think it's a memory problem, because my server has crashed too.

Do you know approximately a good configuration to run on Linux ?

Thanks