search

vmangos / core

Progressive Vanilla Core aimed at all versions from 1.2 to 1.12
GNU General Public License v2.0
679 stars 487 forks source link

šŸ› [Bug] Realmd crashes when connection is being made. #2807

Open dd667 opened 15 hours ago

dd667 commented 15 hours ago

šŸ› Bug report

Freshly compiled core with fresh DB does not want to allow connections. Realmd runs fine for long period but if successful connection is made, then the login server crashes instantly. Checked structure and column 'platform' does exist in realmd database.

Steps to reproduce

  1. account create X X
  2. Use wow client to login
  3. Watch realmd crash with error message

Version & Environment

Client Version:

Crashlog

2024-10-22 16:37:17 Core revision: 84d3b473e94417f415ac / 2024-10-19 18:57:06 +0300 / Linux_x64 (little-endian) [realm-daemon] 2024-10-22 16:37:17 to stop.

2024-10-22 16:37:17 Using configuration file /home/ateny/vmangos/etc/realmd.conf. 2024-10-22 16:37:17 Max allowed open files is 1024 2024-10-22 16:37:17 Database: 127.0.0.1;3306;;;realmd 2024-10-22 16:37:17 Added realm "Azeroth" 2024-10-22 16:38:10 Accepting connection from '192.168.50.44' 2024-10-22 16:38:10 [AuthChallenge] Account '1' using IP '192.168.50.44' is using 'enUS' locale (0) 2024-10-22 16:38:10 [AuthChallenge] Account '1' using IP '192.168.50.44' successfully authenticated 2024-10-22 16:38:10 SQL: UPDATE account SET sessionkey = 'BA922C6CAC27AFF469D949AF00EC07B908B956074003CB135452E445F3FA57CF12D11F7BFA1EE34D', last_ip = '192.168.50.44', last_login = NOW(), locale = '0', failed_logins = 0, os = 'OSX', platform = 'x86' WHERE username = '1' 2024-10-22 16:38:10 [1054] Unknown column 'platform' in 'field list' 2024-10-22 16:38:10 Your database structure is not up to date. Please make sure you have executed all the queries in the sql/updates folders. 2024-10-22 16:38:10 /home/ateny/vmangos/core/src/shared/Database/DatabaseMysql.cpp:184: Error: Assertion in HandleMySQLError failed: false 2024-10-22 16:38:10 ./realmd(+0x3a640) [0x55e04ee8a640] ./realmd(+0x32fc2) [0x55e04ee82fc2] ./realmd(+0x17e9e) [0x55e04ee67e9e] ./realmd(+0x15cf2) [0x55e04ee65cf2] ./realmd(+0x1c045) [0x55e04ee6c045] /lib/x86_64-linux-gnu/libACE-7.0.6.so(_ZN20ACE_Dev_Poll_Reactor17dispatch_io_eventERNS_11Token_GuardE+0x2e7) [0x7f49119d8d27] /lib/x86_64-linux-gnu/libACE-7.0.6.so(_ZN20ACE_Dev_Poll_Reactor13handle_eventsEP14ACE_Time_Value+0x1fe) [0x7f49119dadfe] /lib/x86_64-linux-gnu/libACE-7.0.6.so(_ZN11ACE_Reactor22run_reactor_event_loopER14ACE_Time_ValuePFiPS_E+0xd2) [0x7f4911a298c2] ./realmd(+0x14666) [0x55e04ee64666] /lib/x86_64-linux-gnu/libc.so.6(+0x29d90) [0x7f49109c6d90] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x80) [0x7f49109c6e40] ./realmd(+0x14b05) [0x55e04ee64b05]

Also, during DB update, following error shows:

Invalid default value for 'last_login'

ratkosrb commented 15 hours ago

You failed to run some of the migrations, likely because you are using the wrong mysql version. Switch to mysql 5.5 and you won't have any issues with migrations.