1
1
import unittest
2
2
from sys import exit
3
3
from testgres import get_new_node , stop_all
4
- #import os
5
- from os import path , open , lseek , read , close , O_RDONLY
6
4
from .ptrack_helpers import ProbackupTest , idx_ptrack
7
5
8
- # res = node.execute('postgres', 'show fsync')
9
- # print res[0][0]
10
- # res = node.execute('postgres', 'show wal_level')
11
- # print res[0][0]
12
- # a = ProbackupTest
13
- # res = node.execute('postgres', 'select 1')`
14
- # self.assertEqual(len(res), 1)
15
- # self.assertEqual(res[0][0], 1)
16
- # node.stop()
17
- # a = self.backup_dir(node)
18
-
19
6
20
7
class SimpleTest (ProbackupTest , unittest .TestCase ):
21
8
def __init__ (self , * args , ** kwargs ):
@@ -27,8 +14,9 @@ def teardown(self):
27
14
28
15
# @unittest.skip("123")
29
16
def test_ptrack_cluster_btree (self ):
30
- print 'test_ptrack_cluster_btree started'
31
- node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/test_ptrack_cluster_btree" ,
17
+ fname = self .id ().split ('.' )[3 ]
18
+ print '{0} started' .format (fname )
19
+ node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/{0}" .format (fname ),
32
20
set_replication = True ,
33
21
initdb_params = ['--data-checksums' , '-A trust' ],
34
22
pg_options = {'ptrack_enable' : 'on' , 'wal_level' : 'replica' , 'max_wal_senders' : '2' })
@@ -56,7 +44,7 @@ def test_ptrack_cluster_btree(self):
56
44
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
57
45
# calculate md5sums of pages
58
46
idx_ptrack [i ]['old_pages' ] = self .get_md5_per_page_for_fork (
59
- idx_ptrack [i ]['old_size ' ], idx_ptrack [i ]['path ' ])
47
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['old_size ' ])
60
48
61
49
self .init_pb (node )
62
50
self .backup_pb (node , backup_type = 'full' , options = ['-j100' , '--stream' ])
@@ -72,19 +60,22 @@ def test_ptrack_cluster_btree(self):
72
60
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
73
61
# calculate new md5sums for pages
74
62
idx_ptrack [i ]['new_pages' ] = self .get_md5_per_page_for_fork (
75
- idx_ptrack [i ]['new_size ' ], idx_ptrack [i ]['path ' ])
63
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['new_size ' ])
76
64
# get ptrack for every idx
77
- idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (idx_ptrack [i ]['path' ])
65
+ idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (
66
+ idx_ptrack [i ]['path' ], idx_ptrack [i ]['new_size' ])
78
67
79
68
# compare pages and check ptrack sanity
80
69
self .check_ptrack_sanity (idx_ptrack [i ])
81
70
82
71
self .clean_pb (node )
83
72
node .stop ()
84
73
74
+ @unittest .skip ("123" )
85
75
def test_ptrack_cluster_spgist (self ):
86
- print 'test_ptrack_cluster_spgist started'
87
- node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/test_ptrack_cluster_spgist" ,
76
+ fname = self .id ().split ('.' )[3 ]
77
+ print '{0} started' .format (fname )
78
+ node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/{0}" .format (fname ),
88
79
set_replication = True ,
89
80
initdb_params = ['--data-checksums' , '-A trust' ],
90
81
pg_options = {'ptrack_enable' : 'on' , 'wal_level' : 'replica' , 'max_wal_senders' : '2' })
@@ -112,7 +103,7 @@ def test_ptrack_cluster_spgist(self):
112
103
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
113
104
# calculate md5sums of pages
114
105
idx_ptrack [i ]['old_pages' ] = self .get_md5_per_page_for_fork (
115
- idx_ptrack [i ]['old_size ' ], idx_ptrack [i ]['path ' ])
106
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['old_size ' ])
116
107
117
108
self .init_pb (node )
118
109
self .backup_pb (node , backup_type = 'full' , options = ['-j100' , '--stream' ])
@@ -128,19 +119,22 @@ def test_ptrack_cluster_spgist(self):
128
119
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
129
120
# calculate new md5sums for pages
130
121
idx_ptrack [i ]['new_pages' ] = self .get_md5_per_page_for_fork (
131
- idx_ptrack [i ]['new_size ' ], idx_ptrack [i ]['path ' ])
122
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['new_size ' ])
132
123
# get ptrack for every idx
133
- idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (idx_ptrack [i ]['path' ])
124
+ idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (
125
+ idx_ptrack [i ]['path' ], idx_ptrack [i ]['new_size' ])
134
126
135
127
# compare pages and check ptrack sanity
136
128
self .check_ptrack_sanity (idx_ptrack [i ])
137
129
138
130
self .clean_pb (node )
139
131
node .stop ()
140
132
133
+ @unittest .skip ("123" )
141
134
def test_ptrack_cluster_brin (self ):
142
- print 'test_ptrack_cluster_brin started'
143
- node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/test_ptrack_cluster_brin" ,
135
+ fname = self .id ().split ('.' )[3 ]
136
+ print '{0} started' .format (fname )
137
+ node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/{0}" .format (fname ),
144
138
set_replication = True ,
145
139
initdb_params = ['--data-checksums' , '-A trust' ],
146
140
pg_options = {'ptrack_enable' : 'on' , 'wal_level' : 'replica' , 'max_wal_senders' : '2' })
@@ -168,7 +162,7 @@ def test_ptrack_cluster_brin(self):
168
162
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
169
163
# calculate md5sums of pages
170
164
idx_ptrack [i ]['old_pages' ] = self .get_md5_per_page_for_fork (
171
- idx_ptrack [i ]['old_size ' ], idx_ptrack [i ]['path ' ])
165
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['old_size ' ])
172
166
173
167
self .init_pb (node )
174
168
self .backup_pb (node , backup_type = 'full' , options = ['-j100' , '--stream' ])
@@ -184,19 +178,22 @@ def test_ptrack_cluster_brin(self):
184
178
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
185
179
# calculate new md5sums for pages
186
180
idx_ptrack [i ]['new_pages' ] = self .get_md5_per_page_for_fork (
187
- idx_ptrack [i ]['new_size ' ], idx_ptrack [i ]['path ' ])
181
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['new_size ' ])
188
182
# get ptrack for every idx
189
- idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (idx_ptrack [i ]['path' ])
183
+ idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (
184
+ idx_ptrack [i ]['path' ], idx_ptrack [i ]['new_size' ])
190
185
191
186
# compare pages and check ptrack sanity
192
187
self .check_ptrack_sanity (idx_ptrack [i ])
193
188
194
189
self .clean_pb (node )
195
190
node .stop ()
196
191
192
+ @unittest .skip ("123" )
197
193
def test_ptrack_cluster_gist (self ):
198
- print 'test_ptrack_cluster_gist started'
199
- node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/test_ptrack_cluster_gist" ,
194
+ fname = self .id ().split ('.' )[3 ]
195
+ print '{0} started' .format (fname )
196
+ node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/{0}" .format (fname ),
200
197
set_replication = True ,
201
198
initdb_params = ['--data-checksums' , '-A trust' ],
202
199
pg_options = {'ptrack_enable' : 'on' , 'wal_level' : 'replica' , 'max_wal_senders' : '2' })
@@ -224,7 +221,7 @@ def test_ptrack_cluster_gist(self):
224
221
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
225
222
# calculate md5sums of pages
226
223
idx_ptrack [i ]['old_pages' ] = self .get_md5_per_page_for_fork (
227
- idx_ptrack [i ]['old_size ' ], idx_ptrack [i ]['path ' ])
224
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['old_size ' ])
228
225
229
226
self .init_pb (node )
230
227
self .backup_pb (node , backup_type = 'full' , options = ['-j100' , '--stream' ])
@@ -240,19 +237,22 @@ def test_ptrack_cluster_gist(self):
240
237
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
241
238
# calculate new md5sums for pages
242
239
idx_ptrack [i ]['new_pages' ] = self .get_md5_per_page_for_fork (
243
- idx_ptrack [i ]['new_size ' ], idx_ptrack [i ]['path ' ])
240
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['new_size ' ])
244
241
# get ptrack for every idx
245
- idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (idx_ptrack [i ]['path' ])
242
+ idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (
243
+ idx_ptrack [i ]['path' ], idx_ptrack [i ]['new_size' ])
246
244
247
245
# compare pages and check ptrack sanity
248
246
self .check_ptrack_sanity (idx_ptrack [i ])
249
247
250
248
self .clean_pb (node )
251
249
node .stop ()
252
250
251
+ @unittest .skip ("123" )
253
252
def test_ptrack_cluster_gin (self ):
254
- print 'test_ptrack_cluster_gin started'
255
- node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/test_ptrack_cluster_gin" ,
253
+ fname = self .id ().split ('.' )[3 ]
254
+ print '{0} started' .format (fname )
255
+ node = self .make_simple_node (base_dir = "tmp_dirs/ptrack/{0}" .format (fname ),
256
256
set_replication = True ,
257
257
initdb_params = ['--data-checksums' , '-A trust' ],
258
258
pg_options = {'ptrack_enable' : 'on' , 'wal_level' : 'replica' , 'max_wal_senders' : '2' })
@@ -280,7 +280,7 @@ def test_ptrack_cluster_gin(self):
280
280
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
281
281
# calculate md5sums of pages
282
282
idx_ptrack [i ]['old_pages' ] = self .get_md5_per_page_for_fork (
283
- idx_ptrack [i ]['old_size ' ], idx_ptrack [i ]['path ' ])
283
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['old_size ' ])
284
284
285
285
self .init_pb (node )
286
286
self .backup_pb (node , backup_type = 'full' , options = ['-j100' , '--stream' ])
@@ -296,9 +296,10 @@ def test_ptrack_cluster_gin(self):
296
296
idx_ptrack [i ]['path' ] = self .get_fork_path (node , i )
297
297
# calculate new md5sums for pages
298
298
idx_ptrack [i ]['new_pages' ] = self .get_md5_per_page_for_fork (
299
- idx_ptrack [i ]['new_size ' ], idx_ptrack [i ]['path ' ])
299
+ idx_ptrack [i ]['path ' ], idx_ptrack [i ]['new_size ' ])
300
300
# get ptrack for every idx
301
- idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (idx_ptrack [i ]['path' ])
301
+ idx_ptrack [i ]['ptrack' ] = self .get_ptrack_bits_per_for_fork (
302
+ idx_ptrack [i ]['path' ], idx_ptrack [i ]['new_size' ])
302
303
303
304
# compare pages and check ptrack sanity
304
305
self .check_ptrack_sanity (idx_ptrack [i ])
0 commit comments