How to flush prepared statement cache without restarting the service

14 views

Skip to first unread message

Musa Avcı

unread,

Dec 12, 2024, 7:11:16 AM12/12/24

to proxysql

Hello,

I encountered an issue after changing a table schema. When I attempt to execute a query on the updated table, I receive the following error:

Packets out of order. Expected 1, received 27

From my investigation, this seems to be related to the prepared statement cache in ProxySQL. Restarting the ProxySQL service resolves the issue, but I would like to avoid restarting the service.

Is there a way to flush the prepared statement cache without restarting the ProxySQL service?

Thank you for your assistance.

René Cannaò

unread,

Dec 12, 2024, 7:22:51 AM12/12/24

to Musa Avcı, proxysql

The problem is probably related to your client driver/ORM .

Prepared statement metadata can change at any time, and client should be able to handle that.

Prepared statement metadata cache in ProxySQL is refreshed every time the backend sends new metadata, and ProxySQL sends new metadata to the client.

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/proxysql/908ec23c-d140-4aae-a925-22e5eaad0cc7n%40googlegroups.com.

Musa Avcı

unread,

Dec 13, 2024, 6:19:02 AM12/13/24

to René Cannaò, proxysql

Hello,

Thank you for your reply. I agree with this too but the problem is that's not happening.

For example here is a simple reproducible test case:

https://github.com/sysown/proxysql/issues/1574#issuecomment-697116378

Do you have any suggestions to solve this problem with PHP PDO? Should I add some attributes?

Thanks.

René Cannaò <re...@proxysql.com>, 12 Ara 2024 Per, 15:22 tarihinde şunu yazdı:

Reply all

Reply to author

Forward

0 new messages