See http://ci.opensuse.org/job/obs_master_testsuite_api/1728/changes Changes: [mls] [backend] support keys without content in /lastnotifications [adrian] [dist] add backend dependencies to obs-api-deps package [mls] enforce a time in notify events, add back 'block' mode for /lastnotifications [adrian] [api] do right locking when changing request or review states [mls] [backend] lastnotifications: improve 'next' logic [adrian] [dist] sync obs-api-dep spec file, used from now on from git ------------------------------------------ [...truncated 48259 lines...] [e25c03cc-bc03-47ed-8cf0-d9e419cfb218] [5399.80] [1m[36m (0.2ms)[0m [1mSELECT `issues`.`id` FROM `issues` LEFT JOIN issue_trackers ON issues.issue_tracker_id = issue_trackers.id WHERE ((issue_trackers.name = 'bnc' AND issues.name = '123456'))[0m [e25c03cc-bc03-47ed-8cf0-d9e419cfb218] [5399.80] [1m[35mSQL (0.2ms)[0m SELECT `issues`.`id` AS t0_r0, `issues`.`name` AS t0_r1, `issues`.`issue_tracker_id` AS t0_r2, `issues`.`summary` AS t0_r3, `issues`.`owner_id` AS t0_r4, `issues`.`created_at` AS t0_r5, `issues`.`updated_at` AS t0_r6, `issues`.`state` AS t0_r7, `issue_trackers`.`id` AS t1_r0, `issue_trackers`.`name` AS t1_r1, `issue_trackers`.`kind` AS t1_r2, `issue_trackers`.`description` AS t1_r3, `issue_trackers`.`url` AS t1_r4, `issue_trackers`.`show_url` AS t1_r5, `issue_trackers`.`regex` AS t1_r6, `issue_trackers`.`user` AS t1_r7, `issue_trackers`.`password` AS t1_r8, `issue_trackers`.`label` AS t1_r9, `issue_trackers`.`issues_updated` AS t1_r10, `issue_trackers`.`enable_fetch` AS t1_r11 FROM `issues` LEFT OUTER JOIN `issue_trackers` ON `issue_trackers`.`id` = `issues`.`issue_tracker_id` WHERE `issues`.`id` IN (1) [e25c03cc-bc03-47ed-8cf0-d9e419cfb218] [5399.80] no schema found, skipping validation for {"match"=>"[@tracker=\"bnc\" and @name=\"123456\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"response"} [e25c03cc-bc03-47ed-8cf0-d9e419cfb218] [5399.80] Validate XML response: #ActionDispatch::Response:0x00000006991168 took 0ms [e25c03cc-bc03-47ed-8cf0-d9e419cfb218] [5399.80] Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 0.7ms | Backend: 0.0ms | XML: 0.1ms) [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.80] Started GET "/search/issue?match=%5B%40name%3D%220123456%22+and+%40tracker%3D%22bnc%22%5D" for 127.0.0.1 at 2013-09-02 15:32:03 +0000 [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.80] Processing by SearchController#issue as XML [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.80] Parameters: {"match"=>"[@name=\"0123456\" and @tracker=\"bnc\"]"} [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.80] Validate XML request: #ActionDispatch::Request:0x00000006ad1cd0 [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.80] no schema found, skipping validation for {"match"=>"[@name=\"0123456\" and @tracker=\"bnc\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"request"} [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1[0m [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] USER found: Iggy [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] User Iggy initialised [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] searching in issues, predicate: '@name="0123456" and @tracker="bnc"' [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] SELECT `issues`.* FROM `issues`.find {:joins=>"LEFT JOIN issue_trackers ON issues.issue_tracker_id = issue_trackers.id", :conditions=>["(issues.name = ? AND issue_trackers.name = ?)", "0123456", "bnc"]} [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] [1m[35m (0.2ms)[0m SELECT `issues`.`id` FROM `issues` LEFT JOIN issue_trackers ON issues.issue_tracker_id = issue_trackers.id WHERE ((issues.name = '0123456' AND issue_trackers.name = 'bnc')) [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] no schema found, skipping validation for {"match"=>"[@name=\"0123456\" and @tracker=\"bnc\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"response"} [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] Validate XML response: #ActionDispatch::Response:0x00000006ad1c30 took 0ms [40abdd18-ebe9-4ca5-b220-9a5e617bd39b] [5399.81] Completed 200 OK in 3ms (Views: 0.2ms | ActiveRecord: 0.4ms | Backend: 0.0ms | XML: 0.1ms) [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] Started GET "/search/issue?match=%5B%40tracker%3D%22bnc%22+and+%28%40name%3D%22123456%22+or+%40name%3D%221234%22%29%5D" for 127.0.0.1 at 2013-09-02 15:32:03 +0000 [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] Processing by SearchController#issue as XML [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] Parameters: {"match"=>"[@tracker=\"bnc\" and (@name=\"123456\" or @name=\"1234\")]"} [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] Validate XML request: #ActionDispatch::Request:0x00000006bc3b98 [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] no schema found, skipping validation for {"match"=>"[@tracker=\"bnc\" and (@name=\"123456\" or @name=\"1234\")]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"request"} [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1[0m [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] USER found: Iggy [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] User Iggy initialised [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] searching in issues, predicate: '@tracker="bnc" and (@name="123456" or @name="1234")' [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] SELECT `issues`.* FROM `issues`.find {:joins=>"LEFT JOIN issue_trackers ON issues.issue_tracker_id = issue_trackers.id", :conditions=>["(issue_trackers.name = ? AND (issues.name = ? OR issues.name = ?))", "bnc", "123456", "1234"]} [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] [1m[35m (0.2ms)[0m SELECT `issues`.`id` FROM `issues` LEFT JOIN issue_trackers ON issues.issue_tracker_id = issue_trackers.id WHERE ((issue_trackers.name = 'bnc' AND (issues.name = '123456' OR issues.name = '1234'))) [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.81] [1m[36mSQL (0.3ms)[0m [1mSELECT `issues`.`id` AS t0_r0, `issues`.`name` AS t0_r1, `issues`.`issue_tracker_id` AS t0_r2, `issues`.`summary` AS t0_r3, `issues`.`owner_id` AS t0_r4, `issues`.`created_at` AS t0_r5, `issues`.`updated_at` AS t0_r6, `issues`.`state` AS t0_r7, `issue_trackers`.`id` AS t1_r0, `issue_trackers`.`name` AS t1_r1, `issue_trackers`.`kind` AS t1_r2, `issue_trackers`.`description` AS t1_r3, `issue_trackers`.`url` AS t1_r4, `issue_trackers`.`show_url` AS t1_r5, `issue_trackers`.`regex` AS t1_r6, `issue_trackers`.`user` AS t1_r7, `issue_trackers`.`password` AS t1_r8, `issue_trackers`.`label` AS t1_r9, `issue_trackers`.`issues_updated` AS t1_r10, `issue_trackers`.`enable_fetch` AS t1_r11 FROM `issues` LEFT OUTER JOIN `issue_trackers` ON `issue_trackers`.`id` = `issues`.`issue_tracker_id` WHERE `issues`.`id` IN (2, 1)[0m [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.82] no schema found, skipping validation for {"match"=>"[@tracker=\"bnc\" and (@name=\"123456\" or @name=\"1234\")]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"response"} [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.82] Validate XML response: #ActionDispatch::Response:0x00000006bc3b70 took 0ms [a424c6e6-5d7b-4aef-983f-d2fbcaa35447] [5399.82] Completed 200 OK in 6ms (Views: 0.2ms | ActiveRecord: 0.7ms | Backend: 0.0ms | XML: 0.1ms) [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] Started GET "/search/issue?match=%5B%40tracker%3D%22bnc%22+and+%28%40name%3D%22123456%22+or+%40name%3D%221234%22%29+and+%40state%3D%22CLOSED%22%5D" for 127.0.0.1 at 2013-09-02 15:32:03 +0000 [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] Processing by SearchController#issue as XML [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] Parameters: {"match"=>"[@tracker=\"bnc\" and (@name=\"123456\" or @name=\"1234\") and @state=\"CLOSED\"]"} [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] Validate XML request: #ActionDispatch::Request:0x00000006d35b20 [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] no schema found, skipping validation for {"match"=>"[@tracker=\"bnc\" and (@name=\"123456\" or @name=\"1234\") and @state=\"CLOSED\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"request"} [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1 [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] USER found: Iggy [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] User Iggy initialised [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] searching in issues, predicate: '@tracker="bnc" and (@name="123456" or @name="1234") and @state="CLOSED"' [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] SELECT `issues`.* FROM `issues`.find {:joins=>"LEFT JOIN issue_trackers ON issues.issue_tracker_id = issue_trackers.id", :conditions=>["((issue_trackers.name = ? AND (issues.name = ? OR issues.name = ?)) AND issues.state = ?)", "bnc", "123456", "1234", "CLOSED"]} [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] [1m[36m (0.2ms)[0m [1mSELECT `issues`.`id` FROM `issues` LEFT JOIN issue_trackers ON issues.issue_tracker_id = issue_trackers.id WHERE (((issue_trackers.name = 'bnc' AND (issues.name = '123456' OR issues.name = '1234')) AND issues.state = 'CLOSED'))[0m [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] [1m[35mSQL (0.2ms)[0m SELECT `issues`.`id` AS t0_r0, `issues`.`name` AS t0_r1, `issues`.`issue_tracker_id` AS t0_r2, `issues`.`summary` AS t0_r3, `issues`.`owner_id` AS t0_r4, `issues`.`created_at` AS t0_r5, `issues`.`updated_at` AS t0_r6, `issues`.`state` AS t0_r7, `issue_trackers`.`id` AS t1_r0, `issue_trackers`.`name` AS t1_r1, `issue_trackers`.`kind` AS t1_r2, `issue_trackers`.`description` AS t1_r3, `issue_trackers`.`url` AS t1_r4, `issue_trackers`.`show_url` AS t1_r5, `issue_trackers`.`regex` AS t1_r6, `issue_trackers`.`user` AS t1_r7, `issue_trackers`.`password` AS t1_r8, `issue_trackers`.`label` AS t1_r9, `issue_trackers`.`issues_updated` AS t1_r10, `issue_trackers`.`enable_fetch` AS t1_r11 FROM `issues` LEFT OUTER JOIN `issue_trackers` ON `issue_trackers`.`id` = `issues`.`issue_tracker_id` WHERE `issues`.`id` IN (1) [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] no schema found, skipping validation for {"match"=>"[@tracker=\"bnc\" and (@name=\"123456\" or @name=\"1234\") and @state=\"CLOSED\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"response"} [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] Validate XML response: #ActionDispatch::Response:0x00000006d35ad0 took 0ms [b6797be2-1a00-424c-8ee9-6f27a80533b8] [5399.82] Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 0.7ms | Backend: 0.0ms | XML: 0.1ms) [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] Started GET "/search/issue?match=%5Bowner%2F%40login%3D%22fred%22%5D" for 127.0.0.1 at 2013-09-02 15:32:03 +0000 [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] Processing by SearchController#issue as XML [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] Parameters: {"match"=>"[owner/@login=\"fred\"]"} [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] Validate XML request: #ActionDispatch::Request:0x00000006d94468 [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] no schema found, skipping validation for {"match"=>"[owner/@login=\"fred\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"request"} [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] [1m[36mUser Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1[0m [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] USER found: Iggy [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] User Iggy initialised [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] searching in issues, predicate: 'owner/@login="fred"' [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] SELECT `issues`.* FROM `issues`.find {:joins=>"LEFT JOIN users ON users.id = issues.owner_id", :conditions=>["users.login = ?", "fred"]} [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] [1m[35m (0.2ms)[0m SELECT `issues`.`id` FROM `issues` LEFT JOIN users ON users.id = issues.owner_id WHERE (users.login = 'fred') [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] [1m[36mSQL (0.2ms)[0m [1mSELECT `issues`.`id` AS t0_r0, `issues`.`name` AS t0_r1, `issues`.`issue_tracker_id` AS t0_r2, `issues`.`summary` AS t0_r3, `issues`.`owner_id` AS t0_r4, `issues`.`created_at` AS t0_r5, `issues`.`updated_at` AS t0_r6, `issues`.`state` AS t0_r7, `issue_trackers`.`id` AS t1_r0, `issue_trackers`.`name` AS t1_r1, `issue_trackers`.`kind` AS t1_r2, `issue_trackers`.`description` AS t1_r3, `issue_trackers`.`url` AS t1_r4, `issue_trackers`.`show_url` AS t1_r5, `issue_trackers`.`regex` AS t1_r6, `issue_trackers`.`user` AS t1_r7, `issue_trackers`.`password` AS t1_r8, `issue_trackers`.`label` AS t1_r9, `issue_trackers`.`issues_updated` AS t1_r10, `issue_trackers`.`enable_fetch` AS t1_r11 FROM `issues` LEFT OUTER JOIN `issue_trackers` ON `issue_trackers`.`id` = `issues`.`issue_tracker_id` WHERE `issues`.`id` IN (1)[0m [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] no schema found, skipping validation for {"match"=>"[owner/@login=\"fred\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"response"} [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] Validate XML response: #ActionDispatch::Response:0x00000006d94418 took 0ms [a4fc1558-9f5f-48ab-9764-d9e0fcb13394] [5399.83] Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 0.6ms | Backend: 0.0ms | XML: 0.1ms) [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] Started GET "/search/issue?match=%5Bowner%2F%40email%3D%22fred%40feuerstein.de%22%5D" for 127.0.0.1 at 2013-09-02 15:32:03 +0000 [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] Processing by SearchController#issue as XML [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] Parameters: {"match"=>"[owner/@email=\"fred@feuerstein.de\"]"} [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] Validate XML request: #ActionDispatch::Request:0x000000076c7fa8 [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] no schema found, skipping validation for {"match"=>"[owner/@email=\"fred@feuerstein.de\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"request"} [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] [1m[35mUser Load (0.2ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1 [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] USER found: Iggy [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] User Iggy initialised [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] searching in issues, predicate: 'owner/@email="fred@feuerstein.de"' [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.83] SELECT `issues`.* FROM `issues`.find {:joins=>"LEFT JOIN users ON users.id = issues.owner_id", :conditions=>["users.email = ?", "fred@feuerstein.de"]} [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.84] [1m[36m (0.2ms)[0m [1mSELECT `issues`.`id` FROM `issues` LEFT JOIN users ON users.id = issues.owner_id WHERE (users.email = 'fred@feuerstein.de')[0m [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.84] [1m[35mSQL (0.2ms)[0m SELECT `issues`.`id` AS t0_r0, `issues`.`name` AS t0_r1, `issues`.`issue_tracker_id` AS t0_r2, `issues`.`summary` AS t0_r3, `issues`.`owner_id` AS t0_r4, `issues`.`created_at` AS t0_r5, `issues`.`updated_at` AS t0_r6, `issues`.`state` AS t0_r7, `issue_trackers`.`id` AS t1_r0, `issue_trackers`.`name` AS t1_r1, `issue_trackers`.`kind` AS t1_r2, `issue_trackers`.`description` AS t1_r3, `issue_trackers`.`url` AS t1_r4, `issue_trackers`.`show_url` AS t1_r5, `issue_trackers`.`regex` AS t1_r6, `issue_trackers`.`user` AS t1_r7, `issue_trackers`.`password` AS t1_r8, `issue_trackers`.`label` AS t1_r9, `issue_trackers`.`issues_updated` AS t1_r10, `issue_trackers`.`enable_fetch` AS t1_r11 FROM `issues` LEFT OUTER JOIN `issue_trackers` ON `issue_trackers`.`id` = `issues`.`issue_tracker_id` WHERE `issues`.`id` IN (1) [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.84] no schema found, skipping validation for {"match"=>"[owner/@email=\"fred@feuerstein.de\"]", "format"=>"xml", "controller"=>"search", "action"=>"issue", "method"=>"GET", "type"=>"response"} [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.84] Validate XML response: #ActionDispatch::Response:0x000000076c7f80 took 0ms [578dabe0-d4be-4e7b-928c-bbb5bf8bfdb8] [5399.84] Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 0.6ms | Backend: 0.0ms | XML: 0.2ms) [5399.84] [1m[36m (0.1ms)[0m [1mROLLBACK[0m [5399.84] [1m[35m (0.0ms)[0m BEGIN [5399.84] -------------------------------------------------------- [5399.84] SearchControllerTest: test_search_one_maintained_package [5399.84] -------------------------------------------------------- [5399.84] Wait for scheduler thread to finish start [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.86] Started GET "/search/attribute?namespace=OBS&name=Maintained" for 127.0.0.1 at 2013-09-02 15:32:54 +0000 [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.86] Processing by SearchController#attribute as XML [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.86] Parameters: {"namespace"=>"OBS", "name"=>"Maintained"} [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.86] Validate XML request: #ActionDispatch::Request:0x000000077993a0 [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.86] no schema found, skipping validation for {"namespace"=>"OBS", "name"=>"Maintained", "format"=>"xml", "controller"=>"search", "action"=>"attribute", "method"=>"GET", "type"=>"request"} [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.87] [1m[36m (0.4ms)[0m [1mSELECT `configurations`.`anonymous` FROM `configurations` LIMIT 1[0m [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.87] no authentication string was sent [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.87] Filter chain halted as :extract_user rendered or redirected [b1cd0978-592d-461c-b965-bce264e1de2e] [5449.87] Completed 401 Unauthorized in 3ms (Views: 0.9ms | ActiveRecord: 0.4ms | Backend: 0.0ms | XML: 0.1ms) [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] Started GET "/search/attribute?namespace=OBS&name=Maintained" for 127.0.0.1 at 2013-09-02 15:32:54 +0000 [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] Processing by SearchController#attribute as XML [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] Parameters: {"namespace"=>"OBS", "name"=>"Maintained"} [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] Validate XML request: #ActionDispatch::Request:0x000000077ba370 [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] no schema found, skipping validation for {"namespace"=>"OBS", "name"=>"Maintained", "format"=>"xml", "controller"=>"search", "action"=>"attribute", "method"=>"GET", "type"=>"request"} [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] [1m[35mUser Load (0.5ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1 [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] USER found: Iggy [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] User Iggy initialised [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.87] [1m[36mAttribType Load (0.5ms)[0m [1mSELECT `attrib_types`.* FROM `attrib_types` INNER JOIN `attrib_namespaces` ON `attrib_namespaces`.`id` = `attrib_types`.`attrib_namespace_id` WHERE (attrib_namespaces.name = 'OBS' and attrib_types.name = 'Maintained') ORDER BY `attrib_types`.`id` ASC LIMIT 1[0m [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.88] [1m[35m (0.3ms)[0m SELECT `attribs`.`id`, `attribs`.`db_package_id` FROM `attribs` WHERE `attribs`.`attrib_type_id` = 58 [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.88] [1m[36mAttribValue Load (0.2ms)[0m [1mSELECT `attrib_values`.* FROM `attrib_values` WHERE (attrib_id IN (101))[0m [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.88] [1m[35mRelationship Load (0.3ms)[0m SELECT ur.project_id, ur.user_id from flags f, relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.88] [1m[36mRole Exists (0.4ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 267 AND `roles`.`title` = 'Admin' LIMIT 1[0m [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.88] [1m[35m (0.3ms)[0m SELECT `packages`.`id`, `packages`.`name`, `packages`.`db_project_id` FROM `packages` WHERE (packages.db_project_id not in (0,3000,3006)) AND (packages.id IN (1355)) [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.88] [1m[36m (0.3ms)[0m [1mSELECT `projects`.`id`, `projects`.`name` FROM `projects` WHERE `projects`.`id` IN (226) AND (projects.id not in (0,3000,3006))[0m [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.89] no schema found, skipping validation for {"namespace"=>"OBS", "name"=>"Maintained", "format"=>"xml", "controller"=>"search", "action"=>"attribute", "method"=>"GET", "type"=>"response"} [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.89] Validate XML response: #ActionDispatch::Response:0x000000077ba348 took 0ms [506a8617-8e74-4ba1-bab0-b51607aa733c] [5449.89] Completed 200 OK in 17ms (Views: 0.5ms | ActiveRecord: 2.9ms | Backend: 0.0ms | XML: 0.0ms) [5449.89] [1m[35m (0.2ms)[0m ROLLBACK [5449.89] [1m[36m (0.1ms)[0m [1mBEGIN[0m [5449.89] ----------------------------------------------------------------------------- [5449.89] SearchControllerTest: test_search_package_in_hidden_project_as_non_maintainer [5449.89] ----------------------------------------------------------------------------- [5449.89] Wait for scheduler thread to finish start [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.91] Started GET "/search/package?match=%5B%40name%3D%22pack%22+and+%40project%3D%22HiddenProject%22%5D" for 127.0.0.1 at 2013-09-02 15:33:44 +0000 [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.91] Processing by SearchController#package as XML [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.91] Parameters: {"match"=>"[@name=\"pack\" and @project=\"HiddenProject\"]"} [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.91] Validate XML request: #ActionDispatch::Request:0x0000000780c058 [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.91] no schema found, skipping validation for {"match"=>"[@name=\"pack\" and @project=\"HiddenProject\"]", "format"=>"xml", "controller"=>"search", "action"=>"package", "method"=>"GET", "type"=>"request"} [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] [1m[35mUser Load (0.8ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1 [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] USER found: Iggy [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] User Iggy initialised [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] searching in packages, predicate: '@name="pack" and @project="HiddenProject"' [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] [1m[36mRelationship Load (0.7ms)[0m [1mSELECT ur.project_id, ur.user_id from flags f, relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id[0m [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] [1m[35mRole Exists (0.3ms)[0m SELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 267 AND `roles`.`title` = 'Admin' LIMIT 1 [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0,3000,3006)).find {:joins=>"LEFT JOIN projects ON packages.db_project_id=projects.id", :conditions=>["(packages.name = ? AND projects.name = ?)", "pack", "HiddenProject"]} [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] [1m[36m (0.3ms)[0m [1mSELECT `packages`.`id` FROM `packages` LEFT JOIN projects ON packages.db_project_id=projects.id WHERE (packages.db_project_id not in (0,3000,3006)) AND ((packages.name = 'pack' AND projects.name = 'HiddenProject'))[0m [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] no schema found, skipping validation for {"match"=>"[@name=\"pack\" and @project=\"HiddenProject\"]", "format"=>"xml", "controller"=>"search", "action"=>"package", "method"=>"GET", "type"=>"response"} [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] Validate XML response: #ActionDispatch::Response:0x0000000780c030 took 0ms [37b31e2f-e412-41a0-bcc1-baa231bc2c7d] [5499.92] Completed 200 OK in 11ms (Views: 0.4ms | ActiveRecord: 2.1ms | Backend: 0.0ms | XML: 0.4ms) [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] Started GET "/search/package?match=%5B%40name%3D%22pack%22%5D" for 127.0.0.1 at 2013-09-02 15:33:44 +0000 [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] Processing by SearchController#package as XML [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] Parameters: {"match"=>"[@name=\"pack\"]"} [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] Validate XML request: #ActionDispatch::Request:0x00000007842270 [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] no schema found, skipping validation for {"match"=>"[@name=\"pack\"]", "format"=>"xml", "controller"=>"search", "action"=>"package", "method"=>"GET", "type"=>"request"} [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1 [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] USER found: Iggy [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] User Iggy initialised [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] searching in packages, predicate: '@name="pack"' [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] [1m[36mRole Exists (0.4ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 267 AND `roles`.`title` = 'Admin' LIMIT 1[0m [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0,3000,3006)).find {:joins=>"", :conditions=>["packages.name = ?", "pack"]} [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] [1m[35m (0.3ms)[0m SELECT `packages`.`id` FROM `packages` WHERE (packages.db_project_id not in (0,3000,3006)) AND (packages.name = 'pack') [749b8456-08b4-472b-b9f9-598597b566b5] [5499.93] [1m[36mSQL (0.3ms)[0m [1mSELECT `packages`.`id` AS t0_r0, `packages`.`db_project_id` AS t0_r1, `packages`.`name` AS t0_r2, `packages`.`title` AS t0_r3, `packages`.`description` AS t0_r4, `packages`.`created_at` AS t0_r5, `packages`.`updated_at` AS t0_r6, `packages`.`url` AS t0_r7, `packages`.`update_counter` AS t0_r8, `packages`.`activity_index` AS t0_r9, `packages`.`bcntsynctag` AS t0_r10, `packages`.`develpackage_id` AS t0_r11, `packages`.`delta` AS t0_r12, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`title` AS t1_r2, `projects`.`description` AS t1_r3, `projects`.`created_at` AS t1_r4, `projects`.`updated_at` AS t1_r5, `projects`.`remoteurl` AS t1_r6, `projects`.`remoteproject` AS t1_r7, `projects`.`type_id` AS t1_r8, `projects`.`maintenance_project_id` AS t1_r9, `projects`.`develproject_id` AS t1_r10, `projects`.`delta` AS t1_r11 FROM `packages` LEFT OUTER JOIN `projects` ON `projects`.`id` = `packages`.`db_project_id` WHERE `packages`.`id` IN (11008) AND (packages.db_project_id not in (0,3000,3006))[0m [749b8456-08b4-472b-b9f9-598597b566b5] [5499.94] [1m[35m (0.6ms)[0m SELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 11008 ORDER BY role_name, login [749b8456-08b4-472b-b9f9-598597b566b5] [5499.94] [1m[36m (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 11008 ORDER BY role_name, title[0m [749b8456-08b4-472b-b9f9-598597b566b5] [5499.94] [1m[35mFlag Load (0.3ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 11008 ORDER BY `flags`.position ASC [749b8456-08b4-472b-b9f9-598597b566b5] [5499.94] Rendered models/_package.xml.builder (6.0ms) [749b8456-08b4-472b-b9f9-598597b566b5] [5499.94] no schema found, skipping validation for {"match"=>"[@name=\"pack\"]", "format"=>"xml", "controller"=>"search", "action"=>"package", "method"=>"GET", "type"=>"response"} [749b8456-08b4-472b-b9f9-598597b566b5] [5499.94] Validate XML response: #ActionDispatch::Response:0x00000007842248 took 0ms [749b8456-08b4-472b-b9f9-598597b566b5] [5499.94] Completed 200 OK in 17ms (Views: 0.4ms | ActiveRecord: 2.5ms | Backend: 0.0ms | XML: 0.1ms) [5499.95] [1m[36m (0.1ms)[0m [1mROLLBACK[0m [5499.95] [1m[35m (0.1ms)[0m BEGIN [5499.95] --------------------------------------------------------------------------- [5499.95] SearchControllerTest: test_search_package_in_hidden_project_with_valid_user [5499.95] --------------------------------------------------------------------------- [5499.95] Wait for scheduler thread to finish start [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] Started GET "/search/package?match=%5B%40name%3D%22pack%22+and+%40project%3D%22HiddenProject%22%5D" for 127.0.0.1 at 2013-09-02 15:34:34 +0000 [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] Processing by SearchController#package as XML [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] Parameters: {"match"=>"[@name=\"pack\" and @project=\"HiddenProject\"]"} [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] Validate XML request: #ActionDispatch::Request:0x000000078a2b48 [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] no schema found, skipping validation for {"match"=>"[@name=\"pack\" and @project=\"HiddenProject\"]", "format"=>"xml", "controller"=>"search", "action"=>"package", "method"=>"GET", "type"=>"request"} [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] [1m[36mUser Load (0.4ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'adrian' ORDER BY `users`.`id` ASC LIMIT 1[0m [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] USER found: adrian [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] User adrian initialised [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] searching in packages, predicate: '@name="pack" and @project="HiddenProject"' [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] [1m[35mRelationship Load (0.4ms)[0m SELECT ur.project_id, ur.user_id from flags f, relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.97] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 42 AND `roles`.`title` = 'Admin' LIMIT 1[0m [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.98] SELECT `packages`.* FROM `packages` WHERE (packages.db_project_id not in (0,3006)).find {:joins=>"LEFT JOIN projects ON packages.db_project_id=projects.id", :conditions=>["(packages.name = ? AND projects.name = ?)", "pack", "HiddenProject"]} [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.98] [1m[35m (0.3ms)[0m SELECT `packages`.`id` FROM `packages` LEFT JOIN projects ON packages.db_project_id=projects.id WHERE (packages.db_project_id not in (0,3006)) AND ((packages.name = 'pack' AND projects.name = 'HiddenProject')) [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.98] [1m[36mSQL (0.3ms)[0m [1mSELECT `packages`.`id` AS t0_r0, `packages`.`db_project_id` AS t0_r1, `packages`.`name` AS t0_r2, `packages`.`title` AS t0_r3, `packages`.`description` AS t0_r4, `packages`.`created_at` AS t0_r5, `packages`.`updated_at` AS t0_r6, `packages`.`url` AS t0_r7, `packages`.`update_counter` AS t0_r8, `packages`.`activity_index` AS t0_r9, `packages`.`bcntsynctag` AS t0_r10, `packages`.`develpackage_id` AS t0_r11, `packages`.`delta` AS t0_r12, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`title` AS t1_r2, `projects`.`description` AS t1_r3, `projects`.`created_at` AS t1_r4, `projects`.`updated_at` AS t1_r5, `projects`.`remoteurl` AS t1_r6, `projects`.`remoteproject` AS t1_r7, `projects`.`type_id` AS t1_r8, `projects`.`maintenance_project_id` AS t1_r9, `projects`.`develproject_id` AS t1_r10, `projects`.`delta` AS t1_r11 FROM `packages` LEFT OUTER JOIN `projects` ON `projects`.`id` = `packages`.`db_project_id` WHERE `packages`.`id` IN (11000) AND (packages.db_project_id not in (0,3006))[0m [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.98] [1m[35m (0.6ms)[0m SELECT users.login as login, roles.title AS role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `users` ON `users`.`id` = `relationships`.`user_id` WHERE `relationships`.`package_id` = 11000 ORDER BY role_name, login [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.99] [1m[36m (0.3ms)[0m [1mSELECT groups.title as title, roles.title as role_name FROM `relationships` INNER JOIN `roles` ON `roles`.`id` = `relationships`.`role_id` INNER JOIN `groups` ON `groups`.`id` = `relationships`.`group_id` WHERE `relationships`.`package_id` = 11000 ORDER BY role_name, title[0m [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.99] [1m[35mFlag Load (0.2ms)[0m SELECT `flags`.* FROM `flags` WHERE `flags`.`db_package_id` = 11000 ORDER BY `flags`.position ASC [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.99] Rendered models/_package.xml.builder (5.7ms) [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.99] no schema found, skipping validation for {"match"=>"[@name=\"pack\" and @project=\"HiddenProject\"]", "format"=>"xml", "controller"=>"search", "action"=>"package", "method"=>"GET", "type"=>"response"} [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.99] Validate XML response: #ActionDispatch::Response:0x000000078a2b20 took 0ms [5d50591c-3cc5-439e-921d-970fc9e672ed] [5549.99] Completed 200 OK in 19ms (Views: 0.4ms | ActiveRecord: 2.8ms | Backend: 0.0ms | XML: 0.3ms) [5549.99] [1m[36m (0.1ms)[0m [1mROLLBACK[0m [5549.99] [1m[35m (0.1ms)[0m BEGIN [5549.99] ----------------------------------------------- [5549.99] SearchControllerTest: test_search_repository_id [5549.99] ----------------------------------------------- [5549.99] Wait for scheduler thread to finish start [a642237a-e33d-4a64-9296-bc28dc989568] [5600.01] Started GET "/search/repository/id" for 127.0.0.1 at 2013-09-02 15:35:24 +0000 [a642237a-e33d-4a64-9296-bc28dc989568] [5600.01] Processing by SearchController#repository_id as XML [a642237a-e33d-4a64-9296-bc28dc989568] [5600.01] Validate XML request: #ActionDispatch::Request:0x000000078f6220 [a642237a-e33d-4a64-9296-bc28dc989568] [5600.01] no schema found, skipping validation for {"format"=>"xml", "controller"=>"search", "action"=>"repository_id", "method"=>"GET", "type"=>"request"} [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] [1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`login` = 'Iggy' ORDER BY `users`.`id` ASC LIMIT 1[0m [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] USER found: Iggy [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] User Iggy initialised [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] searching in repositorys, predicate: '*' [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] [1m[35mRelationship Load (0.3ms)[0m SELECT ur.project_id, ur.user_id from flags f, relationships ur where f.flag = 'access' and f.status = 'disable' and ur.project_id = f.db_project_id [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 267 AND `roles`.`title` = 'Admin' LIMIT 1[0m [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] SELECT `repositories`.* FROM `repositories` WHERE (db_project_id not in (0,3000,3006)).find {:joins=>"", :conditions=>[""]} [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] [1m[35m (0.3ms)[0m SELECT `repositories`.`id` FROM `repositories` WHERE (db_project_id not in (0,3000,3006)) [a642237a-e33d-4a64-9296-bc28dc989568] [5600.02] [1m[36mSQL (0.5ms)[0m [1mSELECT `repositories`.`id` AS t0_r0, `repositories`.`db_project_id` AS t0_r1, `repositories`.`name` AS t0_r2, `repositories`.`remote_project_name` AS t0_r3, `repositories`.`rebuild` AS t0_r4, `repositories`.`block` AS t0_r5, `repositories`.`linkedbuild` AS t0_r6, `repositories`.`hostsystem_id` AS t0_r7, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`title` AS t1_r2, `projects`.`description` AS t1_r3, `projects`.`created_at` AS t1_r4, `projects`.`updated_at` AS t1_r5, `projects`.`remoteurl` AS t1_r6, `projects`.`remoteproject` AS t1_r7, `projects`.`type_id` AS t1_r8, `projects`.`maintenance_project_id` AS t1_r9, `projects`.`develproject_id` AS t1_r10, `projects`.`delta` AS t1_r11 FROM `repositories` LEFT OUTER JOIN `projects` ON `projects`.`id` = `repositories`.`db_project_id` WHERE `repositories`.`id` IN (75, 81, 85, 82, 83, 211, 142, 144, 141, 91, 95, 92, 86, 93, 96, 90, 94, 87, 88)[0m [a642237a-e33d-4a64-9296-bc28dc989568] [5600.03] no schema found, skipping validation for {"format"=>"xml", "controller"=>"search", "action"=>"repository_id", "method"=>"GET", "type"=>"response"} [a642237a-e33d-4a64-9296-bc28dc989568] [5600.03] Validate XML response: #ActionDispatch::Response:0x000000078f61f8 took 0ms [a642237a-e33d-4a64-9296-bc28dc989568] [5600.03] Completed 200 OK in 17ms (Views: 0.4ms | ActiveRecord: 1.9ms | Backend: 0.0ms | XML: 0.2ms) [9047e082-1020-4821-8759-451e35f1665d] [5600.03] Started GET "/search/repository/id" for 127.0.0.1 at 2013-09-02 15:35:24 +0000 [9047e082-1020-4821-8759-451e35f1665d] [5600.03] Processing by SearchController#repository_id as XML [9047e082-1020-4821-8759-451e35f1665d] [5600.03] Validate XML request: #ActionDispatch::Request:0x0000000795dee8 [9047e082-1020-4821-8759-451e35f1665d] [5600.03] no schema found, skipping validation for {"format"=>"xml", "controller"=>"search", "action"=>"repository_id", "method"=>"GET", "type"=>"request"} [9047e082-1020-4821-8759-451e35f1665d] [5600.04] [1m[35mUser Load (0.3ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`login` = 'king' ORDER BY `users`.`id` ASC LIMIT 1 [9047e082-1020-4821-8759-451e35f1665d] [5600.04] USER found: king [9047e082-1020-4821-8759-451e35f1665d] [5600.04] User king initialised [9047e082-1020-4821-8759-451e35f1665d] [5600.04] searching in repositorys, predicate: '*' [9047e082-1020-4821-8759-451e35f1665d] [5600.04] [1m[36mRole Exists (0.3ms)[0m [1mSELECT DISTINCT 1 AS one FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 2 AND `roles`.`title` = 'Admin' LIMIT 1[0m [9047e082-1020-4821-8759-451e35f1665d] [5600.04] SELECT `repositories`.* FROM `repositories` WHERE (db_project_id not in (0)).find {:joins=>"", :conditions=>[""]} [9047e082-1020-4821-8759-451e35f1665d] [5600.04] [1m[35m (0.3ms)[0m SELECT `repositories`.`id` FROM `repositories` WHERE (db_project_id not in (0)) [9047e082-1020-4821-8759-451e35f1665d] [5600.04] [1m[36mSQL (0.4ms)[0m [1mSELECT `repositories`.`id` AS t0_r0, `repositories`.`db_project_id` AS t0_r1, `repositories`.`name` AS t0_r2, `repositories`.`remote_project_name` AS t0_r3, `repositories`.`rebuild` AS t0_r4, `repositories`.`block` AS t0_r5, `repositories`.`linkedbuild` AS t0_r6, `repositories`.`hostsystem_id` AS t0_r7, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`title` AS t1_r2, `projects`.`description` AS t1_r3, `projects`.`created_at` AS t1_r4, `projects`.`updated_at` AS t1_r5, `projects`.`remoteurl` AS t1_r6, `projects`.`remoteproject` AS t1_r7, `projects`.`type_id` AS t1_r8, `projects`.`maintenance_project_id` AS t1_r9, `projects`.`develproject_id` AS t1_r10, `projects`.`delta` AS t1_r11 FROM `repositories` LEFT OUTER JOIN `projects` ON `projects`.`id` = `repositories`.`db_project_id` WHERE `repositories`.`id` IN (75, 81, 85, 82, 83, 211, 142, 144, 141, 91, 95, 92, 86, 93, 89, 96, 90, 94, 87, 88)[0m [9047e082-1020-4821-8759-451e35f1665d] [5600.15] no schema found, skipping validation for {"format"=>"xml", "controller"=>"search", "action"=>"repository_id", "method"=>"GET", "type"=>"response"} [9047e082-1020-4821-8759-451e35f1665d] [5600.15] Validate XML response: #ActionDispatch::Response:0x0000000795dec0 took 0ms [9047e082-1020-4821-8759-451e35f1665d] [5600.16] Completed 200 OK in 121ms (Views: 0.5ms | ActiveRecord: 1.3ms | Backend: 0.0ms | XML: 0.4ms) [5600.16] [1m[35m (0.2ms)[0m ROLLBACK [5600.16] [1m[36m (0.1ms)[0m [1mBEGIN[0m [5600.16] ----------------------------------------- [5600.16] SearchControllerTest: test_search_request [5600.16] ----------------------------------------- [5600.16] Wait for scheduler thread to finish start [5644.20] [1m[35m (0.2ms)[0m ROLLBACK + echo + cleanup + echo 'Killing backend processes' Killing backend processes + egrep 'perl|ruby' + fuser -v http://ci.opensuse.org/job/obs_master_testsuite_api/ws/ USER PID ACCESS COMMAND http://ci.opensuse.org/job/obs_master_testsuite_api/ws/: ci ..c.. sh ci ..c.. sh ci ..c.. egrep ci ..c.. fuser + echo 'Remove log/tmp files to save disc space' Remove log/tmp files to save disc space + rm -rf src/api/log/backend_access.log src/api/log/test.log src/api/tmp/backend_config src/api/tmp/cache src/api/tmp/pids src/api/tmp/sessions src/api/tmp/sockets 'src/webui/log/*' src/webui/tmp/cache src/webui/tmp/pids src/webui/tmp/sessions src/webui/tmp/sockets + exit 1 Build step 'Execute shell' marked build as failure [locks-and-latches] Releasing all the locks [locks-and-latches] All the locks released -- To unsubscribe, e-mail: obs-tests+unsubscribe@opensuse.org To contact the owner, e-mail: obs-tests+owner@opensuse.org