Re: mysqld: ma_pagecache.c:2103: find_block: Assertion `block->rlocks == 0' failed with Aria

core + binary + datadir
LPexportBug727869_var-bug727869.zip

Re: mysqld: ma_pagecache.c:2103: find_block: Assertion `block->rlocks == 0' failed with Aria
Another backtrace:

1. 2011-03-03T03:38:29 #5 0x00000035a6e340d5 in abort () from /lib64/libc.so.6
2. 2011-03-03T03:38:29 #6 0x00000035a6e2b8b5 in __assert_fail () from /lib64/libc.so.6
3. 2011-03-03T03:38:29 #7 0x00000000009d115e in find_block (pagecache=0x1a38b60, file=0x7f095c1291c8, pageno=4, init_hits_left=3, wrmode=1 '\001', block_is_copied=1 '\001',
4. 2011-03-03T03:38:29 reg_req=1 '\001', page_st=0x7f09d41ea21c) at ma_pagecache.c:2103
5. 2011-03-03T03:38:29 #8 0x00000000009d52a8 in pagecache_read (pagecache=0x1a38b60, file=0x7f095c1291c8, pageno=4, level=3, buff=0x7f09d41ea390 "\001", type=PAGECACHE_LSN_PAGE,
6. 2011-03-03T03:38:29 lock=PAGECACHE_LOCK_WRITE, page_link=0x7f09d41ea330) at ma_pagecache.c:3383
7. 2011-03-03T03:38:29 #9 0x0000000000993b9c in _ma_fetch_keypage (page=0x7f09d41f2db0, info=0x7f094c069578, keyinfo=0x7f095c129788, pos=131072, lock=PAGECACHE_LOCK_WRITE,
8. 2011-03-03T03:38:29 level=3, buff=0x7f09d41ea390 "\001", return_buffer=0 '\000') at ma_page.c:109
9. 2011-03-03T03:38:29 #10 0x0000000000998313 in w_search (info=0x7f094c069578, comp_flag=0, key=0x0, page_pos=0, father_page=0x0, father_keypos=0x0, insert_last=0 '\000')
10. 2011-03-03T03:38:29 at ma_write.c:619
11. 2011-03-03T03:38:29 #11 0x00000000009987b1 in w_search (info=0x7f094c069578, comp_flag=402, key=0x7f09d41f2dc0, page_pos=2815028952344838, father_page=0x7f09d41fc970,
12. 2011-03-03T03:38:29 father_keypos=0x20000 <Address 0x20000 out of bounds>, insert_last=9 '\t') at ma_write.c:711
13. 2011-03-03T03:38:29 #12 0x0000000000997dd3 in _ma_ck_real_write_btree (info=0x7f094c069578, key=0x7f09d41fc970, root=0x7f09d41fc860, comp_flag=655425) at ma_write.c:512
14. 2011-03-03T03:38:29 #13 0x0000000000997c76 in _ma_ck_write_btree_with_log (info=0x7f094c069578, key=0x7f09d41fc970, root=0x7f095c129a38, comp_flag=655425) at ma_write.c:478
15. 2011-03-03T03:38:29 #14 0x0000000000997acb in _ma_ck_write_btree (info=0x7f094c069578, key=0x7f09d41fc970) at ma_write.c:438
16. 2011-03-03T03:38:29 #15 0x0000000000997a3f in _ma_ck_write (info=0x7f094c069578, key=0x7f09d41fc970) at ma_write.c:423
17. 2011-03-03T03:38:29 #16 0x0000000000997247 in maria_write (info=0x7f094c069578, record=0x7f094c05e870 "\377\177\001c") at ma_write.c:178
18. 2011-03-03T03:38:29 #17 0x000000000093c246 in ha_maria::write_row (this=0x7f094c05e6e0, buf=0x7f094c05e870 "\377\177\001c") at ha_maria.cc:1040
19. 2011-03-03T03:38:29 #18 0x00000000007cddae in handler::ha_write_row (this=0x7f094c05e6e0, buf=0x7f094c05e870 "\377\177\001c") at handler.cc:4728
20. 2011-03-03T03:38:29 #19 0x000000000072d64f in write_record (thd=0x7f094c05e6e0, table=0x7f094c05e870, info=0x93c246) at sql_insert.cc:1630
21. 2011-03-03T03:38:29 #20 0x000000000072b4e6 in mysql_insert (thd=0x49f1558, table_list=0x7f0958007088, fields=..., values_list=..., update_fields=..., update_values=...,
22. 2011-03-03T03:38:29 duplic=DUP_ERROR, ignore=false) at sql_insert.cc:860
23. 2011-03-03T03:38:29 #21 0x000000000068c8df in mysql_execute_command (thd=0x49f1558) at sql_parse.cc:3279
24. 2011-03-03T03:38:29 #22 0x000000000069580d in mysql_parse (thd=0x49f1558,
25. 2011-03-03T03:38:29 rawbuf=0x7f0958006f10 "INSERT INTO smf_permissions (`id_group`,`permission`,`add_deny`) VALUES (16302336,'c',10338048)", length=95,
26. 2011-03-03T03:38:29 found_semicolon=0x7f09d41fdc70) at sql_parse.cc:6163
27. 2011-03-03T03:38:29 #23 0x0000000000687600 in dispatch_command (command=COM_QUERY, thd=0x49f1558,
28. 2011-03-03T03:38:29 packet=0x49f4169 "INSERT INTO smf_permissions (`id_group`,`permission`,`add_deny`) VALUES (16302336,'c',10338048)", packet_length=95)
29. 2011-03-03T03:38:29 at sql_parse.cc:1273
30. 2011-03-03T03:38:29 #24 0x0000000000686620 in do_command (thd=0x49f1558) at sql_parse.cc:899
31. 2011-03-03T03:38:29 #25 0x000000000068360f in handle_one_connection (arg=0x49f1558) at sql_connect.cc:1151
32. 2011-03-03T03:38:29 #26 0x00000035a7207761 in start_thread () from /lib64/libpthread.so.0
33. 2011-03-03T03:38:29 #27 0x00000035a6ee098d in clone () from /lib64/libc.so.6
34. 2011-03-03T03:38:29 #5 0x00000035a6e340d5 in abort () from /lib64/libc.so.6

RQG command line:

perl runall.pl -queries=1M --engine=Maria --mysqld=default-storage-engine=Maria --mysqld=safe-mode --mysqld=loose-debug-assert-if-crashed-table --mysqld=sync-sys=0 --mysqld=log-output=file --mysqld=maria_log_purge_type=at_flush --reporters=ErrorLog,Backtrace,Recovery,Shutdown --duration=480 --threads=20 --rows=1000 --mask-level=2 --mysqld=maria-repair-threads=2 --mysqld=loose-maria-group-commit=soft --mysqld=loose-maria_group_commit_interval=100 --mysqld=maria-checkpoint-interval=32K --mysqld=table_cache=32K --mysqld=maria-block-size=32K --mysqld=maria-pagecache-buffer-size=512K --seed=1299116045 --queries=100000000 --mask=3931 --mysqld=-init-file=/home/philips/bzr/randgen/conf/smf/smf2.sql --grammar=conf/smf/smf2.yy --basedir=/home/philips/bzr/maria-5.1-merge/

Re: mysqld: ma_pagecache.c:2103: find_block: Assertion `block->rlocks == 0' failed with Aria on INSERT/REPLACE
Have now run the test case for 36 hours over and over again without any problems, so problem should be fixed.
Fix pushed into 5.2 and merged to 5.3

Launchpad bug id: 727869