1213 Deadlock

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • 1213 Deadlock

      Source Code

      1. [04-Jul-2021 21:07:49] USER ERROR: "SQLSTATE[40001]: Serialization failure: 1213 Deadlock: wsrep aborted transaction
      2. Query-Code:UPDATE ln_planets as p,ln_users as u SET
      3. p.metal = 21478.00051236,
      4. p.crystal = 24009.90020802,
      5. p.deuterium = 10000,
      6. p.eco_hash = b2487d624d836f045bc6eb11e1b0fdac,
      7. p.last_update = 1625447269,
      8. p.b_building = 1625447601,
      9. p.b_building_id = a:2:{i:0;a:5:{i:0;i:4;i:1;i:9;i:2;d:336;i:3;d:1625447601;i:4;s:5:"build";}i:1;a:5:{i:0;i:1;i:1;i:9;i:2;d:240;i:3;d:1625447841;i:4;s:5:"build";}},
      10. p.field_current = 24,
      11. p.b_hangar_id = ,
      12. p.b_defense_id = ,
      13. p.metal_perhour = 9568.980448,
      14. p.crystal_perhour = 6276.428036,
      15. p.deuterium_perhour = 0.000000,
      16. p.metal_max = 37500,
      17. p.crystal_max = 37500,
      18. p.deuterium_max = 37500,
      19. p.energy_used = -1029,
      20. p.energy = 1317,
      21. p.b_hangar = 0,
      22. p.b_defense = 0,
      23. u.darkmatter = 3396,
      24. u.b_tech = 0,
      25. u.b_tech_id = 0,
      26. u.b_tech_planet = 0,
      27. u.b_tech_queue =
      28. WHERE p.id = 13227 AND u.id = 1046;"
      29. File: /srv/www/xxx/htdocs/includes/classes/Database.class.php | Line: 126
      30. URL: https://xxx/game.php?page=buildings | Version: 2.1.git
      31. Stack trace:
      32. #0 /includes/classes/Database.class.php(177): Database->_query('UPDATE ln_plane...', Array, 'update')
      33. #1 /includes/classes/class.PlanetRessUpdate.php(847): Database->update('UPDATE %%PLANET...', Array)
      34. #2 /includes/classes/class.PlanetRessUpdate.php(116): ResourceUpdate->SavePlanetToDB(Array, Array)
      35. #3 /includes/pages/game/AbstractGamePage.class.php(18): ResourceUpdate->CalcResource()
      36. #4 /includes/pages/game/ShowBuildingsPage.class.php(24): AbstractGamePage->__construct()
      37. #5 /game.php(45): ShowBuildingsPage->__construct()
      38. #6 {main}
      Display All
      Hola desde hace ya un tiempo se me marca este error los log del juego y la verdad no tengo ni idea de lo que pueda estar ocurriendo si alguien tuviera alguna idea de como resolverlo y la pueda compartir seria de mucha ayuda y muchas gracias de antemano ;( ;(