Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

[Odoo 12e] Server Error while duplicating existing database.

Subscribe

Get notified when there's activity on this post

This question has been flagged
odoo12
2 Replies
6863 Views
Avatar
Murshid C

This happens when I try to click the Duplicate button on database manager page. Here are the logs:

2019-07-18 06:38:29,123 10000 INFO dev6 odoo.service.db: DUMP DB: dev6 format zip

2019-07-18 06:38:33,988 10000 INFO dev6 werkzeug: 127.0.0.1 - - [18/Jul/2019 06:38:33] "POST /web/database/backup HTTP/1.1" 200 - 2 0.001 5.013
2019-07-18 06:38:53,962 10000 INFO None odoo.service.db: Duplicate database `dev6` to `dev7`.
2019-07-18 06:38:53,963 10000 INFO None odoo.sql_db: ConnectionPool(used=1/count=6/max=64): Closed 4 connections to 'host=localhost port=5432 user=openpg password=xxxxxxxxx sslmode=prefer dbname=dev6'
2019-07-18 06:38:58,937 10000 INFO dev7 odoo.modules.loading: loading 1 modules...
2019-07-18 06:38:58,951 10000 INFO dev7 odoo.modules.loading: 1 modules loaded in 0.01s, 0 queries
2019-07-18 06:38:59,074 10000 INFO dev7 odoo.modules.loading: loading 95 modules...
2019-07-18 06:38:59,229 10000 WARNING dev7 odoo.models: The model pos_max.refund_policy has no _description
2019-07-18 06:38:59,232 10000 INFO dev7 odoo.modules.loading: 95 modules loaded in 0.16s, 0 queries
2019-07-18 06:38:59,462 10000 INFO dev7 odoo.fields: Field stock.production.lot.product_uom_id depends on non-stored field product.product.uom_id
2019-07-18 06:38:59,463 10000 INFO dev7 odoo.fields: Field stock.picking.move_ids_without_package depends on non-stored field stock.move.picking_type_entire_packs
2019-07-18 06:38:59,464 10000 INFO dev7 odoo.fields: Field stock.picking.move_line_ids_without_package depends on non-stored field stock.move.line.picking_type_entire_packs
2019-07-18 06:38:59,492 10000 INFO dev7 odoo.fields: Field purchase.order.line.product_uom_qty depends on non-stored field product.product.uom_id
2019-07-18 06:38:59,494 10000 INFO dev7 odoo.fields: Field pos.order.product_list depends on non-stored field product.product.name
2019-07-18 06:38:59,499 10000 INFO dev7 odoo.fields: Field pos.credit.update.config_id depends on non-stored field pos.order.config_id
2019-07-18 06:38:59,503 10000 INFO dev7 odoo.modules.loading: Modules loaded.
2019-07-18 06:39:00,216 10000 INFO dev7 werkzeug: 127.0.0.1 - - [18/Jul/2019 06:39:00] "POST /web/database/duplicate HTTP/1.1" 500 - 42 4.955 1.447
2019-07-18 06:39:00,221 10000 ERROR dev7 werkzeug: Error on request:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0e\python\lib\site-packages\werkzeug\serving.py", line 205, in run_wsgi
execute(self.server.app)
File "C:\Program Files (x86)\Odoo 12.0e\python\lib\site-packages\werkzeug\serving.py", line 193, in execute
application_iter = app(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\service\server.py", line 409, in app
return self.app(e, s)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\service\wsgi_server.py", line 128, in application
return application_unproxied(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\service\wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\http.py", line 1318, in __call__
return self.dispatch(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\http.py", line 1291, in __call__
return self.app(environ, start_wrapped)
File "C:\Program Files (x86)\Odoo 12.0e\python\lib\site-packages\werkzeug\wsgi.py", line 599, in __call__
return self.app(environ, start_response)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\http.py", line 1490, in dispatch
response = self.get_response(httprequest, result, explicit_session)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\http.py", line 284, in __exit__
self._cr.commit()
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0e\server\odoo\sql_db.py", line 372, in commit
result = self._cnx.commit()
psycopg2.InterfaceError: connection already closed - - -
0
Avatar
Discard
Avatar
Lyall van der Linde
Best Answer

The database you are trying to copy is probably in use. Use the database manager URL  (~/web/database/manager) and first select another database or create a new one if there is not currently another one.


0
Avatar
Discard
Avatar
Sofien Moalla
Best Answer

increase max_connections in /etc/postgresql/x.x/main/postgresql.conf

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Odoo Mail Sending Limit Solved
odoo12
Avatar
Avatar
Avatar
2
Dec 23
16553
(Document type: Invoice, Operation: write) - (Records: [], User: 2)
odoo12
Avatar
0
Oct 23
33
Error while importing data in Odoo12: An unknown issue occurred during import (possibly lost connection, data limit exceeded or memory limits exceeded)
odoo12
Avatar
Avatar
Avatar
Avatar
3
Oct 23
790
Remove duplicate record when importing data from excel to Odoo
odoo12
Avatar
Avatar
1
Oct 23
569
Multiple group on field Odoo12
odoo12
Avatar
Avatar
1
Aug 23
3418
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now