Table corruption with key-cache-segments > 51
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Unassigned |
Bug Description
In Maria 5.2, the main.ctype_
perl mysql-test-run.pl --mysqld=
main.ctype_
Test ended at 2010-07-14 15:01:23
CURRENT_TEST: main.ctype_
--- /home/philips/
+++ /home/philips/
@@ -139,13 +139,17 @@
a
check table t1;
Table Op Msg_type Msg_text
-test.t1 check status OK
+test.t1 check error Size of indexfile is: 1024 Should be: 2048
+test.t1 check error Corrupt
select * from t1 where a like "�%";
a b
� 1
�a 1
�c 1
�o 1
+Warnings:
+Error 145 Table './test/t1' is marked as crashed and should be repaired
+Error 1194 Table 't1' is marked as crashed and should be repaired
select * from t1 where a like binary "%�%";
a b
� 2
mysqltest: Result length mismatch
The test basically inserts some non-ascii values in a table and then runs CHECK TABLE
Changed in maria: | |
importance: | Undecided → High |
Changed in maria: | |
milestone: | none → 5.2 |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Philip Stoev wrote: latin1_ de test fails when run with key- --key-cache- segments= 52 latin1_ de latin1_ de [ fail ] latin1_ de bzr/maria- 5.2/mysql- test/r/ ctype_latin1_ de.result 2010-07-12 17:43:46.149554000 +0300 bzr/maria- 5.2/mysql- test/r/ ctype_latin1_ de.reject 2010-07-14 15:01:23.744825496 +0300
> Public bug reported:
>
> In Maria 5.2, the main.ctype_
> cache-segments > 51 :
>
> perl mysql-test-run.pl --mysqld=
> main.ctype_
>
> main.ctype_
> Test ended at 2010-07-14 15:01:23
>
> CURRENT_TEST: main.ctype_
> --- /home/philips/
> +++ /home/philips/
> @@ -139,13 +139,17 @@
> a
> check table t1;
> Table Op Msg_type Msg_text
> -test.t1 check status OK
> +test.t1 check error Size of indexfile is: 1024 Should be: 2048
> +test.t1 check error Corrupt
> select * from t1 where a like "�%";
> a b
> � 1
> �a 1
> �c 1
> �o 1
> +Warnings:
> +Error 145 Table './test/t1' is marked as crashed and should be repaired
> +Error 1194 Table 't1' is marked as crashed and should be repaired
> select * from t1 where a like binary "%�%";
> a b
> � 2
>
> mysqltest: Result length mismatch
>
> The test basically inserts some non-ascii values in a table and then
> runs CHECK TABLE
>
> ** Affects: maria
> Importance: Undecided
> Status: New
>
>
> ** Tags: cache key segmented
>
Philip,
I failed to reproduce this bug with the current 5.2 tree.
Regards,
Igor.