public inbox for [email protected]help / color / mirror / Atom feed
Unknown temp directories and library files 4+ messages / 2 participants [nested] [flat]
* Unknown temp directories and library files @ 2024-10-10 18:36 Priancka Chatz <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Priancka Chatz @ 2024-10-10 18:36 UTC (permalink / raw) To: [email protected] 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. I am attaching screenshots for reference. Can anyone shed some light or direct me to any links to troubleshoot this? Regards, Priyanka Attachments: [image/png] Screenshot 2024-10-10 at 12.20.00.png (519.8K, 3-Screenshot%202024-10-10%20at%2012.20.00.png) download | view image [image/png] Screenshot 2024-10-10 at 12.20.21.png (1.5M, 4-Screenshot%202024-10-10%20at%2012.20.21.png) download | view image ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Unknown temp directories and library files @ 2024-10-13 16:01 Adrian Klaver <[email protected]> parent: Priancka Chatz <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Adrian Klaver @ 2024-10-13 16:01 UTC (permalink / raw) To: Priancka Chatz <[email protected]>; [email protected] 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 [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Unknown temp directories and library files @ 2024-10-13 18:34 Priancka Chatz <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Priancka Chatz @ 2024-10-13 18:34 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: [email protected] Hi Adrian, There is patroni and pgqd running on the server. So possibly these are using psycopg2. Regards, Priyanka On Sun, 13 Oct 2024 at 6:01 PM, Adrian Klaver <[email protected]> wrote: > 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 > [email protected] > > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Unknown temp directories and library files @ 2024-10-13 19:42 Adrian Klaver <[email protected]> parent: Priancka Chatz <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Adrian Klaver @ 2024-10-13 19:42 UTC (permalink / raw) To: Priancka Chatz <[email protected]>; +Cc: [email protected] On 10/13/24 11:34, Priancka Chatz wrote: > Hi Adrian, > > There is patroni and pgqd running on the server. So possibly these are > using psycopg2. You are going to have investigate what is actually repeatedly installing psycopg2-binary and psycopg2. Steps I can think of to do this: 1) Sort the temp directories by timestamp and see if there is a pattern. 2) Look at the OS system log for entries at the above timestamps. 3) Do same for Postgres log. > > Regards, > Priyanka > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-10-13 19:42 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-10-10 18:36 Unknown temp directories and library files Priancka Chatz <[email protected]> 2024-10-13 16:01 ` Adrian Klaver <[email protected]> 2024-10-13 18:34 ` Priancka Chatz <[email protected]> 2024-10-13 19:42 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox