Errors in log when pg_hint_plan is loaded as shared_preload_libraries

[jj13github]

Hi, to Load pg_hint_plan user has to have superuser privileges so I decided to load libraries during postmaster startup but when I did this there a lot of Error was showed in log.

2019-11-28 08:48:56 CET [378337]: [1-1] db=mydatabase,user=user2,app=pgAdmin 4 - DB:mydatabase,client=192.168.1.1 WARNING:  terminating connection because of crash of another server process
2019-11-28 08:48:56 CET [378337]: [2-1] db=mydatabase,user=user2,app=pgAdmin 4 - DB:mydatabase,client=192.168.1.1 DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2019-11-28 08:48:56 CET [378337]: [3-1] db=mydatabase,user=user2,app=pgAdmin 4 - DB:mydatabase,client=192.168.1.1 HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2019-11-28 08:48:56 CET [284325]: [1-1] db=,user=,app=,client= WARNING:  terminating connection because of crash of another server process
2019-11-28 08:48:56 CET [284325]: [2-1] db=,user=,app=,client= DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2019-11-28 08:48:56 CET [284325]: [3-1] db=,user=,app=,client= HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2019-11-28 08:48:56 CET [270120]: [17-1] db=,user=,app=,client= LOG:  all server processes terminated; reinitializing
2019-11-28 08:48:58 CET [412756]: [1-1] db=,user=,app=,client= LOG:  database system was interrupted; last known up at 2019-11-28 08:46:13 CET
2019-11-28 08:48:58 CET [412774]: [1-1] db=mydatabase,user=user2,app=[unknown],client=192.168.1.1 FATAL:  the database system is in recovery mode
2019-11-28 08:48:59 CET [412756]: [2-1] db=,user=,app=,client= LOG:  database system was not properly shut down; automatic recovery in progress
2019-11-28 08:48:59 CET [412756]: [3-1] db=,user=,app=,client= LOG:  redo starts at 392A/B253D988

[horiguti]

How did you install the extension? Specifically I need: The version of the PostgreSQL, including minor version. The version of pg_hint_plan, or the name of RPM package if any.

It would be nicer if you can take a stack trace.

[jj13github]

I have loaded the newest version (with PG12 support) and problem seems to be resolved.

[michaelpq]

Yeah, no issues spotted here at the top of the branches, so I am closing this issue.