Schema diff - Timeout error is not handled when pgAdmin4 is hosted on Apache/Httpd (RM #7104)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7104
Originally created by Murtuza Zabuawala at 2022-01-07 06:32:35 UTC.

Newer version of httpd on CentOS/Redhat has very low TimeOut value by default - 60 sec
So if schema diff takes longer than that it throws blank error popup.

Refer attached screenshot.

Expected - Display proper error instead of blank popup.

[dpage]

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6555
Originally created by Murtuza Zabuawala at 2022-01-07 06:30:40 UTC.

Filename: Screenshot_2022-01-07_at_11.59.51_AM.png

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-2
Originally created by Murtuza Zabuawala at 2022-01-07 07:09:12 UTC.

If we can use utilize https://docs.python.org/3/library/asyncio.html for comparing objects logic, i think comparison would be faster.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-3
Originally created by Aditya Toshniwal at 2022-01-07 09:54:21 UTC.

pgAdmin supports Python 3.6+ and asyncio is available from 3.7.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-4
Originally created by Yogesh Mahajan at 2022-01-07 11:21:07 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-5
Originally created by Murtuza Zabuawala at 2022-01-11 06:44:02 UTC.

Hello Aditya,

The asyncio module is part of the Python standard library since Python 3.4. In version 3.7, they introduced .run() method which was not available earlier though there was another way to run it.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-6
Originally created by Akshay Joshi at 2022-01-19 10:20:29 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	Ready	EDB Sprint 109

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-7
Originally created by Akshay Joshi at 2022-01-26 17:21:22 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 109	EDB Sprint 110

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-8
Originally created by Akshay Joshi at 2022-02-16 10:24:15 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 110	Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-9
Originally created by Akshay Joshi at 2022-03-30 10:45:33 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	Ready	EDB Sprint 114

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7104#note-10
Originally created by Akshay Joshi at 2022-04-05 05:30:21 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 114	Ready

[adityatoshniwal]

This can be handled with SocketIO lib which pgAdmin is already using in psql and in ERD to fetch database tables data.

[FaharAbbasRizvi]

Tested on candidate build for v6.16.