Skip to Content
Odoo Menú
  • Registra entrada
  • Prova-ho gratis
  • Aplicacions
    Finances
    • Comptabilitat
    • Facturació
    • Despeses
    • Full de càlcul (IA)
    • Documents
    • Signatura
    Vendes
    • CRM
    • Vendes
    • Punt de venda per a botigues
    • Punt de venda per a restaurants
    • Subscripcions
    • Lloguer
    Imatges de llocs web
    • Creació de llocs web
    • Comerç electrònic
    • Blog
    • Fòrum
    • Xat en directe
    • Aprenentatge en línia
    Cadena de subministrament
    • Inventari
    • Fabricació
    • PLM
    • Compres
    • Manteniment
    • Qualitat
    Recursos humans
    • Empleats
    • Reclutament
    • Absències
    • Avaluacions
    • Recomanacions
    • Flota
    Màrqueting
    • Màrqueting Social
    • Màrqueting per correu electrònic
    • Màrqueting per SMS
    • Esdeveniments
    • Automatització del màrqueting
    • Enquestes
    Serveis
    • Projectes
    • Fulls d'hores
    • Servei de camp
    • Suport
    • Planificació
    • Cites
    Productivitat
    • Converses
    • Validacions
    • IoT
    • VoIP
    • Coneixements
    • WhatsApp
    Aplicacions de tercers Odoo Studio Plataforma d'Odoo al núvol
  • Sectors
    Comerç al detall
    • Llibreria
    • Botiga de roba
    • Botiga de mobles
    • Botiga d'ultramarins
    • Ferreteria
    • Botiga de joguines
    Food & Hospitality
    • Bar i pub
    • Restaurant
    • Menjar ràpid
    • Guest House
    • Distribuïdor de begudes
    • Hotel
    Immobiliari
    • Agència immobiliària
    • Estudi d'arquitectura
    • Construcció
    • Gestió immobiliària
    • Jardineria
    • Associació de propietaris de béns immobles
    Consultoria
    • Empresa comptable
    • Partner d'Odoo
    • Agència de màrqueting
    • Bufet d'advocats
    • Captació de talent
    • Auditoria i certificació
    Fabricació
    • Textile
    • Metal
    • Mobles
    • Menjar
    • Brewery
    • Regals corporatius
    Salut i fitness
    • Club d'esport
    • Òptica
    • Centre de fitness
    • Especialistes en benestar
    • Farmàcia
    • Perruqueria
    Trades
    • Servei de manteniment
    • Hardware i suport informàtic
    • Sistemes d'energia solar
    • Shoe Maker
    • Serveis de neteja
    • Instal·lacions HVAC
    Altres
    • Nonprofit Organization
    • Agència del medi ambient
    • Lloguer de panells publicitaris
    • Fotografia
    • Lloguer de bicicletes
    • Distribuïdors de programari
    Browse all Industries
  • Comunitat
    Aprèn
    • Tutorials
    • Documentació
    • Certificacions
    • Formació
    • Blog
    • Pòdcast
    Potenciar l'educació
    • Programa educatiu
    • Scale-Up! El joc empresarial
    • Visita Odoo
    Obtindre el programari
    • Descarregar
    • Comparar edicions
    • Novetats de les versions
    Col·laborar
    • GitHub
    • Fòrum
    • Esdeveniments
    • Traduccions
    • Converteix-te en partner
    • Services for Partners
    • Registra la teva empresa comptable
    Obtindre els serveis
    • Troba un partner
    • Troba un comptable
    • Contacta amb un expert
    • Serveis d'implementació
    • Referències del client
    • Suport
    • Actualitzacions
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Programar una demo
  • Preus
  • Ajuda

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

  • CRM
  • e-Commerce
  • Comptabilitat
  • Inventari
  • PoS
  • Projectes
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
Ajuda

Time-out : Point of sale - Validate closing and post entries

Subscriure's

Get notified when there's activity on this post

This question has been flagged
possessiontimeoutodoo10
8 Respostes
7316 Vistes
Avatar
abd

Hello, 

It has been a year I didn't close the POS session by clicking the button : Validate closing and post entries

Now I am trying to close it after like more 1300 commands. However it time outs after like 30 minutes ...

When I check the odoo.log file I get : 


"

Many times this line :

   2020-09-02 23:49:45,009 5856 INFO Lib werkzeug: 127.0.0.1 - - [02/Sep/2020 23:49:45] "POST /longpolling/poll HTTP/1.1" 200 -

Then

2020-09-02 23:49:45,009 5856 ERROR Lib odoo.service.server: Exception happened during processing of request from ('127.0.0.1', 50937)

Traceback (most recent call last):

  File "SocketServer.pyc", line 599, in process_request_thread

  File "SocketServer.pyc", line 334, in finish_request

  File "SocketServer.pyc", line 657, in __init__

  File "SocketServer.pyc", line 716, in finish

  File "socket.pyc", line 283, in close

  File "socket.pyc", line 307, in flush

error: [Errno 10053] Une connexion établie a été abandonnée par un logiciel de votre ordinateur hôte

2020-09-02 23:51:23,036 5856 ERROR ? odoo.addons.bus.models.bus: Bus.loop error, sleep and retry

Traceback (most recent call last):

  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\addons\bus\models\bus.py", line 180, in run

  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\addons\bus\models\bus.py", line 166, in loop

OperationalError: server closed the connection unexpectedly

This probably means the server terminated abnormally

before or while processing the request.

"

Please help me bypass this problem. it is really making me afraid I will lose the app. because all my library is based on it.

Environnment : Windows 10, Odoo 10.

P.S : I will close it then I will try to slowly migrate to the latest Odoo version. 

P.S 2 : I copied the entire database to a more powerfull laptop, installed odoo 10 and restored the database. when I try to close the session i get the same timeout problem and same errors.

Thank you so much in advance.

1
Avatar
Descartar
Avatar
Xavier Brochard
Best Answer

First of all, you should allways close the POS sessions on day to day.

To solve time out problems you need to tweak your Odoo and Postgresql config files. For instance, on a recent inventory operation I had to multiply the CPU time limit per 20.

In Odoo, do you use workers ? Did you setup CPU time limit and Ram limit ? In Postgresql, did you changed the config settings (may be with pgtune) ? If you answered "No" to one of these questions please copy-paste your odoo.conf and tell us more about your hardware (memory, cpu and disk).


How to fix your time-out problem

Tune Postgresql settings

Odoo is mostly data-driven and all those datas are handled by Postgresql. When you close the POS session, a lot of datas regarding accounting, stock and products are written in the Postgresql database. Obviously, the first thing to do is to improve Postgresql speed. And luckily this is quite easy : go to https://pgtune.leopard.in.ua fill the form and it will return all you need to change in postgresql.conf (type 200 in Number of Connections).

Tune Odoo settings

The reference document is Deploying Odoo in the developper documentation (https://www.odoo.com/documentation/13.0/setup/deploy.html) and the various talks from Olivier Dony at the Odoo Experience, like this one https://www.slideshare.net/openobject/performance2014-35689113 and this one https://www.youtube.com/watch?v=A_BWyFeGgVA

By setting up a reverse proxy and  a cache (with Nginx) you would be able to enable workers in Odoo and to save some CPU time. Unfortunatly, workers are not available on Windows. Following parameters are all per workers, in your case I calculate with one worker.

dbmaxconn = 190 a bit lower than Postgresql max_connections. Pgtune will probably give you 200

limits should keep rooms for Postgresql and should maximize CPU usage. Let's divide equally your Ram between Odoo and Postgresql. Postgresql will probably use less than 2GB so you will have 2GB free for Windows.

limit_memory_hard = 4294967296 (4GB)
limit_memory_soft
  = 3758096384 (3,5GB)

Following should be enough. These are big numbers.
limit_request = 8192
limit_time_cpu = 800
limit_time_real = 1400

Windows

There are usualy limits in the kernel. On a desktop system, they are lower than on a server. One can increase them but I don't know precisely how to do that on Windows. You should free windows as much as you can from userspace program. Keep it out of the network. It will save CPU time.

Try on Linux

I can't help with Windows tweaking, but I know how to increase Odoo performances on Linux (basicaly using Workers). Hence I suggest to install Linux on a small partition on your laptop. Odoo is nearly a one-click install on Debian, Ubuntu, Fedora, Red Hat and Centos. If you are not comfortable with command-line, you can install a Desktop version.

Check your Postgresql version from Windows 10 first and please report it. This will help with Linux choice

or use a small VPS server

This can be a good and low-cost option and I will be able to connect in if you want.

In any case, ask for more help if it don't work.
0
Avatar
Descartar
abd
Autor

Hello Xavier,

Did you see my answer above ? I am really blocked and waiting for answer, if you can kindly help :-)

Thanks again

abd
Autor

Hello Xavier,

I made all the changes. However still getting timeouts :s :s

I was also monitoring my cpu and memory usage, there is no overload at all. nothing is changing when closing the session.

do you have any other alternatives ?

thank you so much.

Xavier Brochard
See my updated answer.

Le mar. 8 sept. 2020 à 00:43, abd <a.benhima@hotmail.fr> a écrit :

Hello Xavier,

I made all the changes. However still getting timeouts :s :s

I was also monitoring my cpu and memory usage, there is no overload at all. nothing is changing when closing the session.

do you have any other alternatives ?

thank you so much.

Envoyé par Odoo S.A. utilisant Odoo.



--

Cordialement
Xavier Brochard / zeroheure
abd
Autor

Hi again,

I just set up a virtual machine with Centos 7.

6GB of memory and 2 CPU cores.

What can I do next please ?

Thanks a lot.

Avatar
abd
Autor Best Answer

Hello Xavier, 

Thank you for your quick feedback. It is a long story why we didn't close the POS session but this is a mistake I agree.

The answer to all the question is no, no workers, no CPU or RAM limit, no change to Postgres config or odoo config.

my laptop is an i7 with 8G RAM and ssd hard drive so good enough I suppose.

my odoo.conf looks like : 

"

[options]

addons_path = C:\Program Files (x86)\Odoo 10.0\server\odoo\addons

admin_passwd = admin

bin_path = C:\Program Files (x86)\Odoo 10.0\thirdparty

csv_internal_sep = ,

data_dir = C:\Users\BENHIMA\AppData\Local\OpenERP S.A\Odoo

db_host = localhost

db_maxconn = 64

db_name = False

db_password = openpgpwd

db_port = 5432

db_template = template1

db_user = openpg

dbfilter = .*

demo = {}

email_from = False

geoip_database = /usr/share/GeoIP/GeoLite2-City.mmdb

import_partial = 

limit_memory_hard = None

limit_memory_soft = None

limit_request = None

limit_time_cpu = None

limit_time_real = None

limit_time_real_cron = None

list_db = True

log_db = False

log_db_level = warning

log_handler = :INFO

log_level = info

logfile = C:\Program Files (x86)\Odoo 10.0\server\odoo.log

logrotate = False

longpolling_port = 8072

max_cron_threads = 2

osv_memory_age_limit = 1.0

osv_memory_count_limit = False

pg_path = C:\Program Files (x86)\Odoo 10.0\PostgreSQL\bin

pidfile = None

proxy_mode = False

reportgz = False

server_wide_modules = web,web_kanban

smtp_password = False

smtp_port = 25

smtp_server = localhost

smtp_ssl = False

smtp_user = False

syslog = False

test_commit = False

test_enable = False

test_file = False

test_report_directory = False

translate_modules = ['all']

unaccent = False

without_demo = False

workers = None

xmlrpc = True

xmlrpc_interface = 

xmlrpc_port = 8069

"

I really appreciate your help and your time.

Best regards, 

Abdel.

0
Avatar
Descartar
Xavier Brochard

OK, thanks. Let me answer in a couple of hours, I have to finish my work before.

Xavier Brochard

See my complete answer above.

Xavier Brochard

See my updated amswer

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

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

Registrar-se
Related Posts Respostes Vistes Activitat
POS Accounting Entry Posting Date- Session Opening Date, Closing Date or Posting Date ?
pos session
Avatar
Avatar
1
de març 24
6322
Validiation Error : The name of this POS Session must be unique !
pos session
Avatar
Avatar
1
de jul. 23
3478
Can't close POS session Solved
pos session
Avatar
Avatar
1
de des. 22
4605
Odoo session expired problem Solved
session odoo10
Avatar
Avatar
Avatar
Avatar
3
de març 22
17620
How to resolve "Cannot create unbalanced journal entry" while closing session in POS
pos journal session journalentries odoo10
Avatar
Avatar
2
de març 22
19846
Community
  • Tutorials
  • Documentació
  • Fòrum
Codi obert
  • Descarregar
  • GitHub
  • Runbot
  • Traduccions
Serveis
  • Allotjament a Odoo.sh
  • Suport
  • Actualització
  • Desenvolupaments personalitzats
  • Educació
  • Troba un comptable
  • Troba un partner
  • Converteix-te en partner
Sobre nosaltres
  • La nostra empresa
  • Actius de marca
  • Contacta amb nosaltres
  • Llocs de treball
  • Esdeveniments
  • Pòdcast
  • Blog
  • Clients
  • Informació legal • Privacitat
  • Seguretat
الْعَرَبيّة 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 és un conjunt d'aplicacions empresarials de codi obert que cobreix totes les necessitats de la teva empresa: CRM, comerç electrònic, comptabilitat, inventari, punt de venda, gestió de projectes, etc.

La proposta única de valor d'Odoo és ser molt fàcil d'utilitzar i estar totalment integrat, ambdues alhora.

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