postgresql 9.3 on SpecVirt 작업 일지

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

Error 메시지 - (Reference 1 참조)

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

makeme_dbserver.sh

테이블 생성이 모두 실패.

하지만 끝까지 진행

loaddb_postgres.sh

막판에 read error 3개 발생

하지만 완료 

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

특이 사항

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

디비를 새로 생성하고, 기존의 데이터를 반드시 없애야 함. (아니면 디비가 실행이 안됨)

디비를 생성한 계정으로 postgresql-9.3 을 실행해야만 함.

initdb: 한번 디비의 데이터가 생성된 경우(/var/lib/pgsql/9.3/data) 반드시 fail이 발생한다. 백업을 다른 곳에 해두고 initdb를 다시 할것

service postgresql-9.3 start 가 그래도 안될 경우, 

/usr/pgsql-9.3/bin/postgres -D /dbstore/data 를 해보고 메시지를 살필것.

postgres cannot access the server configuration file "/dbstore/postgresql.conf": No such file or directory

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

Reference 1

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

[root@dbserver1 dbvm_scripts]# ./makeme_dbserver.sh

++ cat /opt/hosts.vms

++ echo JAVA_HOME=/usr/lib/jvm/jre

++ echo 'export JAVA_HOME'

++ POSTGRES_CONFDIR=/etc

++ service postgresql-9.3 initdb

Data directory is not empty!

++ service postgresql-9.3 start                            [FAILED]

Starting postgresql-9.3 service:                           [  OK  ]

++ service postgresql-9.3 stop

Stopping postgresql-9.3 service:                           [  OK  ]

++ chkconfig postgresql-9.3 on

++ mkdir -p /dbstore

++ mkdir -p /dbstore/data/spects

++ mkdir -p /dbstore/log

++ mv /var/lib/pgsql/9.3/data/pg_clog /dbstore/log

++ mv /var/lib/pgsql/9.3/data/pg_xlog /dbstore/log

++ ln -s /dbstore/log/pg_clog /var/lib/pgsql/9.3/data/pg_clog

++ ln -s /dbstore/log/pg_xlog /var/lib/pgsql/9.3/data/pg_xlog

++ chown -R postgres:postgres /dbstore

++ cp /var/lib/pgsql/9.3/data/pg_hba.conf /var/lib/pgsql/9.3/data/pg_hba.conf.orig

++ cp /var/lib/pgsql/9.3/data/postgresql.conf /var/lib/pgsql/9.3/data/postgresql.conf.orig

++ sed -i s/ident/trust/g /var/lib/pgsql/9.3/data/pg_hba.conf

++ sed -i s/peer/trust/g /var/lib/pgsql/9.3/data/pg_hba.conf

++ cat /opt/dbvm_scripts/files/postgresql93.conf.append

++ echo 'host all all 20.20.20.0/24 trust'

++ echo 'host all all 192.168.100.0/24 trust'

++ echo 500 64000 400 512

++ service postgresql-9.3 start

Starting postgresql-9.3 service:                           [  OK  ]

++ sleep 20

++ cd /opt/SPECjAppServer2004/schema/postgresql/

++ sed -i s/postgres/dbstore/g sql/create_tablespace.sql

++ service postgresql-9.3 stop

Stopping postgresql-9.3 service:                           [  OK  ]

++ sleep 20

++ service postgresql-9.3 start

Starting postgresql-9.3 service:                           [  OK  ]

++ ./buildall.sh

CREATE TABLESPACE

dropdb: database removal failed: ERROR:  database "specdb" does not exist

SET

ERROR:  table "c_customerinventory" does not exist

CREATE TABLE

CREATE INDEX

ERROR:  table "c_customer" does not exist

CREATE TABLE

ERROR:  table "c_supplier" does not exist

CREATE TABLE

ERROR:  table "c_site" does not exist

CREATE TABLE

ERROR:  table "c_parts" does not exist

CREATE TABLE

SET

ERROR:  table "m_parts" does not exist

CREATE TABLE

ERROR:  table "m_bom" does not exist

CREATE TABLE

ERROR:  table "m_workorder" does not exist

CREATE TABLE

ERROR:  table "m_largeorder" does not exist

CREATE TABLE

CREATE INDEX

CREATE INDEX

ERROR:  table "m_inventory" does not exist

CREATE TABLE

SET

ERROR:  table "o_orders" does not exist

CREATE TABLE

CREATE INDEX

ERROR:  table "o_orderline" does not exist

CREATE TABLE

ERROR:  table "o_item" does not exist

CREATE TABLE

CREATE INDEX

SET

ERROR:  table "s_component" does not exist

CREATE TABLE

ERROR:  table "s_supp_component" does not exist

CREATE TABLE

ERROR:  table "s_supplier" does not exist

CREATE TABLE

ERROR:  table "s_site" does not exist

CREATE TABLE

ERROR:  table "s_purchase_order" does not exist

CREATE TABLE

ERROR:  table "s_purchase_orderline" does not exist

CREATE TABLE

SET

ERROR:  table "txn_log_table" does not exist

CREATE TABLE

SET

ERROR:  table "u_sequences" does not exist

CREATE TABLE

SET

ALTER TABLE

ERROR:  multiple primary keys for table "c_customer" are not allowed

ERROR:  multiple primary keys for table "c_customerinventory" are not allowed

ERROR:  multiple primary keys for table "c_parts" are not allowed

ERROR:  multiple primary keys for table "c_site" are not allowed

ERROR:  multiple primary keys for table "c_supplier" are not allowed

ERROR:  multiple primary keys for table "m_bom" are not allowed

ERROR:  multiple primary keys for table "m_inventory" are not allowed

ERROR:  multiple primary keys for table "m_largeorder" are not allowed

ERROR:  multiple primary keys for table "m_parts" are not allowed

ERROR:  multiple primary keys for table "m_workorder" are not allowed

ERROR:  multiple primary keys for table "o_item" are not allowed

ERROR:  multiple primary keys for table "o_orderline" are not allowed

ERROR:  multiple primary keys for table "o_orders" are not allowed

ERROR:  multiple primary keys for table "s_component" are not allowed

ERROR:  multiple primary keys for table "s_purchase_order" are not allowed

ERROR:  multiple primary keys for table "s_purchase_orderline" are not allowed

ERROR:  multiple primary keys for table "s_site" are not allowed

ERROR:  multiple primary keys for table "s_supp_component" are not allowed

ERROR:  multiple primary keys for table "s_supplier" are not allowed

ERROR:  multiple primary keys for table "txn_log_table" are not allowed

ERROR:  multiple primary keys for table "u_sequences" are not allowed

ERROR:  relation "c_custci_idx" already exists

ERROR:  relation "m_lo_cat_idx" already exists

ERROR:  relation "m_lo_o_idx" already exists

ERROR:  relation "o_icat_idx" already exists

ERROR:  relation "o_oc_idx" already exists

REVOKE

REVOKE

GRANT

GRANT

++ echo JAVA_HOME=/usr/lib/jvm/jre

++ echo 'export JAVA_HOME'

++ echo 'PATH=${JAVA_HOME}/bin:$PATH'

++ echo 'export PATH'

++ echo 'java -jar /opt/SPECpoll/pollme.jar -n `hostname`-int -p 8001 > /tmp/pollme.out 2>&1&'

++ /opt/dbvm_scripts/ostune.sh

Reverting to saved sysctl settings:                        [  OK  ]

Calling '/etc/ktune.d/tunedadm.sh stop':                   [  OK  ]

Reverting to cfq elevator: dm-0 dm-1 vda vdb               [  OK  ]

Stopping tuned:                                            [  OK  ]

Switching to profile 'virtual-guest'

Applying deadline elevator: dm-0 dm-1 vda vdb              [  OK  ]

Applying ktune sysctl settings:

/etc/ktune.d/tunedadm.conf:                                [  OK  ]

Calling '/etc/ktune.d/tunedadm.sh start':                  [  OK  ]

Applying sysctl settings from /etc/sysctl.d/libvirtd

Applying sysctl settings from /etc/sysctl.conf

Starting tuned:                                            [  OK  ]

++ set +x