#748 Can't create more than max_prepared_stmt_count statements

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

    Hi, I'm using Prosody 0.9.10 on my Debian Jessie Server with MySQL backend. Recently I'm getting this error message very frequently in my Prosody Logs: Sep 21 10:02:21 trashserver.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:207: in function </usr/lib/prosody/modules/mod_storage_sql.lua:200> (tail call): ? /usr/lib/prosody/modules/mod_storage_sql.lua:237: in function </usr/lib/prosody/modules/mod_storage_sql.lua:236> [C]: in function 'xpcall' /usr/lib/prosody/modules/mod_storage_sql.lua:287: in function 'get' /usr/lib/prosody/modules/mod_vcard.lua:25: in function '?' /usr/lib/prosody/util/events.lua:67: in function </usr/lib/prosody/util/events.lua:63> (tail call): ? /usr/lib/prosody/modules/mod_iq.lua:38: in function '?' /usr/lib/prosody/util/events.lua:67: in function 'fire_event' /usr/lib/prosody/core/stanza_router.lua:187: in function 'core_post_stanza' ... /usr/lib/prosody/util/xmppstream.lua:255: in function 'feed' /usr/lib/prosody/modules/mod_c2s.lua:230: in function 'data' /usr/lib/prosody/modules/mod_c2s.lua:252: in function 'onincoming' /usr/lib/prosody/net/server_event.lua:632: in function </usr/lib/prosody/net/server_event.lua:578> [C]: in function 'loop' /usr/lib/prosody/net/server_event.lua:793: in function </usr/lib/prosody/net/server_event.lua:792> [C]: in function 'xpcall' /usr/lib/prosody/../../bin/prosody:376: in function 'loop' /usr/lib/prosody/../../bin/prosody:407: in main chunk [C]: ? https://haste.tchncs.de/boxidarura.vhdl Something seems to be wrong with the sql backend code. Can i do anything about it? I guess having more than 16,000 prepared statements is not normal. Regards, Thomas

  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.