Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Internal error: index

J. Blume
on 4/6/13, 4:12 PM 5,748 views

Hi there,

When selecting Financials a window is opened with the OpenERP Server Error: InternalError: index "ir_translation_src_hash_idx" contains unexpected zero page at block 84 HINT: Please REINDEX it.

Does anybody knows how this can be done? Is there a tool which I can do this?

So how did you solve this?

on 4/14/13, 11:59 PM


| 5 6 8
Cornwall, Canada

Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com

On 4/6/13, 8:33 PM

You have some database corruption, but probably nothing to worry about. The error report is telling you what you should do . . . use REINDEX.

However, before anything you should use pg_dump to get a text backup copy of your entire database.

Then log in to postgres as admin with psql and run the command REINDEX INDEX ir_translation_src_hash_idx

Just Google it for more details : https://www.google.com/search?q=index+contains+unexpected+zero+page+at+block+HINT%3A+Please+REINDEX+it

If you still have problems after that, try pg_restore with the text backup to a new database and see if that one works. I'm confident it will.

Thanks, pgadminIII and a Reindex did the trick.

J. Blume
on 4/15/13, 7:20 AM

I'm glad I was able to help.

on 4/15/13, 9:28 AM
On 6/27/14, 9:33 AM

GUI method:

Run pgAdmin3, open database-Schemas-public-Tables-ir_translation-Indexes- right click: ir_translation_src_hash_idx - Maintenance.. REINDEX(by default) - OK!

Excelent information !!!!!

Jose M. González
on 1/12/16, 4:00 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 4/6/13, 4:12 PM
Seen: 5748 times
Last updated: 9/24/15, 12:04 AM