Re: [Bug 605375] [NEW] Table corruption with key-cache-segments > 51
Philip Stoev wrote:
> Public bug reported:
>
> In Maria 5.2, the main.ctype_latin1_de test fails when run with key-
> cache-segments > 51 :
>
> perl mysql-test-run.pl -mysqld=-key-cache-segments=52
> main.ctype_latin1_de
>
> main.ctype_latin1_de [ fail ]
> Test ended at 2010-07-14 15:01:23
>
> CURRENT_TEST: main.ctype_latin1_de
> — /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result 2010-07-12 17:43:46.149554000 +0300
> +++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject 2010-07-14 15:01:23.744825496 +0300
> @@ -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.

Re: [Bug 605375] [NEW] Table corruption with key-cache-segments > 51
Hello,

It seems that this bug was fixed by the following push:

Changed by: Sergei Golubchik <sergii@pisem.net>
Changed at: Sat 24 Jul 2010 09:10:03
Branch: 5.2
Revision: 2832

Changed files:

a.. mysys/mf_keycache.c MODIFIED
b.. storage/example/ha_example.cc MODIFIED
c.. storage/xtradb/Makefile.am MODIFIED
Comments:
buildbot detected problems
If you are happy with such a solution, feel free to close the bug. Thank
you.Philip Stoev
----- Original Message -----
From: "Igor Babaev" <igor@askmonty.org>
To: <pstoev@askmonty.org>
Sent: Tuesday, July 27, 2010 1:42 AM
Subject: Re: [Bug 605375] [NEW] Table corruption with key-cache-segments >
51

Philip Stoev wrote:
> Public bug reported:
>
> In Maria 5.2, the main.ctype_latin1_de test fails when run with key-
> cache-segments > 51 :
>
> perl mysql-test-run.pl -mysqld=-key-cache-segments=52
> main.ctype_latin1_de
>
> main.ctype_latin1_de [ fail ]
> Test ended at 2010-07-14 15:01:23
>
> CURRENT_TEST: main.ctype_latin1_de
> — /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result
> 2010-07-12 17:43:46.149554000 +0300
> +++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject
> 2010-07-14 15:01:23.744825496 +0300
> @@ -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.

–
Table corruption with key-cache-segments > 51
https://bugs.launchpad.net/bugs/605375
You received this bug notification because you are a direct subscriber
of the bug.

Status in Maria: New

Bug description:
In Maria 5.2, the main.ctype_latin1_de test fails when run with
key-cache-segments > 51 :

perl mysql-test-run.pl -mysqld=-key-cache-segments=52 main.ctype_latin1_de

main.ctype_latin1_de [ fail ]
Test ended at 2010-07-14 15:01:23

CURRENT_TEST: main.ctype_latin1_de
— /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result
2010-07-12 17:43:46.149554000 +0300
+++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject
2010-07-14 15:01:23.744825496 +0300
@@ -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

To unsubscribe from this bug, go to:
https://bugs.launchpad.net/maria/+bug/605375/+subscribe

Re: [Bug 605375] [NEW] Table corruption with key-cache-segments > 51
Philip Stoev wrote:
> Hello,
>
> It seems that this bug was fixed by the following push:
>
> Changed by: Sergei Golubchik <sergii@pisem.net>
> Changed at: Sat 24 Jul 2010 09:10:03
> Branch: 5.2
> Revision: 2832
>
> Changed files:
>
> a.. mysys/mf_keycache.c MODIFIED
> b.. storage/example/ha_example.cc MODIFIED
> c.. storage/xtradb/Makefile.am MODIFIED
> Comments:
> buildbot detected problems
> If you are happy with such a solution, feel free to close the bug. Thank
> you.Philip Stoev
I'm ok with Sergei's change, but I don't know how to close the bug
(there is no 'closed' button there).

Regards,
Igor.

> ----- Original Message -----
> From: "Igor Babaev" <igor@askmonty.org>
> To: <pstoev@askmonty.org>
> Sent: Tuesday, July 27, 2010 1:42 AM
> Subject: Re: [Bug 605375] [NEW] Table corruption with key-cache-segments >
> 51
>
>
> Philip Stoev wrote:
>> Public bug reported:
>>
>> In Maria 5.2, the main.ctype_latin1_de test fails when run with key-
>> cache-segments > 51 :
>>
>> perl mysql-test-run.pl -mysqld=-key-cache-segments=52
>> main.ctype_latin1_de
>>
>> main.ctype_latin1_de [ fail ]
>> Test ended at 2010-07-14 15:01:23
>>
>> CURRENT_TEST: main.ctype_latin1_de
>> — /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.result
>> 2010-07-12 17:43:46.149554000 +0300
>> +++ /home/philips/bzr/maria-5.2/mysql-test/r/ctype_latin1_de.reject
>> 2010-07-14 15:01:23.744825496 +0300
>> @@ -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.
>

Launchpad bug id: 605375