MariaDB [(none)]> status; -------------- mysql Ver 15.1 Distrib 10.5.9-MariaDB, for Linux (x86_64) using readline 5.1 Connection id: 10 Current database: Current user: unicauser@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.5.9-MariaDB-log MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /tmp/mysql.sock Uptime: 3 days 21 hours 21 min 28 sec Threads: 3 Questions: 84 Slow queries: 0 Opens: 33 Open tables: 4 Queries per second avg: 0.000 -------------- MariaDB [(none)]> SELECT -> ROW_NUMBER() OVER (ORDER BY (SELECT NULL)), -> NULL, -> NULL, -> NULL, -> NULL, -> NULL, -> 'NA'; +--------------------------------------------+------+------+------+------+------+----+ | ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) | NULL | NULL | NULL | NULL | NULL | NA | +--------------------------------------------+------+------+------+------+------+----+ | 1 | NULL | NULL | NULL | NULL | NULL | NA | +--------------------------------------------+------+------+------+------+------+----+ 1 row in set (0.002 sec) MariaDB [plan]> show tables; Empty set (0.000 sec) MariaDB [plan]> CREATE TABLE `denodo_camp_promo_view` ( -> `ID` decimal(15,0) DEFAULT NULL, -> `name` varchar(80) DEFAULT NULL, -> `startdate` date DEFAULT NULL, -> `enddate` date DEFAULT NULL, -> `ownerid` varchar(18) DEFAULT NULL, -> `promotion_code__c` varchar(255) DEFAULT NULL, -> `PROMOCODE_DETAILS` varchar(321) DEFAULT NULL -> ); Query OK, 0 rows affected (0.055 sec) MariaDB [plan]> INSERT INTO denodo_camp_promo_view (ID, name, startdate, enddate, ownerid, promotion_code__c, PROMOCODE_DETAILS) SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),NULL,NULL,NULL,NULL,NULL,'NA'; ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [plan]> status; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 5 Current database: plan -------------- mysql Ver 15.1 Distrib 10.5.9-MariaDB, for Linux (x86_64) using readline 5.1 Connection id: 5 Current database: plan Current user: unicauser@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.5.9-MariaDB-log MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /tmp/mysql.sock Uptime: 24 sec Threads: 3 Questions: 20 Slow queries: 0 Opens: 17 Open tables: 11 Queries per second avg: 0.833 -------------- MariaDB [plan]> MariaDB [plan]> show tables; +------------------------+ | Tables_in_plan | +------------------------+ | denodo_camp_promo_view | +------------------------+ 1 row in set (0.000 sec) MariaDB [plan]> select * from denodo_camp_promo_view; Empty set (0.001 sec) MariaDB [plan]> ================== 2023-12-12 7:42:59 0 [Note] /data/HCL/mariadb/bin/mariadbd (initiated by: unicauser[unicauser] @ localhost []): Normal shutdown 2023-12-12 7:42:59 0 [Note] Event Scheduler: Purging the queue. 0 events 2023-12-12 7:42:59 0 [Note] InnoDB: FTS optimize thread exiting. 2023-12-12 7:42:59 0 [Note] InnoDB: Starting shutdown... 2023-12-12 7:42:59 0 [Note] InnoDB: Dumping buffer pool(s) to /data/HCL/mariadb/data/ib_buffer_pool 2023-12-12 7:42:59 0 [Note] InnoDB: Buffer pool(s) dump completed at 231212 7:42:59 2023-12-12 7:43:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2023-12-12 7:43:00 0 [Note] InnoDB: Shutdown completed; log sequence number 46748765; transaction id 141 2023-12-12 7:43:00 0 [Note] /data/HCL/mariadb/bin/mariadbd: Shutdown complete 231212 07:43:00 mysqld_safe mysqld from pid file /data/HCL/mariadb/data/quuswe1bhxunwcadbs1001.pid ended 231212 07:51:12 mysqld_safe Starting mariadbd daemon with databases from /data/HCL/mariadb/data 2023-12-12 7:51:12 0 [Note] /data/HCL/mariadb/bin/mariadbd (mysqld 10.5.9-MariaDB-log) starting as process 462646 ... 2023-12-12 7:51:12 0 [Warning] The parameter innodb_buffer_pool_instances is deprecated and has no effect. 2023-12-12 7:51:12 0 [Note] InnoDB: innodb_page_size=32768 2023-12-12 7:51:12 0 [Note] InnoDB: Uses event mutexes 2023-12-12 7:51:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-12-12 7:51:12 0 [Note] InnoDB: Number of pools: 1 2023-12-12 7:51:12 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-12-12 7:51:12 0 [Note] InnoDB: Using Linux native AIO 2023-12-12 7:51:12 0 [Note] InnoDB: Initializing buffer pool, total size = 10737418240, chunk size = 134217728 2023-12-12 7:51:12 0 [Note] InnoDB: Completed initialization of buffer pool 2023-12-12 7:51:12 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2023-12-12 7:51:12 0 [Note] InnoDB: 128 rollback segments are active. 2023-12-12 7:51:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-12-12 7:51:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-12-12 7:51:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-12-12 7:51:12 0 [Note] InnoDB: 10.5.9 started; log sequence number 46748765; transaction id 141 2023-12-12 7:51:12 0 [Warning] Invalid monitor counter name: 'YES' 2023-12-12 7:51:12 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-12-12 7:51:12 0 [Note] InnoDB: Loading buffer pool(s) from /data/HCL/mariadb/data/ib_buffer_pool 2023-12-12 7:51:12 0 [Note] InnoDB: Buffer pool(s) load completed at 231212 7:51:12 2023-12-12 7:51:12 0 [Note] Server socket created on IP: '10.210.3.130'. 2023-12-12 7:51:12 0 [Note] Reading of all Master_info entries succeeded 2023-12-12 7:51:12 0 [Note] Added new Master_info '' to hash table 2023-12-12 7:51:12 0 [Note] /data/HCL/mariadb/bin/mariadbd: ready for connections. Version: '10.5.9-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server 2023-12-12 8:40:33 8 [Note] Start binlog_dump to slave_server(2), pos(, 4), using_gtid(1), gtid('0-1-3') 231216 5:20:27 [ERROR] mysqld got signal 11 ; ========================= Server version: 10.5.9-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=5002 thread_count=3 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11142558 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f6f0c150d18 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f71c809ddb0 thread_stack 0x49000 /data/HCL/mariadb/bin/mariadbd(my_print_stacktrace+0x2e)[0x55c8384bc8ae] mysys/stacktrace.c:213(my_print_stacktrace)[0x55c837e9ab47] sigaction.c:0(__restore_rt)[0x7f71eac2dc20] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f6f0c15b330): INSERT INTO denodo_camp_promo_view (ID, name, startdate, enddate, ownerid, promotion_code__c, PROMOCODE_DETAILS) SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),NULL,NULL,NULL,NULL,NULL,'NA' Connection ID (thread ID): 10 Status: NOT_KILLED 231216 05:20:28 mysqld_safe Number of processes running now: 0 231216 05:20:28 mysqld_safe mysqld restarted 2023-12-16 5:20:28 0 [Note] /data/HCL/mariadb/bin/mariadbd (mysqld 10.5.9-MariaDB-log) starting as process 610027 ... 2023-12-16 5:20:28 0 [Note] mariadbd: Aria engine: starting recovery recovered pages: 0% 31% 43% 100% (0.0 seconds); tables to flush: 1 0 (0.0 seconds); 2023-12-16 5:20:28 0 [Note] mariadbd: Aria engine: recovery done 2023-12-16 5:20:28 0 [Warning] The parameter innodb_buffer_pool_instances is deprecated and has no effect. 2023-12-16 5:20:28 0 [Note] InnoDB: innodb_page_size=32768 2023-12-16 5:20:28 0 [Note] InnoDB: Uses event mutexes 2023-12-16 5:20:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2023-12-16 5:20:28 0 [Note] InnoDB: Number of pools: 1 2023-12-16 5:20:28 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-12-16 5:20:28 0 [Note] InnoDB: Using Linux native AIO 2023-12-16 5:20:28 0 [Note] InnoDB: Initializing buffer pool, total size = 10737418240, chunk size = 134217728 2023-12-16 5:20:29 0 [Note] InnoDB: Completed initialization of buffer pool 2023-12-16 5:20:29 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2023-12-16 5:20:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=46748765,46748765 2023-12-16 5:20:29 0 [Note] InnoDB: Starting final batch to recover 17 pages from redo log. 2023-12-16 5:20:29 0 [Note] InnoDB: Last binlog file './ON.000002', position 17111205 2023-12-16 5:20:29 0 [Note] InnoDB: 128 rollback segments are active. 2023-12-16 5:20:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2023-12-16 5:20:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-12-16 5:20:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-12-16 5:20:29 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-12-16 5:20:29 0 [Note] InnoDB: 10.5.9 started; log sequence number 46757925; transaction id 174 2023-12-16 5:20:29 0 [Warning] Invalid monitor counter name: 'YES' 2023-12-16 5:20:29 0 [Note] Plugin 'FEEDBACK' is disabled. ================= [root@quuswe1bhxunwcadbs1001 ~]# cat /var/log/messages|grep "Dec 16 05:20:2" Dec 16 05:20:20 quuswe1bhxunwcadbs1001 newrelic-infra-service[918]: time="2023-12-16T05:20:20Z" level=error msg="could not queue event" component=Agent entityKey= error="could not queue event: queue is full" Dec 16 05:20:20 quuswe1bhxunwcadbs1001 newrelic-infra-service[918]: time="2023-12-16T05:20:20Z" level=error msg="could not queue event" component=Agent entityKey= error="could not queue event: queue is full" Dec 16 05:20:25 quuswe1bhxunwcadbs1001 newrelic-infra-service[918]: time="2023-12-16T05:20:25Z" level=error msg="could not queue event" component=Agent entityKey= error="could not queue event: queue is full" Dec 16 05:20:25 quuswe1bhxunwcadbs1001 newrelic-infra-service[918]: time="2023-12-16T05:20:25Z" level=error msg="could not queue event" component=Agent entityKey= error="could not queue event: queue is full" Dec 16 05:20:27 quuswe1bhxunwcadbs1001 kernel: mariadbd[609813]: segfault at 0 ip 0000000000000000 sp 00007f71c809cb18 error 14 in mariadbd[55c8374ae000+6aa000] Dec 16 05:20:27 quuswe1bhxunwcadbs1001 kernel: Code: Unable to access opcode bytes at RIP 0xffffffffffffffd6. Dec 16 05:20:28 quuswe1bhxunwcadbs1001 systemd[1]: Created slice system-systemd\x2dcoredump.slice. Dec 16 05:20:28 quuswe1bhxunwcadbs1001 systemd[1]: Started Process Core Dump (PID 609993/UID 0). Dec 16 05:20:28 quuswe1bhxunwcadbs1001 systemd-coredump[609994]: Resource limits disable core dumping for process 462646 (mariadbd). Dec 16 05:20:28 quuswe1bhxunwcadbs1001 systemd-coredump[609994]: Process 462646 (mariadbd) of user 10000 dumped core. Dec 16 05:20:28 quuswe1bhxunwcadbs1001 systemd[1]: systemd-coredump@0-609993-0.service: Succeeded. [root@quuswe1bhxunwcadbs1001 ~]# [root@quuswe1bhxunwcadbs1001 ~]# [root@quuswe1bhxunwcadbs1001 ~]# [root@quuswe1bhxunwcadbs1001 ~]# dmesg|tail -5 [ 23.947313] IPv6: ADDRCONF(NETDEV_UP): eth0: link is not ready [ 28.113868] fbcon: Taking over console [1178434.867857] Adding Red Hat flag eBPF/event. [1453363.047981] mariadbd[609813]: segfault at 0 ip 0000000000000000 sp 00007f71c809cb18 error 14 in mariadbd[55c8374ae000+6aa000] [1453363.059621] Code: Unable to access opcode bytes at RIP 0xffffffffffffffd6. [root@quuswe1bhxunwcadbs1001 ~]#