Transformers and More @ The Seibertron Store
Details subject to change. See listing for latest price and availability.
There is, but it's a moot point because the bits that are still in use apparently DO match. The discrepancy in the IDs doesn't affect anything, and the table is used, just not in the battle script.Seibertron wrote:Well, then there is definitely a discrepancy then if the code doesn't match the database.
Yeah, I get that - what I mean is that in the past we've had an issue where old mission_character records interfered with new missions. I don't believe that's the root issue here, but if there are any records in mission_characters with a mission_id much higher than about 368850, it would be *a* cause - and if there aren't, it can be eliminated from consideration.Seibertron wrote:It's not logging missions currently.Glyph wrote:And if you're looking at the database, could you also check that the highest mission_id in mission_characters isn't higher than the latest ID in the missions table?
Psychout wrote:Im not scared of a gender confused minibot!
Tekka wrote:What she doesn't realize is that Springer actually loves Rodimus.
Psychout wrote:Im not scared of a gender confused minibot!
Tekka wrote:What she doesn't realize is that Springer actually loves Rodimus.
ThunderThruster wrote:Had the same issue as Psychout. Any characters that I could get into a mission, generated "No record available". Just thrown a couple of bots into the Arena to see if it's working.
Seibertron wrote:Sorry guys ... I couldn't figure out what I did earlier that broke the missions. I've been hammering away at this for 14 hours. I'll tackle it again tomorrow night hopefully. Bear with me!
I enabled some new logging functionality tonight so that i can take a look at what's going on. please feel free to add characters into missions and arena battles so that i can take a look at the logs tomorrow to see if any patterns come to light.
If I can't figure this out, I might just rewrite the whole mission and arena log process which has been needed to be done since day 1 of HMW. That's on the agenda anyways but it might happen sooner than later if I can't figure this out.
Nearly all missions have 20 minutes between closing signups and updating characters with the cached results, with nearly all battles/logs getting processed within the first minute. That should give a decent amount of time to try the battle again if it's got the process flag but hasn't been properly completed in, say, five minutes after its start time (or, for that matter, to run a mission multiple times for debug purposes and just keep the last run's result). Outside of that time, no guarantee that bots would be available or that they'd have the same level & stats as when they entered, and you could get some very strange effects if characters suddenly & randomly became busy while players are e.g. doing upgrades - I'd honestly rather shrug off the failed mission than have my bots unexpectedly dropping into a battle/CR at some future point.Seibertron wrote:Basically, I'm working on creating a script that will "requeue" and "reprocess" failed missions [...] The script will grab a few missions which has characters not currently doing something else at the moment, requeue the mission using current timestamps, and then forcing their processing so that I can properly debug this damn code. [...] Once I get all of this working again, I'll modify this script to process all battles that failed that are in the database still.
Given how much time a full rewrite would take and that one of the earlier Silver Age announcements was that the whole site's code is now under version control, can the recent changes not just be rolled back while you're investigating what went wrong?Seibertron wrote:If I can't figure this out, I might just rewrite the whole mission and arena log process which has been needed to be done since day 1 of HMW. That's on the agenda anyways but it might happen sooner than later if I can't figure this out.
Psychout wrote:Im not scared of a gender confused minibot!
[INFO] [b]Starting fix-stuck-missions tool[/b] ...
[INFO] Yes, this script should resolve unfinished missions and missions with Unknowns declared as winner.
[INFO] In addition to that, this will help solve what's going wrong with hmw_battle processing.
[INFO] Mission limit currently set to: 1. This can be adjusted as needed as more examples are needed.
[INFO] Local environment detected — clearing mission state...
[OK] Reset hmw_character_doing for local testing.
[OK] 1 missions found.
[INFO] Processing stuck mission ID: 72034
[OK] 1 characters found for mission (72034)
[INFO] Character roster for mission 72034:
[->] character_id=106387 user_id=132447 faction=2 level=0 health=100
[->] Resetting character_id=106387
[OK] Health set to 100 for character_id=106387
[OK] Doing row inserted/updated for character_id=106387, mission_id=72034
[DEBUG] Characters have been reset into doing for mission 72034. Verify DB state before continuing.
[OK] Queued mission_id=72034 for immediate processing
[INFO] Finished.
[INFO] Starting fix-stuck-missions tool ...
[INFO] Yes, this script should resolve unfinished missions and missions with Unknowns declared as winner.
[INFO] In addition to that, this will help solve what's going wrong with hmw_battle processing.
[INFO] Mission limit currently set to: 1. This can be adjusted as needed as more examples are needed.
[INFO] Local environment detected — clearing mission state...
[OK] Reset hmw_character_doing for local testing.
[OK] 1 missions found.
[INFO] Processing stuck mission ID: 72034
[OK] 1 characters found for mission (72034)
[INFO] Character roster for mission 72034:
[->] character_id=106387 user_id=132447 faction=2 level=0 health=100
[->] Resetting character_id=106387
[OK] Health set to 100 for character_id=106387
[OK] Doing row inserted/updated for character_id=106387, mission_id=72034
[DEBUG] Characters have been reset into doing for mission 72034. Verify DB state before continuing.
[SQL] ...
[OK] Queued mission_id=72034 for immediate processing
[SQL] ...
[OK] Tagged missions in hmw_process_queue with process_tag=68afe4fed0818
[SQL] SELECT * FROM hmw_process_queue WHERE process_tag="68afe4fed0818"
[INFO]Found 1 missions in the process queue with tag 68afe4fed0818.
[INFO] Running queued mission 72034
[DONE] Mission 72034 processed.
[INFO] Finished.
Return to Heavy Metal War Forum
Registered users: Apple [Bot], ChatGPT [Bot], Google [Bot], Google Adsense [Bot], Google Feedfetcher, MSN [Bot], Silver Wind, Yahoo [Bot], Yandex [Bot]