On Wed, Jan 26, 2011 at 10:58 PM, Joe Dalton <joedalt...@yahoo.dk> wrote: > please don't fix this. It is better to have the robot down than up and > running with a 1.000 errors. > > So please take it down again.
Ok, now I'm confused. I was contacted yesterday on IRC to look at the server and it appeared to be running several hundred copies of the perl script and mostly in swap. So I kill all those and it works again, only now the database is missing stuff. So I fix that. And now you want me to take "it" down? What do you mean by "it": DDTSS, DDTP or everything else on that server? Looking at the mail history it looks like all the problems were caused by a disk full which corrupted the database. What makes you think that with recovering the database these aren't all fixed as well. If there's still problems, lets hear them. Now, it's clear that there needs to be more info about how to recover the database so that I'm not the only one who can do it. So I attached something below for the archives. Lets see if the issues are now solved first. Have a nice day, --- cut --- In my home directory there are two programs, /home/kleptog/db_dump and /home/kleptog/db_load. The database is at /org/ddtp.debian.net/ddtss/ddtss2.db . What I did was basically: 1. Lock out the user interface, by editting the script in /var/www/ddtp/ddtss/index.cgi 2. cp /org/ddtp.debian.net/ddtss/ddtss2.db ~/ddtss2.db 3. time nice ./db_dump ~/ddtss2.db -r -f ~/ddtss2.dump 4. time nice ./db_load -t btree -f ~/ddtss2.dump ~/ddtss2.db.fixed 5. mv ~/ddtss2.db.fixed /org/ddtp.debian.net/ddtss/ddtss2.db The exact steps may be different due to permissions and checking whether the resulting files are about the right size. If the files got a lot smaller, you did something wrong. It should be about 300MB. --- cut --- -- Martijn van Oosterhout <klep...@gmail.com> http://svana.org/kleptog/ -- To UNSUBSCRIBE, email to debian-i18n-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/aanlktim1jozwz6-+fixbyzcx5x9m-vndcs7s9vqsa...@mail.gmail.com
