3 Replies Latest reply on May 10, 2018 8:07 AM by mca38

    DS3DB0 creation taking too long

    mca38 Novice

      Hello. I re-provisioned Tile 0 yesterday and noticed the complete creation of DS3DB0 has not finished. It has been almost 24 hours since the provisioning process began. Is it normal for this to take almost 24 hours to complete? Keep in mind that I was able to successfully create DS3DB0 previously, with no changes to the environment.

       

      Here is the output from the installoutput.txt file:

       

      [root@DS3DB0 ~]# tail -f /ds3/VMmark3-DS3installoutput.txt

      Creating Stored Procedures

      Warning: Using a password on the command line interface can be insecure.

      Loading Customer Data

      Warning: Using a password on the command line interface can be insecure.

      Loading Orders Data

      Warning: Using a password on the command line interface can be insecure.

      Loading Orderlines Data

      Warning: Using a password on the command line interface can be insecure.

      Loading Customer History Data

      Warning: Using a password on the command line interface can be insecure.

        • 1. Re: DS3DB0 creation taking too long
          mca38 Novice

          More info:

           

          VMmark3Service_v1.0.0 Finished

           

          Summary::

          /root/VMmark3/provisioning-output/vmmark3-output/

          Automation Ending:

          Please add the contents of hosts-stub.txt to your PrimeClient's /etc/hosts file

          STAX should be started before beginning new runs

          DS3DB0 is still being created : Review VM for status::  :: Detail (if applicable): IP: 192.168.1.5

          Creation Status: ssh DS3DB0 'tail -f /ds3/VMmark3-DS3installoutput.txt'

          Error Output:: Found 0 Errors

          TimeElapsed: 4118 (secs)

          Error Output:: Found 0 Errors

          TimeElapsed: 4136 (secs)

          • 2. Re: DS3DB0 creation taking too long
            fredab2 Novice
            VMware Employees

            It can take as long as 24 hours to create the DS3DB0 db depending on speed of your storage. However, it is strange that you created the day before and you believe it didn't take that long. The message you attached states  "TimeElapsed: 4136 (secs)", which is only a little more than 1 hour.    Has the latest DS3DB0 creation finished by now?

             

            Go ahead and attached the latest file ". /ds3/VMmark3-DS3installoutput.txt" from DS3DB) VM.

             

            Also can you do the following and let me know the results:

             

            ssh -l root DS3DB0

            cd /root/VMmark3/client/DS3DB

            ./DS3_checker.sh

             

            If you get the following message:

                  --------------------------------------------------------------------------------

                  It looks like the database DS3 is built correctly and in initialized state.

                  --------------------------------------------------------------------------------

            then your DB should be ready.

             

            However, if  you get the following message:

                  ---------------------------------------------------------------------------

                  FAIL:  DS3 is either not built completely or not in initialized state.

                 ---------------------------------------------------------------------------

            then run the command below from the same directory.

             

              ./ConfigServer_DS3DB.sh 100

            then run

              ./DS3_checker.sh

             

            I will be waiting for your results / reply to be posted.

            Fred

            • 3. Re: DS3DB0 creation taking too long
              mca38 Novice

              Fred - thanks for the reply. The server finally finished being created. Not sure why it took so much longer this time.

               

              Looks like it took almost 36 hours to complete.

               

              [root@DS3DB0 DS3DB]# tail -f /ds3/VMmark3-DS3installoutput.txt

              Warning: Using a password on the command line interface can be insecure.

              Loading Membership data

              Warning: Using a password on the command line interface can be insecure.

              Loading Reviews data

              Warning: Using a password on the command line interface can be insecure.

              Loading Reviews Helpfulness Ratings Data

              Warning: Using a password on the command line interface can be insecure.

              Removing data files

              Wed May  9 20:49:57 PDT 2018

              VMmark3 DS3DB Setup Completed : Rebooting

               

              ---------------------------------------------------------------

               

              Checking the contents of Tables = category

              ................All checks passwd checking Table CATEGORIES

              Checking the contents of Tables = orders

              ........................All checks passwd checking Table ORDERS

              Checking the contents of Tables = custhist

              ........................All checks passwd checking Table CUST_HIST

              Checking the contents of Tables = orderlines

              ........................All checks passwd checking Table ORDERLINES

              Checking the contents of Tables = customers

              ..All checks passwd checking Table CUSTOMERS

              Checking the contents of Tables = reviews

              ..All checks passwd checking Table REVIEWS

              Checking the contents of Tables = reviewshelpfulness

              ..All checks passwd checking Table REVIEWS_HELPFULNESS

              Checking the contents of Tables = membership

              ..All checks passwd checking Table MEMBERSHIP

              Checking the contents of Tables = inventory

              ...All checks passwd checking Table INVENTORY

              Checking the contents of Tables = products

              ..All checks passwd checking Table PRODUCTS

              --------------------------------------------------------------------------

              It looks like database DS3 is built correctly and in initialized state.

              --------------------------------------------------------------------------