Communications link failure #77


  • New
  • Defect
Open
Assigned to _ForgeUser2779866
  • _ForgeUser7692978 created this issue Jun 25, 2012

    I have install Statistician (2.0.10) on a Debian Squeeze 64bit and original Java 7 64bit from java.com. Bukkit is version 1.2.5-R4.0. MySQL is the original MySQL from Debian with standard my.cnf, version 5.1. My confrig is:

    database_address: localhost
    database_port: 3306
    database_name: mcstats
    database_username: mcstats
    database_password: XXXXXXXXXX
    database_update_time: 120

    Until yesturday, all works fine, new players where displayed at the Portal. But the first player today:

    08:32:55 [INFO] OneUser [/92.xxx.xxx.xxx:46838] logged in with entity id 1462733 at ([world] -302.15957279145346, 70.0, -352.0779311555734)
    08:32:55 [INFO] [Backup] Stopped last backup, because someone joined.
    08:32:55 [WARNING] [Statistician] SELECT player_name FROM players WHERE uuid = '6272bcbd-b3ef-4b6f-ae31-ef6aee136a3f' LIMIT 1 :: Query failed, checking connection...
    (Communications link failure

    The last packet successfully received from the server was 29,902,908 milliseconds ago.  The last packet sent successfully to the server was 94 milliseconds ago.)
    08:32:55 [WARNING] [Statistician] Connection has been lost with database, attempting to reconnect.
    08:32:56 [INFO] [Statistician] Connection to the database re-established, some stats were lost though
    08:32:56 [WARNING] [Statistician] CALL `mcstats`.newPlayer('6272bcbd-b3ef-4b6f-ae31-ef6aee136a3f','power286'); :: Stored procedure failed, checking connection... (Du
    plicate entry '6272bcbd-b3ef-4b6f-ae31-ef6aee136a3f' for key 'PRIMARY')
    08:32:56 [INFO] [Statistician] Connection is still present, it may of been a malformed query.
    08:32:57 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    08:33:24 [INFO] [PLAYER_COMMAND] OneUser: /gm

    The portal does not show this player. Any ideas whats wrong?

  • _ForgeUser7692978 added the tags New Defect Jun 25, 2012
  • _ForgeUser2779866 unassigned issue from _ForgeUser6869524 Nov 24, 2012
  • _ForgeUser2779866 self-assigned this issue Nov 24, 2012

To post a comment, please login or register a new account.