[MDEV-31612]  my max_allowed_packet always show 1073741824 Created: 2023-07-03  Updated: 2023-07-08  Resolved: 2023-07-08

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 10.6.14
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Alok Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Live

Attachments: PNG File Screenshot 2023-07-04 at 12.31.16 AM.png    

 Description   

I am not able to update the max_allowed_packet like max_allowed_packet = 32G
Its showing default value like 

SHOW VARIABLES LIKE 'max_allowed_packet';
 
+--------------------+------------+
 
| Variable_name      | Value      |
 
+--------------------+------------+
 
| max_allowed_packet | 1073741824 |
 
+--------------------+------------+
 
1 row in set (0.001 sec)

neither I am able to downgrade or upgrade, Please help me in solving this issue

 Comments   
Comment by Sergei Golubchik [ 2023-07-08 ]

instead of selecting only default_value from information_schema.system_variables, you should've selected the whole row:

MariaDB [test]> select * from information_schema.system_variables where variable_name='max_allowed_packet'\G
 
*************************** 1. row ***************************
 
        VARIABLE_NAME: MAX_ALLOWED_PACKET
 
        SESSION_VALUE: 16777216
 
         GLOBAL_VALUE: 16777216
 
  GLOBAL_VALUE_ORIGIN: COMPILE-TIME
 
        DEFAULT_VALUE: 16777216
 
       VARIABLE_SCOPE: SESSION
 
        VARIABLE_TYPE: BIGINT UNSIGNED
 
     VARIABLE_COMMENT: Max packet length to send to or receive from the server
 
    NUMERIC_MIN_VALUE: 1024
 
    NUMERIC_MAX_VALUE: 1073741824
 
   NUMERIC_BLOCK_SIZE: 1024
 
      ENUM_VALUE_LIST: NULL
 
            READ_ONLY: NO
 
COMMAND_LINE_ARGUMENT: REQUIRED
 
    GLOBAL_VALUE_PATH: NULL

See what NUMERIC_MAX_VALUE is.

Generated at Thu Feb 08 10:25:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.