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

Attempt to set some system variables in PS mode results in issuing the error "ERROR 1615 (HY000): Prepared statement needs to be re-prepared"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.6, 10.2.37, 10.3.28, 10.4.18, 10.5.9
    • Fix Version/s: 10.6.2
    • Component/s: Prepared Statements
    • Labels:
      None

      Description

      For example, in case mariadb server started with the option --skip-grant-tables, running of the statement "set global event_scheduler=1'" in PS mode results in issuing the error

      ERROR 1615 (HY000): Prepared statement needs to be re-prepared
      

      Test case is below:

      MariaDB [test]> PREPARE stmt1 FROM 'set global event_scheduler=1';
      Query OK, 0 rows affected (0,000 sec)
      Statement prepared
       
      MariaDB [test]> EXECUTE stmt1;
      ERROR 1615 (HY000): Prepared statement needs to be re-prepared
      

      The same error is issued in case the statement

      SET GLOBAL gtid_slave_pos= ""
      

      is executed in PS mode (no matter the option --skip-grant-tables specified or not)

       
      Test case is below:
      MariaDB [test]> PREPARE stmt1 FROM 'SET GLOBAL gtid_slave_pos= ""';
      Query OK, 0 rows affected (0,000 sec)
      Statement prepared
       
      MariaDB [test]> EXECUTE stmt1;
      ERROR 1615 (HY000): Prepared statement needs to be re-prepared
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              shulga Dmitry Shulga
              Reporter:
              shulga Dmitry Shulga
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration