Author Topic: Run loaddb_postgres.sh error  (Read 4270 times)

zgy

  • Newbie
  • *
  • Posts: 42
  • Karma: +0/-0
Run loaddb_postgres.sh error
« 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

lroderic

  • Moderator
  • Full Member
  • *****
  • Posts: 167
  • Karma: +6/-0
Re: Run loaddb_postgres.sh error
« Reply #1 on: September 05, 2017, 10:42:23 AM »
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:

Code: [Select]
/opt/other_scripts/getDBcounts.sh /usr/pgsql-9.2/bin
For example:

Code: [Select]
[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