# Error closing period

**URL:** <https://discuss.tryton.org/t/error-closing-period/5694>\
**Category:** Developer\
**Created:** [November 9, 2022, 9:03pm UTC](https://discuss.tryton.org/t/error-closing-period/5694 "2022-11-09T21:03:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lancheros](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/l/c2a13f/32.png) [@lancheros](https://discuss.tryton.org/u/lancheros)\
**Post date:** [November 9, 2022, 9:03pm UTC](https://discuss.tryton.org/t/error-closing-period/5694/1 "2022-11-09T21:03:04Z")

</div>

when I tried to close a period I get the following error:

```auto
Traceback (most recent call last):
  File "/trytond/wsgi.py", line 117, in dispatch_request
    return endpoint(request, **request.view_args)
  File "/trytond/protocols/dispatcher.py", line 47, in rpc
    return methods.get(request.rpc_method, _dispatch)(
  File "/trytond/wsgi.py", line 84, in auth_required
    return wrapped(*args, **kwargs)
  File "/trytond/protocols/wrappers.py", line 156, in wrapper
    return func(request, pool, *args, **kwargs)
  File "/trytond/protocols/dispatcher.py", line 181, in _dispatch
    result = rpc.result(meth(*c_args, **c_kwargs))
  File "/trytond/modules/account_asset/account.py", line 235, in close
    super(Period, cls).close(periods)
  File "/trytond/model/modelview.py", line 774, in wrapper
    return func(cls, records, *args, **kwargs)
  File "/trytond/model/workflow.py", line 37, in wrapper
    result = func(cls, filtered, *args, **kwargs)
  File "/trytond/modules/account_invoice/account.py", line 160, in close
    super().close(periods)
  File "/trytond/model/modelview.py", line 774, in wrapper
    return func(cls, records, *args, **kwargs)
  File "/trytond/model/workflow.py", line 37, in wrapper
    result = func(cls, filtered, *args, **kwargs)
  File "/trytond/modules/account/period.py", line 307, in close
    database.lock(connection, Move._table)
  File "/trytond/backend/postgresql/database.py", line 436, in lock
    cursor.execute(SQL('LOCK {} IN EXCLUSIVE MODE NOWAIT').format(
  File "/trytond/backend/postgresql/database.py", line 72, in execute
    cursor.execute(self, sql, args)
psycopg2.errors.LockNotAvailable: could not obtain lock on relation "account_move"

```

I appreciate your help

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [November 9, 2022, 10:57pm UTC](https://discuss.tryton.org/t/error-closing-period/5694/2 "2022-11-09T22:57:07Z")

</div>

There is a concurrent transaction that is holding a the table or a row of “account\_move”.  
You can see current transactions with [`SELECT * FROM pg_stat_activity;`](https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW).

---

<div class="post-metadata">

**Author:** ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)\
**Post date:** [December 9, 2022, 10:57pm UTC](https://discuss.tryton.org/t/error-closing-period/5694/3 "2022-12-09T22:57:11Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.