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: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 8.0.15-5-27dev.4.2
    • Fix Version/s: 8.0.18-26.4.3.2-internal
    • Component/s: None
    • Labels:
      None
    • Environment:

      CentOS Linux release 7.6.1810 (Core)

    • Needs Review:
      Yes

      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

            Issue Links

              Activity

                People

                • Assignee:
                  zsolt.parragi Zsolt Parragi
                  Reporter:
                  standardkeyboard Paul Namuag
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 3 hours, 50 minutes
                    3h 50m