Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11935

Queries in stored procedures with and EXISTS(SELECT * FROM VIEW) crashes and closes hte conneciton.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.21, 10.0(EOL), 10.1(EOL), 10.2(EOL)
    • 10.0.30, 10.1.22, 10.2.5
    • Stored routines
    • 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

        1. ip_fault_example_proc.sql
          5 kB
          Nicholas Denning
        2. mariadb_error_log.err
          17 kB
          Nicholas Denning
        3. testdb_20170211.sql
          612 kB
          Nicholas Denning

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              nicholasdenning Nicholas Denning
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.