Database Disappeared - PostgreSQL Database

Roberts, Adam

Some time ago (May 2004), we were making changes to a Postgresql server
to allow a host to connect (pg_hba.conf). When we restarted the server,
and restarted the AOLserver process, there was only one table left. All
the ACS tables were gone.

As we were troubleshooting the problem, we found the last known good
dump (I pg_dump every four hours) was a month previous (sometime in
April), when we made a change to ttracker_ticket s's table.

From that time in April up unitl we last had this problem, openacs
worked fine, but the dumps were missing all ACS related tables.

We have encountered this exact same problem again today. Originally, we
thought it was due to a fault in our procedures in making the changes,
however, this time, no one was altering anything. This appears to have
happened sans any human intervention.

The following is a link to the last post we had with this same problem:
http://openacs.org/forums/message-vi...sage_id=185837

The following is a link to the post we made last friday about the
current problem:
http://openacs.org/forums/message-vi...sage_id=206092
We thought that this might be an AOLserver problem, however, through our
investigation and comments from posts to the OpenACS board, we believe
this is an error with PostgresSQL.
We are hoping that someone might have some ideas or any experience with
this. Thanks!!
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1

Subscribe Reply

2458

Joshua D. Drake

We thought that this might be an AOLserver problem, however, through our
investigatio n and comments from posts to the OpenACS board, we believe
this is an error with PostgresSQL.
We are hoping that someone might have some ideas or any experience with
this. Thanks!!
Are you vacuuming? How often?

Sincerely,

Joshua D. Drake

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

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #2

Tom Lane

"Roberts, Adam" <Ad**********@e chostar.com> writes:

The following is a link to the last post we had with this same problem:
http://openacs.org/forums/message-vi...sage_id=185837

Given the comment about 500M pg_clog, I would venture that you aren't
doing adequate vacuuming and have therefore run into a transaction ID
wraparound failure. 500Mb clog corresponds to 2 billion transactions
which is right about where things would blow up if you'd not done the
necessary database-wide vacuums; and the fact that clog hasn't gotten
truncated is pretty strong evidence that you didn't.

Please read the administrator's guide:
http://www.postgresql.org/docs/7.4/s...intenance.html
(adjust for your PG version as needed)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #3

Similar topics

346

16642

database market share 2003

by: rkusenet | last post by:

http://biz.yahoo.com/rc/040526/tech_database_marketshare_1.html Interesting to see that database sales for windows is more than Unix.

DB2 Database

2137

Help Needed With Bizarre Database Behaviour In Access 2003

by: Wayne Aprato | last post by:

I have a simple database which was originally written in Access 97. When converted to Access 2000 file format it ran flawlessly in Access 2002. I've just tried to run it in Access 2003 and I am seeing the following behaviour: Some of the fields on the continuous main form which is a list of jobs with their related details "flicker". While this is going on the form seems to function as it should and isn't locked up. If I click and hold...

Microsoft Access / VBA

5033

Northwind Database

by: RibGnaw | last post by:

Long, long ago when Access 97 first hit the streets a sample database called Northwind was shipped with it. At that time a number of articles had been posted on the correct procedure to remove all the sample data. Does anyone out there still have this information?

Microsoft Access / VBA

2994

Unrecognized database format

by: timmso | last post by:

I'm using Ado.net in an asp.net project with an Access backend. Whenever I try to do a simple Select or Update, I inevitably see the error "Unrecognized database format". I'm using Access 2000. Here is some code for an aspx page: Sub Page_Load(Source As Object, E As EventArgs) Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.4.0;" & _ "data source=D:\Data\Codelib\codelib.mdb;"

ASP.NET

1951

Downloaded document has disappeared by the time Word has opened

by: Rob Nicholson | last post by:

We've implemented functionality to allow a user to download a document (any document type) from the IIS server using the following code: Response.Clear() Response.ContentType = "application/x-msdownload" Response.AddHeader("Content-Disposition", "attachment; filename=" & System.IO.Path.GetFileName(FilePath)) Response.AddHeader("Content-Length", File.Length.ToString()) Response.WriteFile(FilePath) Response.End()

ASP.NET

1915

CREATE DATABASE on the heap with PostgreSQL?

by: Albretch | last post by:

DBMS like MySQL and hsqldb (the only two I know that can keep and process tables on the heap) have a CREATE DATABASE case in which the 'database' is specified to reside in memory, that is RAM. For some data handling cases for which persistence is not important, this is all you need. These types of DBs are very fast and convenient for temporary and transient 'tables' you don't really need or care to persist, like session tables for web...

PostgreSQL Database

2290

onclick postback event has disappeared

by: Bahman | last post by:

Hello! Except for dropdownlists, all other controls have lost their postback call. The default postback call runs all the time. What would be the more likely cause for this? Thank you for your help! -Bahman

ASP.NET

1159

Strange Database Error

by: Smiley | last post by:

Okay, I've already managed to track down this bug and fix it. But the thing is, I'm not quite sure why it happened and it's left me scratching my head. I was setting up some scripts to display videos embedded in a webpage. The program does some writing to a database to store captions and such. For some reason, though, the database writing wasn't working. I'd tested out the functions in other scripts and they went just fine. I wasn't...

PHP

1349

Database diagrams disappeared after attaching the database on different machine

by: mca47378 | last post by:

Hi, I attached my database on different machine. Everything seems to be okay as of now, but I dont see my database diagrams here, which I had created and saved on the previous machine in this database. Can anyone please suggest me cuase. Thank you, Mithalesh

Microsoft SQL Server

3544

Reattaching database - identity_insert set to off

by: ll | last post by:

Hi, I recently detached and subsequently reattached a database, and now I've had to go back to each table and re-establish the primary keys, as well as the identity="yes" where needed. I am currently getting the following error message, although this table's identity_insert is set to ON ("yes"). I'm currently re-checking all other tables to see if they would perhaps impact this. Would there be anything else I could do at this point? ...

Microsoft SQL Server

9621

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

9454

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

10264

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++

9914

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

6717

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

5355

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4012

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

3610

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2852

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General