search

xerions / mariaex

Pure Elixir database driver for MariaDB / MySQL
Other
263 stars 89 forks source link

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

Open andrelip opened 6 years ago

andrelip commented 6 years ago

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   |
+---------------------+-------+
slientgoat commented 6 years ago

hi @andrelip! I meet the problem too.Are you resolve?

nulian commented 6 years ago

Is the same as #182