Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 410001 - dev-db/mariadb-5.1.60 version bump
Summary: dev-db/mariadb-5.1.60 version bump
Status: RESOLVED TEST-REQUEST
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL: http://downloads.askmonty.org/mariadb...
Whiteboard:
Keywords:
: 423467 (view as bug list)
Depends on:
Blocks: 413883
  Show dependency tree
 
Reported: 2012-03-28 14:08 UTC by Paolo Pedroni
Modified: 2012-11-17 06:44 UTC (History)
4 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
Fix index errors in the ma_test2 unit test binary (20000_all_mariadb_fix_tests.patch,845 bytes, patch)
2012-04-25 18:46 UTC, Brian Evans (RETIRED)
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Paolo Pedroni 2012-03-28 14:08:18 UTC
There is (and it's been there for a few months already) a new version (5.1.60) of mariadb on the mariadb site. An ebuild (even in the overlay) would be nice. I don't know (and I can't check at the moment) if a simple rename would do the trick.
Comment 1 Brian Evans (RETIRED) gentoo-dev 2012-04-17 14:18:32 UTC
MariaDB 5.1.62 is now in the overlay.
A patch from mysql-extras needs a change so please use the updated info.
Comment 2 jannis 2012-04-18 06:52:11 UTC
MariaDB 5.1.62 is now in official tree as unstable :)
RESOLVED FIXED?
Comment 3 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2012-04-18 06:55:29 UTC
Please run the testsuites. I'm not 100% happy with it.
Comment 4 Paolo Pedroni 2012-04-18 12:03:13 UTC
With FEATURES="test -usersandbox" I get these errors:
[13:56:10] mysys/waiting_threads-t ..................................... ok        4 ms
[13:56:10] mysys/base64-t .............................................. ok      154 ms
[13:56:10] mysys/lf-t .................................................. ok      155 ms
[13:56:10] mysys/my_atomic-t ........................................... ok       62 ms
[13:56:10] mysys/bitmap-t .............................................. ok      289 ms
[13:56:10] strings/strings-t ........................................... ok        1 ms
[13:56:10] ../storage/maria/unittest/ma_pagecache_consist_64kHC-t ...... ok        8 ms
[13:56:10] ../storage/maria/unittest/ma_pagecache_consist_64k-t ........ ok        3 ms
[13:56:10] ../storage/maria/unittest/ma_test_loghandler_nologs-t ....... ok      299 ms
[13:56:11] ../storage/maria/unittest/ma_test_loghandler_noflush-t ...... ok       19 ms
[13:56:11] ../storage/maria/unittest/ma_pagecache_consist_1k-t ......... ok        8 ms
[13:56:11] ../storage/maria/unittest/ma_test_loghandler_long-t ......... ok     3861 ms
[13:56:15] ../storage/maria/unittest/ma_pagecache_consist_1kHC-t ....... ok        7 ms
[13:56:15] ../storage/maria/unittest/ma_test_loghandler_readonly-t ..... ok       55 ms
[13:56:15] ../storage/maria/unittest/ma_test_loghandler_purge-t ........ ok      256 ms
[13:56:15] ../storage/maria/unittest/ma_test_loghandler_max_lsn-t ...... ok      269 ms
[13:56:15] ../storage/maria/unittest/ma_test_loghandler_first_lsn-t .... ok       21 ms
[13:56:15] ../storage/maria/unittest/ma_pagecache_consist_64kRD-t ...... ok    33304 ms
[13:56:49] ../storage/maria/unittest/ma_pagecache_consist_1kRD-t ....... ok      443 ms
[13:56:49] ../storage/maria/unittest/ma_pagecache_single_1k-t .......... ok      333 ms
[13:56:49] ../storage/maria/unittest/ma_test_loghandler_multiflush-t ... ok     5572 ms
[13:56:55] ../storage/maria/unittest/ma_test_loghandler_pagecache-t .... ok       22 ms
[13:56:55] ../storage/maria/unittest/ma_test_loghandler_multithread-t .. ok    29585 ms
[13:57:25] ../storage/maria/unittest/ma_test_loghandler_multigroup-t ... ok    27926 ms
[13:57:53] ../storage/maria/unittest/ma_test_loghandler-t .............. ok     4067 ms
[13:57:57] ../storage/maria/unittest/ma_pagecache_rwconsist2_1k-t ...... ok        6 ms
[13:57:57] ../storage/maria/unittest/ma_pagecache_rwconsist_1k-t ....... ok        6 ms
[13:57:57] ../storage/maria/unittest/ma_pagecache_consist_64kWR-t ...... ok    43644 ms
[13:58:40] ../storage/maria/unittest/ma_pagecache_consist_1kWR-t ....... ok     1317 ms
[13:58:42] ../storage/maria/unittest/ma_pagecache_single_8k-t .......... ok     1846 ms
[13:58:44] ../storage/maria/unittest/ma_pagecache_single_64k-t ......... ok        8 ms
[13:58:44] ../storage/maria/unittest/ma_control_file-t ................. ok        1 ms
[13:58:44] ../storage/maria/unittest/trnman-t .......................... ok      687 ms
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 77/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K ' (loop iteration 8.) at line 316
(errcode: 256, test: 83)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 85/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K ' (loop iteration 9.) at line 316
(errcode: 256, test: 85)

Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L ' (loop iteration 10.) at line 316
(errcode: 256, test: 87)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 238/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -S' (loop iteration 8.) at line 316
(errcode: 256, test: 242)

Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -S' (loop iteration 9.) at line 316
(errcode: 256, test: 244)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 246/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -S' (loop iteration 10.) at line 316
(errcode: 256, test: 246)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 399/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M' (loop iteration 8.) at line 316
(errcode: 256, test: 401)

Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M' (loop iteration 9.) at line 316
(errcode: 256, test: 403)

Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M' (loop iteration 10.) at line 316
(errcode: 256, test: 405)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 556/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M -T' (loop iteration 8.) at line 316
(errcode: 256, test: 560)

Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M -T' (loop iteration 9.) at line 316
(errcode: 256, test: 562)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 564/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M -T' (loop iteration 10.) at line 316
(errcode: 256, test: 564)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... 719/830 
Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M -T -C' (loop iteration 8.) at line 316
(errcode: 256, test: 719)

Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M -T -C' (loop iteration 9.) at line 316
(errcode: 256, test: 721)

Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M -T -C' (loop iteration 10.) at line 316
(errcode: 256, test: 723)
[13:58:44] ../storage/maria/unittest/ma_test_all-t ..................... Dubious, test returned 1 (wstat 256, 0x100)
Failed 15/830 subtests 
[14:00:37] ../dbug/tests-t ............................................. skipped: because dbug is disabled
[14:00:37]

Test Summary Report
-------------------
../storage/maria/unittest/ma_test_all-t                   (Wstat: 256 Tests: 830 Failed: 15)
  Failed tests:  83, 85, 87, 242, 244, 246, 401, 403, 405
                560, 562, 564, 719, 721, 723
  Non-zero exit status: 1
Files=35, Tests=145284, 267 wallclock secs ( 8.93 usr  0.30 sys + 138.85 cusr 56.43 csys = 204.51 CPU)
Result: FAIL
Failed 1/35 test programs. 15/145284 subtests failed.

Could it be because I have /var/tmp/portage on a tmpfs?
Comment 5 Paolo Pedroni 2012-04-18 12:13:24 UTC
Nope, same errors on a real filesystem as well. :-(
Comment 6 Brian Evans (RETIRED) gentoo-dev 2012-04-18 12:37:52 UTC
(In reply to comment #4)
> With FEATURES="test -usersandbox" I get these errors:
[snip]
> 
> Test Summary Report
> -------------------
> ../storage/maria/unittest/ma_test_all-t                   (Wstat: 256 Tests:
> 830 Failed: 15)
>   Failed tests:  83, 85, 87, 242, 244, 246, 401, 403, 405
>                 560, 562, 564, 719, 721, 723
>   Non-zero exit status: 1
> Files=35, Tests=145284, 267 wallclock secs ( 8.93 usr  0.30 sys + 138.85
> cusr 56.43 csys = 204.51 CPU)
> Result: FAIL
> Failed 1/35 test programs. 15/145284 subtests failed.
> 
> Could it be because I have /var/tmp/portage on a tmpfs?

I've discovered that ma_test_all-t fails with -O2 or -Os in C(XX)FLAGS set.

They work fine if -O1 is set.

I've pointed this out on the MariaDB mailing list, but not sure if it's a MariaDB bug or gcc optimization issue.

@Robin: Do we need to force -O1 for tests only or should we always do it?
Comment 7 jannis 2012-04-18 14:02:37 UTC
I get the same test failures but they are not new since I get exactly the same test cases failing with version 5.1.50.
Comment 8 Brian Evans (RETIRED) gentoo-dev 2012-04-23 13:14:31 UTC
More info about ma_test_all-t that may be causing random test failures:
https://lists.launchpad.net/maria-discuss/msg00608.html
Comment 9 Brian Evans (RETIRED) gentoo-dev 2012-04-25 18:46:24 UTC
Created attachment 310111 [details, diff]
Fix index errors in the ma_test2 unit test binary

This patch fixes the errors on ma_test2 during unit tests.
It appears randomly due to the rnd function returning a random number between and including 0 to 5000. Since there are 5000 entries in the array, if rnd() pulls 5000, it's out of bounds.

When applied, my test box passes all tests with the following parameters.
FEATURES="test userpriv -usersandbox" USE='-cluster -latin1 embedded extraengine perl ssl community'

This also applies and fixes on mariadb-5.2.12 and mariadb-5.3.6.

5.2.12 only 1 test fails (plugins.unix_socket) due to Portage stripping $USER.
5.3.6 has the same test failure due to Portage
Comment 10 Brian Evans (RETIRED) gentoo-dev 2012-04-25 19:41:12 UTC
Upstream bug on the test failure:
https://bugs.launchpad.net/maria/+bug/986261
Comment 11 Brian Evans (RETIRED) gentoo-dev 2012-08-02 19:32:05 UTC
Patch is now InCVS and will ship with the next mysql-extras release.
Comment 12 Jorge Manuel B. S. Vicetto (RETIRED) Gentoo Infrastructure gentoo-dev 2012-11-17 06:44:37 UTC
*** Bug 423467 has been marked as a duplicate of this bug. ***