[MCOL-1492] Columnstore down with Invalid range error Created: 2018-06-21  Updated: 2021-04-22  Resolved: 2021-04-22

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Abhinav santi Assignee: Denis Khalikov
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

AWS AMI, CENTOS


 Description   

Hello, Columnstore is down with the following error on PM1. there is not much info on any other module. Can you please throw some light on this

Invalid Range from HWM for lbid 225929936, range size should be <= blocksReadAhead: HWM 9389, dbroot 1, highfbo 10239, lowfbo 9728, blocksReadAhead 512, range size -338

Thanks

 Comments   
Comment by David Hill (Inactive) [ 2018-06-21 ]

the best thing to do is run the support report and attach the results, if its not too large.

https://mariadb.com/kb/en/library/system-troubleshooting-mariadb-columnstore/#mariadb-columnstore-support-report-tool

Comment by Abhinav santi [ 2018-06-21 ]

Thanks David. Do you have any FTP location where I can securely upload the log files.

Comment by David Hill (Inactive) [ 2018-06-21 ]

Customer Access
The address is ftp://ftp.mariadb.com
SSL connections are enabled and should be utilized.
There is also a secure listener available via ftps://ftp.mariadb.com/ for some clients (such as curl)
Files may be uploaded to ftp://ftp.mariadb.com/uploads
Anonymous uploads are allowed; no login is necessary.

Comment by Abhinav santi [ 2018-06-21 ]

Uploaded support report to ftp location. Thanks

Comment by Harun Kucuk [ 2018-11-08 ]

Hello @David Hill

Are there any news about this bug. We have faced similar issue today. and the issue was not fixed until mcadmin RestartSystem.

Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.311803 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296824, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1535, lowfbo 1024, blocksReadAhead 512, range size -1023
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.311804 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296184, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1023, lowfbo 512, blocksReadAhead 512, range size -511
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312010 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296832, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1535, lowfbo 1024, blocksReadAhead 512, range size -1023
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312043 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296192, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1023, lowfbo 512, blocksReadAhead 512, range size -511
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312072 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157297336, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 2047, lowfbo 1536, blocksReadAhead 512, range size -1535
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312131 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296840, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1535, lowfbo 1024, blocksReadAhead 512, range size -1023
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.311767 |0|0|0| I 28 CAL0061: PrimProc error reading file for OID 3378; retry updateptrs for /usr/local/mariadb/columnstore/data1/000.dir/000.dir/013.dir/050.dir/000.dir/FILE000.cdf. rc=0, idx=2, ptr.size=1
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312189 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157297344, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 2047, lowfbo 1536, blocksReadAhead 512, range size -1535
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312226 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296848, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1535, lowfbo 1024, blocksReadAhead 512, range size -1023
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312279 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157297352, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 2047, lowfbo 1536, blocksReadAhead 512, range size -1535
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312306 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296856, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1535, lowfbo 1024, blocksReadAhead 512, range size -1023
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312365 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157297360, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 2047, lowfbo 1536, blocksReadAhead 512, range size -1535
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312384 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157296864, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 1535, lowfbo 1024, blocksReadAhead 512, range size -1023
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312484 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 157297368, range size should be <= blocksReadAhead: HWM 0, dbroot 1, highfbo 2047, lowfbo 1536, blocksReadAhead 512, range size -1535
Nov 8 09:34:01 ip-172-31-26-247 PrimProc[1993]: 01.312208 |0|0|0| I 28 CAL0061: PrimProc error reading file for OID 3378; retry updateptrs for /usr/local/mariadb/columnstore/data1/000.dir/000.dir/013.dir/050.dir/000.dir/FILE000.cdf. rc=0, idx=1, ptr.size=1

Comment by Chris Calender (Inactive) [ 2021-04-22 ]

In cases like this, please check that the disk is full. That is the typical reason for such error.

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