I tried to duplicate a DEV database. But it returns the following error. However, I can do a backup and a restore and it would work. Would appreciate any help.
OperationalError: source database "DEV" is being accessed by other users DETAIL: There are 16 other sessions using the database.
As I mentioned in my comment to Shiva, with v8 stopping an operational eCommerce site is probably not desirable.
The simple workaround without any postgres knowledge is to:
- go to URL <your.website>/web/database/manager
- From here create a backup of you database.
- Restore the database by giving it a 'New database name' and selecting "Copy of an existing database" for the mode.
Depending on the size of your db and internet connection the upload may be a slow process, but at least you get around shutting your server down.
Hope it helps someone.
I already had this, the point is that the option workers > 0 in the conf file could cause this kind of troubles.
If possible, change temporarily this option in the conf file with setting workers=0, restart odoo, make your backup/restore, reset the workers to its original value and restart Odoo
Try this - (assuming that you are in Linux environment) 1) Stop your erp server /etc/init.d/openerp-server stop
2) Check if there are any openerp processes still runnning ps -eaf | grep openerp
Even after stopping, if there are openerp processes, it means the previous server restarts did not kill the old processes. 3) If there are any hanging openerp processes still, note down the process numbers and kill them one by one: kill abcd
4) After killing all openerp processes, restart the server /etc/init.d/openerp-server start
Now check the duplication process. Hope it works.
Ok this is what I get after restarting the odoo server:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <title>500 Internal Server Error</title> <h1>Internal Server Error</h1> <p>The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.</p>
I tried it again and I get:
ProgrammingError: database "neuesOdoo" already exists
But it's not listed in odoo, only in the postgres ...
So after another restart of the server the duplicated database is also listed and can be used!
This is at all not a disireable behavior!!!
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
|Asked: 12/7/13, 10:41 AM|
|Seen: 5013 times|
|Last updated: 9/10/16, 8:19 AM|