The worldserver boot loops

[youhuowa]

the latest commit with the latest azerothcore playerbot branch was built successfully but the worldserver ended up boot loops

DBerrors

[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acore_world.c.map' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.
[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acore_world.c.map' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.
[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acore_world.c.map' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.
[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acore_world.c.map' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.
[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acore_world.c.map' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.
[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acore_world.c.map' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.
[1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acore_world.c.map' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.

Server logs

AzerothCore rev. 68d3ec7d77ac 2022-04-04 07:53:51 -0600 (Playerbot branch) (Unix, Release, Static) (worldserver-daemon)
to stop.

█████╗ ███████╗███████╗██████╗ ██████╗ ████████╗██╗ ██╗
██╔══██╗╚══███╔╝██╔════╝██╔══██╗██╔═══██╗╚══██╔══╝██║ ██║
███████║ ███╔╝ █████╗ ██████╔╝██║ ██║ ██║ ███████║
██╔══██║ ███╔╝ ██╔══╝ ██╔══██╗██║ ██║ ██║ ██╔══██║
██║ ██║███████╗███████╗██║ ██║╚██████╔╝ ██║ ██║ ██║
╚═╝ ╚═╝╚══════╝╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═╝ ╚═╝
██████╗ ██████╗ ██████╗ ███████╗
██╔════╝██╔═══██╗██╔══██╗██╔════╝
██║ ██║ ██║██████╔╝█████╗
██║ ██║ ██║██╔══██╗██╔══╝
╚██████╗╚██████╔╝██║ ██║███████╗
╚═════╝ ╚═════╝ ╚═╝ ╚═╝╚══════╝

 AzerothCore 3.3.5a  -  www.azerothcore.org

Using configuration file /root/azerothcore-wotlk/env/dist/etc/worldserver.conf
Using SSL version: OpenSSL 1.1.1f 31 Mar 2020 (library: OpenSSL 1.1.1f 31 Mar 2020)
Using Boost version: 1.71.0

Process priority class set to -15

Loading modules configuration...

Using modules configuration:

mod_ahbot.conf
character_tools.conf.dist
mod_congratsonlevel.conf
mod_customlogin.conf
npc_allmounts.conf
playerbots.conf
reward_system.conf
WorldChat.conf

Initializing Scripts...

Loading C++ scripts

Opening DatabasePool 'acore_auth'. Asynchronous connections: 1, synchronous connections: 1.
DatabasePool 'acore_auth' opened successfully. 2 total connections running.

Opening DatabasePool 'acore_characters'. Asynchronous connections: 1, synchronous connections: 2.
DatabasePool 'acore_characters' opened successfully. 3 total connections running.

Opening DatabasePool 'acore_world'. Asynchronous connections: 1, synchronous connections: 1.
DatabasePool 'acore_world' opened successfully. 2 total connections running.

Updating Auth database...

Auth database is up-to-date! Containing 1 new and 28 archived updates.

Updating Character database...

Character database is up-to-date! Containing 4 new and 48 archived updates.

Updating World database...

World database is up-to-date! Containing 275 new and 2512 archived updates.

Opening DatabasePool 'acore_playerbots'. Asynchronous connections: 1, synchronous connections: 1.
DatabasePool 'acore_playerbots' opened successfully. 2 total connections running.

Updating Playerbots database...
DBUpdater: Given update include directory "/root/azerothcore-wotlk/modules/mod-playerbots/sql/playerbots/archive" does not exist, skipped!

Playerbots database is up-to-date! Containing 0 new and 0 archived updates.

Loading world information...

RealmID: 1
Version DB world: ACDB 335.6-dev
Will clear logs table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ./
WORLD: VMap support included. LineOfSight:true, getHeight:true, indoorCheck:true PetLOS:true

Loading acore strings...

Loaded 1151 acore strings in 27 ms

Initialize data stores...

Initialized 107 data stores in 1251 ms

Using enUS DBC Locale as default. All available DBC locales: enUS

Loading Cinematic Camera files
Loaded 14 cinematic waypoint sets in 3 ms
Loading IP Location Database...

Loading Game Graveyard...

Loaded 685 graveyard in 5 ms

Initializing PlayerDump tables...

Initialized tables for PlayerDump in 167 ms.
Loading SpellInfo store...
Loaded spell custom attributes in 90 ms

Loading SpellInfo data corrections...

Loading spell dbc data corrections in 5 ms

Loading Spell Rank Data...

Loaded 3502 spell rank records in 32 ms

Loading Spell Specific And Aura State...

Loaded spell specific and aura state in 4 ms

Loading SkillLineAbilityMultiMap Data...

Loaded 10219 SkillLineAbility MultiMap Data in 1 ms

Loading SpellInfo custom attributes...

Loaded 255 spell custom attributes from DB in 21 ms
Loaded SpellInfo custom attributes in 33 ms

Loading GameObject models...

Loaded 2324 GameObject models in 2 ms

Loading Script Names...

Loaded 2741 ScriptNames in 2337 ms

Loading Instance Template...

Loaded 85 instance templates in 2 ms

Load Character Cache...
Loaded character infos for 2048 characters in 7 ms

Loading instances...

Loaded instances and binds in 30 ms

Loading Broadcast texts...

Loaded 73039 Broadcast texts in 788 ms

[ZhengPeiRu21]

Is anyone else experiencing this error? Will you please share more information on what "boot loops" is meaning?

[youhuowa]

Here is the coredump
coredump.txt

[ZhengPeiRu21]

Is this still an issue on the latest version?