Columnstore 22.08

[Thorsten Flach]

Hi,

we have upgraded to the latet columnsore and now we have the problem, that the columnstor is defekt.

We get the message (a lot): Invalid Range from HWM for lbid 112335, range size should be <= blocksReadAhead: HWM 979, dbroot 1, highfbo 6143, lowfbo 5632, blocksReadAhead 512, range size -4652#012         %%10%%

We cant drop columnstorefiles or load (cpimport) new one.

We have enough diskspace and tried to repair with  mcsRebuildEM but the file that was created are very small and we get also errors.

Have someone ideas?

Thanks

Thorsten

--

[drrtuy]

Hey Thorsten,

Sorry to hear that. What is the actual version? You can run SQL like 'show status like show status like 'columnstore%';
Which version do you use CS or ES?

Regards,

Roman

понедельник, 3 октября 2022 г. в 12:16:25 UTC+3, Thorsten Flach:

[Thorsten Flach]

Hey Roman,

we use Server version: 10.6.9-5-MariaDB-enterprise

MariaDB [(none)]> show status like 'columnstore%';
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Columnstore_commit_hash | source  |
| Columnstore_version     | 22.08.1 |
+-------------------------+---------+

regards Thorsten

--
You received this message because you are subscribed to the Google Groups "MariaDB ColumnStore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mariadb-columns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mariadb-columnstore/c9e7c35d-41cf-4a09-ab09-fcd5d83419d3n%40googlegroups.com.

--

Thorsten Flach
0162/2525578
Frankfurter Str. 161d
65520 Bad Camberg

[drrtuy]

Very unfortunately RHEL7/8 upgrades are affected by this version. If you first remove all packages and then install them back this will replace on-disk ExtentMap image with an empty file and gives you an error like you have. Luckily there are multiple extent map copies saved in /var/lib/columnstore/data1/systemFiles/dbrm on the primary node of your cluster.

Regards,

Roman

понедельник, 3 октября 2022 г. в 19:38:40 UTC+3, Thorsten Flach: