SPEC Community
Product Support => SPECvirt_sc2013 => Topic started by: zgy on September 05, 2017, 05:55:19 AM
-
HI, when i setup DBserver, after i run loaddb_postgres.sh it return 130 errno number, is that right ??
[root@dbserver other_scripts]# ./loaddb_postgres.sh
ln: creating symbolic link `/opt/SPECjAppServer2004/jdbc/postgresql.jar': File exists
Script started Tue Sep 5 17:00:20 CST 2017
sleep 10
Starting Database Load
Loading database with orders_injection_rate = 500
Loading database with numThreads = 4
Loading Databases ...
INFO : IR supplied : 500
INFO : stepped IR : 500
STARTING loading of tables in the Corp domain...
Launching 4 threads to execute LoadCorp.loadCustomers() concurrently
Starting thread: Thread[CustomerThread-0,5,main] For range 1 - 937500
Starting thread: Thread[CustomerThread-1,5,main] For range 937501 - 1875000
Starting thread: Thread[CustomerThread-2,5,main] For range 1875001 - 2812500
Starting thread: Thread[CustomerThread-3,5,main] For range 2812501 - 3750000
Launching 4 threads to execute LoadCorp.loadParts() concurrently
Starting thread: Thread[LoadPartsThread-0,5,main] For range 0 - 12500
Starting thread: Thread[LoadPartsThread-1,5,main] For range 12500 - 25000
Starting thread: Thread[LoadPartsThread-2,5,main] For range 25000 - 37500
Starting thread: Thread[LoadPartsThread-3,5,main] For range 37500 - 50000
Waiting for LoadCorp.loadParts() to finish..
Waiting to join : Thread[LoadPartsThread-0,5,main]
Joined : Thread[LoadPartsThread-0,5,]
Waiting to join : Thread[LoadPartsThread-1,5,]
Joined : Thread[LoadPartsThread-1,5,]
Waiting to join : Thread[LoadPartsThread-2,5,]
Joined : Thread[LoadPartsThread-2,5,]
Waiting to join : Thread[LoadPartsThread-3,5,]
Joined : Thread[LoadPartsThread-3,5,]
Launching a thread to call LoadCorp.loadCInventory(), and loadSequence
Waiting for Site, and Supplier Loader to finish..
Waiting for LoadCorp.loadCustomer() to finish..
Waiting to join Thread[CustomerThread-0,5,main]
Launching 4 threads to execute LoadCorp.tLoadInventorySequence() concurrently
Starting thread: Thread[LoadInventorySequenceWorkerThread-0,5,main] For range 1 - 937500
Starting thread: Thread[LoadInventorySequenceWorkerThread-1,5,main] For range 937501 - 1875000
Starting thread: Thread[LoadInventorySequenceWorkerThread-2,5,main] For range 1875001 - 2812500
Starting thread: Thread[LoadInventorySequenceWorkerThread-3,5,main] For range 2812501 - 3750000
Waiting for LoadCorp.loadInventorySequenceWorkers to finish..
Waiting to join Thread[LoadInventorySequenceWorkerThread-0,5,main]
Joined CustomerThreadThread[CustomerThread-0,5,]
Waiting to join Thread[CustomerThread-1,5,]
Joined CustomerThreadThread[CustomerThread-1,5,]
Waiting to join Thread[CustomerThread-2,5,main]
Joined CustomerThreadThread[CustomerThread-2,5,]
Waiting to join Thread[CustomerThread-3,5,]
Joined CustomerThreadThread[CustomerThread-3,5,]
Waiting for InventorAndSequenceLoader to finish..
Joined Thread[LoadInventorySequenceWorkerThread-0,5,]
Waiting to join Thread[LoadInventorySequenceWorkerThread-1,5,main]
Joined Thread[LoadInventorySequenceWorkerThread-1,5,]
Waiting to join Thread[LoadInventorySequenceWorkerThread-2,5,main]
Joined Thread[LoadInventorySequenceWorkerThread-2,5,]
Waiting to join Thread[LoadInventorySequenceWorkerThread-3,5,]
Joined Thread[LoadInventorySequenceWorkerThread-3,5,]
LoadInventorySequence: calling loadSequence()
Joined InventorAndSequenceLoader Thread[LoadInventoryAndSequence,5,]
Done. End to End Data load time of Corp domain = 1561 seconds
Launching 4 threads to execute LoadMfg.loadAll() concurrently
Starting thread: Thread[LoadMfg.LoadAll-0,5,main]
Starting thread: Thread[LoadMfg.LoadAll-1,5,main]
Starting thread: Thread[LoadMfg.LoadAll-2,5,main]
Starting thread: Thread[LoadMfg.LoadAll-3,5,main]
Waiting for LoadCorp.loadCustomer() to finish..
Waiting to join Thread[LoadMfg.LoadAll-0,5,main]
Joined Thread[LoadMfg.LoadAll-0,5,]
Waiting to join Thread[LoadMfg.LoadAll-1,5,main]
Joined Thread[LoadMfg.LoadAll-1,5,]
Waiting to join Thread[LoadMfg.LoadAll-2,5,main]
Joined Thread[LoadMfg.LoadAll-2,5,]
Waiting to join Thread[LoadMfg.LoadAll-3,5,]
Joined Thread[LoadMfg.LoadAll-3,5,]
Done. End to End Data load time of Mfg domain = 77 seconds
Launching 4 threads to execute LoadSupp.loadComponents() concurrently
Starting thread: Thread[LoadSupp.loadComponents-0,5,main]
Starting thread: Thread[LoadSupp.loadComponents-1,5,main]
Starting thread: Thread[LoadSupp.loadComponents-2,5,main]
Starting thread: Thread[LoadSupp.loadComponents-3,5,main]
Waiting for LoadCorp.loadCustomer() to finish..
Waiting to join Thread[LoadSupp.loadComponents-0,5,main]
Joined Thread[LoadSupp.loadComponents-0,5,]
Waiting to join Thread[LoadSupp.loadComponents-1,5,]
Joined Thread[LoadSupp.loadComponents-1,5,]
Waiting to join Thread[LoadSupp.loadComponents-2,5,]
Joined Thread[LoadSupp.loadComponents-2,5,]
Waiting to join Thread[LoadSupp.loadComponents-3,5,]
Joined Thread[LoadSupp.loadComponents-3,5,]
Done. End to End Data load time of Supplier domain = 308 seconds
Launching 4 threads to execute LoadOrds.loadItemss() concurrently
Starting thread: Thread[LoadOrds.loadItem-0,5,main]
Starting thread: Thread[LoadOrds.loadItem-1,5,main]
Starting thread: Thread[LoadOrds.loadItem-2,5,main]
Starting thread: Thread[LoadOrds.loadItem-3,5,main]
Waiting for LoadCorp.loadCustomer() to finish..
Waiting to join Thread[LoadOrds.loadItem-0,5,main]
Joined Thread[LoadOrds.loadItem-0,5,]
Waiting to join Thread[LoadOrds.loadItem-1,5,main]
Joined Thread[LoadOrds.loadItem-1,5,]
Waiting to join Thread[LoadOrds.loadItem-2,5,main]
Joined Thread[LoadOrds.loadItem-2,5,]
Waiting to join Thread[LoadOrds.loadItem-3,5,]
Joined Thread[LoadOrds.loadItem-3,5,]
Launching 4 threads to execute LoadOrds.loadOrders() concurrently
Starting thread: Thread[LoadOrds.loadOrders-0,5,main] For range 1 - 93750
Starting thread: Thread[LoadOrds.loadOrders-1,5,main] For range 93751 - 187500
Starting thread: Thread[LoadOrds.loadOrders-2,5,main] For range 187501 - 281250
Starting thread: Thread[LoadOrds.loadOrders-3,5,main] For range 281251 - 375000
Waiting for LoadOrds.loadOrder() threads to finish..
Waiting to join Thread[LoadOrds.loadOrders-0,5,main]
Joined Thread[LoadOrds.loadOrders-0,5,]
Waiting to join Thread[LoadOrds.loadOrders-1,5,]
Joined Thread[LoadOrds.loadOrders-1,5,]
Waiting to join Thread[LoadOrds.loadOrders-2,5,]
Joined Thread[LoadOrds.loadOrders-2,5,]
Waiting to join Thread[LoadOrds.loadOrders-3,5,]
Joined Thread[LoadOrds.loadOrders-3,5,]
Ignoring read() errors...
Ignoring read() errors...
Ignoring read() errors...
Launcher: done waiting.
Finished Database Load
Script ended Tue Sep 5 17:34:28 CST 2017
[root@dbserver other_scripts]#
[root@dbserver other_scripts]#
[root@dbserver other_scripts]# ./loaddb_postgres.sh ^C
[root@dbserver other_scripts]# echo $?
130
-
This looks like it loaded successfully. Please use the helper script backupdb.sh to back it up. Then use the script /opt/other_scripts/getDBcounts.sh and compare it to SPECJapp-DB-table-sizes.xls to see if the table counts are correct:
/opt/other_scripts/getDBcounts.sh /usr/pgsql-9.2/bin
For example:
[root@dbserver1 other_scripts]# /opt/other_scripts/getDBcounts.sh /usr/pgsql-9.2/bin
+ dbname=specdb
+ username=spec
+ /usr/pgsql-9.2/bin/psql -s specdb -U spec
***(Single step mode: verify command)*******************************************
select count(*) from c_site ;
***(press return to proceed or enter x and return to cancel)********************
count
-------
1
(1 row)
***(Single step mode: verify command)*******************************************
select count(*) from c_supplier ;
***(press return to proceed or enter x and return to cancel)********************
count
-------
10
(1 row)
***(Single step mode: verify command)*******************************************
select count(*) from c_customer ;
***(press return to proceed or enter x and return to cancel)********************
count
---------
3750000
(1 row)
and so on. If they're good, you're ready to set up the appserver.
Lisa