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/
<http://127.0.0.1:5432/><dbname> migrate   = falsepool_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/
<http://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

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGTupui2ivJPduZ0SMnNjNtfa-Mmx6aWBi%2BufkuZhvz3dD-osw%40mail.gmail.com.

Reply via email to