Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.9
-
None
-
RHEL 8 4.18.0-553.16.1.el8_10.x86_64
MariaDB 10.5.9
total used free shared buff/cache available
Mem: 39Gi 21Gi 310Mi 0.0Ki 18Gi 18Gi
Swap: 0B 0B 0B
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 16
On-line CPU(s) list: 0-15
Thread(s) per core: 2
Core(s) per socket: 8RHEL 8 4.18.0-553.16.1.el8_10.x86_64 MariaDB 10.5.9 total used free shared buff/cache available Mem: 39Gi 21Gi 310Mi 0.0Ki 18Gi 18Gi Swap: 0B 0B 0B Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 16 On-line CPU(s) list: 0-15 Thread(s) per core: 2 Core(s) per socket: 8
Description
There are "Sort Abort" Warning messages Noticed in MariaDB Error log file. Increased the variables "sort_buffer_size=20Mb" and "innodb_sort_buffer_size=16Mb". After a period the alert reappears.
2024-09-12 9:12:33 2771708 *[Warning] Sort aborted*, host: compute.internal, user: unicauser, thread: 2771708, query: SELECT OLTMMEID,OLTBATCHID,OLTSEQUENCENO,OLTRECIPIENTTYPE,OLTBOUNDARY,CellCode,CellID,OLTSERVICE_ID,CUSTOMER_NAME,TreatmentCode,TRACKINGCODE,EMAIL_ADDR FROM OLT1537 ORDER BY OLTSEQUENCENO
|
2024-09-12 10:45:01 2782289 [Warning] Sort aborted, host:compute.internal, user: unicauser, thread: 2782289, query: SELECT * FROM UAC_217310_104 ORDER BY InternalRowNumber ASC, TreatmentInstID ASC, DirectResponse DESC
|
2024-09-12 13:47:07 2802875 [Warning] Sort aborted, host:compute.internal, user: unicauser, thread: 2802875, query: SELECT OLTMMEID,OLTBATCHID,OLTSEQUENCENO,OLTRECIPIENTTYPE,OLTBOUNDARY,CellCode,CellID,OLTSERVICE_ID,TreatmentCode,TRACKINGCODE,EMAIL_ADDR,CUSTOMER_NAME FROM OLT1537 ORDER BY OLTSEQUENCENO
|
2024-09-12 13:56:48 2803392 [Warning] Sort aborted, host: compute.internal, user:
|