Skip to content

Can't create more than max_prepared_stmt_count statements (current value: 16382) #231

Description

@andrelip

I'm getting this error an production and I need to restart the container everytime to make it work.
(1461): Can't create more than max_prepared_stmt_count statements (current value: 16382)
Everytime I do a simple query it increases by 1 even if it is the same query. The number never drops. Any clue?

iex(4)> Arvore.Repo.get(Arvore.User, 190)
➜  ~ mysql ##MYDATA## -e "show global status like '%prepared%'";
mysql: [Warning] Using a password on the command line interface can be insecure.
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| Prepared_stmt_count | 175   |
+---------------------+-------+

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions