← Back to team overview

linux-traipu team mailing list archive

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

 

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 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


Follow ups