Random test failure for information_schema.test

[Lee Bieber]

When running make test on orisndriz01 which is used to run lcov data we randomly get the following test failure. Sometimes it passes, sometimes it fails. It always passes when run by manually by itself.

main.information_schema
[ fail ] --- ../tests/r/information_schema.result 2009-09-30 07:24:17.026587708 +0300
+++ ../tests/r/information_schema.reject 2009-09-30 07:32:51.696588177 +0300
@@ -457,6 +457,7 @@
 # # # mysqltest Sleep # # NULL
 # # # test Sleep # # NULL
 # # # test Query # # show processlist
+# # # drizzleslap Sleep # # NULL
 SELECT info, command, db
 FROM information_schema.processlist
 WHERE id = CONNECTION_ID();

[Brian Aker (brianaker)]

Hi!

This is a leftover connection. No harm in it. The only option is possibly to bounce the server.

Cheers,
 -Brian

On Dec 16, 2009, at 10:26 AM, Lee Bieber wrote:

> ** Changed in: drizzle
> Importance: Medium => Critical
>
> --
> Random test failure for information_schema.test
> https://bugs.launchpad.net/bugs/439481
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
>
> Status in A Lightweight SQL Database for Cloud and Web: Confirmed
>
> Bug description:
> When running make test on orisndriz01 which is used to run lcov data we randomly get the following test failure. Sometimes it passes, sometimes it fails. It always passes when run by manually by itself.
>
> main.information_schema
> [ fail ] --- ../tests/r/information_schema.result 2009-09-30 07:24:17.026587708 +0300
> +++ ../tests/r/information_schema.reject 2009-09-30 07:32:51.696588177 +0300
> @@ -457,6 +457,7 @@
> # # # mysqltest Sleep # # NULL
> # # # test Sleep # # NULL
> # # # test Query # # show processlist
> +# # # drizzleslap Sleep # # NULL
> SELECT info, command, db
> FROM information_schema.processlist
> WHERE id = CONNECTION_ID();
>
>