Coder Social home page Coder Social logo

[cucumber] SQL PREPARE error about cucumber HOT 3 CLOSED

adeynes avatar adeynes commented on July 20, 2024
[cucumber] SQL PREPARE error

from cucumber.

Comments (3)

adeynes avatar adeynes commented on July 20, 2024

Cela arrive si rien ne se connecte à MySQL pendant 6 heures (pas de /ban, pas de nouveau joueurs, etc). C'est pas super comme bug, mais il sera fixé avec la 2.0 (encore au moins quelques semaines). Pour le moment, vous pouvez utilisez:

SET GLOBAL wait_timeout=86400

dans MySQL. (86400 secondes = 24 heures). Cela veut dire que le serveur se déconnectera après 24h sans interactions, ce qui devrait être assez. Vous pouvez aussi rendre ce nombre aussi haut que vous voulez. Dans tous les cas, ce bug est fixé en restartant le serveur (j'admets que ce n'est pas pratique).

from cucumber.

teracube avatar teracube commented on July 20, 2024

@adeynes
Bonjour,
Pas de news à propos de la résolution de ce bug ?
Merci

from cucumber.

teracube avatar teracube commented on July 20, 2024

@adeynes

désormais, je rencontre ce bug avec une nouvelle installation et une remise à zero de la base.
Pourtant config.yml est correctement renseigné car çà fonctionnait bien avant.
Savez vous d'ou vient le probleme ?

https://poggit.pmmp.io/r/42458/cucumber_dev-43.phar
https://jenkins.pmmp.io/job/PocketMine-MP/1642/artifact/PocketMine-MP.phar

2018-11-30 [15:19:04] [Server thread/INFO]: Enabling cucumber v1.6.2
2018-11-30 [15:19:04] [Server thread/CRITICAL]: adeynes\cucumber\libs\poggit\libasynql\SqlError: "SQL CONNECT error: No route to host" (EXCEPTION) in "cucumber_dev-43.phar/src/adeynes/cucumber/libs/poggit/libasynql/libasynql" at line 133
2018-11-30 [15:19:04] [Server thread/DEBUG]: #0 cucumber_dev-43.phar/src/adeynes/cucumber/Cucumber(106): adeynes\cucumber\libs\poggit\libasynql\libasynql::create(string object(adeynes\cucumber\Cucumber), array Array(), array Array())
2018-11-30 [15:19:04] [Server thread/DEBUG]: #1 cucumber_dev-43.phar/src/adeynes/cucumber/Cucumber(59): adeynes\cucumber\Cucumber->initDatabase()
2018-11-30 [15:19:04] [Server thread/DEBUG]: #2 src/pocketmine/plugin/PluginBase(108): adeynes\cucumber\Cucumber->onEnable()
2018-11-30 [15:19:04] [Server thread/DEBUG]: #3 src/pocketmine/plugin/PluginManager(568): pocketmine\plugin\PluginBase->setEnabled(boolean 1)
2018-11-30 [15:19:04] [Server thread/DEBUG]: #4 src/pocketmine/Server(1919): pocketmine\plugin\PluginManager->enablePlugin(string object(adeynes\cucumber\Cucumber))
2018-11-30 [15:19:04] [Server thread/DEBUG]: #5 src/pocketmine/Server(1905): pocketmine\Server->enablePlugin(string object(adeynes\cucumber\Cucumber))
2018-11-30 [15:19:04] [Server thread/DEBUG]: #6 src/pocketmine/Server(1699): pocketmine\Server->enablePlugins(integer 1)
2018-11-30 [15:19:04] [Server thread/DEBUG]: #7 src/pocketmine/PocketMine(249): pocketmine\Server->__construct(string object(BaseClassLoader), string object(pocketmine\utils\MainLogger), string /home/myserver/, string /home/myserver/plugins/)
2018-11-30 [15:19:04] [Server thread/DEBUG]: #8 /home/myserver/PocketMine-MP.phar(1): require(string phar:///home/myserver/PocketMine-MP.phar/src/pocketmine/PocketMine.php)
2018-11-30 [15:19:04] [Server thread/INFO]: Disabling cucumber v1.6.2

from cucumber.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.