def install_server(product,
edition,
version,
milestone,
branch,
windows,
old=False):
pg = PgInstall(product=product,
edition=edition,
version=version,
milestone=milestone,
branch=branch,
windows=windows)
pg.setup_repo()
if pg.os.is_altlinux() and pg.os.os_arch == 'aarch64':
os.environ['LANG'] = 'en_US.UTF-8'
if not windows:
if old and pg.os_name == 'SLES' and pg.os_version.startswith('12.'):
for pkg in pg.all_packages_in_repo[:]:
if ('libzstd' in pkg):
pg.all_packages_in_repo.remove(pkg)
# PGPRO-3889
if (pg.os_name.startswith('CentOS') or
pg.os_name.startswith('Red Hat') or
pg.os_name.startswith('Oracle Linux')) and \
pg.os_version.startswith('8'):
for pkg in pg.all_packages_in_repo[:]:
if ('jit' in pkg):
pg.all_packages_in_repo.remove(pkg)
pg.install_full_topless()
# PGPRO-2136
if pg.os_name in ALT_BASED:
with open('/etc/sysconfig/i18n', 'r') as file:
for line in file:
kv = line.split('=')
if len(kv) == 2:
os.environ[kv[0]] = kv[1].strip()
else:
pg.install_postgres_win()
pg.client_path_needed = True
pg.server_path_needed = True
pg.install_default_config()
pg.load_shared_libraries()
return pg
def test_multimaster_install(self, request):
"""
Scenario:
1. Install current version
2. Check that setup successfull (select version)
:return:
"""
if self.system == 'Linux':
dist = " ".join(get_distro()[0:2])
elif self.system == 'Windows':
dist = 'Windows'
else:
raise Exception("OS %s is not supported." % self.system)
version = request.config.getoption('--product_version')
name = request.config.getoption('--product_name')
edition = request.config.getoption('--product_edition')
milestone = request.config.getoption('--product_milestone')
target = request.config.getoption('--target')
product_info = " ".join([dist, name, edition, version])
tag_mark = allure.label(LabelType.TAG, product_info)
request.node.add_marker(tag_mark)
branch = request.config.getoption('--branch')
if version.startswith('9.') or version == '10' \
or version == '13' \
or not edition.startswith('ent'):
print('Version %s %s is not supported' % (edition, version))
return
elif version == '11' and dist == 'Windows':
print('Windows is not supported under version %s' % version)
return
# Step 1
pginst = PgInstall(product=name,
edition=edition,
version=version,
milestone=milestone,
branch=branch,
windows=(self.system == 'Windows'))
request.cls.pginst = pginst
if pginst.os.is_altlinux() and pginst.os.os_arch == 'aarch64':
os.environ['LANG'] = 'en_US.UTF-8'
pginst.setup_repo()
print("Running on %s." % target)
if self.system != 'Windows':
pginst.install_full_topless()
else:
pginst.install_postgres_win()
pginst.stop_service()
mm = Multimaster(size=2,
pginst=pginst,
rootdir=os.path.abspath(
os.path.join(pginst.get_datadir(), os.pardir)))
mm.start()
for i, cl_state in mm.get_cluster_state_all().items():
if int(cl_state[0]) != i:
raise Exception('Wrong ID on node %i! %i != %i' %
(i, i, cl_state[0]))
if cl_state[1].lower() != 'online':
print(cl_state)
raise Exception('Node %i is not online!' % i)
print(mm.get_nodes_state_all())
for i, ns_all in mm.get_nodes_state_all().items():
for node_state in ns_all:
if node_state[1].rstrip() != 't':
raise Exception('Node %s is not enabled! (on node %i)' %
(node_state[0], i))
pgbench = {}
for i, node in mm.nodes.items():
pgbench[i] = mm.pgbench(i,
type='simple-update',
duration=60,
max_tries=100)
pgbench[1].init()
for i in range(1, mm.size + 1):
if not mm.nodes[i].referee:
print('Running pgbench on node%i' % i)
pgbench[i].start()
mm.wait_for_txid(600)
print('Cluster state:')
print(mm.get_cluster_state_all())
print(mm.get_nodes_state_all())
print('Current TXID (after pgbench): %s' %
mm.psql('SELECT txid_current()', '-Aqt'))
print('Isolating node 2...')
mm.isolate(2)
if mm.has_referee:
mm.wait_for_referee(1, 60)
pgbench[1].wait()
pgbench[1].start()
mm.wait_for_txid(2700)
print('Cluster state:')
print(mm.get_cluster_state_all(allow_fail=True))
print(mm.get_nodes_state_all(allow_fail=True))
print('De-isolating node 2...')
mm.deisolate(2)
print('Current TXID (after isolation): %s' %
mm.psql('SELECT txid_current()', '-Aqt'))
if not mm.check(2):
print('Try to recover node 2')
mm.wait(2, 600)
print('Cluster state:')
print(mm.get_cluster_state_all(allow_fail=True))
print(mm.get_nodes_state_all(allow_fail=True))
mm.wait_for_txid(3500)
for i in range(1, mm.size):
if not mm.nodes[i].referee:
print('Pgbench %i terminated rc=%i' % (i, pgbench[i].stop()))
mm.sure_pgbench_is_dead(i)
pgbench_tables = ('pgbench_branches', 'pgbench_tellers',
'pgbench_accounts', 'pgbench_history')
print('Current TXID (after pgbench termination): %s' %
mm.psql('SELECT txid_current()', '-Aqt'))
for table in pgbench_tables:
result1 = mm.pg_dump(1, [table])
for i in range(2, mm.size + 1):
if not mm.nodes[i].referee:
result = mm.pg_dump(i, [table])
diff_dbs(result1, result, '%s_1_%i.diff' % (table, i))