linux-traipu team mailing list archive

Thread
Date
Re: [Bug 786568] Re: innodb-system-table-view failing when run via dbqp / make test-dbqp

To: linux-traipu@xxxxxxxxxxxxxxxxxxx
From: Vijay Samuel <786568@xxxxxxxxxxxxxxxxxx>
Date: Wed, 25 May 2011 18:12:04 -0000
Reply-to: Bug 786568 <786568@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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
<786568@xxxxxxxxxxxxxxxxxx>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  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
>

-- 
You received this bug notification because you are a member of UBUNTU -
BR - LINUX TRAIPU, 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	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
References

[Bug 786568] Re: innodb-system-table-view failing when run via dbqp / make test-dbqp
From: Patrick Crews, 2011-05-25