Error when creating database after clean install of Vertica 7.0.0 on Red Hat EL6
Hello,
I am attempting a clean install of vertica-7.0.0-1.x86_64.RHEL5.rpm on 3 RHEL6 hosts, the dbadmin user exists and has SSH configured without password/passphrase prompts, as does the root user for the install. The steps I am using along with output and log files are below, the error on the terminal after the create database fails is:
adminTools Last Chance Error Handler running...
raised error: <type 'exceptions.TypeError'>
error message: 'NoneType' object is not subscriptable
the error trace file ends with:
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/network/SSH.py", line 1180, in createDBMultiNodes
portNo,bcastAddrs[nodeHosts[initiatorOffset]][0],
TypeError: 'NoneType' object is not subscriptable
Here are the steps, thank you.
rpm -ivh /tmp/vertica-7.0.0-1.x86_64.RHEL5.rpm
export SUDO_USER=root
/opt/vertica/sbin/install_vertica --hosts 192.168.20.20,192.168.20.21,192.168.20.22 --rpm /tmp/vertica-7.0.0-1.x86_64.RHEL5.rpm --failure-threshold FAIL --accept-eula --data-dir /data/1 --license /tmp/vlicense.dat
Vertica Analytic Database 7.0.0-1 Installation Tool
>> Validating options...
Upgrading admintools meta data format..
scanning /opt/vertica/config/users
Mapping hostnames in --hosts (-s) to addresses...
>> Starting installation tasks.
>> Getting system information for cluster (this may take a while)...
Default shell on nodes:
192.168.20.20 /bin/bash
192.168.20.21 /bin/bash
192.168.20.22 /bin/bash
>> Validating software versions (rpm or deb)...
>> Beginning new cluster creation...
backing up admintools.conf on 192.168.20.20
>> Installing software (rpm or deb)...
Installing rpm on 2 hosts....
installing node.... 192.168.20.21
installing node.... 192.168.20.22
>> Creating or validating DB Admin user/group...
Successful on hosts (3): 192.168.20.20 192.168.20.21 192.168.20.22
Provided DB Admin account details: user = dbadmin, group = verticadba, home = /home/dbadmin
Creating group... Group already exists
Validating group... Okay
Creating user... User already exists
Validating user... Okay
>> Validating node and cluster prerequisites...
Failures during local (OS) configuration for verify-192.168.20.20.xml:
HINT (S0231): https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=S0231
dbadmin user ('dbadmin') primary group is not verticadba ('verticadba')
WARN (S0170): https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=S0170
lvscan (LVM utility) indicates some active volumes.
Failures during local (OS) configuration for verify-192.168.20.21.xml:
HINT (S0231): https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=S0231
dbadmin user ('dbadmin') primary group is not verticadba ('verticadba')
WARN (S0170): https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=S0170
lvscan (LVM utility) indicates some active volumes.
Failures during local (OS) configuration for verify-192.168.20.22.xml:
HINT (S0231): https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=S0231
dbadmin user ('dbadmin') primary group is not verticadba ('verticadba')
WARN (S0170): https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=S0170
lvscan (LVM utility) indicates some active volumes.
Detected significant differences in the cluster:
HINT: Differences in logical CPU count:
verify-192.168.20.20.xml: 12
verify-192.168.20.21.xml: 12
verify-192.168.20.22.xml: 24
HINT: Differences in RAM (kbytes):
verify-192.168.20.20.xml: 32829528
verify-192.168.20.21.xml: 32829716
verify-192.168.20.22.xml: 49412412
HINT: Differences in OS Version:
verify-192.168.20.20.xml: /etc/redhat-release: Red Hat Enterprise Linux
Server release 6.5 (Santiago)
verify-192.168.20.21.xml: /etc/redhat-release: Red Hat Enterprise Linux
Server release 6.4 (Santiago)
verify-192.168.20.22.xml: /etc/redhat-release: Red Hat Enterprise Linux
Server release 6.5 (Santiago)
For more information, see
https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=CLREQ01
System prerequisites passed. Threshold = FAIL
>> Establishing DB Admin SSH connectivity...
Installing/Repairing SSH keys for dbadmin
>> Setting up each node and modifying cluster...
Creating Vertica Data Directory...
Updating agent...
Creating node node0001 definition for host 192.168.20.20
... Done
Creating node node0002 definition for host 192.168.20.21
... Done
Creating node node0003 definition for host 192.168.20.22
... Done
>> Sending new cluster configuration to all nodes...
>> Completing installation...
Running upgrade logic
No spread upgrade required: /opt/vertica/config/vspread.conf not found on any node
Installation complete.
Please evaluate your hardware using Vertica's validation tools:
https://my.vertica.com/docs/7.0.x/HTML/index.htm#cshid=VALSCRIPT
To create a database:
1. Logout and login as dbadmin. (see note below)
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu
Note: Installation may have made configuration changes to dbadmin
that do not take effect until the next session (logout and login).
To add or remove hosts, select Cluster Management from the Advanced Menu.
exit
sudo -u dbadmin -i
/opt/vertica/bin/adminTools
*** Creating database: vmartdb ***
192.168.20.20 OK [vertica][(7, 0, 0)][001][x86_64]
192.168.20.21 OK [vertica][(7, 0, 0)][001][x86_64]
192.168.20.22 OK [vertica][(7, 0, 0)][001][x86_64]
Checking full connectivity
Creating database vmartdb
adminTools Last Chance Error Handler running...
raised error: <type 'exceptions.TypeError'>
error message: 'NoneType' object is not subscriptable
trace file: /opt/vertica/log/adminTools-dbadmin.errors
REPORT THIS INFORMATION TO TECHNICAL SUPPORT
AND INCLUDE CONTENTS OF THE TRACE FILE IN YOUR REPORT
cat /opt/vertica/log/adminTools-dbadmin.errors
--------------------------------
handler invoked: 2014-01-15 07:18:32
raised error: <type 'exceptions.TypeError'>
Traceback (most recent call last):
File "/opt/vertica/bin/adminTools", line 374, in <module>
ac.runApp()
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/adminCtrl.py", line 3409, in runApp
self.__ui.runFromNavigation("main")
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/uiMgr.py", line 165, in a_wrapper_accepting_args
fn(self, *args, **kwargs)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/uiMgr.py", line 450, in runFromNavigation
self.__navigator.navigate(uimanager=self, startingPoint=runFrom)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/Navigator.py", line 315, in navigate
((self.__menus[ nextMenu ][ self.NAV_MACTIONS ])[ offset ])()
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/ui/adminCtrl.py", line 1659, in createDB
result, info = self.__exec.createDB(DBName, nodesInDB, DBpassword=DBpassword, licenseFile=DBinclude.LICENSE_KEY)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/engine/adminExec.py", line 2844, in createDB
logger=logger)
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/network/SSH.py", line 1180, in createDBMultiNodes
portNo,bcastAddrs[nodeHosts[initiatorOffset]][0],
TypeError: 'NoneType' object is not subscriptable
cat /opt/vertica/log/uiMgr-dbadmin.log
## Starting uiMgr at Wed Jan 15 07:16:32 2014
UIRequest: runFromNavigation('main',)
UIRequest: showMenu(vertica.ui.Navigator.Navigator Instance, 'main')
UIResponse: (0, '6')
UIRequest: showMenu(vertica.ui.Navigator.Navigator Instance, 'main_config')
UIResponse: (0, '1')
UIRequest: displayForm('createDB',)
UIResponse: (0, ['vmartdb', ''])
UIRequest: passwordPrompter('Enter a password for new database: ',)
UIResponse: ('***********',)
UIRequest: passwordPrompter('Re-enter password to confirm: ',)
UIResponse: ('***********',)
UIRequest: multiListSelect('Select hosts for the database', [['192.168.20.20', '', 'on'], ['192.168.20.21', '', 'on'], ['192.168.20.22', '', 'on']])
UIResponse: (0, ['192.168.20.20', '192.168.20.21', '192.168.20.22'])
UIRequest: displayForm[('createDBQuickStart',),{'defaultValues': ['/data/1', '/data/1']}]
UIResponse: (0, ['/data/1', '/data/1'])
UIRequest: confirmAction[('createDBConfirm', ['vmartdb', '']),{'additionalInputs': ['Hosts:', ['192.168.20.20', '192.168.20.21', '192.168.20.22']]}]
UIResponse: (True,)
UIRequest: clearScreen()
cat /opt/vertica/log/adminTools-dbadmin.log
Jan 15 07:15:18 [adminExec.__init__] Unique Ports: False
Jan 15 07:15:18 [adminExec.setInteractive] setting to False
Jan 15 07:15:18 [INotifyService.listen] registered listener <function dc_statechange_listener at 0x1a33320>
Jan 15 07:15:18 [INotifyService.listen] registered listener <function dc_nodestate_listener at 0x1a332a8>
Jan 15 07:15:18 [INotifyService.listen] registered listener <function dc_event_listener at 0x1a33398>
Jan 15 07:15:18 [INotifyService.listen] registered listener <function dc_design_listener at 0x1a33410>
Jan 15 07:16:32 [adminExec.__init__] Unique Ports: False
Jan 15 07:16:32 [isOkToRun] owner of admintools.conf (dbauser) is dbadmin.
Jan 15 07:16:32 [adminTools] Starting admin tools (['/opt/vertica/bin/adminTools'])...
Jan 15 07:16:32 [adminTools] Use unique ports = False
Jan 15 07:16:32 [adminTools] Configuration=
DBinclude.ADMINTOOLS_CONF=/opt/vertica/config/admintools.conf
DBinclude.ADMIN_DIR=/opt/vertica/bin
DBinclude.CHECK_FAILED=-1
DBinclude.CONFIG_DIR=/opt/vertica/config
DBinclude.CONFIG_INFO_DIR=/opt/vertica/config/configInfo
DBinclude.CONFIG_SHARE_DIR=/opt/vertica/config/share
DBinclude.CONFIG_USER_DIR=/opt/vertica/config/users
DBinclude.DB_DIR=/opt/vertica
DBinclude.DBname=<module 'vertica.config.DBname' from '/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/config/DBname.pyc'>
DBinclude.DEFAULT_RESTART_POLICY=ksafe
DBinclude.HELP_DIR=/opt/vertica/bin/help
DBinclude.LCHK_DIR=/opt/vertica/bin
DBinclude.LICENSE_KEY=/opt/vertica/config/share/license.key
DBinclude.LOG=0
DBinclude.LOG_DIR=/opt/vertica/log
DBinclude.MAX_KSAFETY=2
DBinclude.NAG_COUNT=0
DBinclude.NAG_FLAG=0
DBinclude.NAG_MSG={}
DBinclude.OLD_SPREAD_CONF=/opt/vertica/config/vspread.conf
DBinclude.OSNAME=RHEL5
DBinclude.OSS_DIR=/opt/vertica/oss
DBinclude.OS_DEBIAN=7
DBinclude.OS_DEBIAN_S=DEBIAN
DBinclude.OS_FEDORA=4
DBinclude.OS_FEDORA_S=FEDORA
DBinclude.OS_RHEL4=1
DBinclude.OS_RHEL4_S=RHEL4
DBinclude.OS_RHEL5=5
DBinclude.OS_RHEL5_S=RHEL5
DBinclude.OS_SUSE=3
DBinclude.OS_SUSE_S=SUSE
DBinclude.OS_UNSUPPORT=0
DBinclude.PACKAGES_DIR=/opt/vertica/packages
DBinclude.PACKAGE_DESC_FILE=package.conf
DBinclude.PACKAGE_INSTALL_SCRIPT=ddl/install.sql
DBinclude.PACKAGE_ISINSTALLED_SCRIPT=ddl/isinstalled.sql
DBinclude.PACKAGE_UNINSTALL_SCRIPT=ddl/uninstall.sql
DBinclude.PYTHON_BINARY=/opt/vertica/oss/python/bin/python
DBinclude.RESTART_POLICY_LIST=('never', 'ksafe', 'always')
DBinclude.SCRIPT_DIR=/opt/vertica/scripts
DBinclude.SHARE_DIR=/opt/vertica/share
DBinclude.TMP_DIR=/tmp
DBinclude.VERTICA_EGGS=/opt/vertica/share/eggs
DBinclude.adminToolErrorLog=/opt/vertica/log/adminTools-dbadmin.errors
DBinclude.adminToolLog=/opt/vertica/log/adminTools-dbadmin.log
DBinclude.adminToolLogUser=dbadmin
DBinclude.agentToolLog=/opt/vertica/log/agentTool-dbadmin.log
DBinclude.binDir=/opt/vertica/bin
DBinclude.binPath=/opt/vertica/bin/vertica
DBinclude.binPathCmdSetting=PATH=/opt/vertica/bin:$PATH; export PATH
DBinclude.commands=<module 'commands' from '/opt/vertica/oss/python/lib/python2.7/commands.pyc'>
DBinclude.copy=<module 'copy' from '/opt/vertica/oss/python/lib/python2.7/copy.pyc'>
DBinclude.dbDesignerConfig=/opt/vertica/config/configInfo/dbDesignerConfig
DBinclude.designParamsFile=design_params.txt
DBinclude.designParamsFileSuffix=_params.txt
DBinclude.designSchemaFileSuffix=_schema.xml
DBinclude.designerDiagManifest=/opt/vertica/log/DesignerDiagManifest.txt
DBinclude.designerErrorFile=designer_error.msg
DBinclude.designerLog=designer.log
DBinclude.getStringRep=<function getStringRep at 0x1a45c80>
DBinclude.glob=<module 'glob' from '/opt/vertica/oss/python/lib/python2.7/glob.pyc'>
DBinclude.help_url=<function help_url at 0x1a45d70>
DBinclude.libDir=/opt/vertica/lib
DBinclude.os=<module 'os' from '/opt/vertica/oss/python/lib/python2.7/os.pyc'>
DBinclude.pwd=<module 'pwd' (built-in)>
DBinclude.re=<module 're' from '/opt/vertica/oss/python/lib/python2.7/re.pyc'>
DBinclude.redesignParamsFile=redesign_params.txt
DBinclude.rpmDestFile=/tmp/dbRPM.rpm
DBinclude.rpmFC4_SrcInfoFile=/opt/vertica/config/configInfo/rpmFC4Info
DBinclude.rpmRHEL_SrcInfoFile=/opt/vertica/config/configInfo/rpmRHELInfo
DBinclude.rpmSUSE_SrcInfoFile=/opt/vertica/config/configInfo/rpmSUSEInfo
DBinclude.sbinDir=/opt/vertica/sbin
DBinclude.sys=<module 'sys' (built-in)>
DBinclude.uiMgrInput=None
DBinclude.uiMgrLog=/opt/vertica/log/uiMgr-dbadmin.log
Jan 15 07:16:32 [adminExec.__init__] Unique Ports: False
Jan 15 07:16:32 [adminExec.setInteractive] setting to True
Jan 15 07:16:32 [isOkToRun] owner of admintools.conf (dbauser) is dbadmin.
Jan 15 07:18:12 <PexpectAdapter: dbadmin@192.168.20.21>: login start: ssh -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -l dbadmin 192.168.20.21
Jan 15 07:18:12 <PexpectAdapter: dbadmin@192.168.20.22>: login start: ssh -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -l dbadmin 192.168.20.22
Jan 15 07:18:13 <BashAdapter: dbadmin@192.168.20.20>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.21>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.22>: <command hidden>
Jan 15 07:18:13 <BashAdapter: dbadmin@192.168.20.20>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.21>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.22>: <command hidden>
Jan 15 07:18:13 <BashAdapter: dbadmin@192.168.20.20>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.21>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.22>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.21>: <command hidden>
Jan 15 07:18:13 <BashAdapter: dbadmin@192.168.20.20>: <command hidden>
Jan 15 07:18:13 <PexpectAdapter: dbadmin@192.168.20.22>: <command hidden>
Jan 15 07:18:14 <BashAdapter: dbadmin@192.168.20.20>: <command hidden>
Jan 15 07:18:14 <PexpectAdapter: dbadmin@192.168.20.21>: <command hidden>
Jan 15 07:18:14 <PexpectAdapter: dbadmin@192.168.20.22>: <command hidden>
Jan 15 07:18:14 <PexpectAdapter: dbadmin@192.168.20.21>: closeConnection
Jan 15 07:18:14 <PexpectAdapter: dbadmin@192.168.20.22>: closeConnection
Jan 15 07:18:15 [adminExec.isNodeDefined] qry: '['v_vmartdb_node0001', '192.168.20.20', '/data/1', '/data/1']'
Jan 15 07:18:15 [adminExec.do_create_node] creating node w/ ['v_vmartdb_node0001', '192.168.20.20', '/data/1', '/data/1']
Jan 15 07:18:15 [adminExec.do_create_node] creating node w/ ['v_vmartdb_node0001', '192.168.20.20', '/data/1', '/data/1']
Jan 15 07:18:15 [adminExec.isNodeDefined] qry: '['v_vmartdb_node0001', '192.168.20.20', '/data/1', '/data/1']'
Jan 15 07:18:15 [adminExec.isNodeDefined] qry: '['v_vmartdb_node0002', '192.168.20.21', '/data/1', '/data/1']'
Jan 15 07:18:15 [adminExec.do_create_node] creating node w/ ['v_vmartdb_node0002', '192.168.20.21', '/data/1', '/data/1']
Jan 15 07:18:15 [adminExec.do_create_node] creating node w/ ['v_vmartdb_node0002', '192.168.20.21', '/data/1', '/data/1']
Jan 15 07:18:15 [adminExec.isNodeDefined] qry: '['v_vmartdb_node0002', '192.168.20.21', '/data/1', '/data/1']'
Jan 15 07:18:15 [adminExec.isNodeDefined] qry: '['v_vmartdb_node0003', '192.168.20.22', '/data/1', '/data/1']'
Jan 15 07:18:15 [adminExec.do_create_node] creating node w/ ['v_vmartdb_node0003', '192.168.20.22', '/data/1', '/data/1']
Jan 15 07:18:15 [adminExec.do_create_node] creating node w/ ['v_vmartdb_node0003', '192.168.20.22', '/data/1', '/data/1']
Jan 15 07:18:15 [adminExec.isNodeDefined] qry: '['v_vmartdb_node0003', '192.168.20.22', '/data/1', '/data/1']'
Jan 15 07:18:15 <PexpectAdapter: dbadmin@192.168.20.22>: login start: ssh -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -l dbadmin 192.168.20.22
Jan 15 07:18:15 <PexpectAdapter: dbadmin@192.168.20.21>: login start: ssh -oConnectTimeout=30 -o TCPKeepAlive=no -o ServerAliveInterval=15 -o ServerAliveCountMax=2 -l dbadmin 192.168.20.21
Jan 15 07:18:16 <PexpectAdapter: dbadmin@192.168.20.21>: install --owner dbadmin --mode 700 -d /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:16 <PexpectAdapter: dbadmin@192.168.20.22>: install --owner dbadmin --mode 700 -d /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:16 <PexpectAdapter: dbadmin@192.168.20.22>: (rc=0) []
Jan 15 07:18:16 <PexpectAdapter: dbadmin@192.168.20.21>: (rc=0) []
Jan 15 07:18:16 Scp outbound: local_file: /opt/vertica/config/admintools.conf, remote_file: dbadmin@192.168.20.21:/tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file
Jan 15 07:18:16 Scp outbound: local_file: /opt/vertica/config/admintools.conf, remote_file: dbadmin@192.168.20.22:/tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.21>: mv -f /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file /opt/vertica/config/admintools.conf
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.22>: mv -f /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file /opt/vertica/config/admintools.conf
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.22>: (rc=0) []
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.21>: (rc=0) []
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.21>: rm -rf /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.22>: rm -rf /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.22>: (rc=0) []
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.21>: (rc=0) []
Jan 15 07:18:17 <BashAdapter: dbadmin@192.168.20.20>: <command hidden>
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.21>: <command hidden>
Jan 15 07:18:17 <PexpectAdapter: dbadmin@192.168.20.22>: <command hidden>
Jan 15 07:18:23 [adminExec.createDB] creating db vmartdb
Jan 15 07:18:23 Running integrity checks
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.20", "node":"v_vmartdb_node0001", "dbname":"vmartdb", "msg":"Running Integrity Checks", "maxSteps":"6", "currStep":"1"}
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.21", "node":"v_vmartdb_node0002", "dbname":"vmartdb", "msg":"Running Integrity Checks", "maxSteps":"6", "currStep":"1"}
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.22", "node":"v_vmartdb_node0003", "dbname":"vmartdb", "msg":"Running Integrity Checks", "maxSteps":"6", "currStep":"1"}
Jan 15 07:18:23 Will create database on port 5433
Jan 15 07:18:23 Checking that nodes are defined and installed
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.20", "node":"v_vmartdb_node0001", "dbname":"vmartdb", "msg":"Validating RPM", "maxSteps":"6", "currStep":"2"}
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.21", "node":"v_vmartdb_node0002", "dbname":"vmartdb", "msg":"Validating RPM", "maxSteps":"6", "currStep":"2"}
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.22", "node":"v_vmartdb_node0003", "dbname":"vmartdb", "msg":"Validating RPM", "maxSteps":"6", "currStep":"2"}
Jan 15 07:18:23 <BashAdapter: dbadmin@192.168.20.20> (package version check): ['rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\\n"']
Jan 15 07:18:23 <BashAdapter: dbadmin@192.168.20.20>: (rc=0) ['vertica 7.0.0 1 x86_64']
Jan 15 07:18:23 [adminExec.validateRpmVersion]: checking remote nodes ['192.168.20.20', '192.168.20.21', '192.168.20.22'] for version [vertica][(7, 0, 0)][001]
Jan 15 07:18:23 [adminExec.validateRpmVersion]: checking installed versions on host 192.168.20.20
Jan 15 07:18:23 <BashAdapter: dbadmin@192.168.20.20> (package version check): ['rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\\n"']
Jan 15 07:18:23 <BashAdapter: dbadmin@192.168.20.20>: (rc=0) ['vertica 7.0.0 1 x86_64']
Jan 15 07:18:23 [adminExec.validateRpmVersion]: found [vertica][(7, 0, 0)][001][x86_64]
Jan 15 07:18:23 [adminExec.validateRpmVersion]: checking installed versions on host 192.168.20.21
Jan 15 07:18:23 <PexpectAdapter: dbadmin@192.168.20.21>: (package version check) rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\n"
Jan 15 07:18:23 <PexpectAdapter: dbadmin@192.168.20.21>: (rc=0) ['vertica 7.0.0 1 x86_64']
Jan 15 07:18:23 [adminExec.validateRpmVersion]: found [vertica][(7, 0, 0)][001][x86_64]
Jan 15 07:18:23 [adminExec.validateRpmVersion]: checking installed versions on host 192.168.20.22
Jan 15 07:18:23 <PexpectAdapter: dbadmin@192.168.20.22>: (package version check) rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\n"
Jan 15 07:18:23 <PexpectAdapter: dbadmin@192.168.20.22>: (rc=0) ['vertica 7.0.0 1 x86_64']
Jan 15 07:18:23 [adminExec.validateRpmVersion]: found [vertica][(7, 0, 0)][001][x86_64]
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.20", "node":"v_vmartdb_node0001", "dbname":"vmartdb", "msg":"Validating Cluster", "maxSteps":"6", "currStep":"3"}
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.21", "node":"v_vmartdb_node0002", "dbname":"vmartdb", "msg":"Validating Cluster", "maxSteps":"6", "currStep":"3"}
Jan 15 07:18:23 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.22", "node":"v_vmartdb_node0003", "dbname":"vmartdb", "msg":"Validating Cluster", "maxSteps":"6", "currStep":"3"}
Jan 15 07:18:23 <BashAdapter: dbadmin@192.168.20.20>: <command hidden>
Jan 15 07:18:23 <PexpectAdapter: dbadmin@192.168.20.21>: <command hidden>
Jan 15 07:18:23 <PexpectAdapter: dbadmin@192.168.20.22>: <command hidden>
Jan 15 07:18:24 True {'192.168.20.20': []} None []
Jan 15 07:18:24 <PexpectAdapter: dbadmin@192.168.20.21>: install --owner dbadmin --mode 700 -d /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:24 <PexpectAdapter: dbadmin@192.168.20.22>: install --owner dbadmin --mode 700 -d /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:24 <PexpectAdapter: dbadmin@192.168.20.22>: (rc=0) []
Jan 15 07:18:24 <PexpectAdapter: dbadmin@192.168.20.21>: (rc=0) []
Jan 15 07:18:24 Scp outbound: local_file: /opt/vertica/config/share/license.key, remote_file: dbadmin@192.168.20.21:/tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a/file
Jan 15 07:18:25 Scp outbound: local_file: /opt/vertica/config/share/license.key, remote_file: dbadmin@192.168.20.22:/tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a/file
Jan 15 07:18:25 <PexpectAdapter: dbadmin@192.168.20.21>: mv -f /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a/file /opt/vertica/config/share/license.key
Jan 15 07:18:25 <PexpectAdapter: dbadmin@192.168.20.22>: mv -f /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a/file /opt/vertica/config/share/license.key
Jan 15 07:18:25 <PexpectAdapter: dbadmin@192.168.20.22>: (rc=0) []
Jan 15 07:18:25 <PexpectAdapter: dbadmin@192.168.20.21>: (rc=0) []
Jan 15 07:18:25 <PexpectAdapter: dbadmin@192.168.20.21>: rm -rf /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:25 <PexpectAdapter: dbadmin@192.168.20.22>: rm -rf /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:26 <PexpectAdapter: dbadmin@192.168.20.22>: (rc=0) []
Jan 15 07:18:26 <PexpectAdapter: dbadmin@192.168.20.21>: (rc=0) []
Jan 15 07:18:26 Nominated initiator node v_vmartdb_node0001
Jan 15 07:18:26 Creating catalog and data directories
Jan 15 07:18:26 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.20", "node":"v_vmartdb_node0001", "dbname":"vmartdb", "msg":"Creating Catalog and Data Directories", "maxSteps":"6", "currStep":"4"}
Jan 15 07:18:26 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.21", "node":"v_vmartdb_node0002", "dbname":"vmartdb", "msg":"Creating Catalog and Data Directories", "maxSteps":"6", "currStep":"4"}
Jan 15 07:18:26 {"type":"NODEHOST", "state":"VALIDATING", "host":"192.168.20.22", "node":"v_vmartdb_node0003", "dbname":"vmartdb", "msg":"Creating Catalog and Data Directories", "maxSteps":"6", "currStep":"4"}
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: ['[ -e /data/1/vmartdb ]']
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: (rc=1) []
Jan 15 07:18:26 [makeDir] mkdir -p --mode=770 /data/1/vmartdb/v_vmartdb_node0001_catalog
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: ['mkdir -p --mode=770 /data/1/vmartdb/v_vmartdb_node0001_catalog']
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: (rc=0) []
Jan 15 07:18:26 [makeDir ret] 0
Jan 15 07:18:26 [makeDir] mkdir -p --mode=770 /data/1/vmartdb/v_vmartdb_node0001_data
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: ['mkdir -p --mode=770 /data/1/vmartdb/v_vmartdb_node0001_data']
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: (rc=0) []
Jan 15 07:18:26 [makeDir ret] 0
Jan 15 07:18:26 [prepareDBs] echo 5433 >/data/1/vmartdb/port.dat
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: ['echo 5433 >/data/1/vmartdb/port.dat']
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: (rc=0) []
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: ['[ -e /opt/vertica/config/logrotate ]']
Jan 15 07:18:26 <BashAdapter: dbadmin@192.168.20.20>: (rc=0) []
Jan 15 07:18:26 [prepareDBs] logrotate create file:echo '/data/1/vmartdb/v_vmartdb_node0001_catalog/vertica.log /data/1/vmartdb/v_vmartdb_node0001_catalog/UDxLogs/UDxFencedProcesses.log {
# rotate weekly
weekly
# and keep for 52 weeks
rotate 52
# no complaining if vertica did not start yet
missingok
# compress log after rotation
compress
# no creating a new empty log, vertica will do that
nocreate
# if set, only rotates when log size is greater than X
size 10M
# delete files after 90 days (not all logrotate pkgs support this keyword)
# maxage 90
# we have 2 log files to rotate but only signal vertica once
sharedscripts
# signal vertica to reopen and create the log
postrotate
kill -USR1 'head -1 /data/1/vmartdb/v_vmartdb_node0001_catalog/vertica.pid 2> /dev/null' 2> /dev/null || true
endscript
}
/data/1/vmartdb/dbLog {
# rotate weekly
weekly
# and keep for 52 weeks
rotate 52
# no complaining if vertica did not start yet
Comments
--control-network 192.168.20.255
to the install script.
In vertica/network/SSH.py getNetworkProfiles uses nicInfoFromIfconfig to look for the broadcast address on each host in the output from ifconfig.
https://community.vertica.com/vertica/topics/patch_for_vertica_7_vertica_network_ssh_py_in_nicinfofr...