Solved

Unexpected data beyond EOF error in Postgres

Posted on 2011-09-23
3
621 Views
Last Modified: 2012-05-12
Hello, i'm using a Postgres 9.0.1 database and got the following error from one of my sql statements(not sure which one):

ERROR:  unexpected data beyond EOF in block 98762 of relation pg_tblspc/2600082/PG_9.0_201008051/2600083/2732877
HINT:  This has been seen to occur with buggy kernels; consider updating your system.

Open in new window


Has anyone ever seen this before?  Any help would be greatly appreciated.  Thank You.
0
Comment
Question by:Alex Matzinger
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 36589207
Have you pursued the "HINT:  This has been seen to occur with buggy kernels; consider updating your system." According to http://www.experts-exchange.com/Q_24575375.html#a24893470, an upgrade of PostgreSQL indeed fixes the issue.
0
 
LVL 4

Author Comment

by:Alex Matzinger
ID: 36590357
Yes, I have seen that question, but upgrading Postgres isn't really an option(when 9.1 has been out for a little while we'll go to that, but not right now). I'm hoping someone may have been able to track down what exactly might have caused this on their system.  Its only happened once, but it doesn't show up in any logs or really anything, which is very strange.

I made a mistake before, we're on postgres 9.0.4
0
 
LVL 4

Author Closing Comment

by:Alex Matzinger
ID: 37510411
I've caved and upgraded the server.  This still doesn't answer the issue, but it just may be there is no real solution to this besides "get the latest version".  Thank you for your help.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now