Author Topic: Strange sudden errors (Read 2406 times)

Dabaron · « **on:** August 14, 2006, 08:59:14 am »

My bot has been running great for quite a while. All of a sudden for the last 2 days on occasional tower attacks I get the following error:

[2006-08-14 06:10:05] [GROUP] [MSG] [All Towers] 0: Jitterz (OMNI, Java Corp
) attacked Valheru Ascendants (AoF) (CLAN) at Tir County, 3228x669.

Warning: fopen(http://www.anarchy-online.com/character/bio/d/1/name/jitterz/bio.
xml): failed to open stream: HTTP request failed! HTTP/1.0 503 Service Unavailab
le
in C:\BeBot\BeBot_v0.2.4\BeBot_v0.2.4\Bot.php on line 695

Warning: fgets(): supplied argument is not a valid stream resource in C:\BeBot\B
eBot_v0.2.4\BeBot_v0.2.4\Bot.php on line 698
MySQL error (# 1) on query: INSERT INTO tower_attack (time, off_guild, off_side,
off_player, off_level, off_profession, def_guild, def_side, zone, x_coord, y_co
ord) VALUES ('1155535826', 'Java Corp', 'Omni', 'Jitterz', '?', 'Unknown', 'Valh
eru Ascendants (AoF)', 'Clan', 'Tir County', '3228', '669')
Out of range value adjusted for column 'off_level' at row 1

Most of the time its fine, but occasionally that happens. Also when this happens it dies out of IRC at same time due to ping timeout. The bot and irc server are running on the same box so not sure whats going on. It looks to me like its taking too long to get info from Funcoms server or something, but the bot is still in game fine (never dies there) and still works. A whois works fine too.

Any suggestions would be most apreciated.

Brianich · « **Reply #1 on:** August 14, 2006, 09:55:35 am »

Btw, i saw same error (Warning: fopen(http://www.anarchy-online.com/character/bio/d/1/name/jitterz/bio.
xml): failed to open stream: HTTP request failed! HTTP/1.0 503), on my bot, but not always. i think can be problem with internet connection. ten it happends, he lost ai lvls data

.

Check Firewall settings.

btw. do u have ai lvl problems in !online list?

Alreadythere · « **Reply #2 on:** August 14, 2006, 11:01:25 am »

Most likely problem is that either the player isn't in the FC db yet, or the FC site is lagging or unavailable.

The mysql error is caused by the ? in the level column, which only expects numbers as entries.

No clue why IRC disconnects, I'm not using it.

Dabaron · « **Reply #3 on:** August 14, 2006, 11:15:59 am »

Strange part is that I can do a whois right after and it gives me all their info.

Khalem · « **Reply #4 on:** August 14, 2006, 04:29:19 pm »

This is a twofold problem, and unfortunately i don't have any plans to backport the 0.3.x code because it will break backwards compactibility in its current form, something i simply don't want to do in a stable branch.

Part 1 of the problem:
When a tower attack occurs, there will be anywhere from 500 to 2000 bots simultaniously doing a lookup from funcom on the person attacking. In the event of multiple orgs attacking at once, multiply the number of near simultanious request with the original estimate. In short, large attacks overwhelms funcom XML web servers despite of their proxy load balancing.
This is mitigated somewhat by the whois cache in 0.3, or Alreadytheres whois cache in combination with a modified tower module to make use of it.

Part 2 of the problem:
The method 0.2.x uses to fetch URL's cause the bot to "freeze" up completely until the lookup is complete or fails. In the event of funcom servers being unresponsive, it will wait for a timeout. The result of this is that the bot remains unable to process anything else while waiting for the URL fetch to complete. By the time the timeout occurs, you can run into the problem that the bot did not respond to IRC requests like PING causing the bot to get disconnected from IRC.

If you run the IRC server yourself, you could mitigate the problem by decreasing the ping frequency for the bot's connection class.

The MySQL error is clearly a bug however as the bot should handle the eventuality of a lookup failing.

If someone wants to take the trouble to backport the whois cache and new get_site code to 0.2.x without breaking backwards compactibility, please feel free to submitt a patch.

Dabaron · « **Reply #5 on:** August 14, 2006, 07:06:40 pm »

That makes sense.

I did see a module written by Akarah for towers that utilizes the cacheing but for some reason I can't get it working. When I start the bot with that enabled I get about 40 lines of garbage in the bot window and the tower module isn't working. I guess I can either try to mod mine to inclue that, upgrade to .3 or work with Akarah to get that one working since we are in same org.

Glarawyn · « **Reply #6 on:** August 14, 2006, 11:38:08 pm »

Setting up the WhoisCache module and then modifying the towers module to use the whois cache works great, but you have to do it in that order. A modified towers module wouldn't work without the WhoisCache module.