27 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
2
answers
83
views
Oceanbase build error. Relocation R_X86_64_32 cannot be used against local symbol [closed]
I followed this guide(https://oceanbase.github.io/oceanbase/) to build the Oceanbase database on Centos 9 Stream. The default glibc version of this OS is 2.34, which satisfies the problem mentioned in ...
0
votes
0
answers
26
views
How to add NOT NULL constraint to existing column in OceanBase
Environment
OceanBase community edition 4.2.1 (mysql mode).
When attempting to add a NOT NULL constraint to an existing column in OceanBase, I encounter different behavior compared to native MySQL.
...
user avatar
user30195804
0
votes
0
answers
42
views
Why does this simple JOIN query perform poorly in OceanBase
Environment
OceanBase Community Edition 4.2.1 - MySQL mode,3 Availability Zones
I'm evaluating OceanBase for a project that requires complex joins. A query that executes in 200ms on MySQL 5.7 takes ...
0
votes
0
answers
38
views
Extremely slow query on partitioned table despite indexed columns in OceanBase
OceanBase Version
Community Edition 4.2.1 (MySQL mode)
I'm observing a 10x performance degradation in OceanBase compared to MySQL 5.7 when querying a partitioned table, even with proper indexes. Here'...
user avatar
user30403414
0
votes
0
answers
20
views
Transaction rollback not working in OceanBase stored procedure (MySQL mode)
Environment
OceanBase 4.2.1 Community Edition (MySQL mode)
Kubernetes deployment
I'm encountering unexpected transaction behavior in OceanBase when using stored procedures. Here's a minimal ...
user avatar
user30403414
0
votes
1
answer
35
views
How to handle dynamic SQL generation safely in OceanBase stored procedures
Environment
OceanBase community edition 4.2.1 (MySQL Mode)
Tables partitioned by range (archive_2023Q1, archive_2023Q2, etc.)
The user has full DML privileges on all archive tables
I'm implementing ...
user avatar
user30403414
0
votes
1
answer
45
views
How to debug PL/SQL procedure performance issues in OceanBase
Environment
OceanBase community edition 4.2.1 (MySQL Mode)
Table transactions has 1M+ rows, partitioned by id.
I'm encountering performance issues with a stored procedure in OceanBase. The procedure ...
user avatar
user30195804
0
votes
0
answers
26
views
Why does OceanBase's ROW_NUMBER() ignore my index even with ORDER BY matching the index column
OceanBase Version
Community Edition 4.2.1 (MySQL mode)
When using ROW_NUMBER() OVER (ORDER BY indexed_column) in OceanBase, the query ignores my index and does a full scan:
-- Table has an index on (...
0
votes
0
answers
36
views
How to properly retry a transaction after OB_TRANS_KILLED (Error 6002) in OceanBase JDBC
Environment
OceanBase 4.2.1 (community - Mysql mode)
Transaction contains multiple DML operations
When OceanBase JDBC throws OB_TRANS_KILLED (Error Code 6002), what is the correct way to retry the ...
user avatar
user30403414
0
votes
0
answers
26
views
How to programmatically validate no money was lost/gained across all Zones in OceanBase database
Environment
OceanBase Community Edition 4.2.1 (MySQL mode & 3-node cluster)
Sysbench 1.0.20
-- OceanBase 4.2.1 Cluster
SET GLOBAL ob_trx_timeout = 36000000000;
SET GLOBAL _ob_2pc_retry_interval =...
0
votes
0
answers
26
views
OceanBase returns incorrect row count for affected rows in python
Environment
OceanBase community edition 4.2.1 (mysql mode)
Python 3.8
I'm encountering inconsistent behavior when checking affected rows after UPDATE operations in OceanBase using Python. The ...
user avatar
user30195804
1
vote
0
answers
56
views
OceanBase (MySQL Mode) fails to execute stored procedure with dynamic SQL in python
Environmen
OceanBase Community Edition 4.2.1 (MySQL mode)
I'm trying to call an OceanBase stored procedure that contains dynamic SQL (PREPARE ... EXECUTE) from Python, but it fails with a vague error.
...
0
votes
1
answer
44
views
"Access denied" when using PyMySQL with OceanBase in transactional mode, but MySQL client connects fine
Environment
OceanBase Community Edition 4.2.1 (MySQL mode)
Python 3.10
PyMySQL 1.1.0
I'm trying to use PyMySQL to execute transactions on OceanBase, but I'm getting an unexpected "Access denied&...
user avatar
user30195804
0
votes
0
answers
31
views
How to handle auto-increment gaps in OceanBase MySQL mode when bulk inserting
Environments
OceanBase Community 4.2.1 (MySQL mode)
MySQL version 5.7
We're migrating from MySQL 5.7 to OceanBase 4.2.1 (MySQL compatibility mode) and observing different auto-increment behaviors ...
user avatar
user30195804
0
votes
0
answers
39
views
How to debug complex stored procedures in OceanBase
Environment
OceanBase 4.2.1 (Enterprise Edition - Oracle Mode)
I'm migrating Oracle stored procedures to OceanBase (Oracle compatibility mode) and encountering difficulties in debugging multi-step ...
user avatar
user30195804