Author Topic: (closed) rosterupdate fails (Read 2546 times)

screwy · « **on:** July 06, 2009, 11:18:33 pm »

Hey all!

Rosterupdate fails because the bot tried to add stuff to the database that required unique IDs, but is supplying the same one for every entry.

According to the log, these are the SQL entried:

Code: [Select]

INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sylo669', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Apocalypze', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Drkwak', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Pienipupu', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Pulskapupu', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Mundylusius', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Shadowops', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Dirtypickle', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Tinglyma', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Beelzeboob', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Lenridel', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Donkiepunch', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Quantumman', 'Roster-XML', '1246912822', '2', '1')
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Fickitgurl', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Begmefor', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Captaindurrr', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Maotao', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Ecat', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Bennymoowoo', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Lacyqueen', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sirhealaloty', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Timthepinger', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Frynancial', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Urdarnskippy', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Froob1', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Froob2', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Bighairyape', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Hettsbank', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Colkirby', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Gunzblazin', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sillycoon', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Soldiermk1', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Kumdumpster', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Hienztank', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Amarath', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Whofixedwho', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Drhowse', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Krvnik', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Eddysengie', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Wraglexzzor', 'Roster-XML', '1246912822', '2', '1');
INSERT INTO heinzdb_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('2147483647', 'Sillycoone', 'Roster-XML', '1246912822', '2', '1');

As you can see, the char_id is the same for all.

Ideas?

-Screwy.

screwy · « **Reply #1 on:** July 06, 2009, 11:36:51 pm »

I also notices that the whois db has a lot of ID entries with "0". Are those supposed to get update on the next whois? Or so?

Khalem · « **Reply #2 on:** July 07, 2009, 12:09:50 am »

The rosterupdate issue has never been reported before or seen before, even on 64bit php installs.

Are there any errors in the log aside from the MySQL errors?
Could you give us some more information about your operating enviroment, OS, php version, version of the bot, any modifications done etc.

screwy · « **Reply #3 on:** July 11, 2009, 12:02:46 am »

Hey,

I tried to replicate the problem for easier debugging, turns out that after I dumped the botname_users and whois tables, restarted the bot, did a rosterupdate, well, everything is fine again.

Sorry I can not give you any further debug information. For now, let's consider this a one-time-hiccup that can not replicated.

If further errors occur I will keep you folks posted.

-Screwy.