1. Forum
  2. USENET
  3. comp.sys.tandem

  • Temporary files not automatically deleted

    From Keith@kgan238@gmail.com to comp.sys.tandem on Wed Nov 1 22:47:14 2023
    From Newsgroup: comp.sys.tandem

    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?
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From invalid@invalid@nowhere.com (JShepherd) to comp.sys.tandem on Thu Nov 2 13:59:21 2023
    From Newsgroup: comp.sys.tandem

    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

    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Randall@rsbecker@nexbridge.com to comp.sys.tandem on Thu Nov 2 15:03:54 2023
    From Newsgroup: comp.sys.tandem

    On Thursday, November 2, 2023 at 9:59:24rC>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.
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Keith@kgan238@gmail.com to comp.sys.tandem on Sun Nov 5 16:59:13 2023
    From Newsgroup: comp.sys.tandem

    On Friday, November 3, 2023 at 12:59:24rC>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.
    --- Synchronet 3.21d-Linux NewsLink 1.2