So, we've loaded the module cs_accessfounder which appeared to have a bug (told by the person who'd wanted us to load the module... But tested it, worked fine). This module should make it possible to have 2 founders set on a channel, which did work! But... Now our anope is absolutely dead. Step by step what we've done to kill anope:
- We've loaded the module.
- We've set 2 founders for the channel '#ChatArea'. Worked fine.
- A day later, today, anope suddenly closed the connection, so we started anope again.
- Anope didn't respond anymore, /cs help didn't return anything, nothing worked.
- Tried to find out what was wrong, found out that since the module 'cs_accessfounder' this happend.
- Unloaded the module, then ran anope again. Again, nothing.
- Started anope in debug mode, which told us:
[May 25 21:46:05.526425 2011] debug: MySQL: UPDATE anope_cs_ttb SET value = 0, active = 1 WHERE channel = '#Idle' AND ttb_id = 3
[May 25 21:46:05.527067 2011] debug: MySQL: UPDATE anope_cs_ttb SET value = 0, active = 1 WHERE channel = '#Idle' AND ttb_id = 4
[May 25 21:46:05.527717 2011] debug: MySQL: UPDATE anope_cs_ttb SET value = 0, active = 1 WHERE channel = '#Idle' AND ttb_id = 5
[May 25 21:46:05.528380 2011] debug: MySQL: UPDATE anope_cs_ttb SET value = 0, active = 1 WHERE channel = '#Idle' AND ttb_id = 6
[May 25 21:46:05.528966 2011] debug: MySQL: UPDATE anope_cs_ttb SET value = 0, active = 1 WHERE channel = '#Idle' AND ttb_id = 7
[May 25 21:46:05.529574 2011] debug: MySQL: UPDATE anope_cs_info SET founder = 'Angel', successor = '', founderpass = '**********ยค', descr = '*********m', url = '', email = '', time_registered = 1304672446, last_used = 1306352056, last_topic = '4,8Welkom bij InterChat! Hou het gezellig en neem gerust je vrienden mee! Veel plezier!4,8 http://*******/', last_topic_setter = 'jumper', last_topic_time = 1304339374, flags = 12385, forbidby = '', forbidreason = '', bantype = 2, accesscount = 0, akickcount = 0, mlock_on = 548, mlock_off = 0, mlock_limit = 0, mlock_key = '', mlock_flood = '', mlock_redirect = '', entry_message = '', memomax = 20, botnick = '', botflags = 28, bwcount = 0, capsmin = 0, capspercent = 0, floodlines = 0, floodsecs = 0, repeattimes = 0, active = 1 WHERE name = '#InterChat'
[May 25 21:46:05.530309 2011] debug: MySQL: UPDATE anope_cs_levels SET level = 5, active = 1 WHERE channel = '#InterChat' AND position = 0
[May 25 21:46:05.530941 2011] debug: MySQL: UPDATE anope_cs_levels SET level = 10, active = 1 WHERE channel = '#InterChat' AND position = 1
[May 25 21:46:05.531596 2011] debug: MySQL: UPDATE anope_cs_levels SET level = -10000, active = 1 WHERE channel =
And again and again and again... Flooding the same thing which HUGE speed.
- Turned SQL off, restarted anope, everything worked!
- Removed the second owner of the channel #ChatArea and turned SQL back on.
- Again, flood and Anope not responding.
- Backupped our .db files, other stuff etc. and reinstalled Anope (1.8.5.).
- Started anope without SQL, worked fine.
- Cleaned up our MySQL databases and imported clean tables.
- Turned SQL back on and restarted anope
- Updated databases (from .db > MySQL)
- Restarted anope
- And back to the begin, NOTHING.
After this we found out that the table anope_cs_levels has been full flooded with the debug's output. On every channel there has been set an large amount of levels, which shouldn't be. The table anope_cs_levels contains 58 pages of this.
So, we concluded that there has gone something terribly wrong with the sql. The module shouldn't have anything to do with it because we reinstalled Anope without the module and removed the second founder.
In my opinion the table anope_cs_levels shouldn't be like that..
But, to make a large story short: After using a module, Anope does not respond using SQL, DOES respond WITHOUT SQL and in the anope_cs_levels table has been insert a huge amount of rows.
Any help? Please note that we CANNOT give a full debug output. While running anope in debug mode it'll flood putty to death so we cant copy it all, the debug output above was just a small part which I happend to copy by luck.