Обсуждение: BUG #4948: getting error while vacuuming the database
The following bug has been logged online: Bug reference: 4948 Logged by: fous Email address: honza801@gmail.com PostgreSQL version: 8.4.0 Operating system: Linux (CentOS release 5.3) Description: getting error while vacuuming the database Details: hi i'm getting this error while vacuuming the database. proxylog=# VACUUM ; ERROR: failed to re-find parent key in index "user_day" for deletion target page 1441795 the same appears using vacuumdb command vacuumdb: vacuuming of database "proxylog" failed: ERROR: failed to re-find parent key in index "user_day" for deletion target page 1441795 i've found one thread with the same error http://archives.postgresql.org/pgsql-bugs/2007-08/msg00082.php but was not fixed/resolved does anoyne know, where the problem is? thanks fous
"fous" <honza801@gmail.com> writes: > i'm getting this error while vacuuming the database. > proxylog=# VACUUM ; > ERROR: failed to re-find parent key in index "user_day" for deletion > target > page 1441795 > does anoyne know, where the problem is? Nope. If you just want to fix it, reindexing that index should do the trick. If you want us to look into what caused it and whether there's a fixable bug there, we'll need a whole lot more information than the error message. regards, tom lane
well, i knew how to fix it (probably the reindexing, that you mentioned;)) but i think this happens often in our database, so what informations would you like to know? i'm awaiting orders :) fous > Nope. > > If you just want to fix it, reindexing that index should do the trick. > > If you want us to look into what caused it and whether there's a fixable > bug there, we'll need a whole lot more information than the error > message. > > regards, tom lane >