Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
see https://github.com/mariadb-corporation/mariadb-connector-nodejs/issues/207
on mariadb@3.0.1
When i use batch inserts or pool.batch
growing
Com_stmt_prepare
but
Com_stmt_close = 0
And then i get ER_MAX_PREPARED_STMT_COUNT_REACHED error
mariadb@2.5.6
This does not appear
Attachments
Activity
current implementation use @alloc/quick-lru that evict previous cache by bulk. Cache maximum option `prepareCacheLength` is then not repected, because can be up to 2x that value, leading to error when reaching max_prepared_stmt_count
problem result in external package quick-lru that handle cache eviction by group, resulting in having prepared in cached bigger than `prepareCacheLength`, that can eventually lead to reaching server max_prepared_stmt_count limit