갑자기 특정테이블을 조회를 하면 아래와같이 메시지가 뜨고 백업도
되지 않습니다.
어떻게 복구해야되나요 정말 난감합니다..근데 이상한건 데이터가
존재하는테이블은
pgAdmin III에서 조회가 잘되는데 데이터가 존재하지 않는 테이블을
select 하면 아래와 같은 메시지가
나타납니다.
해결방법은 없는지요 혹시나해서 로그파일 올립니다. 정말
급합니다...
could not open relation
1663/17253/17653: No such file or directory
8월1일 로그**********************************
2006-08-01 09:17:15 LOG: database system was shut down at
2006-07-31 19:36:28 대한민국 표준시
2006-08-01 09:17:15 LOG: checkpoint record is at 0/26BBB310
2006-08-01 09:17:15 LOG: redo record is at 0/26BBB310; undo record
is at 0/0; shutdown TRUE
2006-08-01 09:17:15 LOG: next transaction ID: 21742; next OID:
133097
2006-08-01 09:17:16 LOG: database system is ready
2006-08-01 11:33:35 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:33:45 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:34:00 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:34:10 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:34:32 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:34:44 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:35:49 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:36:22 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:37:05 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:38:01 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 11:39:09 ERROR: null value in column "sizee" violates
not-null constraint
2006-08-01 19:56:14 LOG: received fast shutdown request
2006-08-01 19:56:15 LOG: shutting down
2006-08-01 19:56:16 LOG: database system is shut down
2006-08-01 19:56:17 LOG: logger shutting down
8월2일
로그********************************************************************
2006-08-02 12:52:04 LOG: database system was shut down at
2006-08-01 19:56:15 대한민국 표준시
2006-08-02 12:52:04 LOG: checkpoint record is at 0/2728C2C8
2006-08-02 12:52:04 LOG: redo record is at 0/2728C2C8; undo record
is at 0/0; shutdown TRUE
2006-08-02 12:52:04 LOG: next transaction ID: 22020; next OID:
133885
2006-08-02 12:52:04 LOG: database system is ready
2006-08-02 13:03:26 LOG: received fast shutdown request
2006-08-02 13:03:26 LOG: shutting down
2006-08-02 13:03:27 LOG: database system is shut down
2006-08-02 13:03:27 LOG: logger shutting down
2006-08-02 13:04:21 LOG: database system was shut down at
2006-08-02 13:03:27 대한민국 표준시
2006-08-02 13:04:21 LOG: checkpoint record is at 0/2728C348
2006-08-02 13:04:21 LOG: redo record is at 0/2728C348; undo record
is at 0/0; shutdown TRUE
2006-08-02 13:04:21 LOG: next transaction ID: 22020; next OID:
133885
2006-08-02 13:04:21 LOG: database system is ready
2006-08-02 13:05:25 ERROR: could not open relation
1663/17253/17653: No such file or directory
2006-08-02 13:05:30 ERROR: could not open relation
1663/17253/17653: No such file or directory
2006-08-02 13:05:30 ERROR: could not open relation
1663/17253/17649: No such file or directory
2006-08-02 13:05:36 ERROR: could not open relation
1663/17253/17653: No such file or directory
|