Can u kill vacuum?


I started a vacuum cleanup and it has been running over 2 hours, its not hung, but my customers a freaking out.



Can you just ctl-C out of it or will that hurt database?
  • Erich D. Flynn sounds like they 'said':

    >
    > I started a vacuum cleanup and it has been running over 2 hours, its
    > not hung, but my customers a freaking out.
    >
    >
    >
    > Can you just ctl-C out of it or will that hurt database?


    So my response to Erich's comment is...

    Personally, I would leave it running, let it finish. When's the last
    time that has been run on that server? How many users

  • about 60 days ago, it only took appx 1.5h. using newest dsapp 315 users, 450 devices.






    >>> Stevo<steveSPAM@LESSccgov.net> 5/17/2016 12:41 PM >>>



    Erich D. Flynn sounds like they 'said':





    >



    > I started a vacuum cleanup and it has been running over 2 hours, its



    > not hung, but my customers a freaking out.



    >



    >



    >



    > Can you just ctl-C out of it or will that hurt database?





    So my response to Erich's comment is...




    Personally, I would leave it running, let it finish. When's the last

    time that has been run on that server? How many users
  • Erich D. Flynn sounds like they 'said':

    >
    > about 60 days ago, it only took appx 1.5h. using newest dsapp 315
    > users, 450 devices.
    >

    So my response to Erich's comment is...

    Strange, wouldn't think it would take that much more time in 2 months.
    Free HD space ok on that box?

    --
    Stevo

  • ya, I didn't expect it to take this long either.



    Its on the check after DI_deviceIdEclassFolderID_idx and it has been going for 58 minutes.




    >>> Stevo<steveSPAM@LESSccgov.net> 5/17/2016 1:04 PM >>>



    Erich D. Flynn sounds like they 'said':





    >



    > about 60 days ago, it only took appx 1.5h. using newest dsapp 315



    > users, 450 devices.



    >


    So my response to Erich's comment is...




    Strange, wouldn't think it would take that much more time in 2 months.

    Free HD space ok on that box?




    --

    Stevo
  • Erich D. Flynn sounds like they 'said':

    >
    > ya, I didn't expect it to take this long either.
    >
    >
    >
    > Its on the check after DI_deviceIdEclassFolderID_idx and it has been
    > going for 58 minutes.
    >

    So my response to Erich's comment is...

    Ugh, I'm not sure then, with it working on the database I'd hate to
    stop it.

    If it's not going to finish though, you may not be left with a choice.

    Sorry to be so helpful............. :-/

    --
    Stevo

  • Thanks for the responses Steve. I will just wait.




    >>> Stevo<steveSPAM@LESSccgov.net> 5/17/2016 1:32 PM >>>





    Erich D. Flynn sounds like they 'said':





    >



    > ya, I didn't expect it to take this long either.



    >



    >



    >



    > Its on the check after DI_deviceIdEclassFolderID_idx and it has been



    > going for 58 minutes.



    >


    So my response to Erich's comment is...




    Ugh, I'm not sure then, with it working on the database I'd hate to

    stop it.




    If it's not going to finish though, you may not be left with a choice.




    Sorry to be so helpful............. :-/




    --

    Stevo
  • Just to throw my 2 cents out there..

    If you do decide you need to kill the vacuum / index process (not suggested).. you could "refresh" or "cuso (clean up start over)" it.
    See this TID on the process using dsapp: https://www.novell.com/support/kb/doc.php?id=7014473

    Pretty much drops all databases (with a option to preserve user list), deletes all attachments, recreates the databases.
    Downside is you'll need to resync every user - however a good alternative to a excessively long vacuum / index.
  • Just to throw my 2 cents out there..

    If you do decide you need to kill the vacuum / index process (not suggested).. you could "refresh" or "cuso (clean up start over)" it.
    See this TID on the process using dsapp: https://www.novell.com/support/kb/doc.php?id=7014473

    Pretty much drops all databases (with a option to preserve user list), deletes all attachments, recreates the databases.
    Downside is you'll need to resync every user - however a good alternative to a excessively long vacuum / index.

  • For what it worth, this was the culprit. I appreciate all the feedback.



    INFO: "deviceimages": moved 2049601 row versions, truncated 693653 to 605273 pages
    DETAIL: CPU 623.67s/5496.55u sec elapsed 18157.97 sec.





    >>> Erich D. Flynn<EFlynn@grcc.edu> 5/17/2016 12:25 PM >>>


    I started a vacuum cleanup and it has been running over 2 hours, its not hung, but my customers a freaking out.




    Can you just ctl-C out of it or will that hurt database?