Bug: ahbot bids no longer saved to the database #141
Description
Current Behaviour
I have recently updated to e2b8607, as I was excited about the fix for the AH drain over time issue.
I happen to run a grafana dashboard to monitor a few things such as AH activity and mail queues and have noticed that since updating to e2b8607, when an auction is bid on by the bot it is visible in the WOW client but, no longer saved to the database. The impact of this is that if a server is restarted, then all active bids are lost.
Client AH view
Database AH View
In my previous baseline (eea2e77), a bid on an item was written to the database more or less immediately.
If my character makes a bid on an AH item it is still written to the database immediately, which seems correct e.g.:
Expected Behaviour
When using eea2e77, when the ahbot bids on an item, the bid should be written to the database table (acore_characters.auctionhouse.lastbid)
Steps to reproduce the problem
- Wow character lists an item on the AH for sale
- AHbot bids on the item
Extra Notes
No response
AC rev. hash/commit
AC> server debug
AC> AzerothCore rev. d1032678fff2+ 2025-02-16 22:27:55 +0800 (Playerbot branch) (Unix, Release, Static)
Connected players: 0. Characters in world: 365.
Connection peak: 0.
Server uptime: 20 second(s)
Update time diff: 45ms. Last 218 diffs summary:
|- Mean: 33ms
|- Median: 1ms
|- Percentiles (95, 99, max): 38ms, 736ms, 2483ms
Using SSL version: OpenSSL 3.0.15 3 Sep 2024 (library: OpenSSL 3.0.15 3 Sep 2024)
Using Boost version: 1.74.0
Using CMake version: 3.25.1
Using MySQL version: 80403
Found MySQL Executable: /usr/bin/mysql
Compiled on: Linux 6.8.12-5-pve
Worldserver listening connections on port 8085
Realmlist (Realm Id: 1) configured in port 8085
VMAPs status: Enabled. LineOfSight: true, getHeight: true, indoorCheck: true
MMAPs status: Enabled
maps directory located in ./maps. Total size: 291014951 bytes
vmaps directory located in ./vmaps. Total size: 658130721 bytes
mmaps directory located in ./mmaps. Total size: 2192910844 bytes
Default DBC locale: enUS.
All available DBC locales: enUS
Using World DB: ACDB 335.13-dev
Using Playerbots DB Revision:
Latest LoginDatabase update: 2025_01_26_00.sql
Latest CharacterDatabase update: playerbots_names.sql
Latest WorldDatabase update: world_playerbots_rpg_races.sql
LoginDatabase queue size: 0
CharacterDatabase queue size: 22
WorldDatabase queue size: 0
PlayerbotsDatabase queue size: 28
List of enabled modules:
|- mod-ah-bot
|- mod-playerbots
Operating system
Debian 12/Bookworm
Custom changes or Modules
List of enabled modules:
|- mod-ah-bot
|- mod-playerbots