sqlite-web 0.7.2
gitea.db
action
Create
Query
access
access_token
action
action_artifact
action_run
action_run_index
action_run_job
action_runner
action_runner_token
action_schedule
action_schedule_spec
action_task
action_task_output
action_task_step
action_tasks_version
action_variable
app_state
attachment
auth_token
badge
branch
collaboration
comment
commit_status
commit_status_index
commit_status_summary
commit_sync_log
commit_sync_status
dbfs_data
dbfs_meta
deploy_key
email_address
email_hash
external_login_user
follow
gpg_key
gpg_key_import
hook_task
issue
issue_assignees
issue_content_history
issue_dependency
issue_index
issue_label
issue_pin
issue_user
issue_watch
label
language_stat
lfs_lock
lfs_meta_object
login_source
milestone
mirror
notice
notification
oauth2_application
oauth2_authorization_code
oauth2_grant
org_user
package
package_blob
package_blob_upload
package_cleanup_rule
package_file
package_property
package_version
project
project_board
project_issue
protected_branch
protected_tag
public_key
pull_auto_merge
pull_request
push_mirror
reaction
release
renamed_branch
repo_archiver
repo_hidden_file
repo_indexer_status
repo_license
repo_redirect
repo_topic
repo_transfer
repo_unit
repository
review
review_state
secret
session
sqlite_sequence
star
stopwatch
system_setting
task
team
team_invite
team_repo
team_unit
team_user
topic
tracked_time
two_factor
upload
user
user_badge
user_blocking
user_open_id
user_redirect
user_setting
version
watch
webauthn_credential
webhook
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 38547 in action
id
Primary key.
INTEGER NOT NULL
user_id
INTEGER
op_type
INTEGER
act_user_id
INTEGER
repo_id
INTEGER
comment_id
INTEGER
is_deleted
INTEGER NOT NULL (default 0
ref_name
refs/heads/main
TEXT
is_private
INTEGER NOT NULL (default 0
content
{"Commits":[{"Sha1":"90fdca65cfd995e173023f259957080c0318a3d3","Message":"docs: 补记 P12 入口名额服务端台账诊断并更新候选合同合入状态\n\n两份 P12 任务文档顶部状态仍写“候选合同未合入”,且没有服务端名额台账诊断的记录。本次更新顶部状态,追加软件优化文档第六十九步与归因设计文档第67节。\n\n实现内容:\n- 顶部状态改为台账诊断已完成,并写明恢复合同已以 f8a1e54、b892d79 合入主区,不改变诊断边界\n- 第六十九步 / 第67节记录诊断设计、验证过程、对账、三个问题的服务端直接答案(229 次拒绝快照恰 8 持有者;186 次 CLIENT_AUTH×4 + LIFECYCLE_WAIT×4;名额首次空出中位 80.3ms;重试到达 25.8–40.9ms,55 次恢复与“首次空出早于到达”逐条等价)、与第六十八步 E2d 复算的对照(可回收约 21–24/30)、边界与下一步\n\n验证:\n- 内容来自 release/p12-permit-ledger-congestion-local-20261015-8fe8eb8b 公开包 README 与报告;纯文档改动,未运行代码检查\n","AuthorEmail":"gamebyteyu@gmail.com","AuthorName":"starry","CommitterEmail":"gamebyteyu@gmail.com","CommitterName":"starry","Timestamp":"2026-10-15T22:29:30-07:00"},{"Sha1":"dd8a73c4b76dc7dd380609cc7d1caff21a01cee1","Message":"test(capacity): 采集入口名额台账并支持按需开启服务端诊断\n\n容量脚本此前不开启产品的 iam.auth.diagnostics.enabled,观察器也没有读取新增的入口名额台账,无法把服务端拒绝瞬间的持有者阶段与驱动样本按 X-Request-Id 关联。本次让本地诊断轮可按需开启该开关并以固定周期拉取台账,正式容量命令路径不变。\n\n实现内容:\n- round.py 新增 --server-diagnostics,environment.py 据此在两实例启动参数末尾追加 --iam.auth.diagnostics.enabled=true,默认不加并记入 environment.json 与 round.json\n- CapacityMeters 新增 PermitLedgerCollector(按游标拉取直到追平,每次最多 16 页,缺口/重启/截断显式记录,每文件 16MiB 上限)与 validatePermitLedgerPage(页、held、rejected、持有者字段白名单,阶段名只接受固定枚举)\n- CapacityObserver 新增独立线程每 2 秒拉取两实例台账写 permit-ledger-iam0/1.jsonl,状态写 permit-ledger-collector.jsonl,停止标记后再拉取一次保留收尾记录\n- 新增 AuthIngressPermitLedgerIT:真实双实例 PG 屏障下第九个到达的 503 与合同头不变、busy 恰加 1、台账快照恰为 8 个真实持有者(含 LIFECYCLE_WAIT)、释放全部晚于拒绝、每实例只暴露一个只读 read 的台账 MBean,页面同时通过工具侧白名单校验\n- 新增 test_server_diagnostics.py 4 项;README 补“入口名额台账”一节\n\n验证:\n- ./mvnw -o -pl iam-server -am verify -Dit.test=AuthIngressPermitLedgerIT,AuthIngressLifecycleIT,RefreshRecoveryContractIT,SdkRefreshRecoveryIT:21 项通过(AuthIngressPermitLedgerIT 2 项)\n- python3 -m unittest discover -s scripts/capacity -p 'test_*.py':70 项通过\n- 本地受控拥塞一轮(刷新 83/s、池 20000、屏障 200/300/400ms × 20 窗口):229 次首次 503 全部关联到台账,dropped/slot_misses/overwritten 均 0,公开包 release/p12-permit-ledger-congestion-local-20261015-8fe8eb8b\n","AuthorEmail":"gamebyteyu@gmail.com","AuthorName":"starry","CommitterEmail":"gamebyteyu@gmail.com","CommitterName":"starry","Timestamp":"2026-10-15T22:29:30-07:00"},{"Sha1":"5435f06bd1327ad91bcf3d7f58438a53502b9dd1","Message":"feat(security): 新增默认关闭的认证入口名额台账诊断\n\n入口 8 个名额被占满时只有 503 计数与客户端时间线可查,无法知道拒绝瞬间 8 个持有者各在服务端哪个阶段、名额多久空出、带未执行标记的重试到达时名额是否仍满。本次在既有 iam.auth.diagnostics.enabled 开关下补采有界的服务端台账,默认关闭,不改变名额数、tryAcquire/release 顺序、指标与响应。\n\n实现内容:\n- 新增 AuthIngressPermitLedger:8 个持有者槽位(与 Semaphore(8) 对应)、4096 条无锁环形缓冲、read(after) 每页最多 512 条、单条上限 1800 字符;只记录既有 TraceIds 规范化的随机关联号、端点、阶段枚举名、纳秒计数与状态码,时钟故障或超长整条丢弃并计数\n- 每个 token/internal 请求取得名额后登记(取得时刻、取得前可用名额、槽位),释放后写 held;每次 AUTH_BUSY 紧跟 tryAcquire 失败写 rejected,快照至多 8 个持有者的关联号、端点、当前阶段与已持有时长\n- AttackProtectionConfiguration.attackIngress 新增带台账参数的 @Bean 重载,原 3 参方法保留为关闭台账的非 @Bean 重载;释放时先腾槽位、再释放名额、记录指标,最后登记释放时刻\n- AuthRequestDiagnostics 新增同包 current(),供台账读取当前上下文的关联号与阶段,不创建上下文\n- 新增 AuthIngressPermitLedgerConfiguration:台账 bean 随开关创建;开启时注册只读 MBean com.iam:type=AuthIngressPermitLedger,复用既有隔离 JMX 通道\n- 新增 AuthIngressPermitLedgerTest(受控时钟:拒绝快照、释放复用槽位、环形覆盖与分页、时钟故障丢弃)与 IngressPermitLedgerContractTest(台账开启、关闭、旧重载三种构造的状态码、正文、合同头、ingress 指标与预算调用次数逐项一致)\n\n验证:\n- ./mvnw -o -pl iam-server -am test(AuthIngressPermitLedgerTest、IngressPermitLedgerContractTest、IngressOutcomeContractTest、AttackIngressMetricsTest、AuthRequestDiagnosticsTest、AuthDiagnosticsTestProbeTest 等 15 类):104 项通过\n- ./mvnw -o -pl iam-server,iam-java-sdk spotless:check:通过\n- 仅含前一提交与本提交改动的临时工作树 ./mvnw -o -pl iam-server -am test-compile:通过\n","AuthorEmail":"gamebyteyu@gmail.com","AuthorName":"starry","CommitterEmail":"gamebyteyu@gmail.com","CommitterName":"starry","Timestamp":"2026-10-15T22:29:30-07:00"},{"Sha1":"27e4c1c46a88cef96d65a275f0a70def221813b0","Message":"test(protocol): 适配 ApplicationRegistry.client 新增的 displayName 参数\n\n36fd053 为 ApplicationRegistry.client 增加 displayName 参数并更新了 ProtocolFixture,但同期合入的 RefreshRecoveryContractIT 与 SdkRefreshRecoveryIT 仍按旧签名调用,iam-server 测试源码自 36fd053 起无法编译。\n\n实现内容:\n- 两处 registry.client(...) 调用在 clientId 之后补传 displayName 为 null,与 ProtocolFixture 的写法一致;测试逻辑不变\n\n验证:\n- ./mvnw -o -pl iam-server -am verify -Dit.test=RefreshRecoveryContractIT,SdkRefreshRecoveryIT,AuthIngressLifecycleIT,AuthIngressPermitLedgerIT:21 项通过(修正前 iam-server 测试源码在 testCompile 阶段失败)\n- ./mvnw -o -pl iam-server,iam-java-sdk spotless:check:通过\n","AuthorEmail":"gamebyteyu@gmail.com","AuthorName":"starry","CommitterEmail":"gamebyteyu@gmail.com","CommitterName":"starry","Timestamp":"2026-10-15T22:29:30-07:00"}],"HeadCommit":{"Sha1":"90fdca65cfd995e173023f259957080c0318a3d3","Message":"docs: 补记 P12 入口名额服务端台账诊断并更新候选合同合入状态\n\n两份 P12 任务文档顶部状态仍写“候选合同未合入”,且没有服务端名额台账诊断的记录。本次更新顶部状态,追加软件优化文档第六十九步与归因设计文档第67节。\n\n实现内容:\n- 顶部状态改为台账诊断已完成,并写明恢复合同已以 f8a1e54、b892d79 合入主区,不改变诊断边界\n- 第六十九步 / 第67节记录诊断设计、验证过程、对账、三个问题的服务端直接答案(229 次拒绝快照恰 8 持有者;186 次 CLIENT_AUTH×4 + LIFECYCLE_WAIT×4;名额首次空出中位 80.3ms;重试到达 25.8–40.9ms,55 次恢复与“首次空出早于到达”逐条等价)、与第六十八步 E2d 复算的对照(可回收约 21–24/30)、边界与下一步\n\n验证:\n- 内容来自 release/p12-permit-ledger-congestion-local-20261015-8fe8eb8b 公开包 README 与报告;纯文档改动,未运行代码检查\n","AuthorEmail":"gamebyteyu@gmail.com","AuthorName":"starry","CommitterEmail":"gamebyteyu@gmail.com","CommitterName":"starry","Timestamp":"2026-10-15T22:29:30-07:00"},"CompareURL":"pengzhiyu/IAM/compare/36fd0536408149355981d06096633ca3249a035e...90fdca65cfd995e173023f259957080c0318a3d3","Len":4}
TEXT
created_unix
INTEGER
Update
Cancel