database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
ㆍPostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
PostgreSQL Q&A 6802 게시물 읽기
No. 6802
로그파일 해석좀부탁드립니다.
작성자
왕초보
작성일
2006-08-08 16:38ⓒ
2006-08-08 17:21ⓜ
조회수
4,038

갑자기 특정테이블을 조회를 하면 아래와같이 메시지가 뜨고 백업도 되지 않습니다.

어떻게 복구해야되나요 정말 난감합니다..근데 이상한건 데이터가 존재하는테이블은

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

[Top]
No.
제목
작성자
작성일
조회
6805Function 안에서 ROLLBACK? [1]
?
2006-08-09
3702
6804SELECT 의 최적화와 Disk Block 에 대하여
초보
2006-08-09
3272
6803prepared statement 사용시 플랜 공유 범위.. [4]
백수환
2006-08-08
3653
6802로그파일 해석좀부탁드립니다.
왕초보
2006-08-08
4038
6801pgadmin3 에대해서 [1]
이민우
2006-08-08
3773
6800백업에 대한 질문입니다. [1]
궁금이
2006-08-06
3489
6794안녕하세요. 초보질문입니다 (__) [1]
justin
2006-08-01
3154
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.015초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다