[#MDEV-28243] AIX missing my_gethwaddr implementation (and failing spider tests)

Comment by Daniel Black [ 2022-04-05 ]

After porting https://github.com/tridge/junkcode/blob/c271acabd1b1ae24cff1624d5d7bb9bbb9d5c1b9/aix_getmac.c#L10 it failed with a errno 22.

So reverted to using the ioctl SIOCGIFHWADDR.

Comment by Daniel Black [ 2022-04-05 ]

Thanks nayuta-yanagisawa for reviewing the spider test change.

monty, happy with the rest of https://github.com/MariaDB/server/pull/2081?

Comment by Peter ILLETSCHKO [ 2022-08-30 ]

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 with command line 'mysql':

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)

If I use

./mariadb_repo_setup --mariadb-server-version="mariadb-10.6.8"

to set up the mariadb repository, the version before this commit get's installed and it works also:

Your MariaDB connection id is 31

Server version: 10.6.8-MariaDB-1:10.6.8+maria~bullseye mariadb.org binary distribution

.......

MariaDB [(none)]> select UUID();

+--------------------------------------+

| UUID()                               |

+--------------------------------------+

| cc7e9d64-2873-11ed-8542-a249edae51a0 |

+--------------------------------------+

1 row in set (0.000 sec)

Can this be related to this change?

Comment by Daniel Black [ 2022-08-31 ]

illetschko you're right.

My embarrassing error. Sorry for the inconvenience. I should read reviewer suggested code more carefully.

For next bug report, can you please create a new bug report like ~~MDEV-29418~~ that I did for this. A comment on a closed bug can sometime be forgotten.

Thanks for reporting the error and my embarrassing apology for making the bug.

[MDEV-28243] AIX missing my_gethwaddr implementation (and failing spider tests) Created: 2022-04-05 Updated: 2022-09-05 Resolved: 2022-06-08
Status:	Closed
Project:	MariaDB Server
Component/s:	Server, Storage Engine - Spider
Fix Version/s:	10.5.17, 10.6.9, 10.7.5, 10.8.4, 10.9.2

[MDEV-28243] AIX missing my_gethwaddr implementation (and failing spider tests) Created: 2022-04-05 Updated: 2022-09-05 Resolved: 2022-06-08