This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
I have installed the Python 3.7 machine learning feature in SQL Server but the memory growth is huge after executing several Python scripts.
When you execute a SQL job with a python statement the launchpad creates folders in the MSSQL\ExtensibilityData\MSSQLSERVER01 with some files in it, but when the script ends the files are gone but the directories are still there and after a while there is a huge ammount of folders that will consume a lot of memory.
This from the EXTLAUNCHERRORLOG:
2023-02-07 16:22:28.853 GrantPermissionToExternalLibrary failed. ScriptType: 1. Error Code: 0x80070490
2023-02-07 16:22:28.853 GrantPermissionToExternalLibraryDirectories() failed. Error Code: 0x80070490
2023-02-07 16:22:31.119 RevokePermissionToExternalLibrary failed. ScriptType: 1. Error Code: 0x80070490
2023-02-07 16:22:31.119 RevokePermissionToExternalLibraryDirectories failed. Error Code: 0x80070490.
2023-02-07 16:22:31.134 Failed to delete files in directory G:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\ExtensibilityData\MSSQLSERVER01\4E8F0405-1A4A-47DA-9F2F-9E2650FCD88B with HR 0x80070005.
2023-02-07 16:22:31.134 Failed to delete directory G:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\ExtensibilityData\MSSQLSERVER01\4E8F0405-1A4A-47DA-9F2F-9E2650FCD88B with HR 0x80070091.
From the pythonlauncher.log:
[2023-02-07 15:05:56.726][00001B04][00002AC8][Always] ScaleRJobCleaner.Start() successfully started thread 7252 [00001C54].
[2023-02-07 15:05:56.726][00001B04][00002AC8][Always] ProcessPoolTrimmer.Start() successfully started thread 10484 [000028F4].
[2023-02-07 15:05:56.726][00001B04][00001C54][Always] ScaleRStaleJobCleaner::Worker(0000024251F0B7B0) started successfully.
[2023-02-07 15:05:56.726][00001B04][000028F4][Always] ProcessPoolTrimmer::Worker(0000024251F016D0) started successfully.
[2023-02-07 15:05:56.726][00001B04][00002AC8][Always] StaleDirectoryCleaner.Start() successfully started thread 7040 [00001B80].
[2023-02-07 15:05:56.742][00001B04][00002AC8][Always] ComputerName=SE94ADETLDB01
[2023-02-07 15:05:56.742][00001B04][00002AC8][Always] SystemRoot=C:\Windows
[2023-02-07 15:05:56.742][00001B04][00002AC8][Always] User=NT SERVICE\MSSQLLaunchpad
[2023-02-07 15:05:56.742][00001B04][00002AC8][Always] UserProfile=C:\Users\MSSQLLaunchpad
[2023-02-07 15:05:56.742][00001B04][00002AC8][Always] Users=0
[2023-02-07 15:06:35.117][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:06:35.117][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:06:36.695][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:06:36.695][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:06:39.039][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:06:39.039][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:13:21.603][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:13:21.603][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:13:23.275][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:13:23.275][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:13:25.603][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:13:25.603][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:22:27.181][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:22:27.181][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:22:28.775][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:22:28.775][00001B04][00001F78][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:22:31.119][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
[2023-02-07 15:22:31.119][00001B04][00001EDC][Error] Process::TryTerminate failed with error code: 5
I have granted everyone with full rights to the folder above, but still the directories stay in place when executing python scripts in sql server. The only way to delete the folders is by hand and also when you restart the launchpad service.
Can someone help me with this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Eric Bezemer ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Have you granted access to ALL APPLICATION PACKAGES? If not, try that.
I just tried it, but with no result. It's interesting that when I restart the launchpad service the given rights are all going to the default values and the MSSQLSERVER01 folder is empty after that.
Do you have a script the produces the problem? That is, produces a bunch of folders when you run it? (I'm too lazy to write one myself. :--)
When I run several python scripts I produce the problem, because the folders where created but not deleted.
Yeah, but was asking for a repro script, so that I can do some testing at my end.
Hi @Eric Bezemer ,
Seeing error 5 makes me think of an access denied error. Although not necessarily the same as error 5 here, I would like to mention that the SQLRUserGroup group and MSSQLLaunchpad account needed "Read & Execute" access to the R_SERVICES folder.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
I have granted full rights to the PYTHON_SERVICES and the PYTHON_SERVICES3.7 for the SQLRUserGroup and the launchpad, but the same error result. I have no R_SERVICES folder because I dont have R installed.
Hi @Eric Bezemer ,
You can try to install the latest Cumulative Updates(CU31)
Screenshot taken from this: https://learn.microsoft.com/en-us/sql/machine-learning/sql-server-machine-learning-services?view=sql-server-ver16#python-and-r-versions
If that doesn't work, you can try restarting the SQL Server service.
Best regards,
Seeya
Hi @Seeya Xi-MSFT ,
The server has already the latest CU updates and I will try to restart the SQL Server service.