Options
Unable to read bootstrap node metadata.
Hi, I install vertica on ubuntu 12.04, but I can not create a database. Please help.
Log admintools
Log admintools
Oct 18 20:45:43 [1858] <------>Creating database. Oct 18 20:45:43 [1858] [SSH.createDBMultiNodes] bootstrapping with idx 0 node v_ert_node0001 on host 127.0.0.1. Oct 18 20:45:43 [1858] [SSH.createDBMultiNodes] bootstrap cmd '/opt/vertica/bin/bootstrap-catalog -C 'ert' -H '127.0.0.1' -s 'v_ert_node0001' -D '/db/vertica/ert/v_ert_node0001_catalog' -S '/db/vertica/er Oct 18 20:45:43 [1858] (Bootstrapping database ert): . Oct 18 20:45:43 [1858] [SSH.createDBMultiNodes] cmd output '['0', ['License installed for Vertica Community Edition ', '', 'Catalog successfully bootstrapped']]'. Oct 18 20:45:43 [1858] (Reading bootstrap catalog): . Oct 18 20:45:44 [1858] Unable to read bootstrap node metadata. Expected JSON DB desc, got: Stopping editor Error stopping editor: [Errno 3] No such process Traceback (most recent call last): File "/opt/vertica/oss/python/lib/python2.7/runpy.py", line 162, in _run_module_as_main "__main__", fname, loader, pkg_name) File "/opt/vertica/oss/python/lib/python2.7/runpy.py", line 72, in _run_code exec code in run_globals File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 296, in readAndOutputJSON(sys.argv[1], len(sys.argv) > 2 and sys.argv[2] == "silent") File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 288, in readAndOutputJSON db.loadFromCatalog(ce) File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 136, in loadFromCatalog self.name = ce.sendCmd("get singleton Database name").strip() File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/tools/CatalogEditor.py", line 53, in sendCmd self.ceproc.stdin.write(cmd+"\n") IOError: [Errno 32] Broken pipe Exception OSError: (32, 'Broken pipe') in > ignored. Oct 18 20:45:44 [1858] <------>Multi-node start returns: 0. Oct 18 20:45:44 [1858] [killVerticaProcess] [ -e /db/vertica/ert/v_ert_node0001_catalog/vertica.pid ]. Oct 18 20:45:44 [1858] : ['[ -e /db/vertica/ert/v_ert_node0001_catalog/vertica.pid ]']. Oct 18 20:45:44 [1858] : (rc=1) [].
0
Comments
At your earliest convenience, please send in the output of the following command run on the Vertica node you're attempting to create the database on:
ulimit -u
Thanks,
Rory
This is my adminTools-dbadmin.log:
Dec 5 19:31:11 [1860] <BashAdapter: dbadmin@127.0.0.1>: (rc=255) ['Stopping editor', 'Error stopping editor: [Errno 3] No such process', 'Traceback (most recent call last):', ' File "/opt/vertica/oss/python/lib/python2.7/runpy.py", line 162, in _run_module_as_main', ' "__main__", fname, loader, pkg_name)', ' File "/opt/vertica/oss/python/lib/python2.7/runpy.py", line 72, in _run_code', ' exec code in run_globals', ' File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 382, in <module>', ' readAndOutputJSON(sys.argv[1], len(sys.argv) > 2 and sys.argv[2] == "silent")', ' File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 373, in readAndOutputJSON', ' db.loadFromCatalog(ce)', ' File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 221, in loadFromCatalog', ' self.name = ce.sendCmd("get singleton Database name").strip()', ' File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/tools/CatalogEditor.py", line 72, in sendCmd', ' self.ceproc.stdin.write(cmd+"\\n")', 'IOError: [Errno 32] Broken pipe']Dec 5 19:31:11 [1860] Unable to read bootstrap node metadata. Expected JSON DB desc, got: Stopping editor
Error stopping editor: [Errno 3] No such process
Traceback (most recent call last):
File "/opt/vertica/oss/python/lib/python2.7/runpy.py", line 162, in _run_module_as_main
"__main__", fname, loader, pkg_name)
File "/opt/vertica/oss/python/lib/python2.7/runpy.py", line 72, in _run_code
exec code in run_globals
File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 382, in <module>
readAndOutputJSON(sys.argv[1], len(sys.argv) > 2 and sys.argv[2] == "silent")
File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 373, in readAndOutputJSON
db.loadFromCatalog(ce)
File "/opt/vertica/share/eggs/vertica/config/VDatabase.py", line 221, in loadFromCatalog
self.name = ce.sendCmd("get singleton Database name").strip()
File "/opt/vertica/oss/python/lib/python2.7/site-packages/vertica/tools/CatalogEditor.py", line 72, in sendCmd
self.ceproc.stdin.write(cmd+"\n")
IOError: [Errno 32] Broken pipe
admintools.conf:
[Configuration]
last_port = 5433
tmp_dir = /tmp
default_base = /home/dbadmin
format = 3
install_opts = --hosts localhost --failure-threshold FAIL
spreadlog = False
controlsubnet = default
controlmode = broadcast
[Cluster]
hosts = 127.0.0.1
[Nodes]
node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin
ulimit -n returns 65536.
In my case, it was a locale configuration issue, which prevented the vertica binary from successfully starting.
To see if you have this issue, run the following command
locale
If you see warnings or errors, you have to fix them.
Once I did, the issue went away.
Hope this helps
Amir
If your error message starts with something like below:
Apr 21 19:49:59 [45008] Unable to read bootstrap node metadata. Expected JSON DB desc, got: Stopping editor Error stopping editor: [Errno 3] No such process
The error text regarding "Error stopping editor: [Errno 3] No such process" implies that the script couldn't launch a vertica process with special args to try to load and read the catalog created by an earlier boostrap routine. One potential root cause is open file limit. If the open file limit (ulimit -n, ulimit -Hn, ulimit -Sn) are too low vertica won't start. In the situation I ran into they were set to 16k and customer bumped it to 32k and then the create worked.
You can test this by cd to the catalog dir and executing vertica from the command line, noting the documented recommendation is 65536 or mb of memory, whichever is highest.
[dbadmin@scrossman6 v_af_node0001_catalog]$ /opt/vertica/bin/vertica -D .
ERROR: Host does not meet minimum requirements:
Not enough open file handles allowed (16192 available/32768 required); see 'ulimit -n'.
Hoppe it helps,
Steve (I work for HP)