Hi guys, One of my initial tasks has been to check out randgen testing as it is currently being done in drizzle-automation. One issue I have found is that the randgen isn't acting as expected when the server goes away (suspect a crash).
For example: When I run this command line (note, I needed to create a new grammar outer_join_drizzle to accommodate certain changes from the original grammar <no different charsets...thank heavens!>): perl ./gentest.pl--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password="":database=test --threads=1 --gendata=conf/drizzle/outer_join_drizzle.zz --grammar=conf/drizzle/outer_join_drizzle.yy --seed=time --queries=25000 --debug I should see 25k queries execute or some snazzy crash output. The randgen on MySQL is pretty slick about providing a full stacktrace and has some crash-simplification tools to cook down the test case. However, I see this: # 2010-05-27T15:42:46 Killing periodic reporting process with pid 20762... # 2010-05-27T15:42:46 Kill GenTest::ErrorFilter(20761) # 2010-05-27T15:42:46 Test completed successfully. Despite my query count being *very* much lower (at best I'm getting to 4k queries with random seed values) and the server is going away (very silently) The file lib/GenTest/Executor/Drizzle.pm should have code that maps a 'Server is gone' type of error, but I'm not seeing the error codes used by MySQL to detect crashes: >From lib/GenTest/Executor/MySQL.pm: # Server has crashed use constant ER_CONNECTION_ERROR => 2002; use constant ER_CONN_HOST_ERROR => 2003; use constant ER_SERVER_GONE_ERROR => 2006; use constant ER_SERVER_LOST_EXTENDED => 2055; use constant ER_SERVER_LOST => 2013; So, I guess I have two questions: 1) Are there error codes you can point me to that will help us detect a crash? I need a way for the randgen to do this as it makes life much, much easier and faster when we're writing bugs / cooking test cases. 2) Can you recommend any settings for either directly starting the server (drizzled) or with test-run.pl that will provide more informative output? It's kind of irking me that the server is just going away quietly and I want to know why. If anyone wants the outer_join_drizzle grammar, just let me know. I'm still in the process of determining what works and doesn't and haven't pushed anything just yet. Thanks, Patrick
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
