Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36252

RocksDB => MariaDB Blocked (100% of cases)

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.11.11
    • None
    • Server
    • None

    Description

      An other trouble there :

      (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 730 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 735 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 737 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 739 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 741 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 743 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 748 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 751 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 752 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 753 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 756 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 757 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 759 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 760 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 761 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 763 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 766 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 769 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 770 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 771 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 772 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 775 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 776 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 777 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 778 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 779 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 780 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 781 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 782 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 783 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 784 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 785 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 786 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 789 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 790 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 791 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 792 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 794 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 795 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 796 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 797 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 802 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 804 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 806 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 810 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 812 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 813 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 814 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 816 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 819 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 822 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 824 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 825 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 829 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 830 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 831 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 835 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 836 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 837 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 838 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 839 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 840 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 841 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 842 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 843 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 844 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 845 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 846 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 848 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 850 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 854 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 856 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 858 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 864 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 865 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 867 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 868 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 869 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 870 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 873 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 874 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 875 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 876 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 877 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 881 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 882 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 883 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 885 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 886 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 892 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 893 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_text`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 894 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
      ....
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_int`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 1871 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_int`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 1872 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  )  
      UNION ALL
      		 
       (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
        FROM `ts_value_general_int`  a  
        INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
        INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
        WHERE id_ts_variable = 1873 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now()  );

      this query got a table lock with herself ??

      +------+-------------+-------+-------+----------------------------+-----------------+---------+-------------------+------+-------------+
      		 
      | id   | select_type | table | type  | possible_keys              | key             | key_len | ref               | rows | Extra       |
      		 
      +------+-------------+-------+-------+----------------------------+-----------------+---------+-------------------+------+-------------+
      		 
      |    1 | PRIMARY     | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |    1 | PRIMARY     | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |    1 | PRIMARY     | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |    2 | UNION       | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |    2 | UNION       | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |    2 | UNION       | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |    3 | UNION       | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |    3 | UNION       | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |    3 | UNION       | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      ....
      		 
      |  877 | UNION       | c     | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |  877 | UNION       | b     | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |  877 | UNION       | a     | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      +------+-------------+-------+-------+----------------------------+-----------------+---------+-------------------+------+-------------+
      		 
      2631 rows in set *(1 min 46,643 sec)*

      this query got in "table lock" (only that one is running), and around 1m46, and the partition is good, i got no idea where the engine losing time.

      |   87 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   87 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |   88 | UNION       | c     | NULL       | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |   88 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   88 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |   89 | UNION       | c     | NULL       | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |   89 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   89 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      |   90 | UNION       | c     | NULL       | const | PRIMARY,ts_variable_ibfk_1 | PRIMARY         | 4       | const             | 1    |             |
      		 
      |   90 | UNION       | b     | p739686    | const | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    | Using index |
      		 
      |   90 | UNION       | a     | p739686    | ref   | id_mysql_server            | id_mysql_server | 13      | const,const,const | 1    |             |
      		 
      ....

      If we run sub query one by one it's more fast :

      MariaDB [pmacontrol]> SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
          ->   FROM `ts_value_general_text`  a  
          ->   INNER JOIN `ts_date_by_server` b on a.`date` = b.`date` AND a.`id_mysql_server` = b.`id_mysql_server`  
          ->   INNER JOIN `ts_variable` c ON a.`id_ts_variable` = c.id AND b.`id_ts_file` = c.`id_ts_file`  
          ->   WHERE id_ts_variable = 840 AND a.id_mysql_server IN (58) AND a.`date` IN ('2025-03-10 00:05:02')  AND a.`date` <= now();
      		 
      +-----------------+----------------+-----------------+---------------------+-------+
      		 
      | id_mysql_server | id_ts_variable | connection_name | date                | value |
      		 
      +-----------------+----------------+-----------------+---------------------+-------+
      		 
      |              58 |            840 |                 | 2025-03-10 00:05:02 | YES   |
      		 
      +-----------------+----------------+-----------------+---------------------+-------+
      		 
      1 row in set (0,003 sec)

      583*0.003 = 1.749sec

      We are far from 1m36, we have something working wrong for sure there. UNION ALL was to prevent go and back with many query (about 600 there)

      PS : the table like ts_value_general_% are really big (about many billions of rows)
      ts_variable => ~4000 rows
      ts_date_by_server => ~100 million rows

      I can provide test data, just let me know where to send

      Attachments

        1. Capture d’écran du 2025-03-24 16-22-24.png
          735 kB
          Aurélien LEQUOY
        2. Capture d’écran du 2025-03-24 16-33-44.png
          736 kB
          Aurélien LEQUOY
        3. lsof_mariadb
          9.03 MB
          Aurélien LEQUOY
        4. screenshot-1.png
          336 kB
          Aurélien LEQUOY
        5. screenshot-2.png
          216 kB
          Aurélien LEQUOY

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36368 RocksDB + Swapoff -a => compilation of crash

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            View 4 older comments
            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited 

            MariaDB [information_schema]> select * from ROCKSDB_TRX\G
            		 
            *************************** 1. row ***************************
            		 
                      TRANSACTION_ID: 76159
            		 
                               STATE: STARTED
            		 
                                NAME: 
                         WRITE_COUNT: 0
            		 
                          LOCK_COUNT: 0
            		 
                         TIMEOUT_SEC: 1
            		 
                         WAITING_KEY: 
            WAITING_COLUMN_FAMILY_ID: 0
            		 
                      IS_REPLICATION: 0
            		 
                        SKIP_TRX_API: 0
            		 
                           READ_ONLY: 0
            		 
            *  HAS_DEADLOCK_DETECTION: 1*
            		 
                NUM_ONGOING_BULKLOAD: 0
            		 
                           THREAD_ID: 41578
            		 
                               QUERY: (SELECT  a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value 
              FROM `ts_value_general_text`  a  
              INNER JOIN `ts_date_by_server` b on a.`date` = b.`da
            		 
            1 row in set (0,000 sec)

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited MariaDB [information_schema]> select * from ROCKSDB_TRX\G *************************** 1 . row *************************** TRANSACTION_ID: 76159 STATE: STARTED NAME: WRITE_COUNT: 0 LOCK_COUNT: 0 TIMEOUT_SEC: 1 WAITING_KEY: WAITING_COLUMN_FAMILY_ID: 0 IS_REPLICATION: 0 SKIP_TRX_API: 0 READ_ONLY: 0 * HAS_DEADLOCK_DETECTION: 1 * NUM_ONGOING_BULKLOAD: 0 THREAD_ID: 41578 QUERY: (SELECT a.`id_mysql_server`, a.`id_ts_variable`, '' as connection_name,a.`date`, a.`value` as value FROM `ts_value_general_text` a INNER JOIN `ts_date_by_server` b on a.`date` = b.`da 1 row in set ( 0 , 000 sec)
            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited

            I removed OOM Killer for MariaDB to see what happen :

            in error log I got : 

            2025-03-24 16:06:34 0 [ERROR] Error in accept: Too many open files in system

            checking limits

             
            		 
            cat /proc/$(pgrep mariadbd)/limits | grep "open files"
            		 
            Max open files            32768                32768                files     
            root@ist-pmacontrol:~# ulimit -n
            		 
            1024
            		 
            root@ist-pmacontrol:~# ulimit -Hn
            		 
            1048576

            What insteresting there :

            lsof | grep maria > lsof_mariadb 
             
            		 
            cat /root/lsof_mariadb | wc -l
            		 
            64023

            Right now i have no idea whats doing MariaDB :

            (i waiting for the crash)

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited I removed OOM Killer for MariaDB to see what happen : in error log I got : 2025 - 03 - 24 16 : 06 : 34 0 [ERROR] Error in accept: Too many open files in system checking limits   cat /proc/$(pgrep mariadbd)/limits | grep "open files" Max open files 32768 32768 files root@ist-pmacontrol:~# ulimit -n 1024 root@ist-pmacontrol:~# ulimit -Hn 1048576 What insteresting there : lsof | grep maria > lsof_mariadb   cat /root/lsof_mariadb | wc -l 64023 Right now i have no idea whats doing MariaDB : (i waiting for the crash)
            Aurelien_LEQUOY Aurélien LEQUOY added a comment -

            Interesting point after see the swap full I added temporary 2go more :

            root@ist-pmacontrol:~# dd if=/dev/zero of=/swapfile2 bs=1024 count=2097152
            		 
            2097152+0 enregistrements lus
            		 
            2097152+0 enregistrements écrits
            		 
            2147483648 octets (2,1 GB, 2,0 GiB) copiés, 7,98007 s, 269 MB/s
            		 
            root@ist-pmacontrol:~# chmod 600 /swapfile2
            		 
            root@ist-pmacontrol:~# mkswap /swapfile2
            		 
            Configure l'espace d'échange (swap) en version 1, taille = 2 GiB (2147479552 octets)
            		 
            pas d'étiquette, UUID=2378398c-24f2-44be-b97f-52ff0a41f6ee
            		 
            root@ist-pmacontrol:~# swapon /swapfile2

            just after this mariad recovered and started worked again. let's remove swap for next try (yes i want it crash maybe we can see something)

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - Interesting point after see the swap full I added temporary 2go more : root @ist -pmacontrol:~# dd if =/dev/zero of=/swapfile2 bs= 1024 count= 2097152 2097152 + 0  enregistrements lus 2097152 + 0  enregistrements écrits 2147483648  octets ( 2 , 1 GB, 2 , 0 GiB) copiés, 7 , 98007 s, 269 MB/s root @ist -pmacontrol:~# chmod 600 /swapfile2 root @ist -pmacontrol:~# mkswap /swapfile2 Configure l 'espace d' échange (swap) en version  1 , taille = 2 GiB ( 2147479552  octets) pas d'étiquette, UUID=2378398c-24f2-44be-b97f-52ff0a41f6ee root @ist -pmacontrol:~# swapon /swapfile2 just after this mariad recovered and started worked again. let's remove swap for next try ( yes i want it crash maybe we can see something)
            Aurelien_LEQUOY Aurélien LEQUOY added a comment - 

            terminate called after throwing an instance of 'std::bad_alloc'
            		 
              what():  std::bad_alloc
            		 
            250324 22:19:33 [ERROR] /usr/sbin/mariadbd got signal 6 ;
            		 
            Sorry, we probably made a mistake, and this is a bug.
            		 
             
            		 
            Your assistance in bug reporting will enable us to fix this for the next release.
            		 
            To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
            		 
            a bug on https://jira.mariadb.org/.
            		 
             
            		 
            Please include the information from the server start above, to the end of the
            		 
            information below.
            		 
             
            		 
            Server version: 10.11.11-MariaDB-deb12-log source revision: e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4
            		 
             
            		 
            The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
            		 
            contains instructions to obtain a better version of the backtrace below.
            		 
            Following these instructions will help MariaDB developers provide a fix quicker.
            		 
             
            		 
            Attempting backtrace. Include this in the bug report.
            		 
            (note: Retrieving this information may fail)
            		 
             
            		 
            Thread pointer: 0x0
            		 
            stack_bottom = 0x0 thread_stack 0x49000
            		 
            Can't start addr2line
            		 
            /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55a2362d200e]
            		 
            /usr/sbin/mariadbd(handle_fatal_signal+0x229)[0x55a235db0e89]
            		 
            /lib/x86_64-linux-gnu/libc.so.6(+0x3c050)[0x7f207fe5b050]
            		 
            /lib/x86_64-linux-gnu/libc.so.6(+0x8aebc)[0x7f207fea9ebc]
            		 
            /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x12)[0x7f207fe5afb2]
            		 
            /lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7f207fe45472]
            		 
            /lib/x86_64-linux-gnu/libstdc++.so.6(+0x9d919)[0x7f207fc9d919]
            		 
            /lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e1a)[0x7f207fca8e1a]
            		 
            /lib/x86_64-linux-gnu/libstdc++.so.6(+0xa8e85)[0x7f207fca8e85]
            		 
            /lib/x86_64-linux-gnu/libstdc++.so.6(+0xa90d8)[0x7f207fca90d8]
            		 
            /lib/x86_64-linux-gnu/libstdc++.so.6(+0x9d524)[0x7f207fc9d524]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZNK7rocksdb22RandomAccessFileReader4ReadEmmPNS_5SliceEPcb+0x252)[0x7f200f4f8222]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb18FilePrefetchBuffer8PrefetchEPNS_22RandomAccessFileReaderEmmb+0xc6)[0x7f200f4f7c96]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb18FilePrefetchBuffer16TryReadFromCacheEmmPNS_5SliceEb+0x94)[0x7f200f4f7f34]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb12BlockFetcher17ReadBlockContentsEv+0x8a)[0x7f200f4090aa]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(+0x3d86e6)[0x7f200f3d86e6]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZNK7rocksdb15BlockBasedTable13RetrieveBlockINS_5BlockEEENS_6StatusEPNS_18FilePrefetchBufferERKNS_11ReadOptionsERKNS_11BlockHandleERKNS_17UncompressionDictEPNS_13CachableEntryIT_EENS_9BlockTypeEPNS_10GetContextEPNS_23BlockCacheLookupContextEbb+0x1bc)[0x7f200f3f13ac]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZNK7rocksdb15BlockBasedTable20NewDataBlockIteratorINS_13DataBlockIterEEEPT_RKNS_11ReadOptionsERKNS_11BlockHandleES4_NS_9BlockTypeEPNS_10GetContextEPNS_23BlockCacheLookupContextENS_6StatusEPNS_18FilePrefetchBufferEb+0x490)[0x7f200f3f3970]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb23BlockBasedTableIteratorINS_13DataBlockIterENS_5SliceEE13InitDataBlockEv+0xc9)[0x7f200f3fbf59]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb23BlockBasedTableIteratorINS_13DataBlockIterENS_5SliceEE11SeekToFirstEv+0x1c8)[0x7f200f3ff348]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(+0x33c5e7)[0x7f200f33c5e7]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb13CompactionJob25ProcessKeyValueCompactionEPNS0_18SubcompactionStateE+0x396)[0x7f200f4dcc06]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb13CompactionJob3RunEv+0xaa5)[0x7f200f4deb85]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb6DBImpl20BackgroundCompactionEPbPNS_10JobContextEPNS_9LogBufferEPNS0_19PrepickedCompactionENS_3Env8PriorityE+0xeb9)[0x7f200f28e2c9]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb6DBImpl24BackgroundCallCompactionEPNS0_19PrepickedCompactionENS_3Env8PriorityE+0xf3)[0x7f200f292f23]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb6DBImpl16BGWorkCompactionEPv+0x3a)[0x7f200f29398a]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb14ThreadPoolImpl4Impl8BGThreadEm+0x260)[0x7f200f44e5f0]
            		 
            /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb14ThreadPoolImpl4Impl15BGThreadWrapperEPv+0x5f)[0x7f200f44e7af]
            		 
            /lib/x86_64-linux-gnu/libstdc++.so.6(+0xd44a3)[0x7f207fcd44a3]
            		 
            /lib/x86_64-linux-gnu/libc.so.6(+0x891c4)[0x7f207fea81c4]
            		 
            /lib/x86_64-linux-gnu/libc.so.6(+0x10985c)[0x7f207ff2885c]
            		 
            Writing a core file...
            		 
            Working directory at /srv/mysql/data
            		 
            Resource Limits (excludes unlimited resources):
            		 
            Limit                     Soft Limit           Hard Limit           Units
            		 
            Max stack size            8388608              unlimited            bytes
            		 
            Max core file size        0                    unlimited            bytes
            		 
            Max processes             63785                63785                processes
            		 
            Max open files            32768                32768                files
            		 
            Max locked memory         524288               524288               bytes
            		 
            Max pending signals       63785                63785                signals
            		 
            Max msgqueue size         819200               819200               bytes
            		 
            Max nice priority         0                    0
            		 
            Max realtime priority     0                    0
            		 
            Core pattern: core
            		 
             
            		 
            Kernel version: Linux version 6.1.0-31-amd64 (debian-kernel@lists.debian.org) (gcc-12 (Debian 12.2.0-14) 12.2.0, GNU ld (GNU Binutils for Debian) 2.40) #1 SMP PREEMPT_DYNAMIC Debian 6.1.128-1 (2025-02-07)

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - terminate called after throwing an instance of 'std::bad_alloc' what(): std::bad_alloc 250324 22 : 19 : 33 [ERROR] /usr/sbin/mariadbd got signal 6 ; Sorry, we probably made a mistake, and this is a bug.   Your assistance in bug reporting will enable us to fix this for the next release. To report this bug, see https: //mariadb.com/kb/en/reporting-bugs about how to report a bug on https: //jira.mariadb.org/.   Please include the information from the server start above, to the end of the information below.   Server version: 10.11 . 11 -MariaDB-deb12-log source revision: e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4   The information page at https: //mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains instructions to obtain a better version of the backtrace below. Following these instructions will help MariaDB developers provide a fix quicker.   Attempting backtrace. Include this in the bug report. (note: Retrieving this information may fail)   Thread pointer: 0x0 stack_bottom = 0x0 thread_stack 0x49000 Can't start addr2line /usr/sbin/mariadbd(my_print_stacktrace+ 0x2e )[ 0x55a2362d200e ] /usr/sbin/mariadbd(handle_fatal_signal+ 0x229 )[ 0x55a235db0e89 ] /lib/x86_64-linux-gnu/libc.so. 6 (+ 0x3c050 )[ 0x7f207fe5b050 ] /lib/x86_64-linux-gnu/libc.so. 6 (+ 0x8aebc )[ 0x7f207fea9ebc ] /lib/x86_64-linux-gnu/libc.so. 6 (gsignal+ 0x12 )[ 0x7f207fe5afb2 ] /lib/x86_64-linux-gnu/libc.so. 6 (abort+ 0xd3 )[ 0x7f207fe45472 ] /lib/x86_64-linux-gnu/libstdc++.so. 6 (+ 0x9d919 )[ 0x7f207fc9d919 ] /lib/x86_64-linux-gnu/libstdc++.so. 6 (+ 0xa8e1a )[ 0x7f207fca8e1a ] /lib/x86_64-linux-gnu/libstdc++.so. 6 (+ 0xa8e85 )[ 0x7f207fca8e85 ] /lib/x86_64-linux-gnu/libstdc++.so. 6 (+ 0xa90d8 )[ 0x7f207fca90d8 ] /lib/x86_64-linux-gnu/libstdc++.so. 6 (+ 0x9d524 )[ 0x7f207fc9d524 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZNK7rocksdb22RandomAccessFileReader4ReadEmmPNS_5SliceEPcb+ 0x252 )[ 0x7f200f4f8222 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb18FilePrefetchBuffer8PrefetchEPNS_22RandomAccessFileReaderEmmb+ 0xc6 )[ 0x7f200f4f7c96 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb18FilePrefetchBuffer16TryReadFromCacheEmmPNS_5SliceEb+ 0x94 )[ 0x7f200f4f7f34 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb12BlockFetcher17ReadBlockContentsEv+ 0x8a )[ 0x7f200f4090aa ] /usr/lib/mysql/plugin/ha_rocksdb.so(+ 0x3d86e6 )[ 0x7f200f3d86e6 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZNK7rocksdb15BlockBasedTable13RetrieveBlockINS_5BlockEEENS_6StatusEPNS_18FilePrefetchBufferERKNS_11ReadOptionsERKNS_11BlockHandleERKNS_17UncompressionDictEPNS_13CachableEntryIT_EENS_9BlockTypeEPNS_10GetContextEPNS_23BlockCacheLookupContextEbb+ 0x1bc )[ 0x7f200f3f13ac ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZNK7rocksdb15BlockBasedTable20NewDataBlockIteratorINS_13DataBlockIterEEEPT_RKNS_11ReadOptionsERKNS_11BlockHandleES4_NS_9BlockTypeEPNS_10GetContextEPNS_23BlockCacheLookupContextENS_6StatusEPNS_18FilePrefetchBufferEb+ 0x490 )[ 0x7f200f3f3970 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb23BlockBasedTableIteratorINS_13DataBlockIterENS_5SliceEE13InitDataBlockEv+ 0xc9 )[ 0x7f200f3fbf59 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb23BlockBasedTableIteratorINS_13DataBlockIterENS_5SliceEE11SeekToFirstEv+ 0x1c8 )[ 0x7f200f3ff348 ] /usr/lib/mysql/plugin/ha_rocksdb.so(+ 0x33c5e7 )[ 0x7f200f33c5e7 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb13CompactionJob25ProcessKeyValueCompactionEPNS0_18SubcompactionStateE+ 0x396 )[ 0x7f200f4dcc06 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb13CompactionJob3RunEv+ 0xaa5 )[ 0x7f200f4deb85 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb6DBImpl20BackgroundCompactionEPbPNS_10JobContextEPNS_9LogBufferEPNS0_19PrepickedCompactionENS_3Env8PriorityE+ 0xeb9 )[ 0x7f200f28e2c9 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb6DBImpl24BackgroundCallCompactionEPNS0_19PrepickedCompactionENS_3Env8PriorityE+ 0xf3 )[ 0x7f200f292f23 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb6DBImpl16BGWorkCompactionEPv+ 0x3a )[ 0x7f200f29398a ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb14ThreadPoolImpl4Impl8BGThreadEm+ 0x260 )[ 0x7f200f44e5f0 ] /usr/lib/mysql/plugin/ha_rocksdb.so(_ZN7rocksdb14ThreadPoolImpl4Impl15BGThreadWrapperEPv+ 0x5f )[ 0x7f200f44e7af ] /lib/x86_64-linux-gnu/libstdc++.so. 6 (+ 0xd44a3 )[ 0x7f207fcd44a3 ] /lib/x86_64-linux-gnu/libc.so. 6 (+ 0x891c4 )[ 0x7f207fea81c4 ] /lib/x86_64-linux-gnu/libc.so. 6 (+ 0x10985c )[ 0x7f207ff2885c ] Writing a core file... Working directory at /srv/mysql/data Resource Limits (excludes unlimited resources): Limit Soft Limit Hard Limit Units Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max processes 63785 63785 processes Max open files 32768 32768 files Max locked memory 524288 524288 bytes Max pending signals 63785 63785 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Core pattern: core   Kernel version: Linux version 6.1 . 0 - 31 -amd64 (debian-kernel @lists .debian.org) (gcc- 12 (Debian 12.2 . 0 - 14 ) 12.2 . 0 , GNU ld (GNU Binutils for Debian) 2.40 ) # 1 SMP PREEMPT_DYNAMIC Debian 6.1 . 128 - 1 ( 2025 - 02 - 07 )
            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited

            Here something interesting when is removed swap (at 17h24), memory is contained to ~4Go as it's should from begining (like everything is linked) according to my configuration with myrocks !!!

            2025-03-24 22:19:31 39192 [ERROR] mariadbd: Out of memory (Needed 33554400 bytes)  => ~32Mo

            we can see last the small overhead at end when i executed `swapon -a`. My question is RocksDB using swap to artificially grow up memory ?

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited Here something interesting when is removed swap (at 17h24), memory is contained to ~4Go as it's should from begining (like everything is linked) according to my configuration with myrocks !!! 2025-03-24 22:19:31 39192 [ERROR] mariadbd: Out of memory (Needed 33554400 bytes) => ~32Mo we can see last the small overhead at end when i executed `swapon -a`. My question is RocksDB using swap to artificially grow up memory ?

            People

              Unassigned Unassigned
              Aurelien_LEQUOY Aurélien LEQUOY
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.