none
R Services Error: cannot allocate vector of size RRS feed

  • Question


  • Folks,

    I am running queries and utilizing r external scripts. I keep getting "cannot allocate vector of size" errors even though I have plenty of ram and I have changed the rlauncher.config file to up the MEMORY_LIMIT_PERCENT. but I am still getting these errors for relatively small vectors.

    Do I need to do something else to allow R Services to use more memory?

    Thanks





    • Edited by [Mick] Wednesday, May 10, 2017 2:59 PM text keeps encoding badly
    Wednesday, May 10, 2017 2:55 PM

All replies

  • It's possible that you haven't changed the default external resource governor pool. By default this is 20% of the overall system memory. How much memory is available on your database?

    https://docs.microsoft.com/en-us/sql/advanced-analytics/r/how-to-create-a-resource-pool-for-r

    Wednesday, May 10, 2017 7:09 PM
  • Thanks for replying.

    Yeah I did that....

    ALTER RESOURCE POOL "default" WITH (max_memory_percent = 30);  

    ALTER EXTERNAL RESOURCE POOL "default" WITH (max_memory_percent = 70);  

    This is SQL Server 2016 standard edition and it would not allow me to run the following

    ALTER RESOURCE GOVERNOR reconfigure; 

    But I restarted and the following

    SELECT * FROM sys.resource_governor_external_resource_pools WHERE name = 'default'  

    shows the correct figures for modified max_memory_percent for external


    • Edited by [Mick] Wednesday, May 10, 2017 7:20 PM formatting from grammarly
    Wednesday, May 10, 2017 7:20 PM