[#39392] - Error 1615 Prepared statement needs to be re-prepared
- Closed
- 6 Jan 2023
- Medium
- Build: 4.2.5
- # 39392
Steps to reproduce the issue
Uncertain. it happens on occasion, i cannot pinpoint when exactly. When i occurs, the entire site is down, and after about 30 seconds it all works again
Expected result
No error, working site
Actual result
Site down, and 1615 error
System information (as much as possible)
J 4.2.5 / PHP 8.0.14 / 10.3.24 MariaDB cll-lve
Linux 192-168-246-187.atm.cloudlinux.com 4.18.0-305.25.1.el8_4.x86_64 #1 SMP Wed Nov 3 10:29:07 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
Additional comments
Problem seems isolated to 1 server. could be a hosting issue, but i cannot pinpoint itsysteminfo-2022-12-10T19_19_00+01_00.txt
Votes
| Labels |
Removed:
?
|
||
joomla-cms-bot
- | Labels |
Added:
No Code Attached Yet
|
||
See if this helps
… and please report back if it helped.
With these increased values still problems (but less):
table_open_cache = 4096
table_definition_cache = 4096
We keep you posted.
I am asking ISP for details, but problem still appears after Brians suggested fix. It seems J4 has different system requirements then proposed, if so we cannot be the only ones having this issue.
fix was, for now, and it seems to work, to set the connector to mysql instead of mysqli
Thanks for feedback. I'll close this now.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2023-01-06 11:33:03 |
| Closed_By | ⇒ | chmst |
i guess its a bug that has been fixed with a newer maria db.
https://jira.mariadb.org/browse/MDEV-17124
Resolved: 2022-09-30 10:55
I have this on several websites.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/39392.