RE: [Zope] Database Corruption - Please HELP
-----Original Message----- From: Ze Octavio [mailto:joc@hiper.com.br] Sent: Tuesday, July 20, 1999 2:40 PM To: zope@zope.org Subject: [Zope] Database Corruption - Please HELP Importance: High
Hi all
After a hard day of work in Zope yesterday, I arrive today and receive the error message about database corruption. I know that we can truncate the Data.bbb in the address of the record corrupted, great. And I did it in that way:
perl -e 'truncate "Data.bbb",4672086'
And whe I try to open the Data.bbb again, all is gone ! Only the default Data.bbb was restored, all my data is gone. The users, everything. What is the right way to truncate the Data.bbb please.
Looks like you did it the right way. I've never used perl though, just the unix 'split' program. What you should really worry about is why your database got corrupted in the first place (you do back up your data, right? so the loss of the file won't be that much of a loss, right?). Are you storing the Data.bbb file on a remote filesystem? This is a no no and can cause database corruption. -Michel
-- Ze Octavio -- Hiperlógica <http://hiper.com.br> Automação de web-sites | Web-site automation São Paulo | Brasil | Fone: +55-11-251-4894
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
Michel Pelletier wrote:
-----Original Message----- From: Ze Octavio [mailto:joc@hiper.com.br] Sent: Tuesday, July 20, 1999 2:40 PM To: zope@zope.org Subject: [Zope] Database Corruption - Please HELP Importance: High
Hi all
After a hard day of work in Zope yesterday, I arrive today and receive the error message about database corruption. I know that we can truncate the Data.bbb in the address of the record corrupted, great. And I did it in that way:
perl -e 'truncate "Data.bbb",4672086'
And whe I try to open the Data.bbb again, all is gone ! Only the default Data.bbb was restored, all my data is gone. The users, everything. What is the right way to truncate the Data.bbb please.
Looks like you did it the right way. I've never used perl though, just the unix 'split' program.
What you should really worry about is why your database got corrupted in the first place (you do back up your data, right? so the loss of the file won't be that much of a loss, right?). Are you storing the Data.bbb file on a remote filesystem? This is a no no and can cause database corruption.
-Michel
Michel, I had the Data.bbb.old and had the same error, I dont know why, I will try to open in another filesystem with Zope. I renamed the Data.bbb.old from last saturday, to Data.bbb, and when I tried to truncate again the same thing happended... Thanxs for reply
-- Ze Octavio -- Hiperlógica <http://hiper.com.br> Automação de web-sites | Web-site automation São Paulo | Brasil | Fone: +55-11-251-4894
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
-- Ze Octavio -- Hiperlógica <http://hiper.com.br> Automação de web-sites | Web-site automation São Paulo | Brasil | Fone: +55-11-251-4894
Michel Pelletier wrote:
-----Original Message----- From: Ze Octavio [mailto:joc@hiper.com.br] Sent: Tuesday, July 20, 1999 2:40 PM To: zope@zope.org Subject: [Zope] Database Corruption - Please HELP Importance: High
Hi all
After a hard day of work in Zope yesterday, I arrive today and receive the error message about database corruption. I know that we can truncate the Data.bbb in the address of the record corrupted, great. And I did it in that way:
perl -e 'truncate "Data.bbb",4672086'
And whe I try to open the Data.bbb again, all is gone ! Only the default Data.bbb was restored, all my data is gone. The users, everything. What is the right way to truncate the Data.bbb please.
Looks like you did it the right way. I've never used perl though, just the unix 'split' program.
What you should really worry about is why your database got corrupted in the first place (you do back up your data, right? so the loss of the file won't be that much of a loss, right?). Are you storing the Data.bbb file on a remote filesystem? This is a no no and can cause database corruption.
-Michel
-- Ze Octavio -- Hiperlógica <http://hiper.com.br> Automação de web-sites | Web-site automation São Paulo | Brasil | Fone: +55-11-251-4894
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
Michel, Here is the message: Sorry, a SERIOUS APPLICATION ERROR occurred.<p> <!-- Traceback (innermost last): File /home/zope/IDGnow/lib/python/ZPublisher/Publish.py, line 877, in publish_module File /home/zope/IDGnow/lib/python/ZPublisher/Publish.py, line 325, in publish File /home/zope/IDGnow/lib/python/ZPublisher/Publish.py, line 616, in get_module_info File /home/zope/IDGnow/lib/python/Main.py, line 103, in ? File /home/zope/IDGnow/lib/python/OFS/Application.py, line 319, in open_bobobase File /home/zope/IDGnow/lib/python/BoboPOS/PickleDictionary.py, line 159, in __init__ File /home/zope/IDGnow/lib/python/BoboPOS/SimpleDB.py, line 221, in __init__ File /home/zope/IDGnow/lib/python/BoboPOS/SimpleDB.py, line 287, in open File /home/zope/IDGnow/lib/python/BoboPOS/SimpleDB.py, line 1365, in read_index (Info: (4672086, 3776, 0, 926350651.789, 1308, 1267)) ImportError: ('DatabaseError', 'Corrupted data record at 4672086') --> Thanxs for help -- Ze Octavio -- Hiperlógica <http://hiper.com.br> Automação de web-sites | Web-site automation São Paulo | Brasil | Fone: +55-11-251-4894
participants (2)
-
Michel Pelletier -
Ze Octavio