psycopg2 current transaction is aborted, commands ignored until end of transaction block

5,350 views

Skip to first unread message

António Ramos

unread,

Apr 29, 2022, 12:40:51 PM4/29/22

to web...@googlegroups.com

My scheduler was not running my tasks.

So i deleted scheduler tables from postgres and deletes files from databases/

I restarted my app and refreshed appadmin. All files and tables were recreated.

However going in appadmin to

db.scheduler_task

i get this error

Error ticket for "fileit"

Ticket ID

194.65.91.147.2022-04-29.16-40-06.d2cd4be0-a64e-4396-af80-c3c76f6bdbed

<class 'psycopg2.errors.InFailedSqlTransaction'> current transaction is aborted, commands ignored until end of transaction block

Version

web2py™	Version 2.20.4-stable+timestamp.2020.05.03.05.18.50
Python	Python 3.6.8: /home/ramos/apps/fileit/env/bin/uwsgi (prefix: /home/ramos/apps/fileit/env)

Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.

Traceback (most recent call last):
  File "/home/ramos/apps/fileit/web2py/gluon/authapi.py", line 590, in has_membership
    group_id = int(group_id)
ValueError: invalid literal for int() with base 10: 'Admin'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/ramos/apps/fileit/web2py/gluon/restricted.py", line 219, in restricted
    exec(ccode, environment)
  File "/home/ramos/apps/fileit/web2py/applications/fileit/views/appadmin.html", line 154, in <module>
    {{else:}}
  File "/home/ramos/apps/fileit/web2py/gluon/authapi.py", line 592, in has_membership
    group_id = self.id_group(group_id)  # interpret group_id as a role
  File "/home/ramos/apps/fileit/web2py/gluon/authapi.py", line 454, in id_group
    rows = self.db(self.table_group().role == role).select()
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/objects.py", line 2634, in select
    return adapter.select(self.query, fields, attributes)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 878, in select
    return self._select_aux(sql, fields, attributes, colnames)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 835, in _select_aux
    rows = self._select_aux_execute(sql)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 829, in _select_aux_execute
    self.execute(sql)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/__init__.py", line 69, in wrap
    return f(*args, **kwargs)
  File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", line 461, in execute
    rv = self.cursor.execute(command, *args[1:], **kwargs)
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

Any help please ?

Regards

António

António Ramos

unread,

Apr 29, 2022, 1:25:45 PM4/29/22

to web...@googlegroups.com

Solved!

apparently tables were not recreated.

All is fine now!!

Regards

Reply all

Reply to author

Forward

0 new messages