Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100 - Mailing list pgsql-general
| From | Harry Ambrose |
|---|---|
| Subject | Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100 |
| Date | |
| Msg-id | CAK4Knu_YNohugK5XO9HVjcAb9Xmg-Vx8aDz+pUgUvXGdPQb8nA@mail.gmail.com Whole thread Raw |
| In response to | Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100 (Achilleas Mantzios <achill@matrix.gatewaynet.com>) |
| Responses |
Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
(Achilleas Mantzios <achill@matrix.gatewaynet.com>)
|
| List | pgsql-general |
Maybe you could give some info on :
- your ext3 mkfs and mount options (journal, barriers, etc)
Filesystem features: has_journal ext_attr resize_inode dir_index filetype needs_recovery sparse_super large_file
Filesystem flags: signed_directory_hash
Default mount options: (none)
Filesystem state: clean
Errors behavior: Continue
Filesystem OS type: Linux
Inode count: 36634624
Block count: 146506767
Reserved block count: 7325338
Free blocks: 143785740
Free inodes: 36627866
First block: 0
Block size: 4096
Fragment size: 4096
Reserved GDT blocks: 989
Blocks per group: 32768
Fragments per group: 32768
Inodes per group: 8192
Inode blocks per group: 512
RAID stride: 64
RAID stripe width: 64
Filesystem created: Fri Aug 9 16:11:53 2013
Last mount time: Fri Apr 21 22:37:02 2017
Last write time: Fri Apr 21 22:37:02 2017
Mount count: 2
Maximum mount count: 100
Last checked: Thu Sep 15 18:52:43 2016
Check interval: 31536000 (12 months, 5 days)
Next check after: Fri Sep 15 18:52:43 2017
Reserved blocks uid: 0 (user root)
Reserved blocks gid: 0 (group root)
First inode: 11
Inode size: 256
Required extra isize: 28
Desired extra isize: 28
Journal inode: 8
Default directory hash: half_md4
Journal backup: inode blocks
Filesystem features: has_journal ext_attr resize_inode dir_index filetype needs_recovery sparse_super large_file
Filesystem flags: signed_directory_hash
Default mount options: (none)
Filesystem state: clean
Errors behavior: Continue
Filesystem OS type: Linux
Inode count: 73261056
Block count: 293013543
Reserved block count: 14650677
Free blocks: 286208439
Free inodes: 73174728
First block: 0
Block size: 4096
Fragment size: 4096
Reserved GDT blocks: 954
Blocks per group: 32768
Fragments per group: 32768
Inodes per group: 8192
Inode blocks per group: 512
RAID stride: 64
RAID stripe width: 128
Filesystem created: Fri Aug 9 16:11:53 2013
Last mount time: Fri Apr 21 22:37:02 2017
Last write time: Fri Apr 21 22:37:02 2017
Mount count: 2
Maximum mount count: 100
Last checked: Thu Sep 15 18:52:43 2016
Check interval: 31536000 (12 months, 5 days)
Next check after: Fri Sep 15 18:52:43 2017
Reserved blocks uid: 0 (user root)
Reserved blocks gid: 0 (group root)
First inode: 11
Inode size: 256
Required extra isize: 28
Desired extra isize: 28
Journal inode: 8
Default directory hash: half_md4
Journal backup: inode blocks
- your controller setup (battery should be working good and cache mode set to write back)
- your disks setup (write cache should be disabled)
- you should check your syslogs/messages for any errors related to storage
- is your RAM ECC? Did you run any memtest?
- is your CPU overheating ?
- have you experienced any crashes/freezes ?
pgsql-general by date: