Szerző Téma: Syserr fixek/javítások  (Megtekintve 967 alkalommal)

Nem elérhető dunkakika

  • Beginner
  • Thank You
  • -Given: 17
  • -Receive: 0
  • Hozzászólások: 23
  • Segített: 0
Syserr fixek/javítások
« Dátum: 2019-10-02, 07:37:12 »
Sziasztok!

Valaki valami megoldást a syserr beli hibák javítására?

Keresgéltem, de 1-2 hibára nem találtam pontos megoldást :)!

Köszi!

AUTH Syserr:
SYSERR: Oct  1 05:12:56.968506 :: pid_init:
Start of pid: 2130

SYSERR: Oct  1 05:16:08.188712 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct  1 05:16:08.460780 :: pid_deinit:
End of pid

SYSERR: Oct  1 05:18:06.391765 :: pid_init:
Start of pid: 829

SYSERR: Oct  1 05:56:41.941058 :: pid_init:
Start of pid: 824

SYSERR: Oct  1 05:56:41.999071 :: socket_connect: HOST localhost:60500, could not connect.
SYSERR: Oct  1 15:19:28.890971 :: Analyze: Handshake phase does not handle packet 3 (fd 15)
SYSERR: Oct  1 15:19:28.891154 :: Process: SEQUENCE 290c2a80 mismatch 0xaf != 0x2a header 3
SYSERR: Oct  1 15:19:28.891192 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[003 : 0xaf]


CH1 syserr

SYSERR: Oct  1 05:12:59.15703 :: pid_init:
Start of pid: 2133

SYSERR: Oct  1 05:13:23.87857 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:13:23.88029 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:14:08.843645 :: ChildLoop: AsyncSQL: query failed: Table 'log' is read only (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959833, 272679, 5, 'GM_LOGIN', '', '195.228.121.134') errno: 1036)
SYSERR: Oct  1 05:14:08.844486 :: ChildLoop: AsyncSQL: query failed: Table 'log' is read only (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959833, 272679, 0, 'LOGIN', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1036)
SYSERR: Oct  1 05:14:08.845040 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 68697, inet_aton('195.228.121.134'), '') errno: 1366)
SYSERR: Oct  1 05:14:08.845752 :: ChildLoop: AsyncSQL: query failed: Table 'log' is read only (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 50000950, 'SET_SOCKET', '', '', 72702) errno: 1036)
SYSERR: Oct  1 05:15:08.537808 :: ChildLoop: AsyncSQL: query failed: Table 'log' is read only (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2973, 0, 50000950, 'SET_SOCKET', '', '', 72702) errno: 1036)
SYSERR: Oct  1 05:15:35.581390 :: ChildLoop: AsyncSQL: query failed: Table 'log' is read only (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959687, 270117, 0, 'LOGOUT', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1036)
SYSERR: Oct  1 05:15:35.582957 :: ChildLoop: AsyncSQL: query failed: Table 'log' is read only (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 32, 0, 50000950, 'SET_SOCKET', '', '', 72702) errno: 1036)
SYSERR: Oct  1 05:16:08.188704 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct  1 05:16:11.988492 :: pid_deinit:
End of pid

SYSERR: Oct  1 05:18:06.814304 :: pid_init:
Start of pid: 832

SYSERR: Oct  1 05:18:54.143266 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:18:54.143409 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:19:04.623070 :: heart_idle: losing 48 seconds. (lag occured)
SYSERR: Oct  1 05:20:07.41751 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959687, 270117, 0, 'LOGIN', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  1 05:20:07.44153 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 68697, inet_aton('195.228.121.134'), '') errno: 1366)
SYSERR: Oct  1 05:23:15.239011 :: Process: SEQUENCE 29d56200 mismatch 0xaf != 0x64 header 254
SYSERR: Oct  1 05:23:15.239056 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Oct  1 05:42:38.184294 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959801, 271990, 0, 'LOGOUT', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  1 05:42:57.312162 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959801, 271990, 0, 'LOGIN', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  1 05:42:57.312727 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 68697, inet_aton('195.228.121.134'), '') errno: 1366)
SYSERR: Oct  1 05:44:39.314997 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68697, 959714, 270548, 50000967, 'GM', 'Nyúl jelmez (barna)', '195.228.121.134', 41001) errno: 1406)
SYSERR: Oct  1 05:45:33.766425 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:45:33.766589 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:45:44.663159 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:45:44.663334 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:46:06.913120 :: Process: SEQUENCE 29d56200 mismatch 0xaf != 0x64 header 254
SYSERR: Oct  1 05:46:06.913193 :: Process: SEQUENCE_LOG [UNKNOWN]-------------
[254 : 0xaf]

SYSERR: Oct  1 05:48:52.20749 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959817, 271396, 0, 'LOGOUT', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  1 05:56:43.656410 :: pid_init:
Start of pid: 827

SYSERR: Oct  1 05:57:29.38227 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:57:29.38451 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:57:47.938708 :: heart_idle: losing 54 seconds. (lag occured)
SYSERR: Oct  1 05:57:56.37650 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959817, 271396, 0, 'LOGIN', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  1 05:57:56.44560 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 68697, inet_aton('195.228.121.134'), '') errno: 1366)
SYSERR: Oct  1 06:01:06.104918 :: Analyze: login phase does not handle this packet! header 100
SYSERR: Oct  1 06:04:05.7642 :: Analyze: login phase does not handle this packet! header 100
SYSERR: Oct  1 06:06:58.373237 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 960366, 269728, 0, 'LOGOUT', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  1 07:18:22.676177 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959817, 271396, 0, 'LOGIN', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  1 07:18:22.676676 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 68697, inet_aton('195.228.121.134'), '') errno: 1366)
SYSERR: Oct  1 07:19:18.44675 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 960068, 270472, 0, 'LOGOUT', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  2 07:27:45.494056 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Oct  2 07:27:45.494835 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68697, 959817, 271396, 0, 'LOGIN', '195.228.121.134 0 1 41 200000', '195.228.121.134') errno: 1406)
SYSERR: Oct  2 07:27:45.495356 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 68697, inet_aton('195.228.121.134'), '') errno: 1366)
SYSERR: Oct  2 07:27:45.529372 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Oct  2 07:27:46.568250 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 68697, 959817, 271396, 50000967, 'REAL_TIME_EXPIRE', 'Nyúl jelmez (barna) 1 ', '195.228.121.134', 41001) errno: 1406)
SYSERR: Oct  2 07:30:56.205979 :: Analyze: login phase does not handle this packet! header 100

db syserr

SYSERR: Oct  1 05:12:54.794518 :: pid_init:
Start of pid: 2127

SYSERR: Oct  1 05:16:08.188905 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct  1 05:16:08.277489 :: pid_deinit:
End of pid

SYSERR: Oct  1 05:18:03.309235 :: pid_init:
Start of pid: 826

SYSERR: Oct  1 05:53:50.76358 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Oct  1 05:53:50.76435 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Oct  1 05:53:50.76472 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Oct  1 05:53:50.76508 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Oct  1 05:56:40.502674 :: pid_init:
Start of pid: 821

SYSERR: Oct  1 06:08:04.839195 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player  SET job = 5, voice = 0, dir = 0, x = 960366, y = 269728, z = 0, map_index = 41, exit_x = 960366, exit_y = 269728, exit_map_index = 41, hp = 14010, mp = 2705, stamina = 945, random_hp = 4200, random_sp = 2205, playtime = 39, level = 105, level_step = 0, st = 4, ht = 3, dx = 6, iq = 3, gold = 0, exp = 0, stat_point = 270, skill_point = 104, sub_skill_point = 96, stat_reset_count = 0, ip = '195.228.121.134', part_main = 41001, part_hair = 0, last_play = NOW(), skill_group = 0, alignment = 200000, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1569912405, horse_stamina = 200, 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\
SYSERR: Oct  1 07:26:20.533245 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player  SET job = 5, voice = 0, dir = 0, x = 960068, y = 270472, z = 0, map_index = 41, exit_x = 960068, exit_y = 270472, exit_map_index = 41, hp = 14010, mp = 2705, stamina = 945, random_hp = 4200, random_sp = 2205, playtime = 31, level = 105, level_step = 0, st = 4, ht = 3, dx = 6, iq = 3, gold = 0, exp = 0, stat_point = 270, skill_point = 104, sub_skill_point = 96, stat_reset_count = 0, ip = '195.228.121.134', part_main = 41001, part_hair = 0, last_play = NOW(), skill_group = 0, alignment = 200000, horse_level = 30, horse_riding = 1, horse_hp = 50, horse_hp_droptime = 1569912405, horse_stamina = 200, 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\
SYSERR: Oct  1 09:23:20.858079 :: Process: FDWATCH: peer null in event: ident 24

game99 syserr:

SYSERR: Oct  1 05:13:03.168380 :: pid_init:
Start of pid: 2139

SYSERR: Oct  1 05:13:13.967410 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Oct  1 05:13:15.98535 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:13:15.98718 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:16:08.188702 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct  1 05:16:08.546749 :: ForAttrRegion: Cannot find SECTREE_MAP by map index 41
SYSERR: Oct  1 05:16:08.577571 :: pid_deinit:
End of pid

SYSERR: Oct  1 05:18:10.875145 :: pid_init:
Start of pid: 838

SYSERR: Oct  1 05:18:39.652436 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Oct  1 05:18:45.261898 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:18:45.262064 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:18:54.740552 :: heart_idle: losing 38 seconds. (lag occured)
SYSERR: Oct  1 05:45:33.768317 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:45:33.768526 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:45:44.715768 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:45:44.715898 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:56:47.573060 :: pid_init:
Start of pid: 833

SYSERR: Oct  1 05:57:16.21603 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Oct  1 05:57:20.18195 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Oct  1 05:57:20.18386 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Oct  1 05:57:29.158061 :: heart_idle: losing 35 seconds. (lag occured)
« Utoljára szerkesztve: 2019-10-02, 13:51:35 írta [SMOD]Ken »
~ A szerencsejátékban a legnagyobb hasznot úgy érheted el, ha nem játszol~

~ [K]iller ~

Nem elérhető gyertya

  • Trainee
  • *
  • Thank You
  • -Given: 8
  • -Receive: 7
  • Hozzászólások: 79
  • Segített: 3
Re:Syserr fixek/javítások
« Válasz #1 Dátum: 2019-10-05, 13:34:12 »
Szia.

Nem azért hogy kötözködjek de egyértelműen írja mindenre a hibát.

Header-ekbe valami nem egyezik.
3596-os mob-nál vagy a data-ba nincs jól feltöltve a cucc, vagy mob_protoba a skill-nál nem jó a szám. (De inkább az elöbbi)

Log tábla nem írható.
is_gm a loginlog2-ben átkell állítsd design->ott kikeresed az "is_gm" mezőt és nem tudom mire van állítva, azt állítsd át, ha látom min van talán tudok segíteni.

Log tábala design->ott kikeresed a "hint"-et átírod az értéket mondjuk 255-ig abba biztos elfér.

Player tábla Design-> ott kikeresed "part_main" Átállítod nagyobbra gondolom mondjuk 42000+ feletti kosztöm van rajtad, és mikor be akarsz lépni az az érték ami a táblába van, már kivül esik.

Illetve a 41-es mapindex-en lévő mapot nem találja szerver oldalon.

Nem elérhető trodhenta

  • Trainee
  • *
  • Thank You
  • -Given: 6
  • -Receive: 12
  • Hozzászólások: 113
  • Segített: 12
  • President
Re:Syserr fixek/javítások
« Válasz #2 Dátum: 2019-10-05, 15:21:26 »
'Gyertának'  ;D  teljesen igaza van ebben. Ezzel most sok időt elvesztettél hogy ezt ki írtad ide, ha valamihibára nemtudod afixet akkor ctrl+c + ctrl+v google-ba, és megkeresed. 99% hogy a hibák nagy részére van valami leírás, akár magyar, akár külföldi oldalon. + Ráadásul ezek ilyen alap hibáknak tűnnek
Ha segítettem vagy akármi érted, akkor a +-t elfogadom.

Nem elérhető dunkakika

  • Beginner
  • Thank You
  • -Given: 17
  • -Receive: 0
  • Hozzászólások: 23
  • Segített: 0
Re:Syserr fixek/javítások
« Válasz #3 Dátum: 2019-10-09, 06:32:03 »
Kedves gyertya!

Itt a kép loginlog2 ről:

https://imgur.com/a/FXyFtcd


Kedves trodhenta, erre szeretnék megoldást találni leginkább.... a többit megoldom ha nem segít gyertya akkor is.

https://imgur.com/a/UiN31Ys


Köszönöm a válaszokat.
« Utoljára szerkesztve: 2019-10-09, 06:35:47 írta dunkakika »
~ A szerencsejátékban a legnagyobb hasznot úgy érheted el, ha nem játszol~

~ [K]iller ~