# 테이블 "stylesheet\_cache" 내용 덤프 실패: PQgetResult() 실패

**URL:** https://meta.discourse.org/t/dumping-the-contents-of-table-stylesheet-cache-failed-pqgetresult-failed/153291
**Category:** Support
**Created:** [5월 30, 2020, 7:31오전 UTC](https://meta.discourse.org/t/dumping-the-contents-of-table-stylesheet-cache-failed-pqgetresult-failed/153291 "2020-05-30T07:31:37Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![chratec](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/chratec/32/175969_2.png) [@chratec](https://meta.discourse.org/u/chratec)
#### Post date: [5월 30, 2020, 7:31오전 UTC](https://meta.discourse.org/t/dumping-the-contents-of-table-stylesheet-cache-failed-pqgetresult-failed/153291/1 "2020-05-30T07:31:37Z")

</div>

안녕하세요,  
백업을 실행할 때 discourse에서 “stylesheet\_cache” 테이블에 오류가 발생했습니다.  
로그에 표시된 오류는 다음과 같습니다:

```plaintext
[2020-05-30 06:55:50] pg_dump: dumping contents of table "public.stylesheet_cache"
[2020-05-30 06:56:06] pg_dump: error: Dumping the contents of table "stylesheet_cache" failed: PQgetResult() failed.
[2020-05-30 06:56:06] pg_dump: error: Error message from server: ERROR: unexpected chunk size 1996 (expected 1315) in final chunk 44 for toast value 35175 in pg_toast_22999
[2020-05-30 06:56:07] pg_dump: error: The command was: COPY public.stylesheet_cache (id, target, digest, content, created_at, updated_at, theme_id, source_map) TO stdout;
[2020-05-30 06:56:07] Unpausing sidekiq...
[2020-05-30 06:56:07] EXCEPTION: pg_dump failed

```

앱에 접속하여 이 테이블을 재인덱싱(reindex)하려고 시도했지만, CLI에서 다음과 같이 실패했습니다:

```plaintext
discourse=# REINDEX TABLE public.stylesheet_cache;
ERROR: could not create unique index "stylesheet_cache_pkey"
DETAIL: Key (id)=(11604) is duplicated.

```

PostgreSQL에 익숙하지 않아서, 데이터베이스에서 이 오류를 제거하는 방법에 대해 조언해 주실 수 있을까요? 도와주세요.