Page 1 of 1

Linux Resolve 14.3 Postgres Issue

PostPosted: Tue Feb 27, 2018 3:43 pm
by Daniele Pellegrini
Hi all,

I'm experience a big issues with Linux Davinci 14.3, among many random crashes there is a very important one, when I try to connect to my remote Postgres DB, resolve crashes immediately: no logs, no dumps, even with strace command, issued via CLI, I cannot get any valuable information.
It just crashes and the GUI goes off.

PS: The same database works fine with all my Resolve 14.3 (mac and win) facility workstations.

Anyone experienced the same problem?

Suggestions?

Thank you,
Daniele

Re: Linux Resolve 14.3 Postgres Issue

PostPosted: Tue Feb 27, 2018 6:29 pm
by Dwaine Maggart
How was the PostgreSQL server created? From a Resolve installer?

If not, if the server is not setup to use SSL, that will cause an instant crash when a Linux Resolve attempts to connect, but works OK for Mac and Windows.

If you run the Resolve Help menu Create Diagnostics Log on Desktop after restarting Resolve, and provide a link to that log, it would help to determine if this is the issue.

Re: Linux Resolve 14.3 Postgres Issue

PostPosted: Tue Feb 27, 2018 6:55 pm
by Daniele Pellegrini
Hi Dwaine,
thank you for your answer.

Indeed the Postgres SQL server was not installed by a native Resolve installer, it's a Turnkey container, running Postgres and it works perfectly for Windows and mac. I didn't investigate about SSL, I'll do it and I'll report as soon as I can touch the setup (actually rendering..). The same for the log.

Write you soon,
Thx.

Daniele

Re: Linux Resolve 14.3 Postgres Issue

PostPosted: Wed Feb 28, 2018 11:04 am
by Daniele Pellegrini
Hi Dwaine,

I checked the setups, it seems that the database is encrypted with SSL, and openssl is properly installed on my Linux.
I prepared the log dump you required, here's the link:
https://we.tl/EPlgDAOIhj

Moreover, if you can take a look, I often have strange crashes, without any warnings, Resolve becomes unresposive..ie: you can move your mouse around the GUI but nothing works.
I didn't figure out what problem could be, yet.

Thank you for your support.
D.

Re: Linux Resolve 14.3 Postgres Issue

PostPosted: Thu Mar 01, 2018 1:16 am
by Dwaine Maggart
OK, my bad on the PostgreSQL thing.

It's actually the opposite of what I said.

In the postgresql.conf file, you want:

ssl = off

You'll need to restart PostgreSQL after you mod the file.

Please try that and see if that fixes the issue.

Re: Linux Resolve 14.3 Postgres Issue

PostPosted: Thu Mar 01, 2018 5:05 pm
by Daniele Pellegrini
Hi Dwaine,

I agree, Linux DaVinci Resolve crashes immediately (vers. 14.3), if the PostgresSql server has SSL set to 'true' in the postgresql.conf file. (located normally in /etc/postgresql/<version number>/main directory).

Having set that to false (and restarting the server) I have perfect compatibility with Linux, Mac and Windows, without any crash.

problem fixed, thank you.

Maybe it would be useful to highlight this issue to DavInci developers, I guess they could simply detect the error and let a dialogue message come out, displaying the interesting hints we found..

D.