#664 Can't create more than max_prepared_stmt_count statements

Reporter Martin Sebald
Owner Zash
Created
Updated
Stars ★ (1)
Tags
  • Type-Defect
  • Status-Duplicate
  • Priority-Medium
  1. Martin Sebald on

    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]: ?

  2. Zash on

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

    Changes
    • owner Zash
    • tags Status-Duplicate

New comment

Not published. Used for spam prevention and optional update notifications.