The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

wos data moveout

I have stopped writing to the database and I want to alter the resource pool wosdata, but I receive this: vertica=> ALTER RESOURCE POOL wosdata MAXMEMORYSIZE '5G' ; ERROR 3911: maxMemorySize for wosdata can be changed only when the user WOS is empty HINT: Do a moveout and select * from wos_container_storage to confirm How do I "Do a moveout"?

Comments

  • Hi David, You can check in the table projection_storage column wos_used_bytes to see which projection is using WOS data. select * from projection_storage where wos_used_bytes > 0; You can force a moveout by doing =>select do_tm_task('moveout'); Hope this helps. Eugenia
  • That worked. Thanks!
  • Glad to hear that. Eugenia
  • Hi Eugenia,

    I am trying to enlarge the wosdata pool :I do the following ; in the end I have no sessions connected ;

    yet the wos_pool does not cleaned out entirely , hence it keeps failing .

    Since I change to 0 connections I can't just play around with it .

    The db is very large , but still there should be a way to get to a clean up .

    Thanks!

     

    ================= sequence to change a resource pool ========================
    select GET_CONFIG_PARAMETER('MaxClientSessions') ; -- ( save the value)
    select SET_CONFIG_PARAMETER('MaxClientSessions',0) ;
    Select do_tm_task('moveout') ;
    Select close_all_sessions();
    Select do_tm_task('moveout') ;
    select * from wos_container_storage ;
    select node_name ,user_name,client_pid,session_id,client_label,transaction_id ,statement_start ,statement_id from sessions ;
    alter resource pool wosdata MEMORYSIZE '2G' MAXMEMORYSIZE '2G';
    select SET_CONFIG_PARAMETER('MaxClientSessions',500) ;

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.