as current available version lacks several usefull features (https://mariadb.com/kb/en/system-versioned-tables for example)...might be

time to provide something new.

We are working on mariadb 10.5.x and it will be available by the end of 2Q.

In some bad news this commit has started to cause CI failures on aix.

Is it salvagable with a patch?

I know I need to update the AIX machine.

BTW I'm at Open Source India this week. Happy to chat about what the AIX MariaDB strategy is.

I don't know, but:


The following messages makes me think that your script should spit out the current ulimits (soft&hard) before starting to run commands:

2024-10-22 13:46:44 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32182)
2024-10-22 13:46:44 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

This needs to be checked (what is the system default stack): 

/*
Common stack size in MariaDB. Cannot be bigger than system default
stack (common is 8M)
*/

size_t my_stack_size= 299008;

Notice that 1073789920 is 48096 bytes above 1GiB.  Did you try to allocate 1GiB on a 299008 byte stack?

ERROR: 1436  Thread stack overrun:  1073789920 bytes used of a 299008 byte stack, and 32000 bytes needed. Consider increasing the thread_stack system variable.

On file descriptors, the amount requested is based off system variables set. The second message is based on raising the soft limit to the hard limit and then lowering the default variables to account for this new limit. There's no loss in requesting the change and getting an error compared to just trying and maybe succeeding.

The reason for the allocation is the logic is there to attempt to use available stack over heap to perform allocations. The logic on AIX however is incorrect in determining the available stack size.

2024-10-22 13:46:44 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32182)2024-10-22 13:46:44 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

/*Common stack size in MariaDB. Cannot be bigger than system defaultstack (common is 8M)*/size_t my_stack_size= 299008;

ERROR: 1436  Thread stack overrun:  1073789920 bytes used of a 299008 byte stack, and 32000 bytes needed. Consider increasing the thread_stack system variable.

Thanks Daniel for reporting this. We will be in touch with you separately to address these issues. 
We will continue to work with the MariaDB community  to make sure MariaDB works on AIX.