Errors from TPCh test

gistfile1.txt

server signaled
LOG:  received SIGHUP, reloading configuration files
LOG:  parameter "checkpoint_segments" changed to "300"
LOG:  parameter "checkpoint_timeout" changed to "3600s"
LOG:  parameter "checkpoint_completion_target" changed to "0.9"
LOG:  parameter "shared_buffers" cannot be changed without restarting the server
LOG:  parameter "maintenance_work_mem" changed to "1GB"
LOG:  configuration file "/AXLE/postgres/pgdata1GB/postgresql.conf" contains errors; unaffected changes were applied
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
COPY 25
TRUNCATE TABLE
TRUNCATE TABLE
COPY 150000
COPY 200000
COPY 800000
COPY 1500000
ALTER TABLE
ALTER TABLE
ERROR:  insert or update on table "nation" violates foreign key constraint "nation_n_regionkey_fkey"
DETAIL:  Key (n_regionkey)=(0) is not present in table "region".
STATEMENT:  ALTER TABLE NATION
	ADD FOREIGN KEY (N_REGIONKEY) references REGION;
ERROR:  insert or update on table "nation" violates foreign key constraint "nation_n_regionkey_fkey"
DETAIL:  Key (n_regionkey)=(0) is not present in table "region".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
LOG:  sending cancel to blocking autovacuum PID 20506
DETAIL:  Process 20505 waits for AccessExclusiveLock on relation 16403 of database 16384.
STATEMENT:  ALTER TABLE ORDERS
	ADD PRIMARY KEY (O_ORDERKEY);
ERROR:  canceling autovacuum task
CONTEXT:  automatic analyze of table "tpch.public.orders"
ALTER TABLE
LOG:  sending cancel to blocking autovacuum PID 20506
DETAIL:  Process 20505 waits for AccessExclusiveLock on relation 16397 of database 16384.
STATEMENT:  ALTER TABLE PARTSUPP
	ADD FOREIGN KEY (PS_SUPPKEY) references SUPPLIER;
ERROR:  canceling autovacuum task
CONTEXT:  automatic analyze of table "tpch.public.partsupp"
ERROR:  insert or update on table "partsupp" violates foreign key constraint "partsupp_ps_suppkey_fkey"
DETAIL:  Key (ps_suppkey)=(2) is not present in table "supplier".
STATEMENT:  ALTER TABLE PARTSUPP
	ADD FOREIGN KEY (PS_SUPPKEY) references SUPPLIER;
ERROR:  insert or update on table "partsupp" violates foreign key constraint "partsupp_ps_suppkey_fkey"
DETAIL:  Key (ps_suppkey)=(2) is not present in table "supplier".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
Creating 'All' indexes...
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX

checkpoint_timeout = 600s
work_mem = 12GB                      #2 to 16GB
effective_cache_size = 192GB        #3/4 of total RAM (192GB)
default_statistics_target = 5000    #requires analyze to take effect
maintenance_work_mem = 32MB

server signaled
LOG:  received SIGHUP, reloading configuration files
LOG:  parameter "shared_buffers" cannot be changed without restarting the server
LOG:  parameter "checkpoint_timeout" changed to "600s"
LOG:  parameter "work_mem" changed to "12GB"
LOG:  parameter "effective_cache_size" changed to "192GB"
LOG:  parameter "default_statistics_target" changed to "5000"
LOG:  parameter "maintenance_work_mem" changed to "32MB"
LOG:  configuration file "/AXLE/postgres/pgdata1GB/postgresql.conf" contains errors; unaffected changes were applied
never
Running vacuum freeze analyze...
VACUUM
ANALYZE
Checkpointing...
CHECKPOINT
Elapsed time: 0:02:59
Cleaning up before exiting
waiting for server to shut down....LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
 done
server stopped






LOG:  parameter "shared_buffers" cannot be changed without restarting the server
LOG:  parameter "checkpoint_timeout" changed to "600s"
LOG:  parameter "work_mem" changed to "12GB"
LOG:  parameter "effective_cache_size" changed to "192GB"
LOG:  parameter "default_statistics_target" changed to "5000"
LOG:  parameter "maintenance_work_mem" changed to "32MB"
LOG:  configuration file "/AXLE/postgres/pgdata1GB/postgresql.conf" contains errors; unaffected changes were applied
LOG:  sending cancel to blocking autovacuum PID 22453
DETAIL:  Process 22464 waits for ShareUpdateExclusiveLock on relation 16406 of database 16384.
STATEMENT:  vacuum freeze
ERROR:  canceling autovacuum task
CONTEXT:  automatic analyze of table "tpch.public.lineitem"
VACUUM
ANALYZE
Checkpointing...
CHECKPOINT
Elapsed time: 0:06:10
Cleaning up before exiting
waiting for server to shut down....LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
 done
server stopped