Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2688

Function WSREP_SYNC_WAIT_UPTO_GTID does not exist

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 8.0.15-5-27dev.4.2
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      CentOS Linux release 7.6.1810 (Core)

      Description

      Just bump on this WSREP function with Galera 4.0, trying out and testing on PXC 8.0 (experimental version) looks yet not present. See details below:

       

      root@localhost[(none)]#> SELECT WSREP_SYNC_WAIT_UPTO_GTID('ee0d457b-fb33-11e9-91d7-be41124115fd:13', 30);
      ERROR 1046 (3D000): No database selected
      root@localhost[(none)]#> use mysql
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A

      Database changed
      root@localhost[mysql]#> SELECT WSREP_SYNC_WAIT_UPTO_GTID('ee0d457b-fb33-11e9-91d7-be41124115fd:13', 30);
      ERROR 1305 (42000): FUNCTION mysql.WSREP_SYNC_WAIT_UPTO_GTID does not exist

       

      But I have no issues with other functions. 

      e.g.

      root@localhost[(none)]#> select WSREP_LAST_SEEN_GTID();
      -----------------------------------------

      WSREP_LAST_SEEN_GTID()

      -----------------------------------------

      ee0d457b-fb33-11e9-91d7-be41124115fd:15

      -----------------------------------------
      1 row in set (0.00 sec)

       

      root@localhost[mysql]#> SELECT WSREP_LAST_WRITTEN_GTID();
      -----------------------------------------

      WSREP_LAST_WRITTEN_GTID()

      -----------------------------------------

      ee0d457b-fb33-11e9-91d7-be41124115fd:15

      -----------------------------------------
      1 row in set (0.00 sec)

       

      and version is,

      root@localhost[mysql]#> \s
      --------------
      mysql Ver 14.14 Distrib 5.7.23-23, for Linux (x86_64) using 6.2

      Connection id: 18
      Current database: mysql
      Current user: root@localhost
      SSL: Not in use
      Current pager: stdout
      Using outfile: ''
      Using delimiter: ;
      Server version: 8.0.15-5-27dev.4.2 Percona XtraDB Cluster binary (GPL) 8.0.15-27dev.4.2, Revision f42c652 - UNIV_DEBUG ON
      Protocol version: 10
      Connection: Localhost via UNIX socket
      Server characterset: utf8mb4
      Db characterset: utf8mb4
      Client characterset: utf8
      Conn. characterset: utf8
      UNIX socket: /opt/percona/node2/socket.sock
      Uptime: 2 hours 23 min 10 sec

      Threads: 8 Questions: 87208 Slow queries: 0 Opens: 501 Flush tables: 2 Open tables: 202 Queries per second avg: 10.152
      --------------

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                standardkeyboard Paul Namuag
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: