Database Corruption ? - PostgreSQL Database

Chris Stokes

Hi all,

I am having a number of problems with a customer of ours. This customer is in Thailand so I don't have good machine direct access to their computers.

Scenario - we have a Java based POS system that we chose to run on Linux using PGSQL. This generally works quite ok, However at this particular customer they seem to be getting regular database corruptions requiring us to recreate the database on the machine. The following are the errors displayed when trying to start the database

[basspos@till1 root]$ postmaster -D /var/lib/pgsql/data

LOG: database system shutdown was interrupted at 2003-11-12 14:46:30 ICT
LOG: checkpoint record is at 1/812CFFC0
LOG: redo record is at 1/812CFFC0; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 4704776; next oid: 4616023
LOG: database system was not properly shut down; automatic recovery in progress
LOG: ReadRecord: unexpected pageaddr 1/7A2D0000 in log file 1, segment 129, offset 2949120
LOG: redo is not required
PANIC: XLogWrite: write request 1/812D0000 is past end of log 1/812D0000
LOG: startup process (pid 4672) was terminated by signal 6
LOG: aborting startup due to startup process failure

My questions are
What might cause this? I can't vouch for the users of these machines they may well be just powering them off without proper shutdown but I would hope that PGSQL is more robust than that.

Is this repairable? I am currently getting them to just drop the database and start again.

Regards

Chris Stokes
Senior Systems Consultant
Phone: +61 3 8415 9305 (Direct)
Level 5 534 Church St
Richmond Vic 3121 Aust
ch****@basssoft ware.com <mailto:ch****@ basssoftware.co m>

BASS Software

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1

Subscribe Reply

1492

Tom Lane

"Chris Stokes" <Ch****@BassSof tware.com> writes:

PANIC: XLogWrite: write request 1/812D0000 is past end of log 1/812D0000

This sure looks like the symptom of the 7.3.3 failure-to-restart bug.
If you are on 7.3.3 then an update to 7.3.4 will fix it.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

Similar topics

3527

DAO and database corruption

by: Mike | last post by:

I have done a lot of research on DAO and database corruption and have not yet found any solid information for my problem. I use DAO extensively in my Access 97 databases (back-end on network, front-ends on clients' computers). I'm having some difficulties with the multi-user environment (my databases corrupt frequently) and I'm thinking it has to do with how I'm using DAO to read/write to recordsets. Up until now, I have been setting...

Microsoft Access / VBA

7144

Unrecognized database format 'filename.mdb'

by: L Mehl | last post by:

I tested a FE/BE application developed in A2000 on a A2002 machine and got this message when exiting the app. Clicking the only available button "OK", exits the application, as intended. The FE is just the mdb, not an mde. FE and BE are in different directories on the same machine. Are there settings, preferably via code, that I can add to stop this error? Thank you for any help.

Microsoft Access / VBA

3427

Japanese characters corrupt database

by: Gary Schrader via AccessMonster.com | last post by:

I have a database I use for training. I copy the database to the local drive of each studens machine. During training, as we work through a series of exercises, some of the machines will convert the text in some of the fields in the database to Japanese characters and corrupt the database. There is no consistency in when this occurs. It is not specific to any particular table, form, report, query or module. It is random and does not...

Microsoft Access / VBA

4545

Advice needed: Should we upgrade MS Access 2000? And if so to what?

by: ship | last post by:

Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!

Microsoft Access / VBA

1846

Networking Database

by: Gary | last post by:

I have recently placed an access database (back end) on a network folder. The standalone pc's accessing the network have in their own respective C drives a copy of the database (minus the table). I have linked the backend source table to these front end database copies. The networking has been working nicely but the other day, I got a message when trying to access the database stating that the format is not a recognizable one... ie i...

Microsoft Access / VBA

3126

Detecting database corruption

by: Jack Orenstein | last post by:

My company is developing a PostgreSQL 7.4 application. We don't want our customers to have to manage the database, so we're automating as much maintenance as possible. If the database ever becomes corrupt, we have procedures for restoring the database from backup data. The question we've been wondering about is how to detect a corrupt database. False positives are acceptable (database isn't really corrupt but we think it is); false...

PostgreSQL Database

2254

Synchronizing with a non-replicated database is not allowed. The <name> database is not a Design Master or replica

by: MAILTONRK | last post by:

Hi, I am a Mainframe guy. I am working with MS access(maintaining a application) for the last 2 weeks. I had one master database and four replicas. One of my replica had trouble in synchronization(It said, database is in use..). After searching google, I ran "Compact and repair" utlity against my replica. It looks like, it has changed the attribute of my replica.

Microsoft Access / VBA

4895

How to corrupt a MS Access database file in a 'normal' way?

by: shineofleo | last post by:

Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was some problems with this programm. I checked, the log files showed that the database was corrupted. The customer told me that there no 'illegal' operation such as pull out the plug, or kill the programm via task manager... So is there any...

Microsoft Access / VBA

2015

Grrrr!! Access 2003 Database Corrupting On Exit

by: suzanne | last post by:

I have a database that had been stable until 3 weeks ago. The Access 2003 database occasionally (a couple of times a week) gets corrupted when the last user exits the application. At least, that's what I'm assuming since they get no error while working. If I make a copy of the database prior to the last user logging out, that copied DB remains undamaged. If I attempt to log back the original DB in once everyone is out, I get the dreaded...

Microsoft Access / VBA

1826

Vista - WinXP environment and database corruption?

by: Vincent | last post by:

The company I work for has developed a Microsoft Access application. Currently, it is distributed with the Microsoft Access 2002 runtime. Some of our customers have begun purchasing new Vista computers and we have seen some unsettling results. In particular, after installing a Vista computer on their LAN, one of our customer's experienced repeated database corruption. We suggested they discontinue their use of the Vista computer. Once...

Microsoft Access / VBA

9629

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9465

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10296

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9923

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8954

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7474

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6723

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5497

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4031

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp