File: auto_increment_offset_save.inc

package info (click to toggle)
mariadb 1%3A11.8.3-1
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 772,520 kB
  • sloc: ansic: 2,414,714; cpp: 1,791,394; asm: 381,336; perl: 62,905; sh: 49,647; pascal: 40,897; java: 39,363; python: 20,791; yacc: 20,432; sql: 17,907; xml: 12,344; ruby: 8,544; cs: 6,542; makefile: 6,145; ada: 1,879; lex: 1,193; javascript: 996; objc: 80; tcl: 73; awk: 46; php: 22
file content (44 lines) | stat: -rw-r--r-- 1,308 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
# This file can be used to save the @@global.auto_increment_offset value at
# the beginning of any test that intends to restart any of the participating
# nodes. This is required as the node may get auto-assigned a different
# auto_increment_offset value on restart, which could cause MTR's internal
# post-check to fail. auto_increment_offset_restore.inc can be used at the
# end of the test to restore these saved values.

# Parameters
# ----------
# $node_1
#   Connection handle for 1st node
# $node_2
#   Connection handle for 2nd node
# $node_3 (optional)
#   Connection handle for 3rd node
# $node_4 (optional)
#   Connection handle for 4th node

if (!$node_1)
{
  --die ERROR IN TEST: $node_1 must be set before sourcing auto_increment_offset_save.inc
}

if (!$node_2)
{
  --die ERROR IN TEST: $node_2 must be set before sourcing auto_increment_offset_save.inc
}

--connection $node_1
let $auto_increment_offset_node_1 = `SELECT @@global.auto_increment_offset`;
--connection $node_2
let $auto_increment_offset_node_2 = `SELECT @@global.auto_increment_offset`;

if ($node_3)
{
  --connection $node_3
  let $auto_increment_offset_node_3 = `SELECT @@global.auto_increment_offset`;
}

if ($node_4)
{
  --connection $node_4
  let $auto_increment_offset_node_4 = `SELECT @@global.auto_increment_offset`;
}