[MDEV-87] query_cache fails (sporadically) on Windows Created: 2012-01-17  Updated: 2012-05-18  Resolved: 2012-05-18

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.20
Fix Version/s: None

Type: Bug Priority: Blocker
Reporter: Vladislav Vaintroub Assignee: Vladislav Vaintroub
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/win2008r2-vs2010-i386-packages/builds/529/steps/test/logs/stdio

Note the sporadic nature of the failure (retry-pass)



 Comments   
Comment by Oleksandr Byelkin [ 2012-01-18 ]

It works on XP.

I can't build it on Win7 yet (have to wait the build fix)

Comment by Vladislav Vaintroub [ 2012-01-18 ]

See the comment on sporadic nature of the failure. It works for me too, but it fails sometimes on buildbot

Comment by Oleksandr Byelkin [ 2012-01-19 ]

The problem could be cause by really high and uneven load on the testing box. The test makes assumption that load on the box is more or less even and error caused of high load can't differ from calculated more then on 2 sec.

Other cause of the problem could be different implementation of sleep() in windows where parallel execution of sleep can lead to earlier ending of one of them or delaying other one.

Comment by Oleksandr Byelkin [ 2012-01-19 ]

Could you say something about sleep() implementation in windows? (see comment)

Comment by Vladislav Vaintroub [ 2012-01-19 ]

Sleep implementation on Windows (Item_func_sleep) is the same as anywhere else - it is using wait on a condition variable. The timers Windows uses internally are not high-performance timers, i.e their accuracy is around 10 ms. Parallel waiting on condition variables is of course possible

Comment by Oleksandr Byelkin [ 2012-01-19 ]

The test is not related to QC (sleep is not cached). It is somehow windows specific. My knowladge about windows limited and so I run out of ideas how to repeat it or why it happened on windows.

Comment by Vladislav Vaintroub [ 2012-01-19 ]

No, it is not only windows specific. The link shows Windows failure, because it happened on Windows. Yet, it is test specific, as I have seen it on freebsd, too. Now, we do not have freebsd running on builbot, but it is easily obtainable and installable on virtual machines

Comment by Vladislav Vaintroub [ 2012-01-19 ]

Also, I personally found "sleep" parts of tests in query_cache.test to be tricky to the extend they get incomprehensible and impenetrable. Maybe it is better to just remove them and replace with 1 simple test proving that sleep() is not cached?

Comment by Vladislav Vaintroub [ 2012-05-18 ]

did not fail for quite a long time. Will reopen if I see it failing..

Generated at Thu Feb 08 06:26:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.