Problem of writing data with PyDal

[tomasz bandura]

Hello all,

I noticed a very strange behaviour and i don't know what is a reason and how to solve this problem:

1. I have single Postgresql database and I use 2 separated application connected to it:

a) standard web2py (2.16.1 stable version) application which reads and writes data

With connection defined in config.ini:

[db]
uri       = postgres://<usr>:<pass>@127.0.0.1:5432/<dbname>
migrate   = false
pool_size = 10 

b) tornado (websockets) based application, which uses pydal ( 20190915.2 version) .

The connection url is defined as: db=DAL('postgres://<usr>:<pass>@127.0.0.1:5432/<dbname>',pool_size=5,migrate_enabled=False,check_reserved=['all'])

This application mainly writes only data into db, and there aren't any exceptions in logs.

The strange behaviour is that i cannot see the data written by application B but application B can see these data
Only one thing what I can noticed in application A are the incremented values of sequences ( i.e. msg_table_id_seq values) .

Also external tool , like dbvis, cannot see records written by system B,

Has anyone that case. I do not know if there is any cache or any additional configuration needed ( set autocommit?)

Regards,

Tomasz

PS. I also check that case: If do some changes in app A, it will be accessible in application B, so I am sure that both application are connected to the same DB