Copy Cluster Fails with no "vbr_worker.py"

Hi Team,

I have been trying setup a copycluster job from a source of 3 nodes cluster to another site of exactly same configuration only different ips. Al pre-requisites are met , but while running the job getting some weird error.

Console Out:
ontinued use of this database is in violation of the current license agreement.
Maximum licensed raw data size: 1.00TB
Current raw data size: 2.39TB
License utilization: 239%
IMMEDIATE ACTION IS REQUIRED, PLEASE CONTACT VERTICA
Error: Worker process exited with error: Authorized users only
/opt/vertica/oss/python/bin/python: can't open file '/appdefender/vertica/bin/vbr_worker.py': [Errno 2] No such file or directory

Copycluster FAILED.

Detail console out:
[email protected] ~]$ vbr -t copycluster -c copycluster.ini --debug 3
NOTICE 2001:
***** NOTICE OF LICENSE NON-COMPLIANCE *****
Continued use of this database is in violation of the current license agreement.
Maximum licensed raw data size: 1.00TB
Current raw data size: 2.39TB
License utilization: 239%
IMMEDIATE ACTION IS REQUIRED, PLEASE CONTACT VERTICA
NOTICE 2001:
***** NOTICE OF LICENSE NON-COMPLIANCE *****
Continued use of this database is in violation of the current license agreement.
Maximum licensed raw data size: 1.00TB
Current raw data size: 2.39TB
License utilization: 239%
IMMEDIATE ACTION IS REQUIRED, PLEASE CONTACT VERTICA
Error: Worker process exited with error: Authorized users only
/opt/vertica/oss/python/bin/python: can't open file '/appdefender/vertica/bin/vbr_worker.py': [Errno 2] No such file or directory

Copycluster FAILED.

======================================================== The snippet of the debug message from /tmp/cbr/*.log file

BatchMode=yes -o ExitOnForwardFailure=yes -o PasswordAuthentication=no -o StrictHostKeyChecking=no -oNoHostAuthenticationForLocalhost=yes -L42794:127.0.0.1:37210 10.189.199.xx /opt/vertica/oss/python/bin/python /appdefender/vertica/bin/vbr_worker.py DUMMY
2020-09-16 16:06:34 10.189.199.96 vbr Checked.
2020-09-16 16:06:34 10.189.199.95 vbr Checked.
2020-09-16 16:06:34 10.189.199.97 vbr Checked.
2020-09-16 16:06:43 localhost vsql /opt/vertica/bin/vsql -q -t -X -dappdefenderdb -p5433 -Uverticauser -h10.189.199.96
2020-09-16 16:06:43 localhost vsql select log_vbr_invocations('Copy Cluster Task', '/tmp/vbr/vbr_2020-09-16-160620_SDH7Z21A.log', 'AS411Q1B7ZFWQ5LIX6DED3M9PP8H4KC6', 'Fail');
2020-09-16 16:06:43 localhost vsql Warning from vsql: NOTICE 2001:
***** NOTICE OF LICENSE NON-COMPLIANCE *****
Continued use of this database is in violation of the current license agreement.
Maximum licensed raw data size: 1.00TB
Current raw data size: 2.39TB
License utilization: 239%
IMMEDIATE ACTION IS REQUIRED, PLEASE CONTACT VERTICA.
2020-09-16 16:06:43 localhost vsql Read from vsql: Logged vbr invocations
2020-09-16 16:06:43 localhost vbr Traceback (most recent call last):
File "/opt/vertica/bin/vbr", line 10023, in main
if vbr_task.run():

Best Answer

Answers

  • HibikiHibiki Employee

    Can you check the following items?

    1. Your cluster has had the data more than licensed size. Please run the following statements on vsql and see if all statements works.
    => CREATE TABLE test_20200917 (c1 INT);
    => INSERT INTO test_20200917 VALUES (1);
    => COMMIT;
    => SELECT count(*) FROM test_20200917;
    => DROP TABLE test_20200917;
    
    1. Please check the environment variables set to dbadmin OS user by using the following command. Usually no variables.

    $ env | sort | grep -e '^PYTHON' -e '^VBR'

    1. Please check the existence of vbr_worker.py file by using the following command.

    $ ls -l /opt/vertica/bin/vbr*

    1. Have you run any commands related to 'appdefender' on the Vertica nodes?

    2. Please check the directories and files under /appdefender directory by using the following command. If this directory exists, the output of this command may be huge. So if necessary, please upload this output as the attached file.

    $ find /appdefender

  • Thanks. I will definitely try that out.
    I will appreciate if you can guide me how to reduce the raw data size to minimum without any impact in db. I have option to delete the db but the issue is that it won't educe the size to compliance limit immediately.
    My disk space is usage is hardly 200 GB but how come the raw size shows 2.3 TB.

  • The given statement to create a table is working.
    Any specific files you would like to see as the /appdefender/ list is very long.

    I am using a different vertica dba user "verticauser"
    env | sort | grep -e '^PYTHON' -e '^VBR'
    env for PYTHON is not set.

  • appdefender/vertica/bin/vbr_worker.py is present and owner as root and execute permission is also present.
    IN fact, I did a test by running manually .
    [email protected] $appdefender/vertica/bin/vbr_worker.py /appdefender/vertica/bin/vbr_worker.py
    It works .

  • I have fixed the License compliance issue. Now I am having a typical issue .
    Error: Worker process exited with error: Authorized users only
    /opt/vertica/oss/python/bin/python: can't open file '/appdefender/vertica/bin/vbr_worker.py': [Errno 2] No such file or directory

    Please help.

  • You are absolutely correct. Thanks. In fact, I verified the same in source nodes but forgot to verify in target nodes. I used one soft link and then checked the binary was missing in that location.
    Once I set it correctly it worked.

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.