Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PgAdmin4 v6.10. won't start on ubuntu 20.04. (RM #7442) #5116

Closed
dpage opened this issue Jun 3, 2022 · 38 comments
Closed

PgAdmin4 v6.10. won't start on ubuntu 20.04. (RM #7442) #5116

dpage opened this issue Jun 3, 2022 · 38 comments

Comments

@dpage
Copy link
Contributor

dpage commented Jun 3, 2022

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7442
Originally created by Marko Šuštić at 2022-06-03 07:08:58 UTC.

After updating to 6.10. I can't start pgAdmin4 on ubuntu 20.04. Same thing is happening to few of my colleagues. I can see the process running but app won't start. Downgrading back to 6.9. is the only solution I have found.

@dpage
Copy link
Contributor Author

dpage commented Jun 3, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-1
Originally created by Yogesh Mahajan at 2022-06-03 12:54:34 UTC.

Hello,

We could not reproduce issue either in upgrade from 6.9 to 6.10 or in fresh installation of 6.10.
Could you please share screen who for error if any?
Also can you please share latest log file at location /home//.local/share/pgadmin/?

Thanks

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Marko Šuštić

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-2
Originally created by Vince Vince at 2022-06-08 08:02:28 UTC.

same issue here, v. 6.10 doesn't open a window when i start the desktop version. Rollback to v. 6.9 works well.

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-3
Originally created by Vince Vince at 2022-06-08 08:21:59 UTC.

that;s with 6.10 with Ubuntu 20.04


~$ /usr/pgadmin4/bin/pgadmin4
[0608/101109.102636:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0608/101109.102723:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
[134829:134829:0608/101109.419667:ERROR:gpu_memory_buffer_support_x11.cc(44)] dri3 extension not supported.
[134830:134834:0608/101114.646805:ERROR:nss_util.cc(335)] After loading Root Certs, loaded==false: NSS error code: -8018
[134830:134834:0608/101114.649239:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.

there are no log file generated in ~/.local/share/pgadmin

for version 6.9 which works:


~$ /usr/pgadmin4/bin/pgadmin4
[136532:136559:0608/101750.536533:ERROR:login_database.cc(697)] Password store database is too new, kCurrentVersionNumber=31, GetCompatibleVersionNumber=33
[136532:136548:0608/101750.536611:ERROR:login_database.cc(697)] Password store database is too new, kCurrentVersionNumber=31, GetCompatibleVersionNumber=33
[136532:136559:0608/101750.536654:ERROR:password_store_built_in_backend.cc(538)] Could not create/open login database.
[136532:136548:0608/101750.536703:ERROR:password_store_built_in_backend.cc(538)] Could not create/open login database.
[136564:136564:0608/101750.557556:ERROR:sandbox_linux.cc(379)] InitializeSandbox() called with multiple threads in process gpu-process.
[136532:136545:0608/101752.841180:ERROR:chrome_browser_main_extra_parts_metrics.cc(227)] START: ReportBluetoothAvailability(). If you don't see the END: message, this is crbug.com/1216328.
[136532:136545:0608/101752.841196:ERROR:chrome_browser_main_extra_parts_metrics.cc(230)] END: ReportBluetoothAvailability()
[136565:136572:0608/101755.578546:ERROR:nss_util.cc(286)] After loading Root Certs, loaded==false: NSS error code: -8018
[136565:136572:0608/101755.580192:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[136565:136573:0608/101755.580271:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[136565:136573:0608/101756.406256:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.

and here I have a log file (that I truncated here after the few first lines)


~/.local/share/pgadmin$ cat pgadmin4.1654676270735.log 
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/vincent/.config/pgadmin/runtime_config.json"
pgAdmin Config File: "/usr/pgadmin4/web/config.py"
Webapp Path: "/usr/pgadmin4/web/pgAdmin4.py"
pgAdmin Command: "/usr/pgadmin4/venv/bin/python3 -s /usr/pgadmin4/web/pgAdmin4.py"
Environment: 
  - SHELL: /bin/bash
...

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6809
Originally created by Dave Page at 2022-06-08 08:46:06 UTC.

Screenshot_2022-06-08_at_09.45.38.png

Filename: Screenshot_2022-06-08_at_09.45.38.png

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-5
Originally created by Dave Page at 2022-06-08 08:46:32 UTC.

Odd - it's working fine on my Ubuntu 20.04 (screenshot attached). Fahar, can you test ASAP please?

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Marko Šuštić Fahar Abbas
Attachment added Screenshot 2022-06-08 at 09.45.38.png

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-6
Originally created by Fahar Abbas at 2022-06-08 08:52:20 UTC.

Hi Marko!

Can you please please upgrade your VM and follow the steps below:

  1. sudo apt-get update
  2. sudo apt-get upgrade
  3. follow instructions to install pgadmin4 under
    https://www.pgadmin.org/download/pgadmin-4-apt/
  4. Launch pgadmin4 from the application
    pgadmin4 launched successfully.

Redmine ticket header update:

Name Old Value New Value
Priority changed High Normal
Assigned To changed Fahar Abbas Marko Šuštić

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-7
Originally created by Dave Page at 2022-06-08 08:56:11 UTC.

On further investigation, it looks other Chromium based apps are having the same issue, e.g. microsoft/playwright-python#1277

Please try launching pgAdmin with the --disable-gpu command line option. That should happen automatically as it's in the manifest, but maybe something broke in the latest version of nwjs.

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-8
Originally created by Vince Vince at 2022-06-08 09:13:24 UTC.

on the about window the only difference in my setup is the kernel at 5.4
*Operating System
Linux-5.4.0-113-generic-x86_64-with-glibc2.29
*
from what i understand you have the HWE kernels and I have the GA one
(i'm not familiar with all this)
https://askubuntu.com/questions/248914/what-is-hardware-enablement-hwe

perhaps it's a track to follow if the following log
*[0608/101109.102636:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0608/101109.102723:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
*
doesn't lead to anything (user used to execute a process ? file permission ? venv related user environment)
underlying default python versions ? 2 or 3 ? 3.x ? 3.8 ? ...

I see also 2 chrome_crashpad_handler processes using htop. can any relevent log be retreived from that.
the NW.js and chrome version are not the same in 6.9 and 6.10 maybe it's related to those ? ¯_(ツ)_/¯

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6810
Originally created by Fahar Abbas at 2022-06-08 09:25:17 UTC.

Screen_Shot_2022-06-08_at_2.24.31_PM.png

Filename: Screen_Shot_2022-06-08_at_2.24.31_PM.png

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-10
Originally created by Fahar Abbas at 2022-06-08 09:25:30 UTC.

I am not able to reproduce the issue on ubuntu 20.04.

Redmine ticket header update:

Name Old Value New Value
Attachment added Screen Shot 2022-06-08 at 2.24.31 PM.png

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-11
Originally created by Dave Page at 2022-06-08 10:39:02 UTC.

Vince Vince wrote:

on the about window the only difference in my setup is the kernel at 5.4
*Operating System
Linux-5.4.0-113-generic-x86_64-with-glibc2.29
*
from what i understand you have the HWE kernels and I have the GA one
(i'm not familiar with all this)
https://askubuntu.com/questions/248914/what-is-hardware-enablement-hwe

I have whatever the default was when I installed into VMware Fusion.

perhaps it's a track to follow if the following log
*[0608/101109.102636:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0608/101109.102723:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
*
doesn't lead to anything (user used to execute a process ? file permission ? venv related user environment)
underlying default python versions ? 2 or 3 ? 3.x ? 3.8 ? ...

You can package NW apps as zip files, and I think that's NW trying to unpack a zip before realising we don't package that way. Regardless of whether I'm right or not, I get that error on my working system as well (and the AIA chasing one). Unfortunately NWjs does tend to spit out a few warnings and errors like that, even when everything is fine.

I see also 2 chrome_crashpad_handler processes using htop. can any relevent log be retreived from that.
the NW.js and chrome version are not the same in 6.9 and 6.10 maybe it's related to those ? ¯_(ツ)_/¯

In theory we could analyse the .dmp file that should be produced, though in practice I doubt any of us here know even remotely enough about the internals of NW/Chromium to be able to figure out what's going on.

Were you able to try starting pgAdmin from the command line with the --disable-gpu option?

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-12
Originally created by Vince Vince at 2022-06-08 12:22:04 UTC.

/usr/pgadmin4/bin/pgadmin4 --disable-gpu doesn't seem to change anything
either run on 6.9 or 6.10
(regarding the std output or the tree of process generated

all I can see in pgadmin generate a process /proc/self/exe in which the command line as a --disable-gpu-compositing argument
but that's when starting normally 6.9 or 6.10 so it may not be related to anything at all.
I've also set up a virtual box ubuntu 20.04.4 VM and started on 5.4 and 5.13 kernels. All works well regarding 6.10

but if it's a gpu or gpu+kernel related issue, that would be normal.
I'll try to update my OS to 5.13 once if I find time for that.

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-13
Originally created by DJ Caësar 9114 at 2022-06-08 14:40:45 UTC.

I have exactly the same problem.

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6811
Originally created by Dave Page at 2022-06-08 15:44:25 UTC.

Screenshot_2022-06-08_at_16.44.05.png

Filename: Screenshot_2022-06-08_at_16.44.05.png

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-15
Originally created by Dave Page at 2022-06-08 15:44:35 UTC.

Can any of those of you who are seeing this issue please try downloading https://dl.nwjs.io/v0.65.0/nwjs-v0.65.0-linux-x64.tar.gz, unpacking it, and then running the nw binary, e.g. ./nwjs-v0.65.0-linux-x64/nw ? Does it display a window, such as that in the attached screenshot?

Redmine ticket header update:

Name Old Value New Value
Attachment added Screenshot 2022-06-08 at 16.44.05.png

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-16
Originally created by DJ Caësar 9114 at 2022-06-08 22:09:45 UTC.

It doesn't display any window, but I have this in the console:

[0609/000740.366695:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0609/000740.366852:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
[0609/000740.367044:ERROR:zip.cc(179)] Cannot open '/home/cesar/Téléchargements/nwjs-v0.65.0-linux-x64/package.nw': FILE_ERROR_NOT_FOUND: Aucun fichier ou dossier de ce type (2)
libva error: vaGetDriverNameByIndex() failed with unknown libva error, driver_name = (null)
[17224:17224:0609/000742.729131:ERROR:CONSOLE(0)] "Unchecked runtime.lastError: Invalid value for bounds. Bounds must be at least 50% within visible screen space.", source: chrome-extension://aafddpmiffkameplnjkglahmbnbgidce/_generated_background_page.html (0)
[17259:17266:0609/000757.499111:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.

The beginning seems to be the same errors as when I try to launch pgadmin binary:

[0609/000332.573475:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0609/000332.573631:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
libva error: vaGetDriverNameByIndex() failed with unknown libva error, driver_name = (null)
[16662:16669:0609/000347.214269:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[16662:16670:0609/000347.214777:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.

@dpage
Copy link
Contributor Author

dpage commented Jun 8, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-17
Originally created by DJ Caësar 9114 at 2022-06-08 22:17:02 UTC.

I upgraded to Ubuntu 22.04, I still have the same problem.
Is there a way to downgrade to 6.9 and not lose any settings (I configured a lot of connections...)?

@dpage
Copy link
Contributor Author

dpage commented Jun 9, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-18
Originally created by Marko Šuštić at 2022-06-09 05:33:26 UTC.

Can any of those of you who are seeing this issue please try downloading https://dl.nwjs.io/v0.65.0/nwjs-v0.65.0-linux-x64.tar.gz, unpacking it, and then running the nw binary, e.g. ./nwjs-v0.65.0-linux-x64/nw ? Does it display a window, such as that in the attached screenshot?
No display but same errors as mentioned above.

Is there a way to downgrade to 6.9 and not lose any settings (I configured a lot of connections...)?
Try: sudo apt-get install pgadmin4-server=6.9
sudo apt-get install pgadmin4-desktop=6.9
This should keep all your settings.

@dpage
Copy link
Contributor Author

dpage commented Jun 9, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-19
Originally created by Dave Page at 2022-06-09 09:33:45 UTC.

DJ Caësar 9114 wrote:

It doesn't display any window, but I have this in the console:

[...]

The beginning seems to be the same errors as when I try to launch pgadmin binary:

[...]

OK, so I see the same FILE_NOT_FOUND error, but I do see a window.

It sounds like this is an NWjs issue - I'll report it to them.

Thanks!

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Marko Šuštić Dave Page
Status changed New Waiting for upstream

@dpage
Copy link
Contributor Author

dpage commented Jun 9, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-20
Originally created by Dave Page at 2022-06-09 10:26:55 UTC.

I've done a bunch of further testing with different kernels and couldn't reproduce this issue. I did manage to find another issue (with Linux ubuntu 5.4.0-117-generic #132-Ubuntu SMP Thu Jun 2 00:39:06 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux) where just a white screen was displayed, and many MB of text output to the console.

I've logged the problems upstream at nwjs/nw.js#7902

@dpage
Copy link
Contributor Author

dpage commented Jun 9, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-21
Originally created by Dave Page at 2022-06-09 10:29:19 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (relates) changed RM #7445

@dpage
Copy link
Contributor Author

dpage commented Jun 10, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-22
Originally created by Dave Page at 2022-06-10 09:12:38 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (relates) changed RM #7445

@dpage
Copy link
Contributor Author

dpage commented Jun 10, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-23
Originally created by Dave Page at 2022-06-10 09:12:48 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (duplicated) changed RM #7445

@dpage
Copy link
Contributor Author

dpage commented Jun 10, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-24
Originally created by Dave Page at 2022-06-10 09:17:01 UTC.

Can those who are seeing this issue please try downloading https://dl.nwjs.io/v0.65.0/nwjs-v0.65.0-linux-x64.tar.gz, unpacking it, and then running the nw binary with:

@./nwjs-v0.65.0-linux-x64/nw --url=chrome://gpu@

If it manages to display anything, please post the output here.

Thanks.

@dpage
Copy link
Contributor Author

dpage commented Jun 10, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-25
Originally created by Marko Šuštić at 2022-06-10 10:20:32 UTC.


./nw --url=chrome://gpu
[0610/121804.665679:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0610/121804.666412:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
[0610/121804.666821:ERROR:zip.cc(179)] Cannot open '/home/msustic/Desktop/nwjs-v0.65.0-linux-x64/package.nw': FILE_ERROR_NOT_FOUND: No such file or directory (2)
[45816:45816:0610/121805.220917:ERROR:CONSOLE(0)] "Unchecked runtime.lastError: Invalid value for bounds. Bounds must be at least 50% within visible screen space.", source: chrome-extension://aafddpmiffkameplnjkglahmbnbgidce/_generated_background_page.html (0)
[45848:45858:0610/121810.297087:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.

No display. Same error as before.

@dpage
Copy link
Contributor Author

dpage commented Jun 10, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-26
Originally created by Dave Page at 2022-06-10 10:28:58 UTC.

Thanks Marko - I'll add that info to the NWJS bug.

What kernel are you running btw? If it's the 5.4 stable version, would it be possible to test with the 5.13 HWE version?

FYI, if you're feeling adventurous, you might want to see if you can persuade apt to let you install pgadmin-server v6.10 with pgadmin-desktop v6.9 (with your normal kernel). That would give you all the changes in v6.10, but with the older runtime (the only change to which was the version of NWJS iirc).

@dpage
Copy link
Contributor Author

dpage commented Jun 10, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-27
Originally created by Yogesh Mahajan at 2022-06-10 11:43:10 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Waiting for upstream

@dpage
Copy link
Contributor Author

dpage commented Jun 15, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-28
Originally created by Vince Vince at 2022-06-15 07:19:17 UTC.

no window open on my Ubuntu 20.04.4 LTS using BOOT_IMAGE=/vmlinuz-5.4.0-113-generic


~/Downloads$ ./nwjs-v0.65.0-linux-x64/nw --url=chrome://gpu
[0615/090757.352534:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0615/090757.352646:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
[0615/090757.352751:ERROR:zip.cc(179)] Cannot open '/home/vincent/Downloads/nwjs-v0.65.0-linux-x64/package.nw': FILE_ERROR_NOT_FOUND: No such file or directory (2)
[1512059:1512059:0615/090757.614193:ERROR:gpu_memory_buffer_support_x11.cc(44)] dri3 extension not supported.
[1512028:1512028:0615/090757.711078:ERROR:CONSOLE(0)] "Unchecked runtime.lastError: Invalid value for bounds. Bounds must be at least 50% within visible screen space.", source: chrome-extension://aafddpmiffkameplnjkglahmbnbgidce/_generated_background_page.html (0)
[1512061:1512068:0615/090802.857740:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[1512061:1512068:0615/090857.600158:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
^C^C

and I,m using a display configuration with a laptop, with my desktop extended to two 4k display.

I removed my two 4k display to be only on the laptop display and then I have that :


$ ./nwjs-v0.65.0-linux-x64/nw --url=chrome://gpu
[0615/091323.457089:ERROR:zip_reader.cc(153)] Cannot open ZIP from file handle 3
[0615/091323.457137:ERROR:zip.cc(202)] Cannot open ZIP from file handle 3
[0615/091323.457180:ERROR:zip.cc(179)] Cannot open '/home/vincent/Downloads/nwjs-v0.65.0-linux-x64/package.nw': FILE_ERROR_NOT_FOUND: No such file or directory (2)
[1514483:1514483:0615/091323.680279:ERROR:gpu_memory_buffer_support_x11.cc(44)] dri3 extension not supported.
Warning: loader_scanned_icd_add: Driver /usr/lib/x86_64-linux-gnu/libvulkan_lvp.so supports Vulkan 1.1, but only supports loader interface version 4. Interface version 5 or newer required to support this version of Vulkan (Policy #LDP_DRIVER_7)
Warning: loader_scanned_icd_add: Driver /usr/lib/x86_64-linux-gnu/libvulkan_intel.so supports Vulkan 1.2, but only supports loader interface version 4. Interface version 5 or newer required to support this version of Vulkan (Policy #LDP_DRIVER_7)
Warning: loader_scanned_icd_add: Driver /usr/lib/x86_64-linux-gnu/libvulkan_radeon.so supports Vulkan 1.2, but only supports loader interface version 4. Interface version 5 or newer required to support this version of Vulkan (Policy #LDP_DRIVER_7)
WARNING: lavapipe is not a conformant vulkan implementation, testing use only.
[1514484:1514492:0615/091327.915774:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.
[1514484:1514492:0615/091328.675255:ERROR:cert_verify_proc_builtin.cc(603)] No net_fetcher for performing AIA chasing.

@dpage
Copy link
Contributor Author

dpage commented Jun 15, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-29
Originally created by Vince Vince at 2022-06-15 07:21:39 UTC.

and this is the copied report from nwjs :



Graphics Feature Status
Canvas: Hardware accelerated
Canvas out-of-process rasterization: Disabled
Direct Rendering Display Compositor: Disabled
Compositing: Hardware accelerated
Multiple Raster Threads: Enabled
OpenGL: Enabled
Rasterization: Hardware accelerated
Raw Draw: Disabled
Skia Renderer: Enabled
Video Decode: Hardware accelerated
Video Encode: Software only. Hardware acceleration disabled
Vulkan: Disabled
WebGL: Hardware accelerated
WebGL2: Hardware accelerated
WebGPU: Disabled
Driver Bug Workarounds
adjust_src_dst_region_for_blitframebuffer
clear_uniforms_before_first_program_use
disable_discard_framebuffer
enable_webgl_timer_query_extensions
exit_on_context_lost
force_cube_complete
init_gl_position_in_vertex_shader
init_vertex_attributes
pack_parameters_workaround_with_pack_buffer
reset_base_mipmap_level_before_texstorage
unpack_alignment_workaround_with_unpack_buffer
unpack_overlapping_rows_separately_unpack_buffer
use_virtualized_gl_contexts
disabled_extension_GL_KHR_blend_equation_advanced
disabled_extension_GL_KHR_blend_equation_advanced_coherent
disabled_extension_GL_MESA_framebuffer_flip_y
Problems Detected
WebGPU has been disabled via blocklist or the command line.
Disabled Features: webgpu
Accelerated video encode has been disabled, either via blocklist, about:flags or the command line.
Disabled Features: video_encode
Program link fails in NVIDIA Linux if gl_Position is not set: 286468
Applied Workarounds: init_gl_position_in_vertex_shader
Clear uniforms before first program use on all platforms: 124764, 349137
Applied Workarounds: clear_uniforms_before_first_program_use
Linux NVIDIA drivers don't have the correct defaults for vertex attributes: 351528
Applied Workarounds: init_vertex_attributes
MakeCurrent is slow on Linux with NVIDIA drivers: 449150, 514510
Applied Workarounds: use_virtualized_gl_contexts
NVIDIA fails glReadPixels from incomplete cube map texture: 518889
Applied Workarounds: force_cube_complete
Pack parameters work incorrectly with pack buffer bound: 563714
Applied Workarounds: pack_parameters_workaround_with_pack_buffer
Alignment works incorrectly with unpack buffer bound: 563714
Applied Workarounds: unpack_alignment_workaround_with_unpack_buffer
Framebuffer discarding can hurt performance on non-tilers: 570897
Applied Workarounds: disable_discard_framebuffer
Unpacking overlapping rows from unpack buffers is unstable on NVIDIA GL driver: 596774
Applied Workarounds: unpack_overlapping_rows_separately_unpack_buffer
Disable KHR_blend_equation_advanced until cc shaders are updated: 661715
Applied Workarounds: disable(GL_KHR_blend_equation_advanced), disable(GL_KHR_blend_equation_advanced_coherent)
Expose WebGL's disjoint_timer_query extensions on platforms with site isolation: 808744, 870491
Applied Workarounds: enable_webgl_timer_query_extensions
glTexStorage* are buggy when base mipmap level is not 0: 877874
Applied Workarounds: reset_base_mipmap_level_before_texstorage
Some drivers can't recover after OUT_OF_MEM and context lost: 893177
Applied Workarounds: exit_on_context_lost
adjust src/dst region if blitting pixels outside framebuffer on Linux NVIDIA: 830046
Applied Workarounds: adjust_src_dst_region_for_blitframebuffer
Disable GL_MESA_framebuffer_flip_y for desktop GL: 964010
Applied Workarounds: disable(GL_MESA_framebuffer_flip_y)
DAWN Info

 Vulkan backend - Quadro P3200 with Max-Q Design
[Default Toggle Names]
lazy_clear_resource_on_first_use: https://crbug.com/dawn/145: Clears resource to zero on first usage. This initializes the resource so that no dirty bits from recycled memory is present in the new resource.
use_temporary_buffer_in_texture_to_texture_copy: https://crbug.com/dawn/42: Split texture-to-texture copy into two copies: copy from source texture into a temporary buffer, and copy from the temporary buffer into the destination texture when copying between compressed textures that don't have block-aligned sizes. This workaround is enabled by default on all Vulkan drivers to solve an issue in the Vulkan SPEC about the texture-to-texture copies with compressed formats. See #1005 (https://github.com/KhronosGroup/Vulkan-Docs/issues/1005) for more details.
vulkan_use_d32s8: https://crbug.com/dawn/286: Vulkan mandates support of either D32_FLOAT_S8 or D24_UNORM_S8. When available the backend will use D32S8 (toggle to on) but setting the toggle to off will make it use the D24S8 format when possible.
vulkan_use_s8: https://crbug.com/dawn/666: Vulkan has a pure stencil8 format but it is not universally available. When this toggle is on, the backend will use S8 for the stencil8 format, otherwise it will fallback to D32S8 or D24S8.
disallow_unsafe_apis: http://crbug.com/1138528: Produces validation errors on API entry points or parameter combinations that aren't considered secure yet.
use_vulkan_zero_initialize_workgroup_memory_extension: https://crbug.com/dawn/1302: Initialize workgroup memory with OpConstantNull on Vulkan when the Vulkan extension VK_KHR_zero_initialize_workgroup_memory is supported.
[WebGPU Forced Toggles - enabled]
disallow_spirv: https://crbug.com/1214923: Disallow usage of SPIR-V completely so that only WGSL is used for shader modules. This is useful to prevent a Chromium renderer process from successfully sending SPIR-V code to be compiled in the GPU process.
[Supported Features]
texture-compression-bc
pipeline-statistics-query
timestamp-query
depth-clamping
depth24unorm-stencil8
depth32float-stencil8
dawn-internal-usages
dawn-native

 Vulkan backend - llvmpipe (LLVM 12.0.0, 256 bits)
[Default Toggle Names]
lazy_clear_resource_on_first_use: https://crbug.com/dawn/145: Clears resource to zero on first usage. This initializes the resource so that no dirty bits from recycled memory is present in the new resource.
use_temporary_buffer_in_texture_to_texture_copy: https://crbug.com/dawn/42: Split texture-to-texture copy into two copies: copy from source texture into a temporary buffer, and copy from the temporary buffer into the destination texture when copying between compressed textures that don't have block-aligned sizes. This workaround is enabled by default on all Vulkan drivers to solve an issue in the Vulkan SPEC about the texture-to-texture copies with compressed formats. See #1005 (https://github.com/KhronosGroup/Vulkan-Docs/issues/1005) for more details.
vulkan_use_d32s8: https://crbug.com/dawn/286: Vulkan mandates support of either D32_FLOAT_S8 or D24_UNORM_S8. When available the backend will use D32S8 (toggle to on) but setting the toggle to off will make it use the D24S8 format when possible.
vulkan_use_s8: https://crbug.com/dawn/666: Vulkan has a pure stencil8 format but it is not universally available. When this toggle is on, the backend will use S8 for the stencil8 format, otherwise it will fallback to D32S8 or D24S8.
disallow_unsafe_apis: http://crbug.com/1138528: Produces validation errors on API entry points or parameter combinations that aren't considered secure yet.
[WebGPU Forced Toggles - enabled]
disallow_spirv: https://crbug.com/1214923: Disallow usage of SPIR-V completely so that only WGSL is used for shader modules. This is useful to prevent a Chromium renderer process from successfully sending SPIR-V code to be compiled in the GPU process.
[Supported Features]
texture-compression-bc
pipeline-statistics-query
timestamp-query
depth-clamping
depth24unorm-stencil8
depth32float-stencil8
dawn-internal-usages
dawn-native

 Vulkan backend - SwiftShader Device (Subzero)
[Default Toggle Names]
lazy_clear_resource_on_first_use: https://crbug.com/dawn/145: Clears resource to zero on first usage. This initializes the resource so that no dirty bits from recycled memory is present in the new resource.
use_temporary_buffer_in_texture_to_texture_copy: https://crbug.com/dawn/42: Split texture-to-texture copy into two copies: copy from source texture into a temporary buffer, and copy from the temporary buffer into the destination texture when copying between compressed textures that don't have block-aligned sizes. This workaround is enabled by default on all Vulkan drivers to solve an issue in the Vulkan SPEC about the texture-to-texture copies with compressed formats. See #1005 (https://github.com/KhronosGroup/Vulkan-Docs/issues/1005) for more details.
vulkan_use_d32s8: https://crbug.com/dawn/286: Vulkan mandates support of either D32_FLOAT_S8 or D24_UNORM_S8. When available the backend will use D32S8 (toggle to on) but setting the toggle to off will make it use the D24S8 format when possible.
vulkan_use_s8: https://crbug.com/dawn/666: Vulkan has a pure stencil8 format but it is not universally available. When this toggle is on, the backend will use S8 for the stencil8 format, otherwise it will fallback to D32S8 or D24S8.
disallow_unsafe_apis: http://crbug.com/1138528: Produces validation errors on API entry points or parameter combinations that aren't considered secure yet.
use_vulkan_zero_initialize_workgroup_memory_extension: https://crbug.com/dawn/1302: Initialize workgroup memory with OpConstantNull on Vulkan when the Vulkan extension VK_KHR_zero_initialize_workgroup_memory is supported.
[WebGPU Forced Toggles - enabled]
disallow_spirv: https://crbug.com/1214923: Disallow usage of SPIR-V completely so that only WGSL is used for shader modules. This is useful to prevent a Chromium renderer process from successfully sending SPIR-V code to be compiled in the GPU process.
[Supported Features]
texture-compression-bc
texture-compression-etc2
texture-compression-astc
timestamp-query
depth-clamping
depth32float-stencil8
dawn-internal-usages
dawn-native
Version Information
Data exported	2022-06-15T07:13:24.076Z
Chrome version	Chrome/102.0.5005.61
Operating system	Linux 5.4.0-113-generic
Software rendering list URL	https://chromium.googlesource.com/chromium/src/+/62f83a7521ae1f32e563795732dff0c9da1b660d/gpu/config/software_rendering_list.json
Driver bug list URL	https://chromium.googlesource.com/chromium/src/+/62f83a7521ae1f32e563795732dff0c9da1b660d/gpu/config/gpu_driver_bug_list.json
ANGLE commit id	6661eb4900da
2D graphics backend	Skia/102 3338e90707323d2cd3a150276acb9f39933deee2
Command Line	./nwjs-v0.65.0-linux-x64/nw --url=chrome://gpu --enable-crashpad --user-data-dir=/home/vincent/.config/nwjs --no-sandbox --no-zygote --flag-switches-begin --flag-switches-end
Driver Information
Initialization time	68
In-process GPU	false
Passthrough Command Decoder	false
Sandboxed	false
GPU0	VENDOR= 0x10de [NVIDIA Corporation], DEVICE=0x1bbb [Quadro P3200 with Max-Q Design/PCIe/SSE2] *ACTIVE*
Optimus	false
AMD switchable	false
Driver vendor	Nvidia
Driver version	470.129.06
GPU CUDA compute capability major version	0
Pixel shader version	4.50
Vertex shader version	4.50
Max. MSAA samples	64
Machine model name	
Machine model version	
GL_VENDOR	NVIDIA Corporation
GL_RENDERER	Quadro P3200 with Max-Q Design/PCIe/SSE2
GL_VERSION	4.5.0 NVIDIA 470.129.06
GL_EXTENSIONS	GL_AMD_multi_draw_indirect GL_AMD_seamless_cubemap_per_texture GL_AMD_vertex_shader_viewport_index GL_AMD_vertex_shader_layer GL_ARB_arrays_of_arrays GL_ARB_base_instance GL_ARB_bindless_texture GL_ARB_blend_func_extended GL_ARB_buffer_storage GL_ARB_cl_event GL_ARB_clear_buffer_object GL_ARB_clear_texture GL_ARB_clip_control GL_ARB_color_buffer_float GL_ARB_compressed_texture_pixel_storage GL_ARB_conservative_depth GL_ARB_compute_shader GL_ARB_compute_variable_group_size GL_ARB_conditional_render_inverted GL_ARB_copy_buffer GL_ARB_copy_image GL_ARB_cull_distance GL_ARB_debug_output GL_ARB_depth_buffer_float GL_ARB_depth_clamp GL_ARB_depth_texture GL_ARB_derivative_control GL_ARB_direct_state_access GL_ARB_draw_buffers GL_ARB_draw_buffers_blend GL_ARB_draw_indirect GL_ARB_draw_elements_base_vertex GL_ARB_draw_instanced GL_ARB_enhanced_layouts GL_ARB_ES2_compatibility GL_ARB_ES3_compatibility GL_ARB_ES3_1_compatibility GL_ARB_ES3_2_compatibility GL_ARB_explicit_attrib_location GL_ARB_explicit_uniform_location GL_ARB_fragment_coord_conventions GL_ARB_fragment_layer_viewport GL_ARB_fragment_program GL_ARB_fragment_program_shadow GL_ARB_fragment_shader GL_ARB_fragment_shader_interlock GL_ARB_framebuffer_no_attachments GL_ARB_framebuffer_object GL_ARB_framebuffer_sRGB GL_ARB_geometry_shader4 GL_ARB_get_program_binary GL_ARB_get_texture_sub_image GL_ARB_gl_spirv GL_ARB_gpu_shader5 GL_ARB_gpu_shader_fp64 GL_ARB_gpu_shader_int64 GL_ARB_half_float_pixel GL_ARB_half_float_vertex GL_ARB_imaging GL_ARB_indirect_parameters GL_ARB_instanced_arrays GL_ARB_internalformat_query GL_ARB_internalformat_query2 GL_ARB_invalidate_subdata GL_ARB_map_buffer_alignment GL_ARB_map_buffer_range GL_ARB_multi_bind GL_ARB_multi_draw_indirect GL_ARB_multisample GL_ARB_multitexture GL_ARB_occlusion_query GL_ARB_occlusion_query2 GL_ARB_parallel_shader_compile GL_ARB_pipeline_statistics_query GL_ARB_pixel_buffer_object GL_ARB_point_parameters GL_ARB_point_sprite GL_ARB_polygon_offset_clamp GL_ARB_post_depth_coverage GL_ARB_program_interface_query GL_ARB_provoking_vertex GL_ARB_query_buffer_object GL_ARB_robust_buffer_access_behavior GL_ARB_robustness GL_ARB_sample_locations GL_ARB_sample_shading GL_ARB_sampler_objects GL_ARB_seamless_cube_map GL_ARB_seamless_cubemap_per_texture GL_ARB_separate_shader_objects GL_ARB_shader_atomic_counter_ops GL_ARB_shader_atomic_counters GL_ARB_shader_ballot GL_ARB_shader_bit_encoding GL_ARB_shader_clock GL_ARB_shader_draw_parameters GL_ARB_shader_group_vote GL_ARB_shader_image_load_store GL_ARB_shader_image_size GL_ARB_shader_objects GL_ARB_shader_precision GL_ARB_shader_storage_buffer_object GL_ARB_shader_subroutine GL_ARB_shader_texture_image_samples GL_ARB_shader_texture_lod GL_ARB_shading_language_100 GL_ARB_shader_viewport_layer_array GL_ARB_shading_language_420pack GL_ARB_shading_language_include GL_ARB_shading_language_packing GL_ARB_shadow GL_ARB_sparse_buffer GL_ARB_sparse_texture GL_ARB_sparse_texture2 GL_ARB_sparse_texture_clamp GL_ARB_spirv_extensions GL_ARB_stencil_texturing GL_ARB_sync GL_ARB_tessellation_shader GL_ARB_texture_barrier GL_ARB_texture_border_clamp GL_ARB_texture_buffer_object GL_ARB_texture_buffer_object_rgb32 GL_ARB_texture_buffer_range GL_ARB_texture_compression GL_ARB_texture_compression_bptc GL_ARB_texture_compression_rgtc GL_ARB_texture_cube_map GL_ARB_texture_cube_map_array GL_ARB_texture_env_add GL_ARB_texture_env_combine GL_ARB_texture_env_crossbar GL_ARB_texture_env_dot3 GL_ARB_texture_filter_anisotropic GL_ARB_texture_filter_minmax GL_ARB_texture_float GL_ARB_texture_gather GL_ARB_texture_mirror_clamp_to_edge GL_ARB_texture_mirrored_repeat GL_ARB_texture_multisample GL_ARB_texture_non_power_of_two GL_ARB_texture_query_levels GL_ARB_texture_query_lod GL_ARB_texture_rectangle GL_ARB_texture_rg GL_ARB_texture_rgb10_a2ui GL_ARB_texture_stencil8 GL_ARB_texture_storage GL_ARB_texture_storage_multisample GL_ARB_texture_swizzle GL_ARB_texture_view GL_ARB_timer_query GL_ARB_transform_feedback2 GL_ARB_transform_feedback3 GL_ARB_transform_feedback_instanced GL_ARB_transform_feedback_overflow_query GL_ARB_transpose_matrix GL_ARB_uniform_buffer_object GL_ARB_vertex_array_bgra GL_ARB_vertex_array_object GL_ARB_vertex_attrib_64bit GL_ARB_vertex_attrib_binding GL_ARB_vertex_buffer_object GL_ARB_vertex_program GL_ARB_vertex_shader GL_ARB_vertex_type_10f_11f_11f_rev GL_ARB_vertex_type_2_10_10_10_rev GL_ARB_viewport_array GL_ARB_window_pos GL_ATI_draw_buffers GL_ATI_texture_float GL_ATI_texture_mirror_once GL_S3_s3tc GL_EXT_texture_env_add GL_EXT_abgr GL_EXT_bgra GL_EXT_bindable_uniform GL_EXT_blend_color GL_EXT_blend_equation_separate GL_EXT_blend_func_separate GL_EXT_blend_minmax GL_EXT_blend_subtract GL_EXT_compiled_vertex_array GL_EXT_Cg_shader GL_EXT_depth_bounds_test GL_EXT_direct_state_access GL_EXT_draw_buffers2 GL_EXT_draw_instanced GL_EXT_draw_range_elements GL_EXT_fog_coord GL_EXT_framebuffer_blit GL_EXT_framebuffer_multisample GL_EXTX_framebuffer_mixed_formats GL_EXT_framebuffer_multisample_blit_scaled GL_EXT_framebuffer_object GL_EXT_framebuffer_sRGB GL_EXT_geometry_shader4 GL_EXT_gpu_program_parameters GL_EXT_gpu_shader4 GL_EXT_multi_draw_arrays GL_EXT_multiview_tessellation_geometry_shader GL_EXT_multiview_texture_multisample GL_EXT_multiview_timer_query GL_EXT_packed_depth_stencil GL_EXT_packed_float GL_EXT_packed_pixels GL_EXT_pixel_buffer_object GL_EXT_point_parameters GL_EXT_polygon_offset_clamp GL_EXT_post_depth_coverage GL_EXT_provoking_vertex GL_EXT_raster_multisample GL_EXT_rescale_normal GL_EXT_secondary_color GL_EXT_separate_shader_objects GL_EXT_separate_specular_color GL_EXT_shader_image_load_formatted GL_EXT_shader_image_load_store GL_EXT_shader_integer_mix GL_EXT_shadow_funcs GL_EXT_sparse_texture2 GL_EXT_stencil_two_side GL_EXT_stencil_wrap GL_EXT_texture3D GL_EXT_texture_array GL_EXT_texture_buffer_object GL_EXT_texture_compression_dxt1 GL_EXT_texture_compression_latc GL_EXT_texture_compression_rgtc GL_EXT_texture_compression_s3tc GL_EXT_texture_cube_map GL_EXT_texture_edge_clamp GL_EXT_texture_env_combine GL_EXT_texture_env_dot3 GL_EXT_texture_filter_anisotropic GL_EXT_texture_filter_minmax GL_EXT_texture_integer GL_EXT_texture_lod GL_EXT_texture_lod_bias GL_EXT_texture_mirror_clamp GL_EXT_texture_object GL_EXT_texture_shadow_lod GL_EXT_texture_shared_exponent GL_EXT_texture_sRGB GL_EXT_texture_sRGB_R8 GL_EXT_texture_sRGB_decode GL_EXT_texture_storage GL_EXT_texture_swizzle GL_EXT_timer_query GL_EXT_transform_feedback2 GL_EXT_vertex_array GL_EXT_vertex_array_bgra GL_EXT_vertex_attrib_64bit GL_EXT_window_rectangles GL_EXT_x11_sync_object GL_EXT_import_sync_object GL_NV_robustness_video_memory_purge GL_IBM_rasterpos_clip GL_IBM_texture_mirrored_repeat GL_KHR_context_flush_control GL_KHR_debug GL_EXT_memory_object GL_EXT_memory_object_fd GL_NV_memory_object_sparse GL_KHR_parallel_shader_compile GL_KHR_no_error GL_KHR_robust_buffer_access_behavior GL_KHR_robustness GL_EXT_semaphore GL_EXT_semaphore_fd GL_NV_timeline_semaphore GL_KHR_shader_subgroup GL_KTX_buffer_region GL_NV_alpha_to_coverage_dither_control GL_NV_bindless_multi_draw_indirect GL_NV_bindless_multi_draw_indirect_count GL_NV_bindless_texture GL_NV_blend_equation_advanced GL_NV_blend_equation_advanced_coherent GL_NVX_blend_equation_advanced_multi_draw_buffers GL_NV_blend_minmax_factor GL_NV_blend_square GL_NV_clip_space_w_scaling GL_NV_command_list GL_NV_compute_program5 GL_NV_conditional_render GL_NV_conservative_raster GL_NV_conservative_raster_dilate GL_NV_conservative_raster_pre_snap_triangles GL_NV_copy_depth_to_color GL_NV_copy_image GL_NV_deep_texture3D GL_NV_depth_buffer_float GL_NV_depth_clamp GL_NV_draw_texture GL_NV_draw_vulkan_image GL_NV_ES1_1_compatibility GL_NV_ES3_1_compatibility GL_NV_explicit_multisample GL_NV_feature_query GL_NV_fence GL_NV_fill_rectangle GL_NV_float_buffer GL_NV_fog_distance GL_NV_fragment_coverage_to_color GL_NV_fragment_program GL_NV_fragment_program_option GL_NV_fragment_program2 GL_NV_fragment_shader_interlock GL_NV_framebuffer_mixed_samples GL_NV_framebuffer_multisample_coverage GL_NV_geometry_shader4 GL_NV_geometry_shader_passthrough GL_NV_gpu_program4 GL_NV_internalformat_sample_query GL_NV_gpu_program4_1 GL_NV_gpu_program5 GL_NV_gpu_program5_mem_extended GL_NV_gpu_program_fp64 GL_NV_gpu_shader5 GL_NV_half_float GL_NV_light_max_exponent GL_NV_memory_attachment GL_NV_multisample_coverage GL_NV_multisample_filter_hint GL_NV_occlusion_query GL_NV_packed_depth_stencil GL_NV_parameter_buffer_object GL_NV_parameter_buffer_object2 GL_NV_path_rendering GL_NV_path_rendering_shared_edge GL_NV_pixel_data_range GL_NV_point_sprite GL_NV_primitive_restart GL_NV_query_resource GL_NV_query_resource_tag GL_NV_register_combiners GL_NV_register_combiners2 GL_NV_sample_locations GL_NV_sample_mask_override_coverage GL_NV_shader_atomic_counters GL_NV_shader_atomic_float GL_NV_shader_atomic_float64 GL_NV_shader_atomic_fp16_vector GL_NV_shader_atomic_int64 GL_NV_shader_buffer_load GL_NV_shader_storage_buffer_object GL_NV_shader_subgroup_partitioned GL_NV_stereo_view_rendering GL_NV_texgen_reflection GL_NV_texture_barrier GL_NV_texture_compression_vtc GL_NV_texture_env_combine4 GL_NV_texture_multisample GL_NV_texture_rectangle GL_NV_texture_rectangle_compressed GL_NV_texture_shader GL_NV_texture_shader2 GL_NV_texture_shader3 GL_NV_transform_feedback GL_NV_transform_feedback2 GL_NV_uniform_buffer_unified_memory GL_NV_vdpau_interop GL_NV_vdpau_interop2 GL_NV_vertex_array_range GL_NV_vertex_array_range2 GL_NV_vertex_attrib_integer_64bit GL_NV_vertex_buffer_unified_memory GL_NV_vertex_program GL_NV_vertex_program1_1 GL_NV_vertex_program2 GL_NV_vertex_program2_option GL_NV_vertex_program3 GL_NV_viewport_array2 GL_NV_viewport_swizzle GL_NVX_conditional_render GL_NV_gpu_multicast GL_NVX_progress_fence GL_NVX_gpu_memory_info GL_NVX_nvenc_interop GL_NV_shader_thread_group GL_NV_shader_thread_shuffle GL_KHR_blend_equation_advanced GL_KHR_blend_equation_advanced_coherent GL_OVR_multiview GL_OVR_multiview2 GL_SGIS_generate_mipmap GL_SGIS_texture_lod GL_SGIX_depth_texture GL_SGIX_shadow GL_SUN_slice_accum
Disabled Extensions	GL_KHR_blend_equation_advanced GL_KHR_blend_equation_advanced_coherent GL_MESA_framebuffer_flip_y
Disabled WebGL Extensions	
Window system binding vendor	NVIDIA Corporation
Window system binding version	1.4
Window system binding extensions	GLX_ARB_get_proc_address GLX_ARB_multisample GLX_EXT_visual_info GLX_EXT_visual_rating GLX_EXT_import_context GLX_SGI_video_sync GLX_NV_swap_group GLX_SGIX_fbconfig GLX_SGIX_pbuffer GLX_SGI_swap_control GLX_EXT_swap_control GLX_EXT_swap_control_tear GLX_EXT_buffer_age GLX_ARB_create_context GLX_ARB_create_context_profile GLX_NV_float_buffer GLX_ARB_fbconfig_float GLX_EXT_texture_from_pixmap GLX_EXT_framebuffer_sRGB GLX_NV_copy_image GLX_NV_copy_buffer GLX_EXT_create_context_es_profile GLX_EXT_create_context_es2_profile GLX_ARB_create_context_no_error GLX_ARB_create_context_robustness GLX_NV_delay_before_swap GLX_EXT_stereo_tree GLX_ARB_context_flush_control GLX_NV_robustness_video_memory_purge GLX_NV_multigpu_context
XDG_CURRENT_DESKTOP	ubuntu:GNOME
XDG_SESSION_TYPE	x11
GDMSESSION	ubuntu
Ozone platform	x11
Direct rendering version	direct but version unknown
Reset notification strategy	0x8252
GPU process crash count	0
gfx::BufferFormats supported for allocation and texturing	R_8: not supported, R_16: not supported, RG_88: not supported, RG_1616: not supported, BGR_565: not supported, RGBA_4444: not supported, RGBX_8888: not supported, RGBA_8888: not supported, BGRX_8888: not supported, BGRA_1010102: not supported, RGBA_1010102: not supported, BGRA_8888: not supported, RGBA_F16: not supported, YVU_420: not supported, YUV_420_BIPLANAR: not supported, P010: not supported
Compositor Information
Tile Update Mode	One-copy
Partial Raster	Enabled
GpuMemoryBuffers Status
R_8	Software only
R_16	Software only
RG_88	Software only
RG_1616	Software only
BGR_565	Software only
RGBA_4444	Software only
RGBX_8888	Software only
RGBA_8888	Software only
BGRX_8888	Software only
BGRA_1010102	Software only
RGBA_1010102	Software only
BGRA_8888	Software only
RGBA_F16	Software only
YVU_420	Software only
YUV_420_BIPLANAR	Software only
P010	Software only
Display(s) Information
Info	Display[3] bounds=[0,0 1920x1080], workarea=[0,27 1920x993], scale=1, rotation=0, panel_rotation=0 external.
Color space (all)	{primaries_d50_referred: [[0.6531, 0.3428], [0.3525, 0.6050], [0.1565, 0.0631]], transfer:SRGB, matrix:RGB, range:FULL}
Buffer format (all)	BGRA_8888
SDR white level in nits	100
HDR relative maximum luminance	1
Bits per color component	8
Bits per pixel	24
Refresh Rate in Hz	60
Video Acceleration Information
Decoding	
Encoding	
Vulkan Information
Device Performance Information
Log Messages
[1514483:1514483:0615/091323.680279:ERROR:gpu_memory_buffer_support_x11.cc(44)] : dri3 extension not supported.

@dpage
Copy link
Contributor Author

dpage commented Jun 15, 2022

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6828
Originally created by Vince Vince at 2022-06-15 07:51:25 UTC.

2022-06-15_09-50.png

Filename: 2022-06-15_09-50.png

Description: display placement

@dpage
Copy link
Contributor Author

dpage commented Jun 15, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-31
Originally created by Vince Vince at 2022-06-15 08:02:00 UTC.

So i,ve been hacking around with my 3 display placements and that affect whether or not I see the nwjs window or i get the log "... !Bounds must be at least 50% within visible screen space.! ..."

so, attached is a screenshot of my regular displays placement. where I get the "at least 50%" log.
if I move display 1 up sush as the bottom of 1 is above the middle of 2 and 3, then I see the nwjs windows.
If I now move display 1 on the far right, right to 3, then I see the njws window only if the middle of 1 is lower than the top of 2 and 3.

I havent't tried scenarios with 1 directly placed under or above 2 or 3, nor tried to change the primary display to another one than 2.

I guess my next step is to retry that with en earlier version of njws (what was the version used in pgadmin4 6.9) ?
and with pgadmin4 6.10, but it all looks like njws as a new feature to prevent the window to be displayed without being accessible to the user, and that feature is buggy related to the display coordinate system and all its possible configurations.

Redmine ticket header update:

Name Old Value New Value
Attachment added 2022-06-15_09-50.png

@dpage
Copy link
Contributor Author

dpage commented Jun 15, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-32
Originally created by Vince Vince at 2022-06-15 08:50:11 UTC.

So, like nwjs-v0.65.0-linux-x64
v0.65.1 has the same problem

v0.63.1 and v.64.1 works and the nwjs window is displayed on the top left of my right most display (while it's on my left most display with 0.65.x when it works)
I also note that with v0.60.0 works well and the nwjs window is displayed in the middle of my right most display. (So the have definitily been tweeaking their code reagarding window location recently)


now with pgadmin4 6.10 :
Same as with nwjs 0.65.x, it opens its window or not exactly in the same conditions.

so I guess pgadmin devs have to to wait for nwjs to be fixed and pack a new version then.
I the meantime for those who don't want to downgrade to 6.9 the dirty workaround is to change your window display configuration to a working config, start pgadmin, then go back to your prefered display config.
As dirty as it is I guess it can event be scripted ^^. I'll stick to 6.9


sudo apt -y remove pgadmin4
sudo apt -y autoremove pgadmin4*
sudo apt -y install  pgadmin4*=6.9

@dpage
Copy link
Contributor Author

dpage commented Jun 28, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-33
Originally created by Paul Tap at 2022-06-28 08:56:30 UTC.

Marko Šuštić wrote:

After updating to 6.10. I can't start pgAdmin4 on ubuntu 20.04. Same thing is happening to few of my colleagues. I can see the process running but app won't start. Downgrading back to 6.9. is the only solution I have found.

Same issue on Debian 11 (Bullseye). Downgrade to 6.9 (fortunately) works.

@dpage
Copy link
Contributor Author

dpage commented Jul 5, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-34
Originally created by DJ Caësar 9114 at 2022-07-05 15:40:40 UTC.

I saw 6.11 was released. Is there any date planned to have this bug removed?
Thanks :)

@dpage
Copy link
Contributor Author

dpage commented Jul 15, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-35
Originally created by Vince Vince at 2022-07-15 13:12:18 UTC.

Yes, 6.11 works for me. They went back to an older nwjs package (0.62.2) instead of 0.65 in pgadmin4 v.6.10

I guess it's not a fix that has to be done in the nwjs project but an implementation in pgadmin4-desktop to tell to open the window (the loading splash one and/or the main one)in the visible area.
By default nwjs opens it now in coordinate 0;0 in TLBR (https://www.google.com/search?q=TLBR+top+left+bottom+right) which on our multiscreen configuration is not visible space.

@dpage
Copy link
Contributor Author

dpage commented Jul 20, 2022

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7442#note-36
Originally created by DJ Caësar 9114 at 2022-07-20 22:41:18 UTC.

Well, I was about to make the same comment (except for your explanation part that I didn't get ;) ): everything works fine for me too.

@nikhil-mohite
Copy link
Contributor

waiting for nw.js to fix it.

@khushboovashi
Copy link
Contributor

This issue has been resolved as we are using latest NWJS v 0.70.0.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants