Solved

buggy kernels / unexpected data beyond EOF in block xxxxxxx

Posted on 2009-07-16
2
1,670 Views
Last Modified: 2012-05-07
We have the following problem on our database server when executing a (quite heavy) sql query.

############################
select count(*) from pqrs();
ERROR:  unexpected data beyond EOF in block xxxxxxx of relation "properties_xyz"
HINT:  This has been seen to occur with buggy kernels; consider updating your system.
CONTEXT:  SQL statement "UPDATE properties_xyz SET abc_option_id =  $1  WHERE id =  $2 "
PL/pgSQL function "pqrs" line 63 at SQL statement

********** Error **********

ERROR: unexpected data beyond EOF in block xxxxxxx of relation "properties_xyz"
SQL status:XX000
Aanwijzing:This has been seen to occur with buggy kernels; consider updating your system.
############################

The serverload becomes critical after some time.

System info:

- Postgres 8.2.12
- Linux: Red Hat 4.1.2-12 (64 bits)

Do you have any idea what causes this and how to solve it?
0
Comment
Question by:R7AF
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Assisted Solution

by:cminear
cminear earned 500 total points
ID: 24871948
The best answer is likely as the HINT suggests: perform an upgrade of the kernel.  What kernel are you running? (Run 'uname -a' and paste results in.)  In external mailing lists, the problem has been resolved by moving from SLES 2.6.5-7.244 to 2.6.5-7.282 (which of course doesn't help you with Redhat kernel versions).  Redhat 4.7 seems to have a base kernel of 2.6.9-78, while Redhat 5.3 seems to have 2.6.18-128.  (I won't guarantee that either of these kernel versions have the specific fix for the kernel bug you are likely hitting, but they probably do.)

If you have a Redhat support contract, I would recommend that you work with them on the best option for upgrading the kernel.  If you do not, investigate an upgrade on a test server on your own.

If a system upgrade is totally out of the question, you may be able to rework the query so that it doesn't hit the bug.  However, this would be a hit or miss fix, and only temporary.  You would almost be better if you schedule the query only during low-load periods (although you seem to indicate that the query itself generates the load, so this may be a non-starter for a work-around).
0
 
LVL 13

Accepted Solution

by:
R7AF earned 0 total points
ID: 24893470
We moved the database to another server, upgraded that server to Postgresql 8.4, and now the problems seem to be disappeared!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

688 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