[MDEV-14300] Buffer Overflow on large select Created: 2017-11-06  Updated: 2017-11-10

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2.10
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Sean Stoves Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: buffer, innodb, partitioning
Environment:

CentOS 7
VM
ISCSI Datastore

Attachments: Text File ShowCreateTable.txt     File my.cnf     Text File mysql.error.log    

 Description   

Attached are the logs. When we are querying a specifically large partition via InnoDB, we are getting buffer_flows. I have the logs printed out and saved below. We are unsure if this is a MySQL or a CentOS 7 buffer. However, we upgraded from 10.2.8 to 10.2.10 and the problem persisted.

We also moved to this server from a MySQL 5.6 Enterprise server that was having physical hardware problems, and then CentoOS 7 and Mysql 5.6 appeared to be having library conflicts when running together.

=== System Specs
CPU: 8vCPU
RAM: 49G

 Comments   
Comment by Elena Stepanova [ 2017-11-07 ]

sman260, can you provide the query itself, and also the output of SHOW CREATE ... for all involved structures, and SHOW INDEX IN ... for all involved tables?
Thanks.

Comment by Sean Stoves [ 2017-11-07 ]

Attached is the show Create table.

The query that causes the crash is: SELECT * FROM sftdev_UTR_MarkIV.F02_Term_Main partition (p300) where CallType in ('International', 'OSInternational');

However, any query even a rebuild partition or a select count causes the crash.

MariaDB [(none)]> show index in sftdev_UTR_MarkIV.F02_Term_Main;
---------------------------------------------------------------------------------------------------------------------------------

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment

---------------------------------------------------------------------------------------------------------------------------------

F02_Term_Main 0 PRIMARY 1 MasterID A 20600911 NULL NULL   BTREE    
F02_Term_Main 0 PRIMARY 2 ReleaseTime A 20600911 NULL NULL   BTREE    
F02_Term_Main 1 ReleaseTime 1 ReleaseTime A 2288990 NULL NULL   BTREE    
F02_Term_Main 1 OrigTN 1 OrigTN A 6866970 NULL NULL YES BTREE    
F02_Term_Main 1 TermTN 1 TermTN A 20600911 NULL NULL YES BTREE    
F02_Term_Main 1 UserID 1 UserID A 6866970 NULL NULL YES BTREE    
F02_Term_Main 1 GroupName 1 GroupName A 936405 NULL NULL YES BTREE    
F02_Term_Main 1 Provider 1 Provider A 355188 NULL NULL YES BTREE    
F02_Term_Main 1 CallType 1 CallType A 357 NULL NULL YES BTREE    
F02_Term_Main 1 SourceServer 1 SourceServer A 517 NULL NULL YES BTREE    
F02_Term_Main 1 Process 1 ProcessID A 119 NULL NULL YES BTREE    
F02_Term_Main 1 Destination 1 Destination A 515022 NULL NULL YES BTREE    

---------------------------------------------------------------------------------------------------------------------------------
12 rows in set (0.00 sec)

MariaDB [(none)]>

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