WebFaction
Community site: login faq

Approx 80 users have been deleted somehow.

I don't think they've been deleted through the django admin UI as there are no django admin logs for it.

It may be related but I also had to REINDEX the django_session_pkey. Part of stack trace: "ProgrammingError: ERROR: index "django_session_pkey" contains unexpected zero page at block 33 [Fri Oct 22 03:50:14 2010] [error] [client 127.0.0.1] HINT: Please REINDEX it."

Has my database been corrupted somehow....How can I find out what deleted these users?

asked 23 Oct '10, 14:29

patquinn
612
accept rate: 0%

tried this: "VACUUM FULL; ..... WARNING: index "auth_user_pkey" contains 149 row versions, but table contains 29 row versions HINT: Rebuild the index with REINDEX. WARNING: index "auth_user_username_key" contains 136 row versions, but table contains 29 row versions HINT: Rebuild the index with REINDEX. WARNING: index "auth_user_pkey" contains 149 row versions, but table contains 29 row versions HINT: Rebuild the index with REINDEX. WARNING: index "auth_user_username_key" contains 136 row versions, but table contains 29 row versions HINT: Rebuild the index with REINDEX. ...... VACUUM"

(23 Oct '10, 14:43) patquinn

That does sound like database corruption. If you'd like to restore your database from a backup, feel free to open a support ticket to let us know the name of the database and the date from which you want the backup (we keep a 10-day history).

permanent link

answered 23 Oct '10, 14:43

seanf
12.2k41836
accept rate: 37%

Ok seanf, thanks for your reply. I've filed a ticket...hopefully the data from 10 days ago was ok. Thanks again.

(23 Oct '10, 15:29) patquinn
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×909
×108
×37
×4

question asked: 23 Oct '10, 14:29

question was seen: 3,785 times

last updated: 23 Oct '10, 15:29

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM