grahamc/hydra2 - Change LZO3C2KIACZ3HN72RBGWWIT5ED4RJMYKI3SAHXT6RIUPHDFL3STQC

* Hack around those SQLite timeouts: just retry the transaction.

Created by Eelco Dolstra on April 22, 2009

LZO3C2KIACZ3HN72RBGWWIT5ED4RJMYKI3SAHXT6RIUPHDFL3STQC

Dependencies

In channels

main

Change contents

Replacement in src/lib/Hydra/Controller/Build.pm at line 276 [8.1]
B:BD[7.354] → [7.354:396]
```
    $c->model('DB')->schema->txn_do(sub {
```
[7.354]
[9.103]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Build.pm at line 307 [8.1]
B:BD[9.619] → [9.619:661]
```
    $c->model('DB')->schema->txn_do(sub {
```
[9.619]
[9.661]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Build.pm at line 343 [8.1]
B:BD[10.379] → [10.379:421]
```
    $c->model('DB')->schema->txn_do(sub {
```
[10.379]
[10.421]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Jobset.pm at line 67 [11.104]
B:BD[6.866] → [6.866:908]
```
    $c->model('DB')->schema->txn_do(sub {
```
[6.866]
[6.908]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Jobset.pm at line 82 [11.104]
B:BD[6.1250] → [6.1250:1292]
```
    $c->model('DB')->schema->txn_do(sub {
```
[6.1250]
[6.1292]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Project.pm at line 47 [12.1245]
B:BD[12.2361] → [12.2361:2403]
```
    $c->model('DB')->schema->txn_do(sub {
```
[12.2361]
[13.834]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Project.pm at line 61 [12.1245]
B:BD[12.2766] → [12.2766:2808]
```
    $c->model('DB')->schema->txn_do(sub {
```
[12.2766]
[13.936]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Project.pm at line 97 [12.1245]
B:BD[12.3258] → [12.3258:3300]
```
    $c->model('DB')->schema->txn_do(sub {
```
[12.3258]
[12.3300]
```
    txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Controller/Project.pm at line 130 [12.1245]
B:BD[6.5258] → [6.5258:5300]
```
    $c->model('DB')->schema->txn_do(sub {
```
[6.5258]
[6.5300]
```
    txn_do($c->model('DB')->schema, sub {
```

Replacement in src/lib/Hydra/Controller/Root.pm at line 149 [15.804]

B:BD[14.1288] → [14.1288:1338]

            $c->model('DB')->schema->txn_do(sub {

[14.1288]

[14.1338]

            txn_do($c->model('DB')->schema, sub {

Replacement in src/lib/Hydra/Controller/Root.pm at line 156 [15.804]

B:BD[16.42] → [16.42:92]

            $c->model('DB')->schema->txn_do(sub {

[16.42]

[16.92]

            txn_do($c->model('DB')->schema, sub {

Replacement in src/lib/Hydra/Controller/Root.pm at line 184 [15.804]
B:BD[17.2289] → [17.2289:2335]
```
        $c->model('DB')->schema->txn_do(sub {
```
[17.2289]
[17.2335]
```
        txn_do($c->model('DB')->schema, sub {
```
Replacement in src/lib/Hydra/Helper/Nix.pm at line 11 [19.436]
B:BD[18.30] → [18.30:74]
```
    getHydraPath getHydraDBPath openHydraDB
```
[18.30]
[20.665]
```
    getHydraPath getHydraDBPath openHydraDB txn_do
```

Insertion in src/lib/Hydra/Helper/Nix.pm at line 81 [19.436]

[21.53]

# Awful hack to handle timeouts in SQLite: just retry the transaction.
# DBD::SQLite *has* a 30 second retry window, but apparently it
# doesn't work.
sub txn_do {
    my ($db, $coderef) = @_;
    while (1) {
        eval {
            $db->txn_do($coderef);
        };
        last if !$@;
        die $@ unless $@ =~ "database is locked";
    }
}

Replacement in src/script/hydra_build.pl at line 68 [23.2912]
∅:D[2.24] → [22.5462:5496]
B:BD[22.5462] → [22.5462:5496]
```
                $db->txn_do(sub {
```
[2.24]
[24.4340]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 83 [23.2912]
∅:D[2.196] → [22.5984:6018]
∅:D[25.519] → [22.5984:6018]
B:BD[22.5984] → [22.5984:6018]
```
                $db->txn_do(sub {
```
[2.196]
[2.197]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 95 [23.2912]
∅:D[5.271] → [22.6461:6495]
∅:D[25.628] → [22.6461:6495]
∅:D[26.3884] → [22.6461:6495]
B:BD[22.6461] → [22.6461:6495]
```
                $db->txn_do(sub {
```
[5.271]
[27.347]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 122 [23.2912]
B:BD[25.764] → [25.764:798]
```
                $db->txn_do(sub {
```
[25.764]
[24.4802]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 135 [23.2912]
B:BD[25.1280] → [25.1280:1314]
```
                $db->txn_do(sub {
```
[25.1280]
[27.586]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 143 [23.2912]
B:BD[25.1765] → [25.1765:1799]
```
                $db->txn_do(sub {
```
[25.1765]
[27.686]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 172 [23.2912]
B:BD[23.4021] → [23.4021:4043]
```
    $db->txn_do(sub {
```
[23.4021]
[28.4982]
```
    txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 268 [23.2912]
∅:D[29.7958] → [23.6940:6958]
B:BD[23.6940] → [23.6940:6958]
```
$db->txn_do(sub {
```
[29.7958]
[30.7991]
```
txn_do($db, sub {
```
Replacement in src/script/hydra_build.pl at line 290 [23.2912]
B:BD[23.7446] → [23.7446:7468]
```
    $db->txn_do(sub {
```
[23.7446]
[31.936]
```
    txn_do($db, sub {
```
Replacement in src/script/hydra_queue_runner.pl at line 22 [23.7823]
∅:D[32.76] → [33.72:94]
B:BD[33.72] → [33.72:94]
```
    $db->txn_do(sub {
```
[32.76]
[32.77]
```
    txn_do($db, sub {
```
Replacement in src/script/hydra_queue_runner.pl at line 57 [23.7823]
B:BD[23.8470] → [23.8470:8492]
```
    $db->txn_do(sub {
```
[23.8470]
[34.22]
```
    txn_do($db, sub {
```
Replacement in src/script/hydra_queue_runner.pl at line 126 [23.7823]
B:BD[23.9144] → [23.9144:9174]
```
            $db->txn_do(sub {
```
[23.9144]
[32.1447]
```
            txn_do($db, sub {
```
Replacement in src/script/hydra_scheduler.pl at line 114 [36.1319]
B:BD[35.3113] → [35.3113:3147]
```
                $db->txn_do(sub {
```
[35.3113]
[37.5354]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_scheduler.pl at line 125 [36.1319]
B:BD[35.3573] → [35.3573:3607]
```
                $db->txn_do(sub {
```
[35.3573]
[31.1004]
```
                txn_do($db, sub {
```
Replacement in src/script/hydra_scheduler.pl at line 173 [36.1319]
B:BD[38.4748] → [38.4748:4778]
```
            $db->txn_do(sub {
```
[38.4748]
[37.5498]
```
            txn_do($db, sub {
```
Replacement in src/script/hydra_scheduler.pl at line 263 [36.1319]
∅:D[39.225] → [23.9381:9403]
B:BD[40.1085] → [23.9381:9403]
```
    $db->txn_do(sub {
```
[39.225]
[41.5149]
```
    txn_do($db, sub {
```
Replacement in src/script/hydra_scheduler.pl at line 329 [36.1319]
B:BD[42.3030] → [42.3030:3056]
```
        $db->txn_do(sub {
```
[42.3030]
[31.1067]
```
        txn_do($db, sub {
```
Deletion in src/script/hydra_scheduler.pl at line 373 [36.1319]
B:BD[43.2226] → [4.465:544]
```
    die "not supported" if scalar @{$inputInfo->{$jobset->nixexprinput}} != 1;
```

Insertion in src/script/hydra_scheduler.pl at line 375 [36.1319]

[43.2372]

[4.609]

    die "multiple alternatives for the input containing the Nix expression are not supported"
        if scalar @{$inputInfo->{$jobset->nixexprinput}} != 1;

Replacement in src/script/hydra_scheduler.pl at line 406 [36.1319]
B:BD[41.6141] → [41.6141:6163]
```
    $db->txn_do(sub {
```
[41.6141]
[3.1981]
```
    txn_do($db, sub {
```
Replacement in src/script/hydra_scheduler.pl at line 452 [36.1319]
B:BD[3.2355] → [3.2355:2381]
```
        $db->txn_do(sub {
```
[3.2355]
[3.2381]
```
        txn_do($db, sub {
```

* Hack around those SQLite timeouts: just retry the transaction.

Dependencies

In channels

Change contents

Replacement in src/lib/Hydra/Controller/Build.pm at line 276 [8.1]

Replacement in src/lib/Hydra/Controller/Build.pm at line 307 [8.1]

Replacement in src/lib/Hydra/Controller/Build.pm at line 343 [8.1]

Replacement in src/lib/Hydra/Controller/Jobset.pm at line 67 [11.104]

Replacement in src/lib/Hydra/Controller/Jobset.pm at line 82 [11.104]

Replacement in src/lib/Hydra/Controller/Project.pm at line 47 [12.1245]

Replacement in src/lib/Hydra/Controller/Project.pm at line 61 [12.1245]

Replacement in src/lib/Hydra/Controller/Project.pm at line 97 [12.1245]

Replacement in src/lib/Hydra/Controller/Project.pm at line 130 [12.1245]

Replacement in src/lib/Hydra/Controller/Root.pm at line 149 [15.804]

Replacement in src/lib/Hydra/Controller/Root.pm at line 156 [15.804]

Replacement in src/lib/Hydra/Controller/Root.pm at line 184 [15.804]

Replacement in src/lib/Hydra/Helper/Nix.pm at line 11 [19.436]

Insertion in src/lib/Hydra/Helper/Nix.pm at line 81 [19.436]

Replacement in src/script/hydra_build.pl at line 68 [23.2912]

Replacement in src/script/hydra_build.pl at line 83 [23.2912]

Replacement in src/script/hydra_build.pl at line 95 [23.2912]

Replacement in src/script/hydra_build.pl at line 122 [23.2912]

Replacement in src/script/hydra_build.pl at line 135 [23.2912]

Replacement in src/script/hydra_build.pl at line 143 [23.2912]

Replacement in src/script/hydra_build.pl at line 172 [23.2912]

Replacement in src/script/hydra_build.pl at line 268 [23.2912]

Replacement in src/script/hydra_build.pl at line 290 [23.2912]

Replacement in src/script/hydra_queue_runner.pl at line 22 [23.7823]

Replacement in src/script/hydra_queue_runner.pl at line 57 [23.7823]

Replacement in src/script/hydra_queue_runner.pl at line 126 [23.7823]

Replacement in src/script/hydra_scheduler.pl at line 114 [36.1319]

Replacement in src/script/hydra_scheduler.pl at line 125 [36.1319]

Replacement in src/script/hydra_scheduler.pl at line 173 [36.1319]

Replacement in src/script/hydra_scheduler.pl at line 263 [36.1319]

Replacement in src/script/hydra_scheduler.pl at line 329 [36.1319]

Deletion in src/script/hydra_scheduler.pl at line 373 [36.1319]

Insertion in src/script/hydra_scheduler.pl at line 375 [36.1319]

Replacement in src/script/hydra_scheduler.pl at line 406 [36.1319]

Replacement in src/script/hydra_scheduler.pl at line 452 [36.1319]