mariaex icon indicating copy to clipboard operation
mariaex copied to clipboard

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

Open andrelip opened this issue 7 years ago • 2 comments

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   |
+---------------------+-------+

andrelip avatar Aug 28 '18 22:08 andrelip

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

slientgoat avatar Oct 10 '18 08:10 slientgoat

Is the same as #182

nulian avatar Oct 16 '18 07:10 nulian