Home > mailing lists
BUG #3254: unexpected data beyond EOF in block - Mailing list pgsql-bugs

From	Mario Santini
Subject	BUG #3254: unexpected data beyond EOF in block
Date	April 26, 2007 19:12:46
Msg-id	200704260754.l3Q7sJE0053415@wwwmaster.postgresql.org Whole thread Raw
Responses	Re: BUG #3254: unexpected data beyond EOF in block
List	pgsql-bugs
Tree view
The following bug has been logged online:

Bug reference:      3254
Logged by:          Mario Santini
Email address:      mario1.santini@telecomitalia.it
PostgreSQL version: 8.2.3
Operating system:   CentOS
Description:        unexpected data beyond EOF in block
Details:

Hello,
I use Mediawiki 1.9.3 with PostgreSQL 8.2.3 on a Linux CentOS :

Linux kabul.sodalia.it 2.6.9-34.ELsmp #1 SMP Wed Mar 8 00:27:03 CST 2006
i686 i686 i386 GNU/Linux

And cpu :

x86info v1.13.  Dave Jones 2001-2003
Feedback to <davej@redhat.com>.

Found 4 CPUs
MP Table:
#       APIC ID Version State           Family  Model   Step    Flags
#        0       0x14    BSP, usable     15      4       10      0xbfebfbff
#        6       0x14    AP, usable      15      4       10      0xbfebfbff

--------------------------------------------------------------------------
CPU #1
/dev/cpu/0/cpuid: No such file or directory
eax in: 0x00000000, eax = 00000005 ebx = 756e6547 ecx = 6c65746e edx =
49656e69
eax in: 0x00000001, eax = 00000f4a ebx = 06020800 ecx = 0000659d edx =
bfebfbff
eax in: 0x00000002, eax = 605b5001 ebx = 00000000 ecx = 00000000 edx =
007d7040
eax in: 0x00000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x00000004, eax = 00004121 ebx = 01c0003f ecx = 0000001f edx =
00000000
eax in: 0x00000005, eax = 00000040 ebx = 00000040 ecx = 00000000 edx =
00000000

eax in: 0x80000000, eax = 80000008 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000001, eax = 00000000 ebx = 00000000 ecx = 00000001 edx =
20000000
eax in: 0x80000002, eax = 20202020 ebx = 20202020 ecx = 20202020 edx =
20202020
eax in: 0x80000003, eax = 6e492020 ebx = 286c6574 ecx = 58202952 edx =
286e6f65
eax in: 0x80000004, eax = 20294d54 ebx = 20555043 ecx = 30382e33 edx =
007a4847
eax in: 0x80000005, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000006, eax = 00000000 ebx = 00000000 ecx = 08006040 edx =
00000000
eax in: 0x80000007, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000008, eax = 00003024 ebx = 00000000 ecx = 00000000 edx =
00000000

Family: 15 Model: 4 Stepping: 10 Type: 0 Brand: 0
CPU Model: Pentium 4 Xeon (Foster) Original OEM
Processor name string: Intel(R) Xeon(TM) CPU 3.80GHz

Feature flags:
        Onboard FPU
        Virtual Mode Extensions
        Debugging Extensions
        Page Size Extensions
        Time Stamp Counter
        Model-Specific Registers
        Physical Address Extensions
        Machine Check Architecture
        CMPXCHG8 instruction
        Onboard APIC
        SYSENTER/SYSEXIT
        Memory Type Range Registers
        Page Global Enable
        Machine Check Architecture
        CMOV instruction
        Page Attribute Table
        36-bit PSEs
        CLFLUSH instruction
        Debug Trace Store
        ACPI via MSR
        MMX support
        FXSAVE and FXRESTORE instructions
        SSE support
        SSE2 support
        CPU self snoop
        Hyper-Threading
        Automatic clock Control
        Pending Break Enable

Extended feature flags:
 est tm2 cntx-id
Pentium 4 specific MSRs:
/dev/cpu/0/msr: No such file or directory

Instruction trace cache:
        Size: 12K uOps  8-way associative.
L1 Data cache:
        Size: 16KB      Sectored, 8-way associative.
        line size=64 bytes.
Instruction TLB: 4K, 2MB or 4MB pages, fully associative, 64 entries.
Data TLB: 4KB or 4MB pages, fully associative, 64 entries.
Processor serial: 0000-0F4A-0000-0000-0000-0000
The physical package supports 2 logical processors

Connector type: Socket603 (PGA603 Socket)


MTRR registers:
MTRRcap (0xfe): MTRRphysBase0 (0x200): MTRRphysMask0 (0x201): MTRRphysBase1
(0x202): MTRRphysMask1 (0x203): MTRRphysBase2 (0x204): MTRRphysMask2
(0x205): MTRRphysBase3 (0x206): MTRRphysMask3 (0x207): MTRRphysBase4
(0x208): MTRRphysMask4 (0x209): MTRRphysBase5 (0x20a): MTRRphysMask5
(0x20b): MTRRphysBase6 (0x20c): MTRRphysMask6 (0x20d): MTRRphysBase7
(0x20e): MTRRphysMask7 (0x20f): MTRRfix64K_00000 (0x250): MTRRfix16K_80000
(0x258): MTRRfix16K_A0000 (0x259): MTRRfix4K_C8000 (0x269): MTRRfix4K_D0000
0x26a: MTRRfix4K_D8000 0x26b: MTRRfix4K_E0000 0x26c: MTRRfix4K_E8000 0x26d:
MTRRfix4K_F0000 0x26e: MTRRfix4K_F8000 0x26f: MTRRdefType (0x2ff):

3.8Ghz processor (estimate).

--------------------------------------------------------------------------
CPU #2
eax in: 0x00000000, eax = 00000005 ebx = 756e6547 ecx = 6c65746e edx =
49656e69
eax in: 0x00000001, eax = 00000f4a ebx = 06020800 ecx = 0000659d edx =
bfebfbff
eax in: 0x00000002, eax = 605b5001 ebx = 00000000 ecx = 00000000 edx =
007d7040
eax in: 0x00000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x00000004, eax = 00004121 ebx = 01c0003f ecx = 0000001f edx =
00000000
eax in: 0x00000005, eax = 00000040 ebx = 00000040 ecx = 00000000 edx =
00000000

eax in: 0x80000000, eax = 80000008 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000001, eax = 00000000 ebx = 00000000 ecx = 00000001 edx =
20000000
eax in: 0x80000002, eax = 20202020 ebx = 20202020 ecx = 20202020 edx =
20202020
eax in: 0x80000003, eax = 6e492020 ebx = 286c6574 ecx = 58202952 edx =
286e6f65
eax in: 0x80000004, eax = 20294d54 ebx = 20555043 ecx = 30382e33 edx =
007a4847
eax in: 0x80000005, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000006, eax = 00000000 ebx = 00000000 ecx = 08006040 edx =
00000000
eax in: 0x80000007, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000008, eax = 00003024 ebx = 00000000 ecx = 00000000 edx =
00000000

Family: 15 Model: 4 Stepping: 10 Type: 0 Brand: 0
CPU Model: Pentium 4 Xeon (Foster) Original OEM
Processor name string: Intel(R) Xeon(TM) CPU 3.80GHz

Feature flags:
        Onboard FPU
        Virtual Mode Extensions
        Debugging Extensions
        Page Size Extensions
        Time Stamp Counter
        Model-Specific Registers
        Physical Address Extensions
        Machine Check Architecture
        CMPXCHG8 instruction
        Onboard APIC
        SYSENTER/SYSEXIT
        Memory Type Range Registers
        Page Global Enable
        Machine Check Architecture
        CMOV instruction
        Page Attribute Table
        36-bit PSEs
        CLFLUSH instruction
        Debug Trace Store
        ACPI via MSR
        MMX support
        FXSAVE and FXRESTORE instructions
        SSE support
        SSE2 support
        CPU self snoop
        Hyper-Threading
        Automatic clock Control
        Pending Break Enable

Extended feature flags:
 est tm2 cntx-id
Pentium 4 specific MSRs:

Instruction trace cache:
        Size: 12K uOps  8-way associative.
L1 Data cache:
        Size: 16KB      Sectored, 8-way associative.
        line size=64 bytes.
Instruction TLB: 4K, 2MB or 4MB pages, fully associative, 64 entries.
Data TLB: 4KB or 4MB pages, fully associative, 64 entries.
Processor serial: 0000-0F4A-0000-0000-0000-0000
The physical package supports 2 logical processors

Connector type: Socket603 (PGA603 Socket)


MTRR registers:
MTRRcap (0xfe): MTRRphysBase0 (0x200): MTRRphysMask0 (0x201): MTRRphysBase1
(0x202): MTRRphysMask1 (0x203): MTRRphysBase2 (0x204): MTRRphysMask2
(0x205): MTRRphysBase3 (0x206): MTRRphysMask3 (0x207): MTRRphysBase4
(0x208): MTRRphysMask4 (0x209): MTRRphysBase5 (0x20a): MTRRphysMask5
(0x20b): MTRRphysBase6 (0x20c): MTRRphysMask6 (0x20d): MTRRphysBase7
(0x20e): MTRRphysMask7 (0x20f): MTRRfix64K_00000 (0x250): MTRRfix16K_80000
(0x258): MTRRfix16K_A0000 (0x259): MTRRfix4K_C8000 (0x269): MTRRfix4K_D0000
0x26a: MTRRfix4K_D8000 0x26b: MTRRfix4K_E0000 0x26c: MTRRfix4K_E8000 0x26d:
MTRRfix4K_F0000 0x26e: MTRRfix4K_F8000 0x26f: MTRRdefType (0x2ff):

3.8Ghz processor (estimate).

--------------------------------------------------------------------------
CPU #3
eax in: 0x00000000, eax = 00000005 ebx = 756e6547 ecx = 6c65746e edx =
49656e69
eax in: 0x00000001, eax = 00000f4a ebx = 06020800 ecx = 0000659d edx =
bfebfbff
eax in: 0x00000002, eax = 605b5001 ebx = 00000000 ecx = 00000000 edx =
007d7040
eax in: 0x00000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x00000004, eax = 00004121 ebx = 01c0003f ecx = 0000001f edx =
00000000
eax in: 0x00000005, eax = 00000040 ebx = 00000040 ecx = 00000000 edx =
00000000

eax in: 0x80000000, eax = 80000008 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000001, eax = 00000000 ebx = 00000000 ecx = 00000001 edx =
20000000
eax in: 0x80000002, eax = 20202020 ebx = 20202020 ecx = 20202020 edx =
20202020
eax in: 0x80000003, eax = 6e492020 ebx = 286c6574 ecx = 58202952 edx =
286e6f65
eax in: 0x80000004, eax = 20294d54 ebx = 20555043 ecx = 30382e33 edx =
007a4847
eax in: 0x80000005, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000006, eax = 00000000 ebx = 00000000 ecx = 08006040 edx =
00000000
eax in: 0x80000007, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000008, eax = 00003024 ebx = 00000000 ecx = 00000000 edx =
00000000

Family: 15 Model: 4 Stepping: 10 Type: 0 Brand: 0
CPU Model: Pentium 4 Xeon (Foster) Original OEM
Processor name string: Intel(R) Xeon(TM) CPU 3.80GHz

Feature flags:
        Onboard FPU
        Virtual Mode Extensions
        Debugging Extensions
        Page Size Extensions
        Time Stamp Counter
        Model-Specific Registers
        Physical Address Extensions
        Machine Check Architecture
        CMPXCHG8 instruction
        Onboard APIC
        SYSENTER/SYSEXIT
        Memory Type Range Registers
        Page Global Enable
        Machine Check Architecture
        CMOV instruction
        Page Attribute Table
        36-bit PSEs
        CLFLUSH instruction
        Debug Trace Store
        ACPI via MSR
        MMX support
        FXSAVE and FXRESTORE instructions
        SSE support
        SSE2 support
        CPU self snoop
        Hyper-Threading
        Automatic clock Control
        Pending Break Enable

Extended feature flags:
 est tm2 cntx-id
Pentium 4 specific MSRs:

Instruction trace cache:
        Size: 12K uOps  8-way associative.
L1 Data cache:
        Size: 16KB      Sectored, 8-way associative.
        line size=64 bytes.
Instruction TLB: 4K, 2MB or 4MB pages, fully associative, 64 entries.
Data TLB: 4KB or 4MB pages, fully associative, 64 entries.
Processor serial: 0000-0F4A-0000-0000-0000-0000
The physical package supports 2 logical processors

Connector type: Socket603 (PGA603 Socket)


MTRR registers:
MTRRcap (0xfe): MTRRphysBase0 (0x200): MTRRphysMask0 (0x201): MTRRphysBase1
(0x202): MTRRphysMask1 (0x203): MTRRphysBase2 (0x204): MTRRphysMask2
(0x205): MTRRphysBase3 (0x206): MTRRphysMask3 (0x207): MTRRphysBase4
(0x208): MTRRphysMask4 (0x209): MTRRphysBase5 (0x20a): MTRRphysMask5
(0x20b): MTRRphysBase6 (0x20c): MTRRphysMask6 (0x20d): MTRRphysBase7
(0x20e): MTRRphysMask7 (0x20f): MTRRfix64K_00000 (0x250): MTRRfix16K_80000
(0x258): MTRRfix16K_A0000 (0x259): MTRRfix4K_C8000 (0x269): MTRRfix4K_D0000
0x26a: MTRRfix4K_D8000 0x26b: MTRRfix4K_E0000 0x26c: MTRRfix4K_E8000 0x26d:
MTRRfix4K_F0000 0x26e: MTRRfix4K_F8000 0x26f: MTRRdefType (0x2ff):

3.8Ghz processor (estimate).

--------------------------------------------------------------------------
CPU #4
eax in: 0x00000000, eax = 00000005 ebx = 756e6547 ecx = 6c65746e edx =
49656e69
eax in: 0x00000001, eax = 00000f4a ebx = 06020800 ecx = 0000659d edx =
bfebfbff
eax in: 0x00000002, eax = 605b5001 ebx = 00000000 ecx = 00000000 edx =
007d7040
eax in: 0x00000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x00000004, eax = 00004121 ebx = 01c0003f ecx = 0000001f edx =
00000000
eax in: 0x00000005, eax = 00000040 ebx = 00000040 ecx = 00000000 edx =
00000000

eax in: 0x80000000, eax = 80000008 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000001, eax = 00000000 ebx = 00000000 ecx = 00000001 edx =
20000000
eax in: 0x80000002, eax = 20202020 ebx = 20202020 ecx = 20202020 edx =
20202020
eax in: 0x80000003, eax = 6e492020 ebx = 286c6574 ecx = 58202952 edx =
286e6f65
eax in: 0x80000004, eax = 20294d54 ebx = 20555043 ecx = 30382e33 edx =
007a4847
eax in: 0x80000005, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000006, eax = 00000000 ebx = 00000000 ecx = 08006040 edx =
00000000
eax in: 0x80000007, eax = 00000000 ebx = 00000000 ecx = 00000000 edx =
00000000
eax in: 0x80000008, eax = 00003024 ebx = 00000000 ecx = 00000000 edx =
00000000

Family: 15 Model: 4 Stepping: 10 Type: 0 Brand: 0
CPU Model: Pentium 4 Xeon (Foster) Original OEM
Processor name string: Intel(R) Xeon(TM) CPU 3.80GHz

Feature flags:
        Onboard FPU
        Virtual Mode Extensions
        Debugging Extensions
        Page Size Extensions
        Time Stamp Counter
        Model-Specific Registers
        Physical Address Extensions
        Machine Check Architecture
        CMPXCHG8 instruction
        Onboard APIC
        SYSENTER/SYSEXIT
        Memory Type Range Registers
        Page Global Enable
        Machine Check Architecture
        CMOV instruction
        Page Attribute Table
        36-bit PSEs
        CLFLUSH instruction
        Debug Trace Store
        ACPI via MSR
        MMX support
        FXSAVE and FXRESTORE instructions
        SSE support
        SSE2 support
        CPU self snoop
        Hyper-Threading
        Automatic clock Control
        Pending Break Enable

Extended feature flags:
 est tm2 cntx-id
Pentium 4 specific MSRs:

Instruction trace cache:
        Size: 12K uOps  8-way associative.
L1 Data cache:
        Size: 16KB      Sectored, 8-way associative.
        line size=64 bytes.
Instruction TLB: 4K, 2MB or 4MB pages, fully associative, 64 entries.
Data TLB: 4KB or 4MB pages, fully associative, 64 entries.
Processor serial: 0000-0F4A-0000-0000-0000-0000
The physical package supports 2 logical processors

Connector type: Socket603 (PGA603 Socket)


MTRR registers:
MTRRcap (0xfe): MTRRphysBase0 (0x200): MTRRphysMask0 (0x201): MTRRphysBase1
(0x202): MTRRphysMask1 (0x203): MTRRphysBase2 (0x204): MTRRphysMask2
(0x205): MTRRphysBase3 (0x206): MTRRphysMask3 (0x207): MTRRphysBase4
(0x208): MTRRphysMask4 (0x209): MTRRphysBase5 (0x20a): MTRRphysMask5
(0x20b): MTRRphysBase6 (0x20c): MTRRphysMask6 (0x20d): MTRRphysBase7
(0x20e): MTRRphysMask7 (0x20f): MTRRfix64K_00000 (0x250): MTRRfix16K_80000
(0x258): MTRRfix16K_A0000 (0x259): MTRRfix4K_C8000 (0x269): MTRRfix4K_D0000
0x26a: MTRRfix4K_D8000 0x26b: MTRRfix4K_E0000 0x26c: MTRRfix4K_E8000 0x26d:
MTRRfix4K_F0000 0x26e: MTRRfix4K_F8000 0x26f: MTRRdefType (0x2ff):

3.8Ghz processor (estimate).

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

The problem appear displaying the pages :

Query failed: ERROR:  unexpected data beyond EOF in block 1311 of relation
"pg_toast_17041"
HINT:  This has been seen to occur with buggy kernels; consider updating
your system.

I see there is similar post in the mailing list, but I could not find any
solution.
Is this a PostgreSQL bug?
There is a fix in the last 8.2.4 release?

Thanks and regards.
pgsql-bugs by date:
From: "Lee Chua"
Date: 26 April 2007, 19:12:40
Subject: Re: BUG #3252: Select Order by time
From: Tom Lane
Date: 26 April 2007, 20:26:32
Subject: Re: BUG #3254: unexpected data beyond EOF in block
BUG #3254: unexpected data beyond EOF in block - Mailing list pgsql-bugs

Previous

Next
