[Bug] Servidor Diz-Se Online, Mas No Processo De Ligaçao Dá Erros

[FoxBoyzz 38]

Boas pessoal quando eu tento ligar o meu servidor ocorrem uma série de erros que não compreendo de onde vieram..
Abaixo meto um print a comprovar isso:

 

 

Alguem sabe que erro é este?

Abraço em muito obrigado desde já

[-Synk2K- 9]

Boas pessoal quando eu tento ligar o meu servidor ocorrem uma série de erros que não compreendo de onde vieram..

Abaixo meto um print a comprovar isso:

 

 

Alguem sabe que erro é este?

Abraço em muito obrigado desde já

 

Não te posso ajudar, infelizmente mas tive a tentar ligar ao servidor e reparei que tava off.

 

Espero que consigam resolver para continuar a testar e poder explorar outros mapas.

[FoxBoyzz 38]

Não te posso ajudar, infelizmente mas tive a tentar ligar ao servidor e reparei que tava off.

 

Espero que consigam resolver para continuar a testar e poder explorar outros mapas.

Muito obrigado desde já pelo apoio.

Estamos a fazer os possíveis para que o server reabra o mais rapidamente possível.

Cumprimentos.

[Rasta Man 71]

Syserr do core? :|

[FoxBoyzz 38]

Syserr do core? :|

Aqui está o erro..

 

SYSERR: Jul 27 14:58:37 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 27 14:58:38 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Jul 27 15:18:05 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'check_trans_ticket', '__status', 526282696) errno: 1317)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(102, 'event_mystery_box', '__status', -163855020) errno: 2002)
SYSERR: Jul 27 15:18:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Jul 27 15:18:05 :: pid_deinit: 

SYSERR: Jul 27 15:19:32 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Jul 27 15:19:33 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Jul 27 16:14:50 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 60345, y = 165608, z = 0, map_index = 21, exit_x = 60345, exit_y = 165608, exit_map_index = 21, hp = 1949, mp = 869, stamina = 1320, random_hp = 1189, random_sp = 609, playtime = 50, level = 30, level_step = 2, st = 6, ht = 4, dx = 3, iq = 3, gold = 3749947, exp = 953, stat_point = 89, skill_point = 0, sub_skill_point = 21, stat_reset_count = 0, ip = '82.154.81.174', part_main = 11209, part_hair = 0, last_play = NOW(), skill_group = 1, alignment = 134, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1438264739, horse_stamina = 120, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: UPDATE player SET job = 5, voice = 0, dir = 0, x = 61388, y = 165699, z = 0, map_index = 21, exit_x = 61388, exit_y = 165699, exit_map_index = 21, hp = 2379, mp = 596, stamina = 1435, random_hp = 649, random_sp = 336, playtime = 44, level = 17, level_step = 0, st = 6, ht = 27, dx = 28, iq = 3, gold = 796135, exp = 8996, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '81.193.189.146', part_main = 11409, part_hair = 2010, last_play = NOW(), skill_group = 1, alignment = 579, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1438264975, horse_stamina = 119, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: UPDATE player SET job = 5, voice = 0, dir = 0, x = 61388, y = 165699, z = 0, map_index = 21, exit_x = 61388, exit_y = 165699, exit_map_index = 21, hp = 2379, mp = 596, stamina = 1435, random_hp = 649, random_sp = 336, playtime = 44, level = 17, level_step = 0, st = 6, ht = 27, dx = 28, iq = 3, gold = 796135, exp = 8996, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '81.193.189.146', part_main = 11409, part_hair = 2010, last_play = NOW(), skill_group = 1, alignment = 579, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1438264975, horse_stamina = 119, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: UPDATE player SET job = 5, voice = 0, dir = 0, x = 61388, y = 165699, z = 0, map_index = 21, exit_x = 61388, exit_y = 165699, exit_map_index = 21, hp = 2379, mp = 596, stamina = 1435, random_hp = 649, random_sp = 336, playtime = 44, level = 17, level_step = 0, st = 6, ht = 27, dx = 28, iq = 3, gold = 796135, exp = 8996, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '81.193.189.146', part_main = 11409, part_hair = 2010, last_play = NOW(), skill_group = 1, alignment = 579, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1438264975, horse_stamina = 119, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Jul 27 16:14:50 :: pid_deinit: 

[Requiem 113]

Tens um problema com o MySQL.. Com a ligação do servidor ao navicat para perceberem bem

[FoxBoyzz 38]

Tens um problema com o MySQL.. Com a ligação do servidor ao navicat para perceberem bem

E como consigo solucionar este problema?

Abraço

[Fяєiтαร™ 265]

BUMP

[nagatto 2,130]

O que mudaste no servidor para originar este erro? É que se tiveste o servidor online alguma coisa alteraste mal, digo eu.

[FoxBoyzz 38]

O que mudaste no servidor para originar este erro? É que se tiveste o servidor online alguma coisa alteraste mal, digo eu.

Estava a alterar umas traduções apenas no locale.

E do nada o servidor caiu e nunca mais voltou a ligar devido a este erro..

Abraço

[nagatto 2,130]

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: UPDATE player SET job = 5, voice = 0, dir = 0, x = 61388, y = 165699, z = 0, map_index = 21, exit_x = 61388, exit_y = 165699, exit_map_index = 21, hp = 2379, mp = 596, stamina = 1435, random_hp = 649, random_sp = 336, playtime = 44, level = 17, level_step = 0, st = 6, ht = 27, dx = 28, iq = 3, gold = 796135, exp = 8996, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '81.193.189.146', part_main = 11409, part_hair = 2010, last_play = NOW(), skill_group = 1, alignment = 579, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1438264975, horse_stamina = 119, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Jul 27 16:14:50 :: pid_deinit:

É estranho estes erros com as localizações de uma personagem, nunca me deu este erro, porém tenta dar backup disso e faz um reset e tenta ligar.

[FoxBoyzz 38]

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: UPDATE player SET job = 5, voice = 0, dir = 0, x = 61388, y = 165699, z = 0, map_index = 21, exit_x = 61388, exit_y = 165699, exit_map_index = 21, hp = 2379, mp = 596, stamina = 1435, random_hp = 649, random_sp = 336, playtime = 44, level = 17, level_step = 0, st = 6, ht = 27, dx = 28, iq = 3, gold = 796135, exp = 8996, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '81.193.189.146', part_main = 11409, part_hair = 2010, last_play = NOW(), skill_group = 1, alignment = 579, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1438264975, horse_stamina = 119, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\

SYSERR: Jul 27 16:14:50 :: ChildLoop: AsyncSQL: retrying

SYSERR: Jul 27 16:14:50 :: pid_deinit:

É estranho estes erros com as localizações de uma personagem, nunca me deu este erro, porém tenta dar backup disso e faz um reset e tenta ligar.

Infelizmente não fiz nenhum backup, pois não estava a alterar nada de crítico.. mas isto foi um abre olhos.. apartir de agora vou fazer sempre..

Talvez irei ter mesmo que dar reset, embora irei guardar todo o meu trabalho :)

Abraços e se alguém souber como resolver isto agradecia..

[nagatto 2,130]

Reset às personagens, não sei percebeste xD

[FoxBoyzz 38]

Reset às personagens, não sei percebeste xD

Irei tentar fazer isso agora mano :)

Edit: Removi todas as personagens e não deu mano..

Abraço

[nagatto 2,130]

Da reset nisso e depois tenta ligar o servidor.

[Laurindinha 319]

/tmp/mysql.sock' (2)

 

 

Faz ps e mostra-nos os processos.