6 Replies Latest reply on Mar 7, 2017 6:34 AM by Gerardo Varela

    Verify database integrity completed with errors

    Kevin Jennings

      Tableau Server Version: 10.1.3 (10100.16.1223.0056) 64-bit

      Server: Windows Server 2012 R2 Standard

       

      Is this happening at anyone else's location, and if so, how are your addressing it?

       

      During nightly backups we are receiving the following error when executing the "tabadmin backup" command, with the verify option.

       

      "tabadmin backup %bkup_file% -v

      ...

      ===== Setting inheritance completed on D:/Program Files/Tableau/Tableau Server/data/tabsvc/temp/pg_data

        *** ActiveRecord::JDBCError: ERROR: duplicate key value violates unique constraint "pg_database_datname_index"

        Detail: Key (datname)=(workgroup) already exists.: CREATE DATABASE workgroup

        *** Verify database integrity completed with errors.

      ===== The integrity of the database could not be verified.

            You will not be able to successfully restore a database backup until you resolve these issues.

            Please contact Tableau Support for assistance.

       

      Per Tableau's suggestion, we follow up with a verify_database command to get a status of the *.tsbak file created in the previous step. 

      The suggestion from Tableau was that if the file verifies clean, then it should be good to use for a recovery.  We did successfully test a recovery using one of the created *.tsbak files.

       

      tabadmin verify_database %bkup_file%

      ===== Beginning of database verification...

      ===== Setting inheritance on D:/Program Files/Tableau/Tableau Server/data/tabsvc/pgsql/data

      ===== Setting inheritance completed on D:/Program Files/Tableau/Tableau Server/data/tabsvc/pgsql/data

      ===== Setting inheritance on D:/Program Files/Tableau/Tableau Server/data/tabsvc/temp/pg_data

      ===== Setting inheritance completed on D:/Program Files/Tableau/Tableau Server/data/tabsvc/temp/pg_data

      ===== Backing up the public schema of database data

      ===== Restoring into test database started on port: 8061

      ===== Verify database completed successfully.

       

      Our order of the scripted backup commands are:

      tabadmin ziplogs %ziplog_file% -l -n -p

      tabadmin cleanup

      tabadmin backup %bkup_file% -v

      tabadmin verify_database %bkup_file%

      tabadmin config -o %cnfg_file%