Delphix Products

 View Only
  • 1.  [VDB] - question about VDB refresh.

    Posted 07-11-2024 10:55:00 AM

    Hi everybody,

    I have a question about VDB refreshs: 

    When we start a refresh job and we get an error on a hook script localized in the post refresh section, does Delphix rollbacks the refresh or not?

    Is there a documentation where i can find this information?

    Thanks.



    ------------------------------
    Bruno Lira
    Estagiário
    V8 Consulting LTDA ME.
    ------------------------------


  • 2.  RE: [VDB] - question about VDB refresh.

    Posted 07-11-2024 11:13:00 AM

    Hello,

     

    As far as I remember the VDB is technically opened, but Delphix will shutdown and disable the VDB after the hook throws an error.

     

    There should be some info on this in official documentation around hooks but we need to check it with a close look.

     

    BR,

    Rahim CETINEL 

    Lead DataOps Architect

    Delphix Blackbelt 

    +971509176453 

    +905334112490 


    Accuras DMCC
     
    DMCC Business Centre Unit No: 1518 
    PO Box 41174, Dubai,  UAE
    https://accuras.com  

     

     






  • 3.  RE: [VDB] - question about VDB refresh.
    Best Answer

    Posted 07-11-2024 12:25:00 PM

    Hello,

    If the hook fails, the VDB should not be accessible ( https://cd.delphix.com/docs/latest/sql-server-hook-operation-notes ):

    If successful, the script must exit with an exit code of 0. All other exit codes will be treated as an operation failure.

    Some customers do masking in their hooks and would not want their VDB provision/refresh to succeed and allow unmasked data out into the wild if the hook failed. There is a new feature request to make this configurable ( IDEA-1173 - Add switch to hooks to still allow provision to complete if hook fails ).

    Once it has failed to provision/refresh Delphix won't allow control of it (start/stop/enable/disable).

    There are other various feature requests like (IDEA-1855 - Provide ability for customer to mark a failed Oracle VDB provision/refresh as good) which would allow you to mark the VDB refresh as good despite the job failure. Or this one (IDEA-3187 - Provide an Option to Allow Auto Refresh of Disabled VDB (via VDB Refresh Policy)

    ) asks for a mechanism to try refreshing again after a failed refresh. It might make sense for transient issues to try the refresh again.

    Often there are non-transient issues (password expired, memory shortages, etc.) that need to be fixed before trying again.

     

    I hope this helps to answer your question.

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 4.  RE: [VDB] - question about VDB refresh.

    Posted 07-11-2024 01:41:00 PM

    As a workaround, it is always possible to use "exit 0" in the last line of a hook, which would make the hook report that it ended with success (whether it's successful or not).

     

     

     

    Rahim CETINEL 

    Lead DataOps Architect

    Delphix Blackbelt 

    +971509176453 

    +905334112490 


    Accuras DMCC
     
    DMCC Business Centre Unit No: 1518 
    PO Box 41174, Dubai,  UAE
    https://accuras.com  

     

     






  • 5.  RE: [VDB] - question about VDB refresh.

    Posted 07-12-2024 01:21:00 PM

    Hi Rahim, thanks for the information. I will add this to the hook.



    ------------------------------
    Bruno Lira
    Estagiário
    V8 Consulting LTDA ME.
    ------------------------------