Bug 864975 - test case run's with environment_id's that don't exist
test case run's with environment_id's that don't exist
Status: CLOSED INSUFFICIENT_DATA
Product: TCMS
Classification: Other
Component: Database (Show other bugs)
Devel
Unspecified Unspecified
unspecified Severity low
: ---
: ---
Assigned To: Yang Ren
tools-bugs
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2012-10-10 10:27 EDT by Chris Ward
Modified: 2016-06-13 03:44 EDT (History)
4 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2016-06-13 03:44:15 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Chris Ward 2012-10-10 10:27:10 EDT
Description of problem:

Some test case runs have environment_id's that don't actually exist in test_environments table.

select DISTINCT environment_id from Testopia.test_environments
(4,)
(5,)
(12,)
(13,)
(16,)
(17,)
(18,)
(21,)
(22,)
(23,)
(24,)
(25,)
(26,)
(27,)
(28,)
(29,)
(30,)
(31,)
(32,)
(33,)
(34,)
(35,)
(36,)
(37,)
(38,)
(39,)
(40,)
(41,)
(42,)
(43,)
(44,)
(45,)
(46,)
(47,)
(48,)
(49,)
(50,)
(51,)
(52,)
(57,)
(58,)
(59,)
(60,)
(61,)
(62,)
(63,)
(64,)
(65,)
(66,)
(67,)
(68,)
(69,)
(70,)
(71,)
(72,)
(73,)
(74,)
(75,)
(76,)
(77,)
(78,)
(79,)
(80,)
(81,)
(82,)
(83,)
(84,)
(85,)
(86,)
(87,)
(88,)
(89,)
(90,)
(91,)
(92,)
(93,)
(94,)
(95,)
(96,)
(97,)
(98,)
(99,)
(100,)
(101,)
(102,)
(117,)
(118,)
(120,)
(121,)
(122,)
(123,)
(124,)
(125,)
(126,)
(127,)
(128,)
(129,)
(130,)
(131,)
(132,)
(133,)
(134,)
(135,)
(136,)
(137,)
(138,)
(139,)
(140,)
(141,)
(142,)
(143,)
(147,)
(148,)
(149,)
(153,)
(154,)
(155,)
(156,)
(157,)
(158,)
(159,)
(160,)
(161,)
(162,)
(163,)
(164,)
(165,)
(166,)
(167,)
(168,)
(169,)
(170,)
(171,)
(172,)
(173,)
(174,)
(175,)
(176,)
(177,)
(178,)
(179,)
(180,)
(181,)
(182,)
(183,)
(185,)
(186,)
(187,)
(188,)
(189,)
(190,)
(191,)
(192,)
(193,)
(194,)
(195,)
(196,)
(197,)
(198,)
(199,)
(200,)
(201,)
(203,)
(204,)
(205,)
(206,)
(207,)
(208,)
(209,)
(210,)
(211,)
(212,)
(213,)
(214,)
(215,)
(216,)
(217,)
(218,)
(219,)
(220,)
(221,)
(222,)
(223,)
(224,)

e("select DISTINCT environment_id from Testopia.test_case_runs")
(0,)
(1,)
(4,)
(5,)
(12,)
(13,)
(16,)
(17,)
(18,)
(21,)
(22,)
(23,)
(24,)
(25,)
(29,)
(30,)
(31,)
(32,)
(33,)
(34,)
(35,)
(36,)
(37,)
(38,)
(39,)
(40,)
(41,)
(42,)
(43,)
(44,)
(45,)
(46,)
(47,)
(48,)
(49,)
(50,)
(51,)
(52,)
(57,)
(58,)
(59,)
(60,)
(61,)
(62,)
(63,)
(68,)
(69,)
(70,)
(71,)
(72,)
(73,)
(74,)
(75,)
(76,)
(77,)
(78,)
(81,)
(82,)
(83,)
(84,)
(85,)
(86,)
(87,)
(88,)
(89,)
(90,)
(91,)
(93,)
(94,)
(95,)
(96,)
(97,)
(99,)
(101,)
(117,)
(118,)
(120,)
(121,)
(122,)
(124,)
(125,)
(126,)
(127,)
(128,)
(129,)
(130,)
(131,)
(132,)
(133,)
(134,)
(135,)
(136,)
(137,)
(138,)
(139,)
(140,)
(141,)
(142,)
(143,)
(147,)
(148,)
(149,)
(153,)
(154,)
(157,)
(159,)
(161,)
(162,)
(163,)
(164,)
(165,)
(166,)
(167,)
(168,)
(169,)
(170,)
(171,)
(172,)
(173,)
(174,)
(175,)
(176,)
(179,)
(181,)
(182,)
(185,)
(186,)
(187,)
(188,)
(189,)
(190,)
(191,)
(192,)
(193,)
(194,)
(195,)
(196,)
(197,)
(198,)
(201,)
(203,)
(204,)
(205,)
(206,)
(207,)
(208,)
(209,)
(210,)
(211,)
(212,)
(213,)
(214,)
(215,)
(216,)
(217,)
(218,)
(219,)
(220,)
(223,)


And if you do a diff:

In [33]: case_run_env_ids - env_ids
Out[33]: set([0, 1])

The environment_id's 0 and 1 should either be defined or the test case runs should be updated to point to an valid environment_id or NULL
Comment 2 Chris Ward 2016-06-13 03:44:15 EDT
Stale bug clean up; reopen if anyone else actually supports this.

Note You need to log in before you can comment on or make changes to this bug.