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
- 表空間監控（二）datafile size detailAI
- request gap sequence is FailedAI
- fork failed - Cannot allocate memoryAI
- Allowed memory size 記憶體不足記憶體
- influxdb報錯：cache-max-memory-size exceededUX
- 關於memory_max_target,memory_target,sga_max_size,sga_target
- ios Request failed: unacceptable content-type: text/html"iOSAIHTML
- Allowed memory size of 134217728 bytes 錯誤解決心得
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- n [Request processing failed; nested exception is com.alibaba.dubbo.rpc.RpcException: Failed to invoAIExceptionRPC
- PostgreSQL DBA(95) - PG 12 Partition(out of shared memory)SQL
- PostgreSQL DBA(56) - Why does checkpointer use so much memorySQL
- android模擬器 一個錯誤：X Error of failed request: BadRequest (invalid request code or no such operation)...AndroidErrorAI
- local.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Allowed memory size of 134217728ErrorException
- composer 報錯：超出記憶體大小的問題（Allowed memory size ）記憶體
- SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192SQL
- Out of sort memory, consider increasing server sort buffer size的兩種情況IDEServer
- ssh到圖形介面時報：X11 forwarding request failed on channel 0ForwardAI
- PostgreSQL提示：‘psql: FATAL: ”Peer authentication failed for user ”postgres“’錯誤SQLAI
- HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGramHTTPAIExceptionSpringFrameworkJDBCSQL
- oracle 10.2.0.3 dbca建庫報Failed to retrieve size of raw device 問題解決方法OracleAIdev
- [Tomcat]嚴重: Context [/xxxx] startup failed due to previous errorsTomcatContextAIError
- PostgreSQL cache lookup failed for type XXXX 錯誤SQLAI
- Memory Notification: Library Cache Object loaded into SGA Heap size 2098K exceeds notification thresObject
- 設定MEMORY_TARGET會導致RESULT_CACHE_MAX_SIZE在重啟後歸零
- 7.20 APPROX_PERCENTILE_DETAILAPPAI
- npm報錯：request to https://registry.npm.taobao.org failed, reason certificate has expiredNPMHTTPAI
- Sector size導致ORA-27061: waiting for async I/Os failed with root.shAI
- Spring Bean的5種作用域--主要是org.springframework.web.context.request.RequestContextListenerSpringBeanFrameworkWebContext
- Javascript記憶體溢位，FATAL ERROR: CALL_AND_RETRY_LAST Allocation failed - JavaScript heap out of memoryJavaScript記憶體溢位ErrorASTAI
- 7.16 APPROX_COUNT_DISTINCT_DETAILAPPAI
- 表空間監控（三）tablespace detailAI
- SAP UI5 應用的主-從-從(Master-Detail-Detail)佈局模式的實現步驟UIASTAI模式
- Based on the SAP R3 Basis Support Function DetailFunctionAI
- 06-記錄網路請求Request failed: unacceptable content-type: text/plain(AFNetworking)AI
- Size DatabaseDatabase
- ContextContext