11import unittest
22from sys import exit
33from testgres import get_new_node ,stop_all
4- #import os
5- from os import path ,open ,lseek ,read ,close ,O_RDONLY
64from .ptrack_helpers import ProbackupTest ,idx_ptrack
75
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-
196
207class SimpleTest (ProbackupTest ,unittest .TestCase ):
218def __init__ (self ,* args ,** kwargs ):
@@ -27,8 +14,9 @@ def teardown(self):
2714
2815# @unittest.skip("123")
2916def 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 ),
3220set_replication = True ,
3321initdb_params = ['--data-checksums' ,'-A trust' ],
3422pg_options = {'ptrack_enable' :'on' ,'wal_level' :'replica' ,'max_wal_senders' :'2' })
@@ -56,7 +44,7 @@ def test_ptrack_cluster_btree(self):
5644idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
5745# calculate md5sums of pages
5846idx_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 ' ])
6048
6149self .init_pb (node )
6250self .backup_pb (node ,backup_type = 'full' ,options = ['-j100' ,'--stream' ])
@@ -72,19 +60,22 @@ def test_ptrack_cluster_btree(self):
7260idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
7361# calculate new md5sums for pages
7462idx_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 ' ])
7664# 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' ])
7867
7968# compare pages and check ptrack sanity
8069self .check_ptrack_sanity (idx_ptrack [i ])
8170
8271self .clean_pb (node )
8372node .stop ()
8473
74+ @unittest .skip ("123" )
8575def 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 ),
8879set_replication = True ,
8980initdb_params = ['--data-checksums' ,'-A trust' ],
9081pg_options = {'ptrack_enable' :'on' ,'wal_level' :'replica' ,'max_wal_senders' :'2' })
@@ -112,7 +103,7 @@ def test_ptrack_cluster_spgist(self):
112103idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
113104# calculate md5sums of pages
114105idx_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 ' ])
116107
117108self .init_pb (node )
118109self .backup_pb (node ,backup_type = 'full' ,options = ['-j100' ,'--stream' ])
@@ -128,19 +119,22 @@ def test_ptrack_cluster_spgist(self):
128119idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
129120# calculate new md5sums for pages
130121idx_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 ' ])
132123# 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' ])
134126
135127# compare pages and check ptrack sanity
136128self .check_ptrack_sanity (idx_ptrack [i ])
137129
138130self .clean_pb (node )
139131node .stop ()
140132
133+ @unittest .skip ("123" )
141134def 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 ),
144138set_replication = True ,
145139initdb_params = ['--data-checksums' ,'-A trust' ],
146140pg_options = {'ptrack_enable' :'on' ,'wal_level' :'replica' ,'max_wal_senders' :'2' })
@@ -168,7 +162,7 @@ def test_ptrack_cluster_brin(self):
168162idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
169163# calculate md5sums of pages
170164idx_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 ' ])
172166
173167self .init_pb (node )
174168self .backup_pb (node ,backup_type = 'full' ,options = ['-j100' ,'--stream' ])
@@ -184,19 +178,22 @@ def test_ptrack_cluster_brin(self):
184178idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
185179# calculate new md5sums for pages
186180idx_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 ' ])
188182# 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' ])
190185
191186# compare pages and check ptrack sanity
192187self .check_ptrack_sanity (idx_ptrack [i ])
193188
194189self .clean_pb (node )
195190node .stop ()
196191
192+ @unittest .skip ("123" )
197193def 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 ),
200197set_replication = True ,
201198initdb_params = ['--data-checksums' ,'-A trust' ],
202199pg_options = {'ptrack_enable' :'on' ,'wal_level' :'replica' ,'max_wal_senders' :'2' })
@@ -224,7 +221,7 @@ def test_ptrack_cluster_gist(self):
224221idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
225222# calculate md5sums of pages
226223idx_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 ' ])
228225
229226self .init_pb (node )
230227self .backup_pb (node ,backup_type = 'full' ,options = ['-j100' ,'--stream' ])
@@ -240,19 +237,22 @@ def test_ptrack_cluster_gist(self):
240237idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
241238# calculate new md5sums for pages
242239idx_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 ' ])
244241# 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' ])
246244
247245# compare pages and check ptrack sanity
248246self .check_ptrack_sanity (idx_ptrack [i ])
249247
250248self .clean_pb (node )
251249node .stop ()
252250
251+ @unittest .skip ("123" )
253252def 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 ),
256256set_replication = True ,
257257initdb_params = ['--data-checksums' ,'-A trust' ],
258258pg_options = {'ptrack_enable' :'on' ,'wal_level' :'replica' ,'max_wal_senders' :'2' })
@@ -280,7 +280,7 @@ def test_ptrack_cluster_gin(self):
280280idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
281281# calculate md5sums of pages
282282idx_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 ' ])
284284
285285self .init_pb (node )
286286self .backup_pb (node ,backup_type = 'full' ,options = ['-j100' ,'--stream' ])
@@ -296,9 +296,10 @@ def test_ptrack_cluster_gin(self):
296296idx_ptrack [i ]['path' ]= self .get_fork_path (node ,i )
297297# calculate new md5sums for pages
298298idx_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 ' ])
300300# 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' ])
302303
303304# compare pages and check ptrack sanity
304305self .check_ptrack_sanity (idx_ptrack [i ])