Hello sudenly my web2py app returns error when creating table with a model like

db.define_table('mytable',
    Field('field1'),
    Field('field2')
)

the error returns when i got to web2py appadmin and try to edit the table

Error ticket for "fileit"
Ticket ID
194.65.91.147.2021-02-09.17-25-44.139628de-94ef-4775-ac11-a46915db90ef

<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
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 24, 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

any help please ???

    cires You could try the following (from psql command line) and see if it shows you which query was aborted. This might give you some insight for further troubleshooting.

    select * from pg_stat_activity where datname = '<your_db_name_here>';

    • sean replied to this.
      Mastodon