The Ultimate Guide to High Availability with MariaDB

Comments - UUID

1 year, 8 months ago Peter ILLETSCHKO
UUID() does not use mac address
This comment has the status of 'removed' and can only be seen by you.

If I install MariaDB on Debian11 from https://dlm.mariadb.com/repo/mariadb-server/... and do a 'SELECT UUID();' then I always get '-040300000000' as the fifth number and not the mac address of the machine. Example:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 30
Server version: 10.5.17-MariaDB-1:10.5.17+maria~deb11 mariadb.org binary distribution
......
MariaDB [(none)]> select UUID();
+--------------------------------------+
| UUID()                               |
+--------------------------------------+
| 3a688c85-239a-11ed-9a5d-040300000000 |
+--------------------------------------+
1 row in set (0,000 sec)

The same happens with MariaDB 10.6 and also on a different machine.

Kernel is: 5.10.0-17-amd64 #1 SMP Debian 5.10.136-1 (2022-08-13) x86_64 GNU/Linux

If I install the package that comes with Debian11 on the same machine everything is fine:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 30
Server version: 10.5.15-MariaDB-0+deb11u1 Debian 11
.....
MariaDB [(none)]> select UUID();
+--------------------------------------+
| UUID()                               |
+--------------------------------------+
| e58b1ad1-239a-11ed-b1cd-a249edae51a0 |
+--------------------------------------+
1 row in set (0.000 sec)

What's going wrong here?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.