#748 Can't create more than max_prepared_stmt_count statements
Reporter
Thomas L.
Owner
Zash
Created
Updated
Stars
★ (1)
Tags
Priority-Medium
Type-Defect
Status-Duplicate
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
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.
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
Hi. Thanks for the report. This is a duplicate of #391, so I will close this one. Please subscribe (star) the other one.
Changes