SQL code: 2048 column store error: search table error: [9] Memory allocation failed

本文探讨了在执行SE16N查询MARC表时遇到的HANA数据库内存分配失败问题,具体表现为SQLcode:2048和columnstoreerror:searchtableerror:[9]Memoryallocationfailed错误。文章详细介绍了如何通过修改HANASTUDIO中的statement_memory_limit参数来解决此问题,以避免长时间运行查询导致的DUMP,并提供了SCN中类似问题的解决案例。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

SQL code: 2048

column store error: search table error: [9] Memory allocation failed

在执行SE16N,不输入任何限制查询MARC表长时间运行DUMP,输入其他条件则不会DUMP,在ST22中查询到如下错误消息

 

 

 

 

 

 

 

 

 

 

 

这个问题是数据库内存限制问题,需要修改如下的HANA STUDIO修改statement_memory_limit参数值为空,即不限制;

在SCN中也有人遇到过类似的问题和解决办法

 

附录

在查询问题中搜索到其他类似的HANA数据库使用问题

The following error messages can indicate OOM situations. Be aware that some of the errors can also be issued in other scenarios. To make sure that they are really memory related, you have to check the related trace file.

SQL error -10108: Session has been reconnected

SQL error 129 while accessing table 

transaction rolled back by an internal error: exception during deltalog replay.

transaction rolled back by an internal error: TableUpdate failed

transaction rolled back by an internal error: exception

1000002: Allocation failed ; $size$=1191936; $name$=TableUpdate; $type$=pool;

$inuse_count$=2180; $allocated_size$=8180736; $alignment$=16#

transaction rolled back by an internal error: TrexUpdate

failed on table with error:

commitOptimizeAttributes() failed with rc=6900, Attribute engine

failed;object=$delta_1$en, rc=6900 - enforce TX rollback

transaction rolled back by an internal error: TrexUpdate

failed on table '' with error: Attribute load

failed;index=en,attribute='$trexexternalkey$' (207), rc=6923 - enforce TX rollback

transaction rolled back by an internal error: TrexUpdate

failed on table '' with error: AttributeEngine: not enough

memory, rc=6952 - enforce TX rollback

SQL error 403 while accessing table 

internal error: ""."": [133] (range 2)

SQL error 2048 while accessing table 

column store error: search table error: [9] Memory allocation failed

column store error: search table error: [1999] general error (no further information available)

column store error: search table error: [2575] flatten scenario failed; Allocation failed

column store error: search table error: [6900] Attribute engine failed

column store error: search table error: [6923] Attribute load failed

column store error: search table error: [6952] Error during optimizer search

column store error: search table error: [6952] AttributeEngine: not enough memory

SQL error 3584 while accessing table

distributed SQL error: [9] Memory allocation failed

distributed SQL error: [2617] executor: plan operation execution failed with an exception

SQL error 3587 at CON

invalid protocol or service shutdown during distributed query execution: 

[2613] executor: communication problem

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值