What steps will reproduce the problem? No idea, prosody.err suddenly was full of errors. This happened at least two times, some users still are logged on, some not, users cannot login anymore. What version of the product are you using? On what operating system? 0.9 1nightly262-1~sid Please provide any additional information below. Apr 14 08:49:20 jabber.hot-chilli.net:storage_sql error QUERY FAILED: Error preparing statement handle: Can't create more than max_prepared_stmt_count statements (current value: 16382) stack traceback: /usr/lib/prosody/modules/mod_storage_sql.lua:214: in function </usr/lib/prosody/modules/mod_storage_sql.lua:207> (tail call): ? /usr/lib/prosody/modules/mod_storage_sql.lua:244: in function </usr/lib/prosody/modules/mod_storage_sql.lua:243> [C]: in function 'xpcall' /usr/lib/prosody/modules/mod_storage_sql.lua:294: in function </usr/lib/prosody/modules/mod_storage_sql.lua:291> (tail call): ? /usr/lib/prosody/core/rostermanager.lua:94: in function 'load_roster' /usr/lib/prosody/core/rostermanager.lua:209: in function 'is_contact_subscribed' /usr/lib/prosody/modules/mod_presence.lua:232: in function </usr/lib/prosody/modules/mod_presence.lua:225> (tail call): ? /usr/lib/prosody/util/events.lua:67: in function 'fire_event' ... /usr/lib/prosody/util/xmppstream.lua:255: in function 'feed' /usr/lib/prosody/modules/mod_s2s/mod_s2s.lua:544: in function 'data' /usr/lib/prosody/modules/mod_s2s/mod_s2s.lua:604: in function 'onincoming' /usr/lib/prosody/net/server_event.lua:633: in function </usr/lib/prosody/net/server_event.lua:579> [C]: in function 'loop' /usr/lib/prosody/net/server_event.lua:794: in function </usr/lib/prosody/net/server_event.lua:793> [C]: in function 'xpcall' /usr/bin/prosody:376: in function 'loop' /usr/bin/prosody:407: in main chunk [C]: ?

Hi. Thanks for the report. This is a duplicate of #391, so I will close this one. Please subscribe (star) the other one.

• owner Zash
• tags Status-Duplicate