Skip to content

Lao Zizhu's home

Domestic GBase Database Usage Experience

  • Homepage
  • Core Index
  • Drive
  • Self-check for faults

Day: June 30, 2020

南大通用GBase 8a集群运行报错Express out of resource:Too many tuples

Posted on 2020年6月30日2021年1月29日 by laozizhu

在SQL执行过程中,如果GBase 8a数据库判断涉及的行数,超过了数据库设定的最大行数,则会报这个Express out of resource:Too many tuples的错误。包括简单的count(*)也会。

南大通用GBase 8a集群限制结果集行数,避免的笛卡尔占用大量磁盘

Posted on 2020年6月30日2020年9月8日 by laozizhu

南大通用GBase 8a 数据库集群对于笛卡尔本身并没有检测机制,但可以通过限制结果集的行数,减少笛卡尔的影响。当结果集行数超过限定时,SQL报错。以此避免产生大量的磁盘文件占用。

南大通用GBase 8a集群限制元数据占用的temp堆内存大小

Posted on 2020年6月30日2021年5月12日 by laozizhu

数据库元数据会持久占用内存,如果表很多,可以通过参数限制其占用的大小。

南大通用GBase 8a集群运行报错BLK_TEMP: return NULL in alloc

Posted on 2020年6月30日2021年1月21日 by laozizhu

南大通用GBase 8a集群运行报错BLK_TEMP: return NULL in alloc

南大通用GBase 8a集群打补丁时需要关闭文件检查功能的参数skip_file_check

Posted on 2020年6月30日2022年10月9日 by laozizhu

南大通用GBase 8a集群打补丁时需要关闭文件检查功能的参数skip_file_check

Skip to footer
June 2020
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
2930  
    Jul »

Tags

Event FoundationDB GBase8c GCDW Cloud Data Warehouse gcware gdom ipv6 JDBC kafka Kerberos Linux ODBC Online Analytical Processing performance_schema Python SSL TiDB User-Defined Function V95 Product Information Metadata Full-text index Memory Function Partition Loading Upgrade Multi-instance Stored procedure Learning Log Safety Install Container Password Export Expand Log Date Port Node Replacement Tuning Timeout Operations and maintenance monitoring 锁 Interview questions

Categories

  • GBase8a Operations Case Study Analysis
  • GBase News
  • GBase8a for Everyday Use
  • GBase8a Configuration Parameters
  • GBase8a Development Interface
  • GBase8a Common Questions
  • GBase8a Error Handling
  • Odds and ends
  • Other databases
  • ClickHouse

Archives

  • June 2026
  • May 2026
  • March 2026
  • February 2026
  • January 2026
  • June 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • June 2024
  • May 2024
  • March 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • September 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020

Friendship link

Nanda Generational Official Website
GBase 8a Official Community
Lao Zizhu's Column (CSDN)
GBase 8s Development and Management

Tianjin ICP prepared No. 17003092
Tianjin Public Network Security Preparation No. 12010202000888

Site Map

Back to Top

Proudly powered by WordPress | Theme: Yocto by Humble Themes.
English
Chinese