Changes in MySQL Workbench 8.0.24 (2021-04-20, General Availability)

Functionality Added or Changed

     * The following third-party libraries were upgraded in this
       release (Bug #32317082):

          + AT-SPI
          + Cairo
          + FreeTDS
          + GDAL/OGR
          + HtmlRenderer (System.Drawing.Html)
          + iODBC
          + libgcrypt
          + Libintl
          + libgpg-error
          + Libpng
          + libssh v0.7.5-openssl1.1_patch
          + Libzip
          + PCRE (Perl Compatible Regular Expressions) Library
          + Pixman
          + PROJ.4
          + PyODBC
          + PySQLite (removed)
          + TreeViewAdv for .NET
          + VSQLite++

     * The linked OpenSSL library for MySQL Workbench has been
       updated to version 1.1.1J. Issues fixed in the new
       OpenSSL version are described at
       https://www.openssl.org/news/cl111.txt and
       https://www.openssl.org/news/vulnerabilities.html.
       (Bug #31957287, Bug #32260611)

Bugs Fixed

     * MySQL Workbench 8.0.23 closed unexpectedly after starting
       on macOS systems. This fix adds the Python 3.7 framework
       as a prerequisite for the installation.
       (Bug #32395192, Bug #102286)

     * Unexpected output was written to the console when MySQL
       Workbench was started from the command line on Linux.
       Adjusting the log level did not stop the output. This
       issue was unrelated to log suppression and was eliminated
       by resolving a different issue. (Bug #32106379)

Changes in MySQL Router 8.0.24 (2021-04-20)


     * Functionality Added or Changed

     * Bugs Fixed

Functionality Added or Changed


     * Changed the default ports used by Router, and default
       behavior depends on the --conf-base-port bootstrap
       option.
       If --conf-base-port is not set, then the associated
       bind_port values begin at 6446; Classic (RW 6446, RO
       6447) and X Protocol (RW 6448, RO 6449). Additionally,
       now setting --conf-base-port to 0 uses the old default
       ports of Classic (RW 6446, RO 6447) and X Protocol (RW
       64460, RO 64470).
       Reason: the previous default X Protocol ports (64460 and
       64470) are defined as "Dynamic Ports" as per RFC 6335.

     * Previously, Router bound the incoming socket at startup
       and kept it open even if no destinations were available.
       Now Router only binds to the socket if destinations are
       available, and otherwise closes the incoming sockets.
       This also means Load-Balancers know whether Router can
       handle traffic.

Bugs Fixed


     * The mysqlrouter.conf file in Debian Router packages did
       not set the run directory to an absolute path name,
       resulting in package installation errors. (Bug #32620788)

     * Disabled code-cache when compiling on Solaris to avoid
       'invalid bytecode' errors; previously it was only
       disabled for sun-cc builds. (Bug #32567899)

     * When using first-available policy and static routing, it
       was possible that the router wouldn't start and emit an
       error similar to "plugin 'routing:test_default' start
       failed: routing:test_default: Failed setting up TCP
       service"; fixed race condition on start-up between 'is
       running' and 'start socket acceptor'. (Bug #32565479)

     * Fixed assertion that a previous destination list
       contained primary destinations after connecting to a
       primary node failed. This assertion was firing because
       the primary destinations were not properly recognized
       during refresh. (Bug #32543464)

     * Network transfers larger than the socket send buffer,
       such as large result sets or queries, could terminate the
       connection. (Bug #32543049)

     * Now return an std::errc::operation_would_block error code
       if write() blocks and no data is written; before 0 was
       returned. (Bug #32542170)

     * Configuring a second Router instance on the same machine
       without the --name parameter would yield unexpected
       errors related to file cleanup. (Bug #32517802)

     * Router would report as READY before the sockets were
       open; so now reports it after the socket acceptors are
       set up. (Bug #32429409)

     * Network loss before connect() was resulting in long
       failover times as it depended on the operating system's
       network timeouts. The connect_timeout option was not
       honored, but is now applied before connecting. (Bug
       #32428113)

     * Router no longer relies upon the MySQL instance's
       availability logic for wait-primary-failover. Instead, it
       now checks the metadata-cache's replicaset info for a new
       Primary. This is because GR membership does not change is
       the network between Router and the Primary is lost. (Bug
       #32393421)

     * After a network loss between Router and a group
       replication PRIMARY (but not network loss between group
       replication members), the wait for the failover by Router
       did not timeout after 10 seconds, and instead the
       connection remained locked. (Bug #32338771)

     * Configuration options expecting numeric values would
       allow hex and octal values; but now only completely
       numeric values are allowed. For example,
       --config-base-port=0xff now reports an error. (Bug
       #32297657)

     * Improved the DEBUG logging mechanism to include the
       following information: host:port, execution time, OK/ERR
       information, and row count. In addition, now log one
       message instead of separate before/after messages. (Bug
       #32293818)

     * The REST endpoint timeout check changed from waiting for
       "timeout + request time" to waiting until the timeout
       expires. (Bug #32252500)