Re: Lost Records in Database
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39522
interpreted = N
texte = Clint Davis wrote: > > I have a WebSTAR server that's under a tremendous load right now. > About once a day, the server crashes and is automatically restarted. > This server hosts 2 sites that are almost entirely database-driven.Classic Mac O/S or OSX? It makes a big difference. Always tell us O/S, web server version, WebCat version, in addition to the hardware details.> > Almost each time the server crashes, one database gets corrupted and > a large block of records is lost. The database is about 8.5MB and the > server has 640MB. This single database is the only one with any > trouble. > > Everything seems to be working normally while the server is running. > It doesn't appear that the database is corrupted. > > This is an emergency. Can anyone think of a possible solution?For every record that is written to this file, also write to a second file that changes every day. That way, you always have today's complete database as well as a backup of only today's data. You can even restore yesterday's complete database and append today's records to recover.However, this is a bandaid solution. If your server is crashing due to load, you need to investigate other options. If you are running under MacOS, it may be that you need to move to OS/X or Linux to get better performance. It may be that you simply have a bad memory chip. It may be that you have 1 page of bad WebDNA that is causing the server to die.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Clint Davis wrote: > > I have a WebSTAR server that's under a tremendous load right now. > About once a day, the server crashes and is automatically restarted. > This server hosts 2 sites that are almost entirely database-driven.Classic Mac O/S or OSX? It makes a big difference. Always tell us O/S, web server version, WebCat version, in addition to the hardware details.> > Almost each time the server crashes, one database gets corrupted and > a large block of records is lost. The database is about 8.5MB and the > server has 640MB. This single database is the only one with any > trouble. > > Everything seems to be working normally while the server is running. > It doesn't appear that the database is corrupted. > > This is an emergency. Can anyone think of a possible solution?For every record that is written to this file, also write to a second file that changes every day. That way, you always have today's complete database as well as a backup of only today's data. You can even restore yesterday's complete database and append today's records to recover.However, this is a bandaid solution. If your server is crashing due to load, you need to investigate other options. If you are running under MacOS, it may be that you need to move to OS/X or Linux to get better performance. It may be that you simply have a bad memory chip. It may be that you have 1 page of bad WebDNA that is causing the server to die.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
SmithMicro at Macworld NY (2000)
Updating fields from different platforms (1998)
Forms Search Questions (1997)
all records returned. (1997)
Faxing orders in place of email (1997)
PCS Frames (1997)
off-topic: SMS interface? (2001)
Where is the secure setting for text variables? (2003)
upgrading (1997)
Next (1997)
Multiple Merchant Accounts? (1997)
WebCat for mass emailings (1997)
Need host (1998)
[Capitalize] (1998)
Help with update to 2.11 (1998)
Authenticate (1997)
Re:Problem (1997)
[searchString] (1997)
Solve the Problem, get the code! (2001)
Client-side Image Maps and WebCat? (1998)