Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Breadth-first search is the bulldozer of science. -- Randy Goebel

computers / comp.sys.tandem / Temporary files not automatically deleted

SubjectAuthor
* Temporary files not automatically deletedKeith
`* Re: Temporary files not automatically deletedJShepherd
 +- Re: Temporary files not automatically deletedRandall
 `- Re: Temporary files not automatically deletedKeith

1
Temporary files not automatically deleted

<e5b77d43-34c1-4cd5-ab83-748fda235becn@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=755&group=comp.sys.tandem#755

  copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:620a:220a:b0:778:91c2:2885 with SMTP id m10-20020a05620a220a00b0077891c22885mr280098qkh.14.1698904035221;
Wed, 01 Nov 2023 22:47:15 -0700 (PDT)
X-Received: by 2002:a05:6870:8555:b0:1e9:9b32:3e7c with SMTP id
w21-20020a056870855500b001e99b323e7cmr3679049oaj.4.1698904034979; Wed, 01 Nov
2023 22:47:14 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Wed, 1 Nov 2023 22:47:14 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=130.41.239.3; posting-account=osbHJgoAAADBhvRtSBcl0KwwWNN2TZDt
NNTP-Posting-Host: 130.41.239.3
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e5b77d43-34c1-4cd5-ab83-748fda235becn@googlegroups.com>
Subject: Temporary files not automatically deleted
From: kgan...@gmail.com (Keith)
Injection-Date: Thu, 02 Nov 2023 05:47:15 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: Keith - Thu, 2 Nov 2023 05:47 UTC

DSAP shows a large amount of temp files on a disk. On closer investigation I found out that there are lots of temp files but are not opened by any processes. This should not happened as closing a temp file should have it automatically deleted. Attempt to manually purge them returns an error 12. Has anyone encountered this and how to fix this?

Re: Temporary files not automatically deleted

<ui09vo$27hli$1@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=757&group=comp.sys.tandem#757

  copy link   Newsgroups: comp.sys.tandem
Path: i2pn2.org!i2pn.org!paganini.bofh.team!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: inva...@nowhere.com (JShepherd)
Newsgroups: comp.sys.tandem
Subject: Re: Temporary files not automatically deleted
Date: Thu, 2 Nov 2023 13:59:21 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 24
Message-ID: <ui09vo$27hli$1@dont-email.me>
References: <e5b77d43-34c1-4cd5-ab83-748fda235becn@googlegroups.com>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Injection-Date: Thu, 2 Nov 2023 13:59:21 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="c0e5847bc7394b5adf209a7be3a97d67";
logging-data="2344626"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX195ewPH7hkP6Tmb44eqIHTB4mo5LNAMB6I="
Cancel-Lock: sha1:cBzmuSP5VD/0jUauPjT3yplruMY=
 by: JShepherd - Thu, 2 Nov 2023 13:59 UTC

In article <e5b77d43-34c1-4cd5-ab83-748fda235becn@googlegroups.com>,
kgan238@gmail.com says...
>
>DSAP shows a large amount of temp files on a disk. On closer investigation =
>I found out that there are lots of temp files but are not opened by any pro=
>cesses. This should not happened as closing a temp file should have it auto=
>matically deleted. Attempt to manually purge them returns an error 12. Has =
>anyone encountered this and how to fix this?

A bigger problem, on systems with a lot of SQL/MX create/drop happening,
is the mass of .ddl files in /usr/tandem/sqlmx/ddl .

A single QA test cycle on MX here can create/drop a thousand MX tables.

The first time /usr became full it took a while to find the culprit,
which was was over 300,000 .ddl files in /usr/tandem/sqlmx/ddl

Now, we have a program we run occasionally to clean them out

From this morning on one system
mxscan has deleted 14068 .ddl files

Re: Temporary files not automatically deleted

<64eebc14-d20e-49ea-9b92-d937c6f366f7n@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=758&group=comp.sys.tandem#758

  copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:6214:ab3:b0:66d:5404:b52 with SMTP id ew19-20020a0562140ab300b0066d54040b52mr355058qvb.11.1698962635458;
Thu, 02 Nov 2023 15:03:55 -0700 (PDT)
X-Received: by 2002:a05:6870:239a:b0:1e9:9250:aa41 with SMTP id
e26-20020a056870239a00b001e99250aa41mr9717077oap.1.1698962635263; Thu, 02 Nov
2023 15:03:55 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.mixmin.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Thu, 2 Nov 2023 15:03:54 -0700 (PDT)
In-Reply-To: <ui09vo$27hli$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=2607:fea8:3fa9:4200:ecbd:bbfe:8646:265d;
posting-account=6VebZwoAAAAgrpUtsowyjrKRLNlqxnXo
NNTP-Posting-Host: 2607:fea8:3fa9:4200:ecbd:bbfe:8646:265d
References: <e5b77d43-34c1-4cd5-ab83-748fda235becn@googlegroups.com> <ui09vo$27hli$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <64eebc14-d20e-49ea-9b92-d937c6f366f7n@googlegroups.com>
Subject: Re: Temporary files not automatically deleted
From: rsbec...@nexbridge.com (Randall)
Injection-Date: Thu, 02 Nov 2023 22:03:55 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: Randall - Thu, 2 Nov 2023 22:03 UTC

On Thursday, November 2, 2023 at 9:59:24 a.m. UTC-4, JShepherd wrote:
> In article <e5b77d43-34c1-4cd5...@googlegroups.com>,
> kga...@gmail.com says...
> >
> >DSAP shows a large amount of temp files on a disk. On closer investigation =
> >I found out that there are lots of temp files but are not opened by any pro=
> >cesses. This should not happened as closing a temp file should have it auto=
> >matically deleted. Attempt to manually purge them returns an error 12. Has > >anyone encountered this and how to fix this?
> A bigger problem, on systems with a lot of SQL/MX create/drop happening,
> is the mass of .ddl files in /usr/tandem/sqlmx/ddl .
>
> A single QA test cycle on MX here can create/drop a thousand MX tables.
>
> The first time /usr became full it took a while to find the culprit,
> which was was over 300,000 .ddl files in /usr/tandem/sqlmx/ddl
>
> Now, we have a program we run occasionally to clean them out
>
> From this morning on one system
> mxscan has deleted 14068 .ddl files

You might want to look at how swap space is configured on your system. Some of these files (particularly the ones you cannot purge) might be associated with those.

Re: Temporary files not automatically deleted

<4c4c65c7-8502-41b6-b3e1-8059244db7afn@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=761&group=comp.sys.tandem#761

  copy link   Newsgroups: comp.sys.tandem
X-Received: by 2002:a05:622a:1994:b0:41e:a56c:23a3 with SMTP id u20-20020a05622a199400b0041ea56c23a3mr132787qtc.4.1699232354365;
Sun, 05 Nov 2023 16:59:14 -0800 (PST)
X-Received: by 2002:a05:6808:3601:b0:3b2:e488:a5d4 with SMTP id
ct1-20020a056808360100b003b2e488a5d4mr8573978oib.9.1699232354034; Sun, 05 Nov
2023 16:59:14 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Sun, 5 Nov 2023 16:59:13 -0800 (PST)
In-Reply-To: <ui09vo$27hli$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=130.41.228.154; posting-account=osbHJgoAAADBhvRtSBcl0KwwWNN2TZDt
NNTP-Posting-Host: 130.41.228.154
References: <e5b77d43-34c1-4cd5-ab83-748fda235becn@googlegroups.com> <ui09vo$27hli$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4c4c65c7-8502-41b6-b3e1-8059244db7afn@googlegroups.com>
Subject: Re: Temporary files not automatically deleted
From: kgan...@gmail.com (Keith)
Injection-Date: Mon, 06 Nov 2023 00:59:14 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2382
 by: Keith - Mon, 6 Nov 2023 00:59 UTC

On Friday, November 3, 2023 at 12:59:24 AM UTC+11, JShepherd wrote:

> >DSAP shows a large amount of temp files on a disk. On closer investigation =
> >I found out that there are lots of temp files but are not opened by any pro=
> >cesses. This should not happened as closing a temp file should have it auto=
> >matically deleted. Attempt to manually purge them returns an error 12. Has > >anyone encountered this and how to fix this?
> A bigger problem, on systems with a lot of SQL/MX create/drop happening,
> is the mass of .ddl files in /usr/tandem/sqlmx/ddl .
>
> A single QA test cycle on MX here can create/drop a thousand MX tables.
>
> The first time /usr became full it took a while to find the culprit,
> which was was over 300,000 .ddl files in /usr/tandem/sqlmx/ddl
>
> Now, we have a program we run occasionally to clean them out
>
> From this morning on one system
> mxscan has deleted 14068 .ddl files

Raised this with HPE. The issue was that a permanent file with CLEARONPURGE was purged. DP2 converts this to a temp file but did not purge it. It's a DP2 issue unfortunately.

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor