Ir al contenido
Odoo Menú
  • Identificarse
  • Pruébalo gratis
  • Aplicaciones
    Finanzas
    • Contabilidad
    • Facturación
    • Gastos
    • Hoja de cálculo (BI)
    • Documentos
    • Firma electrónica
    Ventas
    • CRM
    • Ventas
    • TPV para tiendas
    • TPV para restaurantes
    • Suscripciones
    • Alquiler
    Sitios web
    • Creador de sitios web
    • Comercio electrónico
    • Blog
    • Foro
    • Chat en directo
    • eLearning
    Cadena de suministro
    • Inventario
    • Fabricación
    • PLM
    • Compra
    • Mantenimiento
    • Calidad
    Recursos Humanos
    • Empleados
    • Reclutamiento
    • Ausencias
    • Evaluación
    • Referencias
    • Flota
    Marketing
    • Marketing social
    • Marketing por correo electrónico
    • Marketing por SMS
    • Eventos
    • Automatización de marketing
    • Encuestas
    Servicios
    • Proyecto
    • Partes de horas
    • Servicio de campo
    • Servicio de asistencia
    • Planificación
    • Citas
    Productividad
    • Conversaciones
    • Aprobaciones
    • IoT
    • VoIP
    • Conocimientos
    • WhatsApp
    Aplicaciones de terceros Studio de Odoo Plataforma de Odoo Cloud
  • Industrias
    Comercio al por menor
    • Librería
    • Tienda de ropa
    • Tienda de muebles
    • Tienda de ultramarinos
    • Ferretería
    • Juguetería
    Alimentación y hostelería
    • Bar y taberna
    • Restaurante
    • Comida rápida
    • Casa de huéspedes
    • Distribuidor de bebidas
    • Hotel
    Inmueble
    • Agencia inmobiliaria
    • Estudio de arquitectura
    • Construcción
    • Gestión inmobiliaria
    • Jardinería
    • Asociación de propietarios
    Consultoría
    • Empresa contable
    • Partner de Odoo
    • Agencia de marketing
    • Bufete de abogados
    • Adquisición de talentos
    • Auditorías y certificaciones
    Fabricación
    • Textil
    • Metal
    • Muebles
    • Alimentos
    • Brewery
    • Regalos de empresas
    Salud y bienestar
    • Club deportivo
    • Óptica
    • Gimnasio
    • Terapeutas
    • Farmacia
    • Peluquería
    Oficios
    • Handyman
    • Hardware y asistencia informática
    • Sistemas de energía solar
    • Zapatero
    • Servicios de limpieza
    • Servicios de calefacción, ventilación y aire acondicionado
    Otros
    • Organización sin ánimo de lucro
    • Agencia de protección del medio ambiente
    • Alquiler de paneles publicitarios
    • Estudio fotográfico
    • Alquiler de bicicletas
    • Distribuidor de software
    Browse all Industries
  • Comunidad
    Aprender
    • Tutoriales
    • Documentación
    • Certificaciones
    • Formación
    • Blog
    • Podcast
    Potenciar la educación
    • Programa de formación
    • Scale Up! El juego empresarial
    • Visita Odoo
    Obtener el software
    • Descargar
    • Comparar ediciones
    • Versiones
    Colaborar
    • GitHub
    • Foro
    • Eventos
    • Traducciones
    • Convertirse en partner
    • Services for Partners
    • Registrar tu empresa contable
    Obtener servicios
    • Encontrar un partner
    • Encontrar un asesor fiscal
    • Contacta con un experto
    • Servicios de implementación
    • Referencias de clientes
    • Ayuda
    • Actualizaciones
    GitHub YouTube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Solicitar una demostración
  • Precios
  • Ayuda

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

  • CRM
  • e-Commerce
  • Contabilidad
  • Inventario
  • PoS
  • Proyecto
  • MRP
All apps
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Acerca de este foro
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Acerca de este foro
Ayuda

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

Suscribirse

Reciba una notificación cuando haya actividad en esta publicación

Se marcó esta pregunta
possessiontimeoutodoo10
8 Respuestas
7295 Vistas
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
Mejor respuesta

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 Mejor respuesta

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

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Inscribirse
Publicaciones relacionadas Respuestas Vistas Actividad
POS Accounting Entry Posting Date- Session Opening Date, Closing Date or Posting Date ?
pos session
Avatar
Avatar
1
mar 24
6298
Validiation Error : The name of this POS Session must be unique !
pos session
Avatar
Avatar
1
jul 23
3464
Can't close POS session Resuelto
pos session
Avatar
Avatar
1
dic 22
4589
Odoo session expired problem Resuelto
session odoo10
Avatar
Avatar
Avatar
Avatar
3
mar 22
17582
How to resolve "Cannot create unbalanced journal entry" while closing session in POS
pos journal session journalentries odoo10
Avatar
Avatar
2
mar 22
19807
Comunidad
  • Tutoriales
  • Documentación
  • Foro
Código abierto
  • Descargar
  • GitHub
  • Runbot
  • Traducciones
Servicios
  • Alojamiento Odoo.sh
  • Ayuda
  • Actualizar
  • Desarrollos personalizados
  • Educación
  • Encontrar un asesor fiscal
  • Encontrar un partner
  • Convertirse en partner
Sobre nosotros
  • Nuestra empresa
  • Activos de marca
  • Contacta con nosotros
  • Puestos de trabajo
  • Eventos
  • Podcast
  • Blog
  • Clientes
  • Información legal • Privacidad
  • Seguridad
الْعَرَبيّة 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 es un conjunto de aplicaciones de código abierto que cubren todas las necesidades de tu empresa: CRM, comercio electrónico, contabilidad, inventario, punto de venta, gestión de proyectos, etc.

La propuesta única de valor de Odoo es ser muy fácil de usar y totalmente integrado.

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