we just recently updated our Vertica from 5.0 to 6.1
After that we added two new nodes to the, until then, single instance (so three alltogether now).
But now the backups fails with a rather strange eror:
Code: Select all
[dbadmin@n131 ~]$ /opt/vertica/bin/vbr.py -t backup --debug 2
Preparing...
Found Database port: 5433
[...]
v_x_node0001 10.x.x.131 /data/vertica_db/x/v_x_node0001_catalog
v_x_node0002 10.x.x.132 /data/vertica_db/x/v_x_node0002_catalog
v_x_node0003 10.x.x.133 /data/vertica_db/x/v_x_node0003_catalog
set([('10.x.x.133', True), ('10.x.x.193', False), ('10.x.x.131', True), ('10.x.x.132', True)])
/opt/vertica/bin/vsql -dx -p5433 -Udbadmin -h 10.x.x.133 -X -q -c "select database_snapshot('test', true);
"
ERROR 5127: Unable to create snapshot Could not link file [/data/vertica_db/x/v_x_node0003_catalog/Snapshots/test/data/vertica_db/x/procedures/dumpquerytotmp.sh] to [/data/vertica_db/x/procedures/dumpquerytotmp.sh]: File exists
When communicating with vertica, the process failed with code 1
backup failed!
I already tried deleting one or the other of the files, but no change.
With one, I get same error, with the other that the file is missing.
Any idea what else I can do?