codingapi / codingapi/tx-lcn

The database is read only; SQL statement:

Open
#449 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
4.2k
Forks
1.4k
PR merge metrics
No merged PRs in 30d

Description

java.sql.SQLException: java.sql.SQLException: The database is read only; SQL statement:
INSERT INTO TXC_UNDO_LOG (UNIT_ID,GROUP_ID,SQL_TYPE,ROLLBACK_INFO,CREATE_TIME) VALUES(?,?,?,?,?) [90097-197] Query: INSERT INTO TXC_UNDO_LOG (UNIT_ID,GROUP_ID,SQL_TYPE,ROLLBACK_INFO,CREATE_TIME) VALUES(?,?,?,?,?) Parameters: [ac006b42457ed1e82c93555e6f237d3c, 554a159c96c537, 3, [11, 10, 8, 116, 98, 95, 116, 111, 107, 101, 110, 19, 11, 10, 8, 116,
在客户端为什么总会更新这种表,这张表TXC_UNDO_LOG 是干什么用的?用着用着就会出现这个问题

Contributor guide

No contributing guide indexed for this repository

Research direction

Start from the TXC_UNDO_LOG INSERT shown in the exception and trace where this table is written in the transaction flow. Reproduce the read-only database failure and determine the table's purpose and why the client updates it. Done means the cause and an actionable resolution are documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
backend, databases, distributed-systems
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.