innodb-system-table-view failing when run via dbqp / make test-dbqp

[Patrick Crews]

Failing with the following diff, appears that we need to add some cleanup before the test & re-record it.

20110521-121239 innobase.innodb-system-table-view [ fail ] 56
20110521-121239 --- /Users/hudson/src/workspace/drizzle-build-hades/plugin/innobase/tests/r/innodb-system-table-view.result 2011-05-21 11:31:43.000000000 -0700
20110521-121239 +++ /Users/hudson/src/workspace/drizzle-build-hades/plugin/innobase/tests/r/innodb-system-table-view.reject 2011-05-21 12:12:39.000000000 -0700
20110521-121239 @@ -2,7 +2,7 @@
20110521-121239 TABLE_ID NAME FLAG N_COLS SPACE
20110521-121239 11 SYS_FOREIGN 0 7 0
20110521-121239 12 SYS_FOREIGN_COLS 0 7 0
20110521-121239 -13 SYS_REPLICATION_LOG 0 11 0
20110521-121239 +13 SYS_REPLICATION_LOG 0 9 0
20110521-121239 SELECT * FROM DATA_DICTIONARY.INNODB_SYS_INDEXES;
20110521-121239 INDEX_ID NAME TABLE_ID TYPE N_FIELDS PAGE_NO SPACE
20110521-121239 11 ID_IND 11 3 1 302 0
20110521-121239 @@ -25,10 +25,8 @@
20110521-121239 13 SEGID 1 6 0 4
20110521-121239 13 COMMIT_ID 2 6 0 8
20110521-121239 13 END_TIMESTAMP 3 6 0 8
20110521-121239 -13 ORIGINATING_SERVER_UUID 4 5 4129792 0
20110521-121239 -13 ORIGINATING_COMMIT_ID 5 6 0 8
20110521-121239 -13 MESSAGE_LEN 6 6 0 4
20110521-121239 -13 MESSAGE 7 5 4129792 0
20110521-121239 +13 MESSAGE_LEN 4 6 0 4
20110521-121239 +13 MESSAGE 5 5 4129792 0
20110521-121239 SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FIELDS;
20110521-121239 INDEX_ID NAME POS
20110521-121239 11 ID 0
20110521-121239 @@ -72,7 +70,7 @@
20110521-121239 NAME FLAG N_COLS SPACE
20110521-121239 SYS_FOREIGN 0 7 0
20110521-121239 SYS_FOREIGN_COLS 0 7 0
20110521-121239 -SYS_REPLICATION_LOG 0 11 0
20110521-121239 +SYS_REPLICATION_LOG 0 9 0
20110521-121239 test/child 1 5 0
20110521-121239 test/parent 1 4 0
20110521-121239 SELECT name, n_fields
20110521-121239
20110521-121239 drizzletest: Result content mismatch
20110521-121239
20110521-121239

[Patrick Crews (patrick-crews)]

Was due to an error in dbqp after adding the backwards_compatibility functionality.

To summarize - we weren't properly tracking that we had used an external datadir and that subsequent tests would need a reset server to ensure the expected 'pristine' state.

We were only looking at server options and so thought things were cool when the datadir was far different than expected : /

Added code to track this and properly reset the server in such cases.

[Vijay Samuel (vjsamuel)]

Hi pcrews,
  This is a duplicate of the bug that i already filed yesterday.

Cheers,
 -Vijay

On Wed, May 25, 2011 at 11:27 PM, Patrick Crews
<email address hidden>wrote:

> Was due to an error in dbqp after adding the backwards_compatibility
> functionality.
>
> To summarize - we weren't properly tracking that we had used an external
> datadir and that subsequent tests would need a reset server to ensure
> the expected 'pristine' state.
>
> We were only looking at server options and so thought things were cool
> when the datadir was far different than expected : /
>
> Added code to track this and properly reset the server in such cases.
>
> ** Branch linked: lp:~patrick-crews/drizzle/bug786568
>
> ** Changed in: drizzle/fremont
> Status: In Progress => Fix Committed
>
> --
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
> https://bugs.launchpad.net/bugs/786568
>
> Title:
> innodb-system-table-view failing when run via dbqp / make test-dbqp
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications:
> Fix Committed
> Status in Drizzle fremont series:
> Fix Committed
>
> Bug description:
> Failing with the following diff, appears that we need to add some
> cleanup before the test & re-record it.
>
> 20110521-121239 innobase.innodb-system-table-view [ fail ]
> 56
> 20110521-121239 ---
> /Users/hudson/src/workspace/drizzle-build-hades/plugin/innobase/tests/r/innodb-system-table-view.result
> 2011-05-21 11:31:43.000000000 -0700
> 20110521-121239 +++
> /Users/hudson/src/workspace/drizzle-build-hades/plugin/innobase/tests/r/innodb-system-table-view.reject
> 2011-05-21 12:12:39.000000000 -0700
> 20110521-121239 @@ -2,7 +2,7 @@
> 20110521-121239 TABLE_ID NAME FLAG N_COLS SPACE
> 20110521-121239 11 SYS_FOREIGN 0 7 0
> 20110521-121239 12 SYS_FOREIGN_COLS 0 7 0
> 20110521-121239 -13 SYS_REPLICATION_LOG 0 11 0
> 20110521-121239 +13 SYS_REPLICATION_LOG 0 9 0
> 20110521-121239 SELECT * FROM DATA_DICTIONARY.INNODB_SYS_INDEXES;
> 20110521-121239 INDEX_ID NAME TABLE_ID TYPE N_FIELDS
> PAGE_NO SPACE
> 20110521-121239 11 ID_IND 11 3 1 302 0
> 20110521-121239 @@ -25,10 +25,8 @@
> 20110521-121239 13 SEGID 1 6 0 4
> 20110521-121239 13 COMMIT_ID 2 6 0 8
> 20110521-121239 13 END_TIMESTAMP 3 6 0 8
> 20110521-121239 -13 ORIGINATING_SERVER_UUID 4 5 4129792 0
> 20110521-121239 -13 ORIGINATING_COMMIT_ID 5 6 0 8
> 20110521-121239 -13 MESSAGE_LEN 6 6 0 4
> 20110521-121239 -13 MESSAGE 7 5 4129792 0
> 20110521-121239 +13 MESSAGE_LEN 4 6 0 4
> 20110521-121239 +13 MESSAGE 5 5 4129792 0
> 20110521-121239 SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FIELDS;
> 20110521-121239 INDEX_ID NAME POS
> 20110521-121239 11 ID 0
> 20110521-121239 @@ -72,7 +70,7 @@
> 20110521-121239 NAME FLAG N_COLS...