We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Backup failed unexpectedly! ERROR — Vertica Forum

Backup failed unexpectedly! ERROR

Hi,
My Vertica backups were working great untill i updated to the last version.
I use vbr.py but i get the message "backup failed unexpectedly!" every time i try to use it.
I even tried to do the --setupconfig but it doesn't help...

Does someone has an idea ?

Thanks 

Comments


  • Can you post the contents of the created config file?
  • Yes, here it is:

    [Misc]snapshotName = fullBackup
    restorePointLimit = 1

    [Database]
    dbName = xxxxxx
    dbUser = yyyyyy

    [Transmission]

    [Mapping]
    v_xxxxxx_node0001 = 127.0.0.1:/tmp/vbr

    If i add the --debug 3 option i can see this error:

    Traceback (most recent call last):  File "/opt/vertica/bin/vbr.py", line 2526, in backup
        prepareAll()
      File "/opt/vertica/bin/vbr.py", line 1888, in prepareAll
        configCheck()
      File "/opt/vertica/bin/vbr.py", line 506, in configCheck
        concurrency_upperboud = int(subprocess.Popen(['ulimit -u'], shell=True, stdout= subprocess.PIPE).communicate()[0].strip())
    ValueError: invalid literal for int() with base 10: 'unlimited'
    backup failed unexpectedly!

    Thansk for your help


  • Is the OS Ubuntu?
    Can you provide the output of ls -l /bin/sh
     
  • It's Debian,

    lrwxrwxrwx 1 root root 4 Dec 17 10:53 /bin/sh -> bash
  • Can you try running -
    ulimit -u
     
  • I get "unlimited"
  • Hi Fredou!


    1. Can you post output for:
    python -c "import json; print json.dumps('/opt/vertica/bin/validators.sh', indent=2)"
    2. Modify limits.conf file, set max number of processes (lets say db super user is dbadmin):
    dbadmin  -   nproc  65536
    3. Validate settings:
    $ ulimit -u
    65536
    do reboot and try backup.


    PS
    Try to validate it without reboot, set limit manually and if it do not hangs an error run backup.

    *********

    How to set limit manually?
    ulimit -u 65536
    if it do not throws an error so try to do a backup.

    *********

    Example of error:
    daniel@synapse:/etc/security$ ulimit -u 131072
    bash: ulimit: max user processes: cannot modify limit: Operation not permitted

    Regards, idiot :)
  • Thanks, the "ulimit -u 65536" did the trick !

  • Hi!

    I will ask to run a first command from my post above one more time. You have to set a proper value(65536 - is an arbitrary value) for nproc (the key is max_user_proc)
    daniel@synapse:~$ python -c "import json; print json.dumps('/opt/vertica/bin/validators.sh', indent=2)"
    {
    "total_memory": 7844,
    "vertica": {
    "release": "2",
    "brand": "vertica",
    "version": "7.1.1",
    "arch": "iamd64"
    },
    "nics": [
    {
    "broadcast": "",
    "ipaddr": "",
    "netmask": "",
    "speed": "unknown",
    "name": "eth0"
    },
    {
    "broadcast": "255.255.255.255",
    "ipaddr": "127.0.0.1",
    "netmask": "255.0.0.0",
    "speed": "locallink",
    "name": "lo"
    },
    {
    "broadcast": "",
    "ipaddr": "",
    "netmask": "",
    "speed": "unknown",
    "name": "ppp0"
    }
    ],
    "hostname": "synapse",
    "max_user_proc": "62582",
    "cpu_info": {
    "number_of_cpus": 8,
    "cpu_type": " Intel(R) Core(TM) i7-3612QM CPU @ 2.10GHz"
    }
    }

Leave a Comment

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