Accessing categories failed


Hi guys, we encoured an issue accessing categories in last few days.

Scenario to replicate is

click on Categories list
select a Category (all are broken)

It gives a 500 error internal error, URL is not reachable.

Logs (INFO) give

ActiveRecord::StatementInvalid (PG::DataCorrupted: ERROR:  could not read block 0 in file "base/16384/65447": read only 4096 of 8192 bytes
: SELECT "category_featured_users".* FROM "category_featured_users" WHERE "category_featured_users"."category_id" IN (68))
/var/www/discourse/vendor/bundle/ruby/2.3.0/gems/rack-mini-profiler-0.10.1/lib/patches/db/pg.rb:90:in `exec'

Do you have any idea on it? Note that we update Discourse each week, but no tweaks on Category as far.

Thank you for your help!

(Jeff Atwood) #2

Datacorrupted implies you have a corrupt database.


OK, that confirm what I was thinking, thx! Is there any way to simply fix database? the only way consists to drop recreate restore with last data backup (from admin?)?

Thank you