Title: Neither background nor thread jobs seemingly automatically release COM / unmanaged resources when they complete / are stopped · Issue #24549 · PowerShell/PowerShell · GitHub
Open Graph Title: Neither background nor thread jobs seemingly automatically release COM / unmanaged resources when they complete / are stopped · Issue #24549 · PowerShell/PowerShell
X Title: Neither background nor thread jobs seemingly automatically release COM / unmanaged resources when they complete / are stopped · Issue #24549 · PowerShell/PowerShell
Description: f### Prerequisites Write a descriptive title. Make sure you are able to repro it on the latest released version Search the existing issues. Refer to the FAQ. Refer to Differences between Windows PowerShell 5.1 and PowerShell. Steps to re...
Open Graph Description: f### Prerequisites Write a descriptive title. Make sure you are able to repro it on the latest released version Search the existing issues. Refer to the FAQ. Refer to Differences between Windows Po...
X Description: f### Prerequisites Write a descriptive title. Make sure you are able to repro it on the latest released version Search the existing issues. Refer to the FAQ. Refer to Differences between Windows Po...
Opengraph URL: https://github.com/PowerShell/PowerShell/issues/24549
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Neither background nor thread jobs seemingly automatically release COM / unmanaged resources when they complete / are stopped","articleBody":"f### Prerequisites\r\n\r\n- [X] Write a descriptive title.\r\n- [X] Make sure you are able to repro it on the [latest released version](https://github.com/PowerShell/PowerShell/releases)\r\n- [X] Search the existing issues.\r\n- [X] Refer to the [FAQ](https://github.com/PowerShell/PowerShell/blob/master/docs/FAQ.md).\r\n- [X] Refer to [Differences between Windows PowerShell 5.1 and PowerShell](https://learn.microsoft.com/powershell/scripting/whats-new/differences-from-windows-powershell).\r\n\r\n### Steps to reproduce\r\n\r\nNote:\r\n\r\n* The repro below uses COM; I suspect - but haven't verified - that _any_ unmanaged resources that aren't explicitly released are affected.\r\n\r\n* I would expect at least jobs that complete by themselves to auto-release such resources; ideally also when `Stop-Job`, `Remove-Job -Force` is used (don't know about the technical feasibility; `Stop-Process` applied to a regular session forcefully kills it and therefore does _not_ auto-release).\r\n\r\n * That regular sessions _do_ auto-release can be verified by setting `$useJobs` to `$false` below and re-running the script, which uses CLI calls instead of jobs.\r\n\r\n * Curiously, `ForEach-Object -Parallel` is seemingly _not_ affected; in the following example the Excel processes _do_ eventually disappear:\r\n\r\n Stop-Process -Name excel -ea ignore; 1, 2 | ForEach-Object -Parallel { $xl = New-Object -ComObject Excel.Application; $xl.Name; Start-Sleep 5 }\r\n\r\n\r\n```powershell\r\n# Make sure no Excel processes are running\r\nGet-Process -ErrorAction Ignore Excel | Stop-Process -Force -ErrorAction Stop\r\n\r\n\r\n# A script block that creates a new Excel process via COM, assigns it to a variable, and waits 2 secs.\r\n# before exiting (to ensure that it isn't garbage collected right away).\r\n$sb = { $xl = New-Object -ComObject Excel.Application; $xl.Name; Start-Sleep 2 }\r\n\r\n# Set this to $false to use CLI calls instead, which work correctly.\r\n$useJobs = $true\r\n\r\nif ($useJobs) {\r\n Write-Verbose -Verbose '--- Creating a background and a thread job each of which creates an Excel process via COM...'\r\n $jobs = (Start-Job $sb), (Start-ThreadJob $sb)\r\n} else {\r\n Write-Verbose -Verbose '--- Calling the CLIs (powershell.exe and pwsh.exe) each of which create an Excel process via COM...'\r\n powershell -NoProfile $sb\r\n pwsh -NoProfile $sb\r\n}\r\n\r\nif ($useJobs) {\r\n $jobs | Receive-Job -Wait -AutoRemoveJob\r\n}\r\n\r\n# Wait a while to allow extra time for the COM resources to be released,\r\n# which should result in the termination of the Excel processes.\r\nWrite-Verbose -Verbose 'Sleeping 30 secs. to wait for release of COM resources...'\r\nStart-Sleep 30\r\n\r\n# Now there should be NO Excel processes.\r\nWrite-Verbose -Verbose '--- Excel processes after (there should be no output)...'\r\nGet-Process -ErrorAction Ignore Excel\r\n```\r\n\r\n### Expected behavior\r\n\r\n```console\r\nVERBOSE: --- Creating a background and a thread job each of which creates an Excel process via COM...\r\nMicrosoft Excel\r\nMicrosoft Excel\r\nVERBOSE: Sleeping 30 secs. to wait for release of COM resources...\r\nVERBOSE: --- Excel processes after (there should be no output)...\r\n```\r\n\r\nThat is, the two Excel processes should eventually terminate due to auto-release of the COM wrapper.\r\n\r\n\r\n### Actual behavior\r\n\r\n```console\r\nVERBOSE: --- Creating a background and a thread job each of which creates an Excel process via COM...\r\nMicrosoft Excel\r\nMicrosoft Excel\r\nVERBOSE: Sleeping 30 secs. to wait for release of COM resources...\r\nVERBOSE: --- Excel processes after (there should be no output)...\r\n\r\n NPM(K) PM(M) WS(M) CPU(s) Id SI ProcessName\r\n ------ ----- ----- ------ -- -- -----------\r\n 65 71.33 233.75 1.17 5900 12 EXCEL\r\n 66 72.31 234.75 0.88 10488 12 EXCEL\r\n```\r\n\r\nThat is, the two Excel processes linger, because the COM wrapper was never released.\r\n\r\n\r\n### Error details\r\n\r\n_No response_\r\n\r\n### Environment data\r\n\r\n```powershell\r\nPowerShell 7.5.0-preview.5\r\n```\r\n\r\n\r\n### Visuals\r\n\r\n_No response_","author":{"url":"https://github.com/mklement0","@type":"Person","name":"mklement0"},"datePublished":"2024-11-05T18:35:29Z","url":"https://github.com/PowerShell/PowerShell/issues/24549"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:3d83ea1c-3a78-d932-f65e-4badfe767413 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | C746:255994:13AD21:1A25FF:6AFD0F2E |
| html-safe-nonce | 86f72fc12603af9eac39f75034f1b9efb602cad40f4200b1527ac1a0c1d12e3c |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNzQ2OjI1NTk5NDoxM0FEMjE6MUEyNUZGOjZBRkQwRjJFIiwidmlzaXRvcl9pZCI6IjUwNjk5NDIxNzI5NTg5MjA0OTQiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 0b142bc3ca0622aafab3d674231762eab02b4e84b6354097f00c93d0ba6d35df |
| hovercard-subject-tag | issue:2636188248 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/PowerShell/PowerShell/24549/issue_layout |
| twitter:image | https://opengraph.githubassets.com/daf547581e32fc1a90897973861957e22139d63a2f2b2f9c41b59929267c3fe2/PowerShell/PowerShell/issues/24549 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/daf547581e32fc1a90897973861957e22139d63a2f2b2f9c41b59929267c3fe2/PowerShell/PowerShell/issues/24549 |
| og:image:alt | f### Prerequisites Write a descriptive title. Make sure you are able to repro it on the latest released version Search the existing issues. Refer to the FAQ. Refer to Differences between Windows Po... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | mklement0 |
| hostname | github.com |
| expected-hostname | github.com |
| None | 7c34e25df4e46e972c8f0225e63410231bdeb9ea5634597c712796bbcdb2e627 |
| turbo-cache-control | no-preview |
| go-import | github.com/PowerShell/PowerShell git https://github.com/PowerShell/PowerShell.git |
| octolytics-dimension-user_id | 11524380 |
| octolytics-dimension-user_login | PowerShell |
| octolytics-dimension-repository_id | 49609581 |
| octolytics-dimension-repository_nwo | PowerShell/PowerShell |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 49609581 |
| octolytics-dimension-repository_network_root_nwo | PowerShell/PowerShell |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 8fa571ebaa95e4e6bf872197c0e84b7dc48e6785 |
| ui-target | canary-2 |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width