The Vertica Forum recently got a makeover! Let us know what you think by filling out this short survey.

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: [email protected]>: 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: [email protected]>: 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: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <BashAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <BashAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <BashAdapter: [email protected]>: <command hidden>
Jan 15 07:18:13  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:14  <BashAdapter: [email protected]>: <command hidden>
Jan 15 07:18:14  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:14  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:14  <PexpectAdapter: [email protected]>: closeConnection
Jan 15 07:18:14  <PexpectAdapter: [email protected]>: 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: [email protected]>: 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: [email protected]>: 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: [email protected]>: install --owner dbadmin --mode 700 -d /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:16  <PexpectAdapter: [email protected]>: install --owner dbadmin --mode 700 -d /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:16  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:16  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:16  Scp outbound: local_file: /opt/vertica/config/admintools.conf, remote_file: [email protected]:/tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file
Jan 15 07:18:16  Scp outbound: local_file: /opt/vertica/config/admintools.conf, remote_file: [email protected]:/tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: mv -f /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file /opt/vertica/config/admintools.conf
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: mv -f /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e/file /opt/vertica/config/admintools.conf
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: rm -rf /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: rm -rf /tmp/vstage-fd3e0ec9-dd9e-4f59-86c6-1dc35d99ea0e
Jan 15 07:18:17  <PexpectAdapter: [email protected]2.168.20.22>: (rc=0) []
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:17  <BashAdapter: [email protected]>: <command hidden>
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:17  <PexpectAdapter: [email protected]>: <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: [email protected]> (package version check): ['rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\\n"']
Jan 15 07:18:23  <BashAdapter: [email protected]>: (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: [email protected]> (package version check): ['rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\\n"']
Jan 15 07:18:23  <BashAdapter: [email protected]>: (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: [email protected]>: (package version check) rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\n"
Jan 15 07:18:23  <PexpectAdapter: [email protected]>: (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: [email protected]>: (package version check) rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\n"
Jan 15 07:18:23  <PexpectAdapter: [email protected]>: (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: [email protected]>: <command hidden>
Jan 15 07:18:23  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:23  <PexpectAdapter: [email protected]>: <command hidden>
Jan 15 07:18:24  True {'192.168.20.20': []} None []
Jan 15 07:18:24  <PexpectAdapter: [email protected]>: install --owner dbadmin --mode 700 -d /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:24  <PexpectAdapter: [email protected]>: install --owner dbadmin --mode 700 -d /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:24  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:24  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:24  Scp outbound: local_file: /opt/vertica/config/share/license.key, remote_file: [email protected]:/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: [email protected]:/tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a/file
Jan 15 07:18:25  <PexpectAdapter: [email protected]>: mv -f /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a/file /opt/vertica/config/share/license.key
Jan 15 07:18:25  <PexpectAdapter: [email protected]>: mv -f /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a/file /opt/vertica/config/share/license.key
Jan 15 07:18:25  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:25  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:25  <PexpectAdapter: [email protected]>: rm -rf /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:25  <PexpectAdapter: [email protected]>: rm -rf /tmp/vstage-4e7ca773-712c-4eb4-bb61-34375c5d3d1a
Jan 15 07:18:26  <PexpectAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:26  <PexpectAdapter: [email protected]>: (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: [email protected]>: ['[ -e /data/1/vmartdb ]']
Jan 15 07:18:26  <BashAdapter: [email protected]>: (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: [email protected]>: ['mkdir -p --mode=770 /data/1/vmartdb/v_vmartdb_node0001_catalog']
Jan 15 07:18:26  <BashAdapter: [email protected]>: (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: [email protected]>: ['mkdir -p --mode=770 /data/1/vmartdb/v_vmartdb_node0001_data']
Jan 15 07:18:26  <BashAdapter: [email protected]>: (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: [email protected]>: ['echo 5433 >/data/1/vmartdb/port.dat']
Jan 15 07:18:26  <BashAdapter: [email protected]>: (rc=0) []
Jan 15 07:18:26  <BashAdapter: [email protected]>: ['[ -e /opt/vertica/config/logrotate ]']
Jan 15 07:18:26  <BashAdapter: [email protected]>: (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

  • I have also run /opt/vertica/bin/vnetperf and can confirm TCP and UDP connectivity.
  • I found the problem, user error.  I needed to pass in:
      --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.
  • I needed to patch the code to get it to correctly parse the output from ifconfig on these hosts, while parsing ifconfig output it was incorrectly returning 127.0.0.1 as the IP addr as the regexp used was incorrectly spanning both the local loopback interface and the interface using the target IP address.  Details in:
    https://community.vertica.com/vertica/topics/patch_for_vertica_7_vertica_network_ssh_py_in_nicinfofr...

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.