[mysql error] 1615 Prepared statement needs to be re-prepared

Connecting to SQL
1

When I try to get data from “view” in mysql service, the following error occurs.

DreamFactory Table Module
Failed to retrieve records from ‘myview’.
SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select count(1) as aggregate from mydb.myview)

The df version is below
License Level: OPEN SOURCE

DreamFactory Version: 2.14.0

System Database: mysql

Install Path: /opt/bitnami/apps/dreamfactory/htdocs/

Log Path: /opt/bitnami/apps/dreamfactory/htdocs/storage/logs/

Log Mode: single

Log Level: warning

Cache Driver: file

Cache Path: /opt/bitnami/apps/dreamfactory/htdocs/storage/framework/cache/data/

Demo: false

1 Like
2

I have same problem. Anyone has an solution for this?

3

Hi,

It appears this is an odd MySQL bug as discussed in detail here:

https://bugs.mysql.com/bug.php?id=42041

Have you tried increasing your table_definition_cache setting? Increasing this value appears to have solved the problem for many users found both in the above discussion and on Stack Overflow.