AIX Open Source

 View Only

  • 1.  mariadb: new version?

    Posted Thu April 25, 2024 06:17 AM

    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.



    ------------------------------
    I regret starting this entire conversation
    ------------------------------


  • 2.  RE: mariadb: new version?

    Posted Fri May 17, 2024 03:19 AM

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



    ------------------------------
    RESHMA KUMAR
    ------------------------------

    Original Message


  • 3.  RE: mariadb: new version?

    Posted Tue October 22, 2024 03:39 PM

    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.



    ------------------------------
    Daniel Black
    ------------------------------

    Original Message


  • 4.  RE: mariadb: new version?

    Posted Wed October 23, 2024 06:39 AM

    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.



    ------------------------------
    José Pina Coelho
    IT Specialist at Kyndryl
    ------------------------------

    Original Message


  • 5.  RE: mariadb: new version?

    Posted Thu October 24, 2024 07:44 AM

    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.



    ------------------------------
    Daniel Black
    ------------------------------

    Original Message


  • 6.  RE: mariadb: new version?

    Posted Thu October 24, 2024 09:38 AM

    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. 



    ------------------------------
    Ayappan P
    ------------------------------

    Original Message