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


database doesn't start after server reboot. Can you say where is problem? — Vertica Forum

database doesn't start after server reboot. Can you say where is problem?

Alexandra_1Alexandra_1
in General Discussion
I install vertica 7.0.0-0, create database, set it's restart policy to always, but it doesn't start after server reboot. Can you say where is problem?

Comments

  • Rahul_ChoudharyRahul_Choudhary
    Hi Alexandra

    Kindly provide us the admintool-root.log, admintools-vertica.log files from the server in order to drill this down further.

    Also provide us the output of the below command:

    $ admintools -t view_cluster

    Regards
    Rahul


  • Alexandra_1Alexandra_1
    Hi Rahul

    adminTools-root.log 
    Jan 24 11:35:50  [adminExec.__init__] Unique Ports: False  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['[ -f /etc/fedora-release ]']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: (rc=1) []  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['[ -f /etc/redhat-release ]']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['egrep "release (5|6)" /etc/redhat-release']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: (rc=0) ['CentOS release 6.5 (Final)']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['LANG=C /sbin/ifconfig']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: (rc=0) ['eth0      Link encap:Ethernet  HWaddr 00:50:56:9B:2C:01  ', '          inet addr:192.168.1.33  Bcast:192.168.1.255  Mask:255.255.255.0', '          inet6 addr: fe80::250:56ff:fe9b:2c01/64 Scope:Link', '          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1', '          RX packets:1756 errors:0 dropped:0 overruns:0 frame:0', '          TX packets:817 errors:0 dropped:0 overruns:0 carrier:0', '          collisions:0 txqueuelen:1000 ', '          RX bytes:151751 (148.1 KiB)  TX bytes:146596 (143.1 KiB)', '', 'lo        Link encap:Local Loopback  ', '          inet addr:127.0.0.1  Mask:255.0.0.0', '          inet6 addr: ::1/128 Scope:Host', '          UP LOOPBACK RUNNING  MTU:16436  Metric:1', '          RX packets:2 errors:0 dropped:0 overruns:0 frame:0', '          TX packets:2 errors:0 dropped:0 overruns:0 carrier:0', '          collisions:0 txqueuelen:0 ', '          RX bytes:100 (100.0 b)  TX bytes:100 (100.0 b)']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['rpm -q vertica --qf "%{NAME} %{VERSION} %{RELEASE} %{ARCH}\\n"']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: (rc=0) ['vertica 7.0.0 0 x86_64']  Jan 24 11:35:50  [Profile.VerticaRelease] query results 'vertica 7.0.0 0 x86_64'  Jan 24 11:35:50  Hosts to add: ['192.168.1.33']  Jan 24 11:35:50  Hosts to remove: []  Jan 24 11:35:50  Hosts to update: []  Jan 24 11:35:50  Resulting cluster: ['192.168.1.33']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['echo 'if [ -e "/opt/vertica" ]; then cd /tmp; find /opt/vertica -perm -755 -type d | grep "/opt/vertica\\$"; else echo /opt/vertica; fi'']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: (rc=0) ['/opt/vertica']  Jan 24 11:35:50  RPM Check,  The same version is already installed  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:50  backing up admintools.conf on 192.168.1.33   Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['id dbadmin']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: (rc=0) ['uid=500(dbadmin) gid=500(verticadba) \xd0\xb3\xd1\x80\xd1\x83\xd0\xbf\xd0\xbf\xd1\x8b=500(verticadba)']  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:50  <BashAdapter: root@192.168.1.33>: ['VERT_DBA_USR=dbadmin VERT_DBA_HOME=/home/dbadmin VERT_DBA_GRP=verticadba /opt/vertica/oss/python/bin/python -m vertica.local_coerce']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['install --owner root --mode 700 -d /tmp/vstage-8fc0d59a-2da1-429b-8a6b-6a8b6b5321ff']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['cp -T /opt/vertica/log/verify-latest.xml /tmp/vstage-8fc0d59a-2da1-429b-8a6b-6a8b6b5321ff/file']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown root /tmp/vstage-8fc0d59a-2da1-429b-8a6b-6a8b6b5321ff/file']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['rm -rf /tmp/vstage-8fc0d59a-2da1-429b-8a6b-6a8b6b5321ff']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['install --owner dbadmin --mode 700 -d /tmp/vstage-73992b75-5ba2-47c8-b3a8-161391ccedbd']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ["su --login dbadmin --command '/opt/vertica/share/binlib/util/create-or-export-ssh-key -f /tmp/vstage-73992b75-5ba2-47c8-b3a8-161391ccedbd/id_rsa -u dbadmin'"]  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ["su --login dbadmin --command '/opt/vertica/share/binlib/util/install-ssh-key -f /tmp/vstage-73992b75-5ba2-47c8-b3a8-161391ccedbd/id_rsa -u dbadmin'"]  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) ['Backing up /home/dbadmin/.ssh/id_rsa.pub as /home/dbadmin/.ssh/id_rsa.pub.bak.1390548952']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['rm -rf /tmp/vstage-73992b75-5ba2-47c8-b3a8-161391ccedbd']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['/opt/vertica/sbin/vertica_service_setup.sh stop /opt/vertica RHEL5 spread']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['/opt/vertica/sbin/vertica_service_setup.sh remove /opt/vertica RHEL5 spread']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown dbadmin:verticadba  /opt/vertica/config']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown dbadmin:verticadba  /opt/vertica/config/share']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown dbadmin:verticadba  /opt/vertica/log']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['/opt/vertica/sbin/vertica_service_setup.sh stop /opt/vertica RHEL5 agent']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33> (Removing old agent links): ['/opt/vertica/sbin/vertica_service_setup.sh remove /opt/vertica RHEL5 agent']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33> (Setting up agent daemon): <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown dbadmin:verticadba /opt/vertica/config/share/agent.key']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown dbadmin:verticadba /opt/vertica/config/share/agent.cert']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown dbadmin:verticadba /opt/vertica/config/share/agent.pem']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chmod 400 /opt/vertica/config/share/agent.key']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chmod 400 /opt/vertica/config/share/agent.cert']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chmod 400 /opt/vertica/config/share/agent.pem']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33> (Setting up verticad autorestart): <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  Creating node node0001 definition for host 192.168.1.33  Jan 24 11:35:52  [adminExec.do_create_node] creating node w/ ['node0001', '192.168.1.33', '/home/dbadmin', '/home/dbadmin']  Jan 24 11:35:52  [adminExec.do_create_node] creating node w/ ['node0001', '192.168.1.33', '/home/dbadmin', '/home/dbadmin']  Jan 24 11:35:52  [adminExec.isNodeDefined] qry: '['node0001', '192.168.1.33', '/home/dbadmin', '/home/dbadmin']'  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: <command hidden>  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown dbadmin:verticadba /opt/vertica/config/admintools.conf']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chmod 0664 /opt/vertica/config/admintools.conf']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=0) []  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chown root:verticadba  /opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=1) ['chown: \xd0\xbd\xd0\xb5\xd0\xb2\xd0\xbe\xd0\xb7\xd0\xbc\xd0\xbe\xd0\xb6\xd0\xbd\xd0\xbe \xd0\xbf\xd0\xbe\xd0\xbb\xd1\x83\xd1\x87\xd0\xb8\xd1\x82\xd1\x8c \xd0\xb4\xd0\xbe\xd1\x81\xd1\x82\xd1\x83\xd0\xbf \xd0\xba \xc2\xab/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat\xc2\xbb: \xd0\x9d\xd0\xb5\xd1\x82 \xd1\x82\xd0\xb0\xd0\xba\xd0\xbe\xd0\xb3\xd0\xbe \xd1\x84\xd0\xb0\xd0\xb9\xd0\xbb\xd0\xb0 \xd0\xb8\xd0\xbb\xd0\xb8 \xd0\xba\xd0\xb0\xd1\x82\xd0\xb0\xd0\xbb\xd0\xbe\xd0\xb3\xd0\xb0']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: ['chmod 664 /opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat']  Jan 24 11:35:52  <BashAdapter: root@192.168.1.33>: (rc=1) ['chmod: \xd0\xbd\xd0\xb5\xd0\xb2\xd0\xbe\xd0\xb7\xd0\xbc\xd0\xbe\xd0\xb6\xd0\xbd\xd0\xbe \xd0\xbf\xd0\xbe\xd0\xbb\xd1\x83\xd1\x87\xd0\xb8\xd1\x82\xd1\x8c \xd0\xb4\xd0\xbe\xd1\x81\xd1\x82\xd1\x83\xd0\xbf \xd0\xba \xc2\xab/opt/vertica/config/d5415f948449e9d4c421b568f2411140.dat\xc2\xbb: \xd0\x9d\xd0\xb5\xd1\x82 \xd1\x82\xd0\xb0\xd0\xba\xd0\xbe\xd0\xb3\xd0\xbe \xd1\x84\xd0\xb0\xd0\xb9\xd0\xbb\xd0\xb0 \xd0\xb8\xd0\xbb\xd0\xb8 \xd0\xba\xd0\xb0\xd1\x82\xd0\xb0\xd0\xbb\xd0\xbe\xd0\xb3\xd0\xb0']  Jan 24 11:35:52  Running upgrade logic  Jan 24 11:35:53  <BashAdapter: root@192.168.1.33>: ['[ -e /opt/vertica/config/vspread.conf ]']  Jan 24 11:35:53  <BashAdapter: root@192.168.1.33>: (rc=1) []  Jan 24 11:35:53  No spread upgrade required: /opt/vertica/config/vspread.conf not found on any node
     I can't find admintools-vertica.log. There is no files with name like this.

    The output of this command (admintools -t view_cluster), but I started database from admintools before:
     DB   | Host | State
    ------+------+------- 
    main | ALL  | UP

    main is the name of my database
  • Rahul_ChoudharyRahul_Choudhary
    Hi Alexndra

    The output of the below command clearly indicates that your database is currently up & running 

    $admintools -t view_cluster

    DB   | Host | State
    ------+------+------- 
    main | ALL  | UP


    Can you kindly let me now whether you are able to invoke the admintools &  check the View Database Cluster state?


    Regards
    Rahul
  • Rahul_ChoudharyRahul_Choudhary
    Hi Alexndra

    The output of the below command clearly indicates that your database is currently up & running 

    $admintools -t view_cluster

    DB   | Host | State
    ------+------+------- 
    main | ALL  | UP


    Can you kindly let me now whether you are able to invoke the admintools &  check the View Database Cluster state?


    Regards
    Rahul
  • Alexandra_1Alexandra_1
    Hi Rahul
    Yes, now my database is currently up and running, but if I restart my server, the result of command "admintools -t view_cluster" is:
      DB   | Host | State
    ------+------+------- 
    main | ALL  | DOWN
  • Rahul_ChoudharyRahul_Choudhary
    Alexndra

    Can you kindly let me know how many nodes you have in your cluster?Also is your database K-safe?

    Provide me the output of below command:

    $ admintools -t list_allnodes


    Regards
    Rahul
  • Alexandra_1Alexandra_1
    I have just one node, so it is mean that my database is not K-safe, isn't it?
     admintools -t list_allnodes
     Node                     |        Host         |   State   | Version           | DB
    ------------------------+------------------+-----------+-------------------+------ 
    v_main_node0001 | 192.168.1.33  | DOWN  | vertica-7.0.0.000 | main

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...