Artdaq database bundle installation instructions.

Log into np04-srv-010 using np04daq account ( ssh np04daq@np04-srv-010 ) and do the following:

Note: Respond with YesIam! to the first prompt.

The installation script does the following: installs additional artdaq database products, creates systemd startup scripts, installs and configures mongo database, and starts it up. It uploads a sample artdaq configuration into the ardaq database, reads it back and compares it to the one that was loaded. After that, it starts up webcongigeditor, wgets the default page (to make sure that the majority of plumbing is working), and finally, it stops mongo database and webcongigeditor. For additional details review the installation script itself and log files.

artdaq_database.env

ARTDAQ_BASE_DIR=/local_volume/db_install_dir
ARTDAQ_DB_UPS_VER=v1_04_84
WEBEDITOR_UPS_VER=v1_01_07
ARTDAQ_UPS_QUAL="e17:prof:s87"
MONGOD_UPS_QUAL="e17:prof"
ARTDAQ_DB_NAME=cern_pddaq_v3x_db
ARTDAQ_DB_PULLPRODUCTS="slf7 artdaq_database-${ARTDAQ_DB_UPS_VER} s87-e17 prof"
ARTDAQ_DB_MANIFESTURL="https://cdcvs.fnal.gov/redmine/projects/artdaq-utilities/repository/database/revisions/${ARTDAQ_DB_UPS_VER}/raw/built-in/manifests/artdaq_database-build-Linux64bit+3.10-2.17-s87-e17-prof_MANIFEST.txt"
https_proxy=https://np04-webgw1.cern.ch:3128
http_proxy=http://np04-webgw1.cern.ch:3128

Restore Artdaq database from a nightly backup.

Artdaq database is backed up nightly on np04-srv-010.cern.ch into the /nfs/back/database/cern_pddaq_v3x_db/backup/[DATETIME]/ directory.

Setup artdaq_database:

source /nfs/sw/artdaq/products/setup
setup artdaq_database v1_04_84 -q e17:prof:s87
# cd into the directory with the latest backup
cd /nfs/back/database/cern_pddaq_v3x_db/backup/20180606013002/
Note: Restoring the database can take 20-40 minutes depending on the performance of the server hardware; e.g. restoring a backup from 06/06/2018 on mu2edaq11 took around 20 minutes.

To restore the "Online configuration database" run the following commands:

export ARTDAQ_DATABASE_URI="mongodb://127.0.0.1:27037/cern_pddaq_db"
cd cern_pddaq_db
conftool.py importDatabase

To restore the "Run History database" run the following commands:

export ARTDAQ_DATABASE_URI="mongodb://127.0.0.1:27037/cern_pddaq_db_archive"
cd cern_pddaq_db_archive
conftool.py importDatabase

-- GennadiyLukhanin - 2017-06-06

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r4 - 2020-03-24 - GennadiyLukhanin
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    CENF All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback