Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.21, 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
-
Centos 7 x64
-
10.0.30
Description
I am getting an error:
(conn:7) Could not read packet: unexpected end of stream, read 0 bytes from 4
I see a reference to a similar problem reported in https://jira.mariadb.org/browse/CONJ-348 for the connector.
this recommends the solution of adding ?useServerPrepStmts=false to the connection string.
Unfortunately I am making heavy use of stored procedures and stored procedures automatically have their prepared statemsnts buffered so the second time I use the procedure it crashes with the above error.
this error comes from a statement similar to:
SELECT *
FROM MY_TABLE MT
WHERE EXISTS ( SELECT *
FROM MYVIEW MV
WHERE MV.FIELD1 = MT.FIELD1 )
AND MT.FIELD2 = V_VALUE;
The view is quite complicated and essentially implements a security system I have been working on for some months so its a bit of blocker to rolling out a system.
the text in /CONJ-348 suggests this server error is to be fixed in 10.1.21 so I have upgraded to that but the issue still remains.
Attachments
Issue Links
- blocks
-
CONJ-348 Could not read resultset: unexpected end of stream, read 0 bytes from 4
- Closed
- duplicates
-
MDEV-11993 Server Crash with VIEW in WHERE EXISTS() within a stored procedure.
- Closed