TIL: Fixing “Cannot Find onconfig File” in GBase Database
Today I helped troubleshoot a GBase Database(GBase 8s) instance that failed to start. The error looked like a missing configuration file, but the re…
Latest Web news from Tech News
All topics
AI
agents
ai
api
architecture
automation
backend
beginners
career
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
Fixing "Can't get distribution attribute of table" in GBase 8a
When a gbase database cluster experiences an unclean shutdown — a sudden power loss or kernel panic — some metadata that was still in memory may nev…
GBase 8a 9.5.3 New Feature: Event‑Based Data Node Replacement (eventMode)
Starting from certain builds of GBase 8a 9.5.3, a new event‑driven method for replacing failed data nodes is available. Unlike the traditional redis…
GBase 8a Performance Anomaly Case Study: How a Single Parameter Change Sparked a Chain Reaction
One seemingly innocent parameter adjustment — increasing group_concat_max_len to accommodate a business requirement — caused a cascade of performanc…
GBase 8a Table Design and Modeling: Choosing Data Types, Partitions, Distribution Keys, and Replicated Tables
In a distributed analytical gbase database , many performance issues are baked in at the table design stage. Data types, partitioning, distribution…
GBase 8a Operations in Practice: Load Monitoring, Audit Logs, and Memory Tuning
This guide covers three core areas of daily GBase 8a operations: tracking data loads and collecting error details, configuring audit logs and analys…
What Drags Down Throughput in GBase 8a Bulk Loading — and Where to Look First
When loading large volumes into a gbase database cluster, stability matters far more than a single peak throughput number. The same 500 GB data set…
GBase 8a Security Hardening: Permissions, Password Policies, SSL Encryption, and Audit Logs
This guide provides a complete security hardening checklist for a gbase database cluster, covering user privileges, password policies, SSL encryptio…
GBase 8c Distributed Cluster Operations: Troubleshooting Common Failures with Hands‑On Fixes
Node crashes, connection storms, shard anomalies, and resource overloads are the most frequent disruptions in a gbase database cluster. This guide d…
GBase 8a Data Migration: Standardizing Export, Load, and Verification
When moving data between GBase 8a clusters, stability trumps speed. Failures often stem not from the commands themselves but from inconsistent forma…
GBase 8c Object Dependency Checks Before Schema Changes
The real challenge in a gbase database schema change isn't writing the DDL — it's uncovering every object that depends on the table before you hit “…
GBase 8c DDL Change Risks: Object Dependencies and Troubleshooting
DDL changes in a gbase database often fail not because of syntax errors, but because of hidden object dependencies, long-running transactions, lock…
How NULL Values Skew Comparisons, Aggregations, and Deduplication in GBase 8a
NULL in a gbase database doesn't behave like an ordinary value, nor is it simply a blank. It affects comparisons, deduplication, aggregations, and c…
GBase 8a Slow SQL Diagnosis: 6 Real‑World Cases from Symptom to Fix
Six real slow‑query scenarios with complete trace: data skew, wrong execution plans, oversized intermediate results, and functions that disable part…
Debugging Slow SQL in GBase 8a: How Execution Plans, Distribution Keys, and Parallelism Go Off the Rails Together
A slow query in a gbase database MPP cluster is rarely just a matter of sloppy SQL. More often, it's the combined effect of data distribution, execu…
GBase 8a Backup and Restore Guide: Full and Incremental Backups with gbackup
GBase 8a stores massive analytical datasets across many nodes. If hardware fails, someone drops a table, or an upgrade goes wrong, a solid backup st…
When GBase 8a Execution Plans Go Wrong: Mastering Statistics Management
A simple SQL suddenly triggers a full table scan, or a JOIN order looks completely off. Most of the time, the culprit is stale statistics misleading…
How to Audit Only Critical Operations Like DROP TABLE in GBase 8a
GBase 8a’s audit log can capture virtually every SQL operation. To keep logs lean and focused on security, you can configure a policy that records o…
How GBase 8a Resource Plans Bind to Time Schedules
Resource plans in GBase 8a (e.g., plan_day , plan_night ) are not directly bound to time and do not support cron expressions . Their automated switc…
Why a Failed Rebalance Returns to STARTING Instead of CANCELED in GBase 8a
When a rebalance operation fails on a table that is in RUNNING state, GBase 8a moves the table back to STARTING — not to CANCELED . This behavior re…
IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable
Both IFNULL and NULLIF accept two arguments, but they perform opposite operations. Knowing the difference is key to avoiding subtle data errors. Fun…
Get Real Row Counts in GBase 8s Without UPDATE STATISTICS
The nrows column in systables is only updated when you run UPDATE STATISTICS , so it often shows 0 even right after bulk inserts. If you need the re…
Interval Partitioning in GBase 8s: Automatic Extension and Lifecycle Management
Interval partitioning automatically creates new partitions when data exceeds the defined range, eliminating the need to manually add partitions. GBa…
Expanding a GBase 8a Cluster: Adding a GNode in Practice
As data grows, you'll likely need to add nodes to your existing GBase 8a MPP cluster without downtime. This hands‑on guide walks through the full pr…
GBase 8s: How DELIMIDENT Controls Case Sensitivity
By default, identifiers in GBase 8s are case‑insensitive: uppercase letters are silently treated as lowercase. Setting the environment variable DELI…
End-to-End: Hadoop Deployment and Data Loading into GBase 8a
This post walks through setting up a distributed Hadoop cluster from scratch and loading data from HDFS into GBase 8a, GBASE's China-domestically de…
GBase 8c High Availability with VIP: A Step-by-Step Verification Guide
This walkthrough demonstrates how to deploy a GBase 8c primary‑standby cluster with a virtual IP (VIP) and verify automatic failover. GBase 8c is a…