On 10/10/24 11:36, Priancka Chatz wrote:
Hi admins,
I am observing a new/unknown behavior on some of my instances. My
postgres Data directory path is /home/postgres/pgdata/pgroot/data. And I
see a temp directory present inside /home/postgres/pgdata which has 100s
of directory underneath it and inside each directory some library files
related to Psycopg2. Not sure what these files are and why it is getting
created. However, the only pattern I found is wherever Postgres is down
this behavior is seen.
They are coming from an install of psycopg2-binary:
pip install psycopg2-binary
ll lib/python3.12/site-packages/psycopg2_binary.libs/
total 6944
drwxrwxr-x 2 aklaver aklaver 4096 Oct 13 08:55 ./
drwxrwxr-x 348 aklaver aklaver 20480 Oct 13 08:55 ../
-rwxrwxr-x 1 aklaver aklaver 17497 Oct 13 08:55
libcom_err-2abe824b.so.2.1*
-rwxrwxr-x 1 aklaver aklaver 3133185 Oct 13 08:55
libcrypto-0628e7d4.so.1.1*
-rwxrwxr-x 1 aklaver aklaver 345209 Oct 13 08:55
libgssapi_krb5-497db0c6.so.2.2*
-rwxrwxr-x 1 aklaver aklaver 219953 Oct 13 08:55
libk5crypto-b1f99d5c.so.3.1*
-rwxrwxr-x 1 aklaver aklaver 17913 Oct 13 08:55
libkeyutils-dfe70bd6.so.1.5*
-rwxrwxr-x 1 aklaver aklaver 1018953 Oct 13 08:55 libkrb5-fcafa220.so.3.3*
-rwxrwxr-x 1 aklaver aklaver 76873 Oct 13 08:55
libkrb5support-d0bcff84.so.0.1*
-rwxrwxr-x 1 aklaver aklaver 60977 Oct 13 08:55
liblber-5a1d5ae1.so.2.0.200*
-rwxrwxr-x 1 aklaver aklaver 447329 Oct 13 08:55
libldap-5d2ff197.so.2.0.200*
-rwxrwxr-x 1 aklaver aklaver 406817 Oct 13 08:55
libpcre-9513aab5.so.1.2.0*
-rwxrwxr-x 1 aklaver aklaver 370777 Oct 13 08:55 libpq-e8a033dd.so.5.16*
-rwxrwxr-x 1 aklaver aklaver 119217 Oct 13 08:55
libsasl2-883649fd.so.3.0.0*
-rwxrwxr-x 1 aklaver aklaver 178337 Oct 13 08:55
libselinux-0922c95c.so.1*
-rwxrwxr-x 1 aklaver aklaver 646065 Oct 13 08:55 libssl-3e69114b.so.1.1*
Looks like something is setting up psycopg2-binary and psycopg2 as part
of some script/tool/orm/etc in your $DATA directory.
Are you using something that uses psycopg2 as the client library?
I am attaching screenshots for reference.
Can anyone shed some light or direct me to any links to troubleshoot this?
Regards,
Priyanka
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
