[Solved] Out of Memory Error

Discuss the database features

[Solved] Out of Memory Error

Postby TJM05 » Wed Jul 11, 2012 5:50 pm

Hello All,
My Main Customer table has become corrupted (I'm assuming) and the table will not open. When I attempt to open the table I get the following error:

THE DATA CONTENT COULD NOT BE LOADED. out of memory.

When I click the MORE button I receive the following information:


SQL Status: S1000
Error code: 72

out of memory


AND:

The SQL command leading to this error is:

SELECT * FROM "Orders"

("Orders" is the name of the table that will not open.)

I have tried SHUTDOWN COMPACT and get this message:

1: File input/output error: mydb.script.new in statement [SHUTDOWN COMPACT]

And then in my db folder I see I have a mydb.script AND a mydb.script.new file

I have recently moved to a multi-user set up so I'm wondering if there are duplicate records or some other conflict going on.

ANY help would be greatly appreciated. I am dead in the water until I can get this fixed. Even though I have been utilizing my db for quite sometime without major problems, I'm still rather new to the intricacies of db management.

Thank you!
TJM05
Last edited by TJM05 on Fri Jul 13, 2012 2:42 am, edited 1 time in total.
Open Office 3.3/Windows 7
TJM05
 
Posts: 25
Joined: Tue May 10, 2011 10:58 pm

Re: Out of Memory Error

Postby Sliderule » Thu Jul 12, 2012 3:57 pm

Since no one else has responded yet, I am sending you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1166
Joined: Thu Nov 29, 2007 9:46 am

Re: Out of Memory Error

Postby TJM05 » Fri Jul 13, 2012 2:41 am

OK, what happened is that the file had become so large that the data was inaccessible. I had not run a checkpoint defrag, which is the key to keeping the files manageable. I had a back up from last week that I was able to use before the problem began... and I immediately used ran the Checkpoint Defrag in the SQL command screen and the .data file shrunk extensively. Looks like I'm good to go.

Thank you so much to Sliderule for all your help! :bravo:
Open Office 3.3/Windows 7
TJM05
 
Posts: 25
Joined: Tue May 10, 2011 10:58 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests