?
Solved

buggy kernels / unexpected data beyond EOF in block xxxxxxx

Posted on 2009-07-16
2
Medium Priority
?
1,700 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
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…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

770 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