PostgreSQL Detail: Failed on request of size 8192 in memory context "ErrorContex
報如下錯誤
FROM oss_dwd.dwd_story_dd story FULL JOIN oss_dwd.dwd_story_task_relation_dd str ON story.dwid = str.story dwid FULL JOIN oss_dwd.dwd_task_dd task ON str.task_dwid = task.dwid LEFT JOIN gs5_dwd..dwd_story_member_dd mem ON mem.story_dwid = story.dwid AND mem.member_type = 'story_designer' 2022-06-29 13:43:33.129 [ERROR]Error in execute sql java.lang.RuntimeException: sql execute exception is at com.xxxxxx.rdcxxxxxxxxxxx at com.xxxxxx.rdcxxxxxxxxxxx at com.xxxxxx.rdcxxxxxxxxxxxjava:193) at com.xxxxxx.rdcxxxxxxxxxxx at java.util.concurrent.xxxxxxxxxxx at java.util.concurrentxxxxxxxxxxx at java.util.concurrentxxxxxxxxxxx at java.util.concurrentxxxxxxxxxxx [?:1.8.0__202] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] Caused by: org.postgresgl.util.PSQLException: ERROR: out of memory Detail: Failed on request of size 8192 in memory context "ErrorContext" at orgpostgresal.core.v3.xxxxxx
當前資料庫work_mem是4MB，會話或者例項級別 調整work_mem
set work_mem='64MB';
調整後SQL可以執行成功
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29990276/viewspace-2903407/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- PostgreSQL DBA(179)-invalid memory alloc request size XXXSQL
- fork failed - Cannot allocate memoryAI
- Allowed memory size 記憶體不足記憶體
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- ORA-27121: unable to determine size of shared memory segment
- influxdb報錯：cache-max-memory-size exceededUX
- zblog顯示Allowed memory size of 6553652 bytes exhauste
- local.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Allowed memory size of 134217728ErrorException
- XFS: nfsd(13480) possible memory allocation deadlock size 65532 in kmem_reallocNFS
- PostgreSQL DBA(95) - PG 12 Partition(out of shared memory)SQL
- composer 報錯：超出記憶體大小的問題（Allowed memory size ）記憶體
- 帝國CMSr的Fatal error:Allowed memory size of的解決辦法Error
- Out of sort memory, consider increasing server sort buffer size的兩種情況IDEServer
- PostgreSQL cache lookup failed for type XXXX 錯誤SQLAI
- PostgreSQL DBA(56) - Why does checkpointer use so much memorySQL
- 帝國cms網站Fatal error: Allowed memory size of … bytes exhausted怎麼辦？網站Error
- 帝國CMS更新時提示Fatal error: Allowed memory size of的解決方法Error
- HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGramHTTPAIExceptionSpringFrameworkJDBCSQL
- npm ERR! network request to https://registry.npmmirror.com/create-vite failed,NPMHTTPViteAI
- Sector size導致ORA-27061: waiting for async I/Os failed with root.shAI
- MORE_DETAIL_TECHAI
- WPF master detail viewASTAIView
- PostgreSQL提示：‘psql: FATAL: ”Peer authentication failed for user ”postgres“’錯誤SQLAI
- npm報錯：request to https://registry.npm.taobao.org failed, reason certificate has expiredNPMHTTPAI
- npm報錯：request to https://registry.npm.taobao.org failed處理辦法NPMHTTPAI
- ssh到圖形介面時報：X11 forwarding request failed on channel 0ForwardAI
- 7.20 APPROX_PERCENTILE_DETAILAPPAI
- 關於Allowed memory size of （PHP記憶體溢位）錯誤的可能原因及解決方案PHP記憶體溢位
- Go：context.ContextGoContext
- Javascript記憶體溢位，FATAL ERROR: CALL_AND_RETRY_LAST Allocation failed - JavaScript heap out of memoryJavaScript記憶體溢位ErrorASTAI
- 7.16 APPROX_COUNT_DISTINCT_DETAILAPPAI
- memory
- ContextContext
- go 上下文：context.ContextGoContext
- Android 棧記憶體溢位bug fix小記（pthread_create (1040KB stack) failed: Out of memory）Android記憶體溢位threadAI
- 解決yarn打包時出現“FATAL ERROR: Reached heap limit Allocation failed - JavaScript heap out of memory”的問題YarnErrorMITAIJavaScript
- 《Lua-in-ConTeXt》02：ConTeXt 計算機Context計算機
- BMZCTF：memory