Bug 52795 - pg.InternalError: could not connect to server: No such file or directory
pg.InternalError: could not connect to server: No such file or directory
Status: CLOSED WORKSFORME
Product: UCS
Classification: Unclassified
Component: pkgdb
UCS 5.0
Other Linux
: P5 normal (vote)
: UCS 5.0
Assigned To: Arvid Requate
Felix Botner
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2021-02-13 20:52 CET by Florian Best
Modified: 2021-05-25 16:03 CEST (History)
2 users (show)

See Also:
What kind of report is it?: Development Internal
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:


Attachments
listener.log (5.40 MB, text/x-log)
2021-02-13 20:52 CET, Florian Best
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Florian Best univentionstaff 2021-02-13 20:52:40 CET
Created attachment 10617 [details]
listener.log

During the upgrade to UCS 5.0 the log contains the traceback:

246 times in /var/log/univention/listener.log:
https://jenkins.knut.univention.de:8181/job/UCS-5.0/job/UCS-5.0-0/job/AutotestUpgrade/SambaVersion=no-samba,Systemrolle=master/ws/test/listener.log
Traceback (most recent call last):
  File "/usr/sbin/univention-pkgdb-scan", line 37, in <module>
    univention.pkgdb.main()
  File "/usr/lib/python2.7/dist-packages/univention/pkgdb.py", line 580, in main
    connection = open_database_connection(config_registry, pkgdbu=True)
  File "/usr/lib/python2.7/dist-packages/univention/pkgdb.py", line 564, in open_database_connection
    connection = pgdb.connect(database=connectstring)
  File "/usr/lib/python2.7/dist-packages/pgdb.py", line 1619, in connect
    cnx = _connect(dbname, dbhost, dbport, dbopt, dbuser, dbpasswd)
pg.InternalError: could not connect to server: No such file or directory
Comment 1 Arvid Requate univentionstaff 2021-03-23 20:40:09 CET
I guess it comes from

 /usr/lib/univention-directory-listener/system/pkgdb.py

and it's not "During the upgrade to UCS 5.0" but during the tests after the update.

Works on my updated test VM:

root@master10:~# udm computers/memberserver create --set name=member1
WARNING: The object is not going to be created underneath of its default containers.
Object created: cn=member1,dc=ar41i1,dc=qa

listener.log:
SQL: CREATE USER "member1$" IN GROUP pkgdbg
Comment 2 Felix Botner univentionstaff 2021-04-28 12:22:36 CEST
no more pg.InternalError errors in listener.log

https://jenkins.knut.univention.de:8181/job/UCS-5.0/job/UCS-5.0-0/job/AutotestUpgrade/SambaVersion=no-samba,Systemrolle=master/ws/test/listener.log/*view*/


manual update test with univention-pkgdb works, postgres running after the update
Comment 3 Florian Best univentionstaff 2021-05-25 16:03:23 CEST
UCS 5.0 has been released:
 https://docs.software-univention.de/release-notes-5.0-0-en.html
 https://docs.software-univention.de/release-notes-5.0-0-de.html

If this error occurs again, please use "Clone This Bug".