Processing RepositoriesController#show (for my.ip.addr at 2010-02-22 12:53:21) [GET]
  Parameters: {"action"=>"show", "id"=>"rci-mot", "controller"=>"repositories"}
  SQL (0.3ms)   SELECT max("settings".updated_on) AS max_updated_on FROM "settings" 
  AnonymousUser Load (0.4ms)   SELECT * FROM "users" WHERE ( ("users"."type" = 'AnonymousUser' ) ) LIMIT 1
  Project Load (0.3ms)   SELECT * FROM "projects" WHERE ("projects"."identifier" = 'rci-mot') LIMIT 1
  Repository Load (0.2ms)   SELECT * FROM "repositories" WHERE ("repositories".project_id = 5) LIMIT 1
  EnabledModule Load (0.5ms)   SELECT * FROM "enabled_modules" WHERE ("enabled_modules".project_id = 5) 
  Role Load (0.2ms)   SELECT * FROM "roles" WHERE ("roles"."builtin" = 2) LIMIT 1
Shelling out: darcs changes --repodir /home/james/code/darcs/MoT/ --xml-output --last 1
  Changeset Load (1.1ms)   SELECT * FROM "changesets" WHERE ("changesets".repository_id = 5) ORDER BY changesets.committed_on DESC, changesets.id DESC LIMIT 1
  Changeset Load (0.2ms)   SELECT * FROM "changesets" WHERE ("changesets"."scmid" = '20100219221936-bc714-92ae370ee41e95acd7802b28a8cc10adc060e704.gz') AND ("changesets".repository_id = 5) ORDER BY changesets.committed_on DESC, changesets.id DESC LIMIT 1
Shelling out: darcs changes --repodir /home/james/code/darcs/MoT/ --xml-output --from-match 'hash 20100219180057-bc714-63c6925bc0221d5fbb40e8e0c3a09bc20af39b47.gz'
Shelling out: darcs annotate --repodir /home/james/code/darcs/MoT/ --summary --xml-output --match 'hash 20100219221936-bc714-92ae370ee41e95acd7802b28a8cc10adc060e704.gz' 
Shelling out: darcs annotate --repodir /home/james/code/darcs/MoT/ --summary --xml-output --match 'hash 20100219200538-bc714-40561e33b17950d216f4564784ccca6cba48442d.gz' 
Shelling out: darcs annotate --repodir /home/james/code/darcs/MoT/ --summary --xml-output --match 'hash 20100219184418-bc714-a68cec5683f53e36a7302bac680ffb16b22ae18a.gz' 
Shelling out: darcs annotate --repodir /home/james/code/darcs/MoT/ --summary --xml-output --match 'hash 20100219184332-bc714-1908d98df8ad94fb2b9fa750d335a04bf337b7ec.gz' 
Shelling out: darcs annotate --repodir /home/james/code/darcs/MoT/ --summary --xml-output --match 'hash 20100219180057-bc714-63c6925bc0221d5fbb40e8e0c3a09bc20af39b47.gz' 
  Changeset Load (0.2ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."revision" = '42' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load (0.3ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."scmid" = '20100219180057-bc714-63c6925bc0221d5fbb40e8e0c3a09bc20af39b47.gz' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load (0.2ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."revision" = '43' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load (0.2ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."scmid" = '20100219184332-bc714-1908d98df8ad94fb2b9fa750d335a04bf337b7ec.gz' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load Including Associations (1.2ms)   SELECT "changesets"."id" AS t0_r0, "changesets"."repository_id" AS t0_r1, "changesets"."revision" AS t0_r2, "changesets"."committer" AS t0_r3, "changesets"."committed_on" AS t0_r4, "changesets"."comments" AS t0_r5, "changesets"."commit_date" AS t0_r6, "changesets"."scmid" AS t0_r7, "changesets"."user_id" AS t0_r8, "users"."id" AS t1_r0, "users"."login" AS t1_r1, "users"."hashed_password" AS t1_r2, "users"."firstname" AS t1_r3, "users"."lastname" AS t1_r4, "users"."mail" AS t1_r5, "users"."mail_notification" AS t1_r6, "users"."admin" AS t1_r7, "users"."status" AS t1_r8, "users"."last_login_on" AS t1_r9, "users"."language" AS t1_r10, "users"."auth_source_id" AS t1_r11, "users"."created_on" AS t1_r12, "users"."updated_on" AS t1_r13, "users"."type" AS t1_r14, "users"."identity_url" AS t1_r15 FROM "changesets" LEFT OUTER JOIN "users" ON "users".id = "changesets".user_id AND ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) WHERE ("changesets".repository_id = 5 AND ("changesets"."committer" = 'James Hiebert <hiebert@uvic.ca>')) ORDER BY changesets.committed_on DESC, changesets.id DESC LIMIT 1
  Changeset Create (17.1ms)   INSERT INTO "changesets" ("committed_on", "comments", "commit_date", "scmid", "user_id", "revision", "repository_id", "committer") VALUES('2010-02-19 10:43:32', 'Made the regex in get.calendar.type() more specific "calendar" -> "time:calendar"
Ignore-this: bee49e1fe79ab41a871a4c8362590f27', '2010-02-19 10:43:32', '20100219184332-bc714-1908d98df8ad94fb2b9fa750d335a04bf337b7ec.gz', 1, '43', 5, 'James Hiebert <hiebert@uvic.ca>')
  IssueStatus Load (0.2ms)   SELECT * FROM "issue_statuses" WHERE ("issue_statuses"."id" = '0') LIMIT 1
  Issue Load (0.2ms)   SELECT * FROM "issues" INNER JOIN "changesets_issues" ON "issues".id = "changesets_issues".issue_id WHERE ("changesets_issues".changeset_id = 82 ) 
  Change Create (0.2ms)   INSERT INTO "changes" ("changeset_id", "action", "branch", "path", "revision", "from_path", "from_revision") VALUES(82, 'M', NULL, '/MoT.r', NULL, NULL, NULL)
  Changeset Load (0.2ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."revision" = '44' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load (0.2ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."scmid" = '20100219184418-bc714-a68cec5683f53e36a7302bac680ffb16b22ae18a.gz' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load Including Associations (2.4ms)   SELECT "changesets"."id" AS t0_r0, "changesets"."repository_id" AS t0_r1, "changesets"."revision" AS t0_r2, "changesets"."committer" AS t0_r3, "changesets"."committed_on" AS t0_r4, "changesets"."comments" AS t0_r5, "changesets"."commit_date" AS t0_r6, "changesets"."scmid" AS t0_r7, "changesets"."user_id" AS t0_r8, "users"."id" AS t1_r0, "users"."login" AS t1_r1, "users"."hashed_password" AS t1_r2, "users"."firstname" AS t1_r3, "users"."lastname" AS t1_r4, "users"."mail" AS t1_r5, "users"."mail_notification" AS t1_r6, "users"."admin" AS t1_r7, "users"."status" AS t1_r8, "users"."last_login_on" AS t1_r9, "users"."language" AS t1_r10, "users"."auth_source_id" AS t1_r11, "users"."created_on" AS t1_r12, "users"."updated_on" AS t1_r13, "users"."type" AS t1_r14, "users"."identity_url" AS t1_r15 FROM "changesets" LEFT OUTER JOIN "users" ON "users".id = "changesets".user_id AND ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) WHERE ("changesets".repository_id = 5 AND ("changesets"."committer" = 'James Hiebert <hiebert@uvic.ca>')) ORDER BY changesets.committed_on DESC, changesets.id DESC LIMIT 1
  Changeset Create (0.2ms)   INSERT INTO "changesets" ("committed_on", "comments", "commit_date", "scmid", "user_id", "revision", "repository_id", "committer") VALUES('2010-02-19 10:44:18', 'Change in the master script to serialize all of the final results so that can be analyzed or validated after the run
Ignore-this: ea3c3b5fd4263b37c77b86cc1179fa4f', '2010-02-19 10:44:18', '20100219184418-bc714-a68cec5683f53e36a7302bac680ffb16b22ae18a.gz', 1, '44', 5, 'James Hiebert <hiebert@uvic.ca>')
  IssueStatus Load (0.1ms)   SELECT * FROM "issue_statuses" WHERE ("issue_statuses"."id" = '0') LIMIT 1
  Issue Load (0.2ms)   SELECT * FROM "issues" INNER JOIN "changesets_issues" ON "issues".id = "changesets_issues".issue_id WHERE ("changesets_issues".changeset_id = 83 ) 
  Change Create (0.1ms)   INSERT INTO "changes" ("changeset_id", "action", "branch", "path", "revision", "from_path", "from_revision") VALUES(83, 'M', NULL, '/create.all.boxplots.r', NULL, NULL, NULL)
  Changeset Load (0.1ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."revision" = '45' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load (0.2ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."scmid" = '20100219200538-bc714-40561e33b17950d216f4564784ccca6cba48442d.gz' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load Including Associations (1.1ms)   SELECT "changesets"."id" AS t0_r0, "changesets"."repository_id" AS t0_r1, "changesets"."revision" AS t0_r2, "changesets"."committer" AS t0_r3, "changesets"."committed_on" AS t0_r4, "changesets"."comments" AS t0_r5, "changesets"."commit_date" AS t0_r6, "changesets"."scmid" AS t0_r7, "changesets"."user_id" AS t0_r8, "users"."id" AS t1_r0, "users"."login" AS t1_r1, "users"."hashed_password" AS t1_r2, "users"."firstname" AS t1_r3, "users"."lastname" AS t1_r4, "users"."mail" AS t1_r5, "users"."mail_notification" AS t1_r6, "users"."admin" AS t1_r7, "users"."status" AS t1_r8, "users"."last_login_on" AS t1_r9, "users"."language" AS t1_r10, "users"."auth_source_id" AS t1_r11, "users"."created_on" AS t1_r12, "users"."updated_on" AS t1_r13, "users"."type" AS t1_r14, "users"."identity_url" AS t1_r15 FROM "changesets" LEFT OUTER JOIN "users" ON "users".id = "changesets".user_id AND ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) WHERE ("changesets".repository_id = 5 AND ("changesets"."committer" = 'James Hiebert <hiebert@uvic.ca>')) ORDER BY changesets.committed_on DESC, changesets.id DESC LIMIT 1
  Changeset Create (0.2ms)   INSERT INTO "changesets" ("committed_on", "comments", "commit_date", "scmid", "user_id", "revision", "repository_id", "committer") VALUES('2010-02-19 12:05:38', 'Changed the master script to report the climate indicies in terms of events per year
Ignore-this: 88e660530f5565a4c13264ca2d1146a2', '2010-02-19 12:05:38', '20100219200538-bc714-40561e33b17950d216f4564784ccca6cba48442d.gz', 1, '45', 5, 'James Hiebert <hiebert@uvic.ca>')
  IssueStatus Load (0.1ms)   SELECT * FROM "issue_statuses" WHERE ("issue_statuses"."id" = '0') LIMIT 1
  Issue Load (0.2ms)   SELECT * FROM "issues" INNER JOIN "changesets_issues" ON "issues".id = "changesets_issues".issue_id WHERE ("changesets_issues".changeset_id = 84 ) 
  Change Create (0.2ms)   INSERT INTO "changes" ("changeset_id", "action", "branch", "path", "revision", "from_path", "from_revision") VALUES(84, 'M', NULL, '/create.all.boxplots.r', NULL, NULL, NULL)
  Changeset Load (0.1ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."revision" = '46' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load (0.2ms)   SELECT "changesets".id FROM "changesets" WHERE ("changesets"."scmid" = '20100219221936-bc714-92ae370ee41e95acd7802b28a8cc10adc060e704.gz' AND "changesets".repository_id = 5) LIMIT 1
  Changeset Load Including Associations (1.1ms)   SELECT "changesets"."id" AS t0_r0, "changesets"."repository_id" AS t0_r1, "changesets"."revision" AS t0_r2, "changesets"."committer" AS t0_r3, "changesets"."committed_on" AS t0_r4, "changesets"."comments" AS t0_r5, "changesets"."commit_date" AS t0_r6, "changesets"."scmid" AS t0_r7, "changesets"."user_id" AS t0_r8, "users"."id" AS t1_r0, "users"."login" AS t1_r1, "users"."hashed_password" AS t1_r2, "users"."firstname" AS t1_r3, "users"."lastname" AS t1_r4, "users"."mail" AS t1_r5, "users"."mail_notification" AS t1_r6, "users"."admin" AS t1_r7, "users"."status" AS t1_r8, "users"."last_login_on" AS t1_r9, "users"."language" AS t1_r10, "users"."auth_source_id" AS t1_r11, "users"."created_on" AS t1_r12, "users"."updated_on" AS t1_r13, "users"."type" AS t1_r14, "users"."identity_url" AS t1_r15 FROM "changesets" LEFT OUTER JOIN "users" ON "users".id = "changesets".user_id AND ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) WHERE ("changesets".repository_id = 5 AND ("changesets"."committer" = 'James Hiebert <hiebert@uvic.ca>')) ORDER BY changesets.committed_on DESC, changesets.id DESC LIMIT 1
  Changeset Create (0.1ms)   INSERT INTO "changesets" ("committed_on", "comments", "commit_date", "scmid", "user_id", "revision", "repository_id", "committer") VALUES('2010-02-19 14:19:36', 'Bug in master script. Climate indicies filename should not include the variable.
Ignore-this: e984a871e5c9a9edd3016d2a634abc11', '2010-02-19 14:19:36', '20100219221936-bc714-92ae370ee41e95acd7802b28a8cc10adc060e704.gz', 1, '46', 5, 'James Hiebert <hiebert@uvic.ca>')
  IssueStatus Load (0.1ms)   SELECT * FROM "issue_statuses" WHERE ("issue_statuses"."id" = '0') LIMIT 1
  Issue Load (0.2ms)   SELECT * FROM "issues" INNER JOIN "changesets_issues" ON "issues".id = "changesets_issues".issue_id WHERE ("changesets_issues".changeset_id = 85 ) 
  Change Create (0.1ms)   INSERT INTO "changes" ("changeset_id", "action", "branch", "path", "revision", "from_path", "from_revision") VALUES(85, 'M', NULL, '/create.all.boxplots.r', NULL, NULL, NULL)
Shelling out: darcs annotate --repodir /home/james/code/darcs/MoT/ --xml-output '.'
Rendering template within layouts/base
  Project Load (0.3ms)   SELECT "projects".* FROM "projects" INNER JOIN "members" ON "projects".id = "members".project_id WHERE (("members".user_id = 2) AND ((projects.status=1))) 
  SQL (0.3ms)   SELECT count(DISTINCT "members".id) AS count_all FROM "members" LEFT OUTER JOIN "projects" ON "projects".id = "members".project_id LEFT OUTER JOIN "member_roles" ON ("members"."id" = "member_roles"."member_id") LEFT OUTER JOIN "roles" ON ("roles"."id" = "member_roles"."role_id") WHERE ("members".user_id = 2 AND (projects.status=1)) 
  SQL (0.4ms)   SELECT count(*) AS count_all FROM "projects" WHERE (((projects.status=1 AND projects.is_public = 't') AND (projects.id != 5)) AND (projects."lft" <= 6 AND projects."rgt" >= 7)) 
  Project Load (0.4ms)   SELECT * FROM "projects" WHERE (((projects.status=1 AND projects.is_public = 't') AND (projects.id != 5)) AND (projects."lft" <= 6 AND projects."rgt" >= 7)) ORDER BY "lft"
  Project Load (0.5ms)   SELECT * FROM "projects" WHERE (projects."lft" <= 6 AND projects."rgt" >= 7) ORDER BY "lft" LIMIT 1
  CACHE (0.0ms)   SELECT * FROM "projects" WHERE (projects."lft" <= 6 AND projects."rgt" >= 7) ORDER BY "lft" LIMIT 1
  SQL (0.3ms)   SELECT count(DISTINCT "versions".id) AS count_all FROM "versions" LEFT OUTER JOIN "projects" ON "projects".id = "versions".project_id WHERE (projects.id = 5 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 5 AND projects.rgt <= 8 AND versions.sharing = 'tree') OR (projects.lft < 6 AND projects.rgt > 7 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 6 AND projects.rgt < 7 AND versions.sharing = 'hierarchy')))) 
  Wiki Load (0.3ms)   SELECT * FROM "wikis" WHERE ("wikis".project_id = 5) LIMIT 1
  SQL (0.2ms)   SELECT count(*) AS count_all FROM "boards" WHERE ("boards".project_id = 5) 
Completed in 1044ms (View: 24, DB: 33) | 500 Internal Server Error [https://my.hostname/projects/rci-mot/repository]