1#
2# Run the built query in $sql, retry temporary errors
3#
4
5let $_continue = 1;
6let $_retry = 0;
7while($_continue)
8{
9  error 0,1297; # Allow OK or temporary error
10  eval $sql;    # Run the query
11
12  if (!$mysql_errno)
13  {
14    # Query suceeded, break the retry loop
15    let $_continue = 0;
16  }
17
18  if ($mysql_errno)
19  {
20    # Query failed
21    inc $_retry;
22    echo Query failed with temporary error, retry:  $_retry;
23
24    sleep 0.1;
25  }
26}
27