DS3DB0 creation taking too long

[mca38]

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.

[mca38]

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)

[fredab2]

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

[mca38 · Accepted solution]

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.

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