@@ -76,10 +76,6 @@ func prepare_db() {
76
76
exec (conn1 , "select dtm_begin_transaction($1, $2)" , nodes , xids )
77
77
exec (conn2 , "select dtm_begin_transaction($1, $2)" , nodes , xids )
78
78
79
- // first global statement
80
- exec (conn1 , "select dtm_get_snapshot()" )
81
- exec (conn2 , "select dtm_get_snapshot()" )
82
-
83
79
for i := 0 ; i < N_ACCOUNTS ; i ++ {
84
80
exec (conn1 , "insert into t values($1, $2)" , i , INIT_AMOUNT )
85
81
exec (conn2 , "insert into t values($1, $2)" , i , INIT_AMOUNT )
@@ -97,7 +93,7 @@ func max(a, b int64) int64 {
97
93
98
94
func transfer (id int , wg * sync.WaitGroup ) {
99
95
var err error
100
- var sum1 , sum2 , sum int32
96
+ // var sum1, sum2, sum int32
101
97
var xids []int32 = make ([]int32 , 2 )
102
98
103
99
conn1 , err := pgx .Connect (cfg1 )
@@ -125,31 +121,10 @@ func transfer(id int, wg *sync.WaitGroup) {
125
121
// register global transaction in DTMD
126
122
exec (conn1 , "select dtm_begin_transaction($1, $2)" , nodes , xids )
127
123
exec (conn2 , "select dtm_begin_transaction($1, $2)" , nodes , xids )
128
-
129
- // first global statement
130
- exec (conn1 , "select dtm_get_snapshot()" )
131
- exec (conn2 , "select dtm_get_snapshot()" )
132
-
133
- sum1 = execQuery (conn1 , "select sum(v) from t" )
134
- sum2 = execQuery (conn2 , "select sum(v) from t" )
135
- sum = sum1 + sum2
136
-
137
- exec (conn1 , "select dtm_get_snapshot()" )
138
- exec (conn2 , "select dtm_get_snapshot()" )
139
124
140
125
exec (conn1 , "update t set v = v + $1 where u=$2" , amount , account1 )
141
126
exec (conn2 , "update t set v = v - $1 where u=$2" , amount , account2 )
142
-
143
- exec (conn1 , "select dtm_get_snapshot()" )
144
- exec (conn2 , "select dtm_get_snapshot()" )
145
127
146
- sum1 = execQuery (conn1 , "select sum(v) from t" )
147
- sum2 = execQuery (conn2 , "select sum(v) from t" )
148
-
149
- if (sum1 + sum2 != sum ) {
150
- fmt .Println ("Before = " , sum , ", after=" , sum1 + sum2 , ", xids=" , xids )
151
- }
152
-
153
128
commit (conn1 , conn2 )
154
129
}
155
130
@@ -180,9 +155,6 @@ func inspect(wg *sync.WaitGroup) {
180
155
exec (conn1 , "select dtm_begin_transaction($1, $2)" , nodes , xids )
181
156
exec (conn2 , "select dtm_begin_transaction($1, $2)" , nodes , xids )
182
157
183
- exec (conn1 , "select dtm_get_snapshot()" )
184
- exec (conn2 , "select dtm_get_snapshot()" )
185
-
186
158
sum1 = execQuery (conn1 , "select sum(v) from t" )
187
159
sum2 = execQuery (conn2 , "select sum(v) from t" )
188
160
0 commit comments