Don't use a prepared statement for the active build steps query

Dependencies

• [2] NZYFWV6M hydra-build: Add system info to the subject and extra headers.
• [3] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
• [4] SMCOU72F hydra: add some admin for adding/enabling/etc build machines
• [5] KA45EBF5 * Send email if a build fails.
• [6] OG7BEM57
• [7] LOMVF2KH do not send email for builds with status 'aborted'
• [8] HPEG2RHV Merge the BuildResultInfo table into the Builds table
• [9] AJKTRRDJ rename var
• [10] EFWN7JBV * Added a status page that shows all the currently executing build steps.
• [11] 6KJXJB7N qualify ordery_by clauses when necessary, remove unnecessary order_by's, reported by Ludo, resulted in errors in sqlite
• [12] FHAVPTZ6 Hydra/23: added some X-headers with meta info in email notifications, added more descriptive status
• [13] 6FRLEP4P first try for timeline of last 24 hours in hydra
• [14] FPK5LF53 * Put the project-related actions in a separate controller. Put the
• [15] FYO6NECE hydra
• [*] J5UVLXOK * Start of a basic Catalyst web interface.
• [*] LBNVQXUB * Build the /build stuff in a separate controller.
• [*] KAZWI5G4 * hydra: buildpage, show changes since last build/successful build
• [*] LUPEGYR7 Hydra: In case of failure, also show changes between last succesful build and the first failed build after this
• [*] 7YBYT2LQ
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the
• [*] E2TOU3L6 * More indices.

Change contents

• replacement in src/lib/Hydra/Controller/Root.pm at line 98
  [4.424]→[4.424:488](∅→∅),[4.488]→[3.2823:2900](∅→∅),[3.2900]→[4.735:771](∅→∅),[4.735]→[4.735:771](∅→∅),[4.771]→[4.631:646](∅→∅),[4.631]→[4.631:646](∅→∅)
  − $c->stash->{steps} = [ $c->model('DB::BuildSteps')->search(

  − { 'me.busy' => 1, 'build.busy' => 1 },

  − { join => [ 'build' ]

  − , order_by => [ 'machine' ]

  − } ) ];
  [4.424]

  [4.646]
  + $c->model('DB')->storage->dbh_do(sub {

  + my (undef, $dbh) = @_;

  + local $dbh->{pg_server_prepare} = 0;

  + $c->stash->{steps} = [ $c->model('DB::BuildSteps')->search(

  + { 'me.busy' => 1, 'build.finished' => 0, 'build.busy' => 1 },

  + { join => [ 'build' ]

  + , order_by => [ 'machine' ]

  + } ) ];

  + });
• edit in src/lib/Hydra/Helper/CatalystUtils.pm at line 24
  [19.271]

  [19.271]
  +
• edit in src/lib/Hydra/Helper/CatalystUtils.pm at line 41
  [20.210]

  [20.210]
  +
• edit in src/lib/Hydra/Helper/CatalystUtils.pm at line 58
  [4.9783]

  [4.9783]
  +
• edit in src/lib/Hydra/Helper/CatalystUtils.pm at line 77
  [4.9785]

  [4.9785]
  +
• edit in src/script/hydra-build at line 92
  [4.4112]→[4.4112:4113](∅→∅)
  −
• edit in src/script/hydra-build at line 194
  [2.106]→[4.781:782](∅→∅),[4.781]→[4.781:782](∅→∅)
  −
• edit in src/sql/hydra.sql at line 501
  [23.2524]

  [24.0]
  + create index IndexBuildStepsOnBusy on BuildSteps(busy);
• edit in src/sql/hydra.sql at line 506
  [23.2580]

  [23.2580]
  + create index IndexBuildsOnFinishedBusy on Builds(finished, busy);