How to solve error after restored database?

v6.1 test synology build restore

2 Svar

26789 Vyer

ton123

I made a backup of my production server and restored it on my test server.

When I started the database on my test server there was a long list of errors ending with:

File "/var/packages/OpenERP6.1/target/openerp/addons/base/ir/ir_model.py", line 509, in check
    if self.pool.get(model_name).is_transient():
AttributeError: 'NoneType' object has no attribute 'is_transient'

Note 1: Restore on production server give no errors.
Note 2: The restore is functioning on the test server, but I think it only need time to have this in trouble.
Note 3: In the settings menu the menu entry modules is missing.
Note 4: Production server uses python 2.7.2-006, v6.1.1-011. For the testserver these are Python 2.7.3-011 and v6.1.1-012.

I think the cause is there are some differences in installed modules. The difference is sure because testserver is a fresh installation and production server has some additionals. I have well documented them.

Why this question?

It is a test in how to trouble shoot restore problems in future critic situations like hardware failure. And I think the result is important for the community.

If the differences in modules is the cause please confirm.

My question is now:

How effectively trouble shoot in these situations this problem?

Ray Carnes

What are the builds (or revisions of each branch) of OpenERP and versions of Postgres on each server?

ton123

Författare

Thanks for your comment! In Note 4 are the numbers of the installers that I used for my Synology servers. It are prepared packages for their servers. I will try to get the answers from them or do you think I can see it somewhere in the coding?

Andreas Brueckl

You should have exact the same versions in Prod, Test and Dev. Otherwise you will never know whether a tested module also runs in production without any problems.

ton123

Författare

Thanks Brueckl. This is the other reasons I want to test this. If I have the test server up and running, I am able to migrate the software on the production server without risk ;-) .

ton123

Författare Bästa svar

I solved it and I report back what it did.

First some response on earlier comments:

Ray Carnes I don't know the builds of my installed software. It is a special prepared package from Synology. I need two clicks for install. One for install of Python and one for install of OpenERP itself. The version number I see is 6.1.1-012. Python is 2.7.3-011. In the file OpenERP6.1.1/openerp/release.py i do not see anything looking like version = "6.1-20121004-232945".
Andreas Brueckle you are right for problem solving you need the same versions on both production and test. But for testing changes it is by definition needed to have differences in small steps. The problems I have seen where - I am almost sure - not originated in differences in versions of in the installation. I think it has something todo with settings.

I already installed BeautifulSoup.py in the needed directory. In my installation this is root/Volume1/@appstore/Python/usr/local/lib/Python2.7/site-packages/

I had the idea to prepare the installation for "specialties" in the installation I wanted to restore. So I installed all the specialties in a testdatabase.

Make a TEST database.
Add besides the default language EN US, the languages EN UK and Dutch / Nederlands.
As admin with extended view I changed the menu. I added Module Import.
Import the Dutch localisation mudules: account_banking account_banking_nl_ing account_iban_preserve_domestic trp_update_tax
Import mass_editing
Install all these modules including ln10n-nl, crm_todo, account_asset, stock, sale, account_accountant, account_cancel
Install basereport_designer ( first I forgot this and there was still an error at restore.)
Restart server

After all these steps I was able to restore my original database without errors!

So for me it was needed to put all earlier used modules in the modulelist of the dummy database but also to install them in the dummy database, before they where able to do their work for the restored database.

Maybe I have done more than the needed steps, so if somebody has suggestions ...

Like why did this work or
what steps are not needed.

I don't know why but for me this worked and I shall use it in my restore procedures as long as I don't have a better procedure.

Daniel Reis

Having different modules in the server where you restored the database can bring up that kind or errors.

You need to copy the addons modules from thee production server to the test server, start the test server, and try to use the restored database.

If it still doesn't work try updating all modules, starting the test server with the option -u all.

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
What build number on a Synology installation? v6.1 synology build	0 mars 15	7231
How to retrieve the build number of an installed version? v6.1 v7 build	1 mars 15	13642
Failling builds Help pls test build timeout odoosh	0 juni 23	3322
ProgrammingError: column res_users.partner_id does not exist Löst v6.1 migration v7 restore	2 dec. 22	10849
Native test suite (js tour) in Event fails after adding a customized input field to registration form test build js tour	0 aug. 20	4833

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!