can broken migration cause current transaction is aborted by pg?

20 views

Skip to first unread message

António Ramos

unread,

Feb 9, 2021, 4:38:39 PM2/9/21

to web...@googlegroups.com

i´m getting this error editing new tables in appadmin.

Does it have to to with broken migrations?

how to solve this?

regards

António

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

Versão

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.

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 85, in <module>
    {{=SQLTABLE(rows,linkto,upload,orderby=True,_class='sortable')}}
  File "/home/ramos/apps/fileit/web2py/applications/fileit/models/tools.py", line 23, in myFriends
    ).select(db.dbentities.id).as_list()
  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

Reply all

Reply to author

Forward

0 new messages