Home / orioledb / orioledb
AI Slop Code RIsk Monitor

orioledb/orioledb

OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)

8.8 Moderate pattern signal View on GitHub

Maintenance and Governance Review

This report summarizes scanner evidence for orioledb/orioledb, a C project with 4,252 GitHub stars. SynthScan examined 221,295 lines of code across 417 source files, recording 1391 pattern matches distributed across 17 syntactic categories. The legacy adjusted pattern signal is 8.8 (Moderate pattern signal); it is not an authorship estimate.

Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.

8.8
Adjusted Signal
8.8
Raw Pattern Score
100%
Time Factor
2026-10-10
Last Push
4.3K
Stars
C
Language
221.3K
Lines of Code
417
Files
1.4K
Pattern Hits
2026-10-12
Scan Date
0.37
HC Hit Rate

Risk Review · v3

Use each vector to guide manual verification of the underlying findings.

Cognitive Ownership Risk 14.2/100 · LOW

Can maintainers explain intent, assumptions, and trade-offs? 885 finding(s).

Hallucinated Dependency & Supply Chain Risk 6.7/100 · LOW

Are imports declared and package/API names verified? 128 finding(s).

Agent Over-Engineering Ratio 27.1/100 · MEDIUM

Are wrappers, guards, and repeated structures necessary? 1012 finding(s).

PR Review Velocity Impact 42.2/100 · MEDIUM

Which changes need focused human review? 1391 finding(s).

What These Metrics Mean

Adjusted Signal
Legacy pattern score normalized per 1,000 scanned lines and multiplied by the repository-level time factor. It is not an estimate of AI authorship.
Raw Pattern Score
Sum of severity- and context-weighted pattern findings before applying the time factor.
Time Factor
A coarse multiplier based on repository last-push metadata. It does not identify when individual code was written.
Pattern Hits
Count of configured pattern findings. Review each location and surrounding code before acting.
HC Hit Rate
High- and critical-severity findings per scanned file. Severity is a configured detector weight, not proof of a vulnerability or authorship.
Lines / Files
Scan coverage denominators used by the legacy normalized score.

Pattern-Signal History

This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.

Severity Breakdown

Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.

CRITICAL 0HIGH 154MEDIUM 132LOW 1105

Directory Score Breakdown

This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.

Pattern Findings

The scanner identified 1391 distinct pattern matches across 17 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.

Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.

Empty Error Handlers106 hits · 470 pts
SeverityFileLineSnippetContext
HIGHorioledb_s3_loader.py241except FileExistsError:CODE
HIGHorioledb_s3_loader.py178except ValueError:CODE
HIGHtest/t/concurrent_index_stopevents_test.py57except Exception:CODE
HIGHtest/t/concurrent_index_test.py67except Exception:CODE
HIGHtest/t/concurrent_index_test.py102except Exception:CODE
HIGHtest/t/concurrent_index_test.py137except Exception:CODE
HIGHtest/t/concurrent_index_test.py197except Exception:CODE
HIGHtest/t/concurrent_index_test.py226except Exception:CODE
HIGHtest/t/concurrent_index_test.py263except Exception:CODE
HIGHtest/t/concurrent_index_test.py294except Exception:CODE
HIGHtest/t/concurrent_index_test.py412except Exception:CODE
HIGHtest/t/concurrent_index_test.py460except Exception:CODE
HIGHtest/t/concurrent_index_test.py530except Exception:CODE
HIGHtest/t/concurrent_index_test.py575except Exception:CODE
HIGHtest/t/concurrent_index_test.py622except Exception:CODE
HIGHtest/t/concurrent_index_test.py677except Exception:CODE
HIGHtest/t/concurrent_index_test.py715except Exception:CODE
HIGHtest/t/concurrent_index_test.py399except Exception:CODE
HIGHtest/t/concurrent_index_test.py405except Exception:CODE
HIGHtest/t/eviction_bgwriter_test.py119except OSError:CODE
HIGHtest/t/incomplete_split_test.py436except Exception:CODE
HIGHtest/t/merge_test.py197except Exception:CODE
HIGHtest/t/merge_test.py700except Exception:CODE
HIGHtest/t/recovery_xid_range_test.py96except Exception:CODE
HIGHtest/t/page_level_guard_test.py158except Exception:CODE
HIGHtest/t/page_level_guard_test.py163except Exception:CODE
HIGHtest/t/parallel_scan_load_error_test.py194except Exception:CODE
HIGHtest/t/parallel_scan_load_error_test.py216except OSError:CODE
HIGHtest/t/move_database_test.py1056except Exception:CODE
HIGHtest/t/reindex_concurrent_test.py50except Exception:CODE
HIGHtest/t/reindex_concurrent_test.py75except Exception:CODE
HIGHtest/t/reindex_concurrent_test.py103except Exception:CODE
HIGHtest/t/reindex_concurrent_test.py174except Exception:CODE
HIGHtest/t/reindex_concurrent_test.py210except Exception:CODE
HIGHtest/t/undo_reserved_race_test.py183except Exception:CODE
HIGHtest/t/undo_reserved_race_test.py188except Exception:CODE
HIGHtest/t/file_operations_test.py105except Exception:CODE
HIGHtest/t/seq_scan_own_write_test.py94except Exception:CODE
HIGHtest/t/page_fit_items_test.py107except Exception:CODE
HIGHtest/t/temp_local_pool_test.py412except Exception:CODE
HIGHtest/t/temp_local_pool_test.py466except Exception:CODE
HIGHtest/t/evict_seq_scan_race_test.py150except Exception: # noqa: BLE001 - teardownCODE
HIGHtest/t/transaction_test.py72except Exception:CODE
HIGHtest/t/transaction_test.py163except Exception:CODE
HIGHtest/t/transaction_test.py236except Exception:CODE
HIGHtest/t/transaction_test.py240except Exception:CODE
HIGHtest/t/transaction_test.py341except Exception:CODE
HIGHtest/t/transaction_test.py345except Exception:CODE
HIGHtest/t/recovery_livelock_test.py306except Exception:CODE
HIGHtest/t/recovery_livelock_test.py337except OSError:CODE
HIGHtest/t/recovery_test.py2459except Exception:CODE
HIGHtest/t/recovery_test.py2440except Exception:CODE
HIGHtest/t/replication_test.py1831except Exception:CODE
HIGHtest/t/replication_test.py2012except Exception:CODE
HIGHtest/t/replication_test.py2170except Exception:CODE
HIGHtest/t/replication_test.py2242except Exception:CODE
HIGHtest/t/replication_test.py2325except Exception:CODE
HIGHtest/t/replication_test.py2440except Exception:CODE
HIGHtest/t/replication_test.py2590except Exception:CODE
HIGHtest/t/replication_test.py2785except Exception:CODE
46 more matches not shown…
Hyper-Verbose Identifiers633 hits · 429 pts
SeverityFileLineSnippetContext
LOWorioledb_s3_loader.py336 def download_files_in_directory(self,STRING
LOWorioledb_s3_loader.py406 def download_unchanged_small_files(self, bucket_name: str,STRING
LOWorioledb_s3_loader.py494 def get_unchanged_file_checksums(self, file_checksums_name: str,STRING
LOWorioledb_s3_loader.py541def get_orioledb_control_data(data_dir: str):STRING
LOWtypedefs_gen.py41def extract_typedefs_dwarfdump():CODE
LOW⚡test/integration/pgbackrest_test.py553 def test_incr_backup_block_diffs_orioledb_file(self):CODE
LOWtest/integration/pgbackrest_test.py170 def _wait_for_history_archive(self, standby, timeout=30):CODE
LOW⚡test/integration/walg_test.py526 def test_delta_backup_ships_whole_orioledb_file(self):CODE
LOWtest/integration/walg_test.py164 def _wait_for_history_archive(self, standby, timeout=30):CODE
LOWtest/integration/walg_test.py219 def _restore_primary_in_place(self, recovery_lines):CODE
LOWtest/t/concurrent_index_stopevents_test.py92 def test_oindex_in_building_state_at_after_ambuild(self):STRING
LOWtest/t/concurrent_index_stopevents_test.py129 def test_writers_released_after_ambuild_gate(self):STRING
LOWtest/t/concurrent_index_stopevents_test.py177 def test_tree_settled_at_before_flip(self):STRING
LOWtest/t/concurrent_index_stopevents_test.py211 def test_unique_built_image_settled_at_before_flip(self):STRING
LOWtest/t/concurrent_index_stopevents_test.py235 def test_concurrent_inserts_around_ambuild_gate(self):STRING
LOWtest/t/base_test.py421 def crash_with_os_buffer_loss(self, mark_name: str = 'crash_point'):CODE
LOWtest/t/base_test.py725def wait_checkpointer_stopevent(node):CODE
LOWtest/t/base_test.py763def release_parked_flush_on_lock(node,CODE
LOWtest/t/parallel_test.py9 def test_parallel_empty_select(self):CODE
LOWtest/t/parallel_test.py33 def test_not_using_gather_during_recovery_for_sql_opclass_function(self):STRING
LOW⚡test/t/concurrent_index_test.py415 def test_cic_concurrent_writes(self):STRING
LOWtest/t/concurrent_index_test.py70 def test_cic_no_leftover_spool_dir(self):STRING
LOWtest/t/concurrent_index_test.py140 def test_cic_unique_native_rejects_concurrent_dup(self):STRING
LOWtest/t/concurrent_index_test.py200 def test_cic_unique_native_rejects_existing_dup(self):STRING
LOWtest/t/concurrent_index_test.py266 def test_cic_bridged_unique_btree(self):STRING
LOWtest/t/concurrent_index_test.py297 def test_cic_bridged_unique_concurrent_insert(self):STRING
LOWtest/t/concurrent_index_test.py463 def test_cic_writer_spans_all_phases(self):STRING
LOWtest/t/concurrent_index_test.py533 def test_cic_crash_orphan_cleanup(self):STRING
LOWtest/t/concurrent_index_test.py578 def test_cic_streaming_replica(self):STRING
LOWtest/t/concurrent_index_test.py625 def test_cic_streaming_replica_participant_fails(self):STRING
LOWtest/t/concurrent_index_test.py680 def test_cic_streaming_replica_failing_expr(self):STRING
LOWtest/t/eviction_bgwriter_test.py16 def test_eviction_multiple_bgwriters(self):CODE
LOWtest/t/eviction_bgwriter_test.py42 def test_eviction_bgwriter_invalidation(self):CODE
LOWtest/t/eviction_bgwriter_test.py70 def test_bgwriter_keeps_number_across_crash(self):CODE
LOWtest/t/checkpoint_update_base_test.py13 def concurrent_update_eviction_base(self,CODE
LOWtest/t/incomplete_split_test.py44 def test_incomplete_leaf_insert_fix(self):STRING
LOWtest/t/incomplete_split_test.py72 def test_incomplete_leaf_insert_checkpoint_fix_middle(self):STRING
LOWtest/t/incomplete_split_test.py106 def test_incomplete_leaf_insert_checkpoint_fix_end(self):STRING
LOWtest/t/incomplete_split_test.py140 def test_incomplete_leaf_checkpoint_fix(self):STRING
LOWtest/t/incomplete_split_test.py180 def test_incomplete_node_insert_fix(self):STRING
LOWtest/t/incomplete_split_test.py206 def test_incomplete_node_checkpoint_fix(self):STRING
LOWtest/t/incomplete_split_test.py253 def test_incomplete_split_sequence(self):STRING
LOWtest/t/incomplete_split_test.py400 def test_incomplete_leaf_delete_by_hint_fix(self):STRING
LOWtest/t/incomplete_split_test.py501 def test_tbl_check_sees_pending_tmpbuf_freelist(self):STRING
LOWtest/t/proc_cache_guard_test.py89 def test_legit_non_builtin_c_comparator_index_builds(self):CODE
LOW⚡test/t/proc_cache_guard_test.py146 def test_forged_prosrc_rejected(self):CODE
LOW⚡test/t/proc_cache_guard_test.py150 def test_forged_probin_rejected(self):CODE
LOW⚡test/t/proc_cache_guard_test.py155 def test_forged_prolang_rejected(self):CODE
LOWtest/t/indices_build_test.py16 def test_index_build_checkpoint(self):CODE
LOWtest/t/indices_build_test.py59 def test_index_build_recovery(self):STRING
LOWtest/t/indices_build_test.py109 def test_rebuild_ctid_offset_wraparound(self):CODE
LOWtest/t/indices_build_test.py137 def test_drop_primary_recovery(self):STRING
LOWtest/t/indices_build_test.py191 def test_create_primary_recovery(self):STRING
LOWtest/t/indices_build_test.py319 def test_index_build_replication(self):STRING
LOWtest/t/indices_build_test.py446 def test_multiple_indices_build_replication(self):STRING
LOWtest/t/indices_build_test.py614 def test_indices_build_concurrent_checkpoint(self):STRING
LOW⚡test/t/merge_test.py814 def test_concurrent_checkpoint_begin(self):CODE
LOW⚡test/t/merge_test.py817 def test_concurrent_checkpoint_middle(self):CODE
LOW⚡test/t/merge_test.py820 def test_concurrent_checkpoint_end(self):CODE
LOW⚡test/t/merge_test.py823 def concurrent_checkpoint_base(self, delete_offset, bp_value,CODE
573 more matches not shown…
Decorative Section Separators102 hits · 318 pts
SeverityFileLineSnippetContext
MEDIUM⚡test/integration/pgbackrest_test.py201 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py203 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py209 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py211 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py219 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py221 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py228 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py230 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py265 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py267 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py274 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py276 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py293 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py295 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py302 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py304 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py421 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py423 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py429 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py431 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py441 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py444 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py463 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py465 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py474 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py476 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py546 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/pgbackrest_test.py548 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py27 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py29 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py69 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py71 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py350 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py352 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py384 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py386 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py490 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/pgbackrest_test.py492 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py310 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py312 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py322 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py324 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py434 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py436 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py442 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py444 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py520 # ------------------------------------------------------------------COMMENT
MEDIUM⚡test/integration/walg_test.py522 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py23 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py25 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py54 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py56 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py242 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py244 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py259 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py261 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py278 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py280 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py357 # ------------------------------------------------------------------COMMENT
MEDIUMtest/integration/walg_test.py359 # ------------------------------------------------------------------COMMENT
42 more matches not shown…
Cross-Language Confusion36 hits · 222 pts
SeverityFileLineSnippetContext
HIGHtest/t/logical_test.py92 'regression_slot', null, null,CODE
HIGHtest/t/transaction_test.py89 and tripsthe Assert(lo >= 0 && lo <= commandIndex) inCODE
HIGHtest/t/s3_inherits_test.py74 alter table o_test_3 alter a set not null;CODE
HIGH⚡test/t/s3_inherits_test.py105 alter table o_test_2 add column a2 int constraint nn not null;CODE
HIGH⚡test/t/s3_inherits_test.py106 alter table o_test_3 alter column a set not null;CODE
HIGH⚡test/t/s3_inherits_test.py107 alter table o_test_1 alter column a drop not null;CODE
HIGH⚡test/t/s3_inherits_test.py108 alter table o_test_1 alter column a set not null;CODE
HIGH⚡test/t/s3_inherits_test.py109 alter table o_test_3 alter column a2 set not null;CODE
HIGH⚡test/t/s3_inherits_test.py110 alter table o_test_2 alter column a2 drop not null;CODE
HIGHtest/t/s3_inherits_test.py140 create table o_test_2 (check (a = 1 or a = null)) inherits(o_test_1)USING orioledb;CODE
HIGHtest/t/s3_inherits_test.py143 insert into o_test_2 values(null);CODE
HIGH⚡test/t/s3_inherits_test.py347 alter table o_test_1 add constraint c1 check (a is not null);CODE
HIGH⚡test/t/s3_inherits_test.py352 alter table o_test_1 add check (a is not null);CODE
HIGH⚡test/t/s3_inherits_test.py354 alter table o_test_1 add constraint c1 check (a is not null);CODE
HIGHtest/t/replication_test.py1013 COLLATE "POSIX" USING f1::text || f2;CODE
HIGHtest/t/replication_test.py1036 COLLATE "POSIX" USING f1::text || f2;CODE
HIGHtest/t/s3_unlogged_test.py120 CREATE INDEX ind_1 ON o_test_1 ((a || b));CODE
HIGHtest/t/s3_unlogged_test.py130 CREATE INDEX ind_2 on o_test_3 ((a || b));CODE
HIGHtest/t/pg_dump_restore_test.py40 SELECT i, '*' || i || repeat('*', mod(i, 5)) FROM generate_series(1, 10) AS i;CODE
HIGHtest/t/pg_dump_restore_test.py55 key | integer | (null) | false | falseCODE
HIGHtest/t/pg_dump_restore_test.py57 hash | integer | (null) | true | falseCODE
HIGHtest/t/pg_dump_restore_test.py98 SELECT i, '*' || i || repeat('*', mod(i, 5)) FROM generate_series(1, 10) AS i;CODE
HIGHtest/t/pg_dump_restore_test.py113 key | integer | (null) | false | falseCODE
HIGHtest/t/pg_dump_restore_test.py115 hash | integer | (null) | true | falseCODE
HIGHtest/t/pg_dump_restore_test.py143 SELECT i, '*' || i || repeat('*', mod(i, 5)) FROM generate_series(1, 10) AS i;CODE
HIGHtest/t/pg_dump_restore_test.py158 key | integer | (null) | false | falseCODE
HIGHtest/t/pg_dump_restore_test.py160 hash | integer | (null) | true | falseCODE
HIGH⚡ci/pgbench.py205 " value1 float8 not null,\n" +CODE
HIGH⚡ci/pgbench.py206 " value2 float8 not null,\n" +CODE
HIGH⚡ci/pgbench.py207 " value3 float8 not null,\n" +CODE
HIGH⚡ci/pgbench.py208 " value4 float8 not null,\n" +CODE
HIGH⚡ci/pgbench.py220 " value1 float8 not null,\n" +CODE
HIGH⚡ci/pgbench.py221 " value2 float8 not null,\n" +CODE
HIGH⚡ci/pgbench.py222 " value3 float8 not null,\n" +CODE
HIGH⚡ci/pgbench.py223 " value4 float8 not null,\n" +CODE
HIGHci/pgbench.py358 '{{"reason": 0, "eventID": null}}', NULL, :emitter, :root_player_id, 'game');CODE
Over-Commented Block160 hits · 150 pts
SeverityFileLineSnippetContext
LOWtest/antithesis/config/workload/jepsen-RR/compose.yaml1# emptyCOMMENT
LOWtest/antithesis/config/workload/jepsen-RC/compose.yaml1# emptyCOMMENT
LOWtest/integration/walg_test.py521 # CleanupCOMMENT
LOWtest/t/incomplete_split_test.py541 # BROKEN_SPLIT. The freed locations of the rewritten leaves goCOMMENT
LOWtest/t/merge_test.py121 # minutes with four processes parked here (the checkpointer, theCOMMENT
LOWtest/t/rewind_time_test.py181## Tests disabled for not to strain CI as they are much similar to neighbouringCOMMENT
LOWtest/t/rewind_time_test.py201# node.safe_psql(COMMENT
LOWtest/t/rewind_time_test.py221# "INSERT INTO o_test_heap VALUES (%d, %d || 'val'); SAVEPOINT sp3;\n"COMMENT
LOWtest/t/rewind_time_test.py241# node.append_conf(COMMENT
LOWtest/t/rewind_time_test.py261# ") USING heap;\n")COMMENT
LOWtest/t/rewind_time_test.py281# 'postgres', "INSERT INTO o_test_heap\n"COMMENT
LOWtest/t/parallel_ordered_scan_test.py1#!/usr/bin/env python3COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1081# node = self.nodeCOMMENT
LOWtest/t/rewind_xid_evict_large_test.py1101# " val text,\n"COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1121# for i in range(2500, 2506):COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1141# (i, i))COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1161# len = int(a)COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1181# node.execute(COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1201# node.start()COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1221# 'postgres', "INSERT INTO o_test_heap\n"COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1241# 'postgres', "INSERT INTO o_test\n"COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1261# node.safe_psql('postgres',COMMENT
LOWtest/t/rewind_xid_evict_large_test.py1281# xidc = int(a)COMMENT
LOWtest/t/replication_test.py1181COMMENT
LOWtest/t/replication_test.py2101 # Master CHECKPOINT. finish_write_xids() scansCOMMENT
LOWtest/t/replication_test.py2521 t_stop.execute("DELETE FROM o_compact WHERE k = 1;")COMMENT
LOWtest/t/replication_test.py2921COMMENT
LOWtest/t/replication_test.py3121 self.replica.free_port()COMMENT
LOWtest/t/parallel_bitmap_scan_test.py1#!/usr/bin/env python3COMMENT
LOWtest/t/parallel_bitmap_scan_test.py201 "generate_series(1000000, 1040000) i;")COMMENT
LOWtest/t/functions_test.py101 node.stop()COMMENT
LOWtest/t/evict_stale_descr_test.py221 self.reasons rather than failing, since none of them says anythingCOMMENT
LOWtest/t/amcheck_test.py321 f.write(struct.pack('<Q', 0xDEADBEEF))COMMENT
LOWci/check_output.sh121 # kernel can drop a core into the same directory for any processCOMMENT
LOWci/sqlsmith.sh1#!/bin/bashCOMMENT
LOWci/sqlsmith.sh201 echo "!!!!! postmaster restarted $((ready_count - 1)) time(s)"COMMENT
LOWci/filter_regression_diff.py1#!/usr/bin/env python3COMMENT
LOWci/filter_regression_diff.py81 ["create_index"],COMMENT
LOWci/filter_regression_diff.py121 r"ERROR: cannot refresh collation \"en-x-icu\" because orioledb (table|index) \"[a-z0-9_]+\" uses it": ["collate.icu.uCOMMENT
LOWci/filter_regression_diff.py161 # starts first the other can hit CREATE USER ("already exists"),COMMENT
LOWci/filter_regression_diff.py1201 # print("FINISH TABLE?")COMMENT
LOWci/post_build_prerequisites.sh21if [ $GITHUB_JOB != "run-benchmark" ] && [ $GITHUB_JOB != "pgindent" ] && [ $GITHUB_JOB != "pg_upgrade" ]; thenCOMMENT
LOWci/check.sh121COMMENT
LOWci/pg_upgrade.sh1#!/bin/bashCOMMENT
LOWci/pg_upgrade.sh201 -j "$(nproc)" || \COMMENT
LOWci/pg_upgrade.sh261# 2c. Strip references to test-only loadable libraries from theCOMMENT
LOWci/pg_upgrade.sh321#COMMENT
LOWci/pg_upgrade.sh341 fiCOMMENT
LOWci/pg_upgrade.sh381# orioledb_data/ tree (plus undo logs in orioledb_undo/), whichCOMMENT
LOWci/pg_upgrade.sh521# 2. INSERT into the expression-index table, then crash (-m immediate)COMMENT
LOWci/pg_upgrade.sh561 # Probe the SQL-function index rebuilt by recovery via the proc cache.COMMENT
LOWinclude/orioledb.h21#include "common/int.h"COMMENT
LOWinclude/orioledb.h341 * compare it explicitly.COMMENT
LOWinclude/orioledb.h361#define MyBackendId MyProcNumberCOMMENT
LOWinclude/orioledb.h441StaticAssertDecl(sizeof(OrioleDBPageHeader) == sizeof(OrioleDBOndiskPageHeader),COMMENT
LOWinclude/tuple/format.h81#if PG_VERSION_NUM < 180000COMMENT
LOWinclude/catalog/o_sys_cache.h21 * IDENTIFICATIONCOMMENT
LOWinclude/catalog/sys_trees.h21COMMENT
LOWinclude/utils/antithesis.h41#pragma GCC diagnostic ignored "-Wdeclaration-after-statement"COMMENT
LOWinclude/utils/page_pool.h21 * ucm may not work correctly with lesser page pool sizeCOMMENT
100 more matches not shown…
Excessive Try-Catch Wrapping158 hits · 123 pts
SeverityFileLineSnippetContext
MEDIUMorioledb_s3_loader.py299 print(f"An error occurred: {e}")STRING
MEDIUMorioledb_s3_loader.py363 print("An error occurred. Stopping all downloads.")STRING
MEDIUMtest/integration/pgbackrest_test.py505def _run_backup():CODE
LOWtest/integration/pgbackrest_test.py508 except Exception as e:CODE
MEDIUMtest/integration/walg_test.py484def _run_backup():CODE
LOWtest/integration/walg_test.py487 except Exception as e:CODE
LOWtest/t/concurrent_index_stopevents_test.py57 except Exception:STRING
MEDIUMtest/t/concurrent_index_stopevents_test.py54def tearDown(self):CODE
LOWtest/t/base_test.py411 except Exception:CODE
LOWtest/t/base_test.py692 except Exception as e:CODE
LOWtest/t/base_test.py797 except Exception as e:CODE
MEDIUMtest/t/base_test.py675def run(self):CODE
LOW⚡test/t/concurrent_index_test.py399 except Exception:STRING
LOW⚡test/t/concurrent_index_test.py405 except Exception:STRING
LOW⚡test/t/concurrent_index_test.py412 except Exception:STRING
LOWtest/t/concurrent_index_test.py67 except Exception:STRING
LOWtest/t/concurrent_index_test.py102 except Exception:STRING
LOWtest/t/concurrent_index_test.py137 except Exception:STRING
LOWtest/t/concurrent_index_test.py197 except Exception:STRING
LOWtest/t/concurrent_index_test.py226 except Exception:STRING
LOWtest/t/concurrent_index_test.py263 except Exception:STRING
LOWtest/t/concurrent_index_test.py294 except Exception:STRING
LOWtest/t/concurrent_index_test.py460 except Exception:STRING
LOWtest/t/concurrent_index_test.py530 except Exception:STRING
LOWtest/t/concurrent_index_test.py575 except Exception:STRING
LOWtest/t/concurrent_index_test.py622 except Exception:STRING
LOWtest/t/concurrent_index_test.py677 except Exception:STRING
LOWtest/t/concurrent_index_test.py715 except Exception:STRING
LOWtest/t/eviction_bgwriter_test.py84 except Exception:CODE
MEDIUMtest/t/eviction_bgwriter_test.py79def get_bgwriters():CODE
LOWtest/t/incomplete_split_test.py436 except Exception:STRING
LOWtest/t/incomplete_split_test.py498 except Exception:STRING
MEDIUMtest/t/incomplete_split_test.py492def failedInsertToSplitTable(self, con, insert_from, insert_to, step):CODE
LOWtest/t/proc_cache_guard_test.py132 except Exception as e:CODE
LOWtest/t/merge_test.py142 except Exception:CODE
LOWtest/t/merge_test.py197 except Exception:CODE
LOWtest/t/merge_test.py520 except Exception as e:CODE
LOWtest/t/merge_test.py700 except Exception:CODE
LOWtest/t/merge_test.py799 except Exception as e:CODE
LOWtest/t/recovery_xid_range_test.py96 except Exception:CODE
LOWtest/t/recovery_xid_range_test.py114 except Exception:CODE
LOW⚡test/t/page_level_guard_test.py152 except Exception:STRING
LOW⚡test/t/page_level_guard_test.py158 except Exception:STRING
LOW⚡test/t/page_level_guard_test.py163 except Exception:STRING
LOWtest/t/parallel_scan_load_error_test.py125 except Exception as e:CODE
LOWtest/t/parallel_scan_load_error_test.py194 except Exception:CODE
LOWtest/t/parallel_scan_load_error_test.py208 except Exception:CODE
LOWtest/t/move_database_test.py31 except Exception as e:CODE
LOWtest/t/move_database_test.py1056 except Exception:STRING
LOWtest/t/reindex_concurrent_test.py50 except Exception:STRING
LOWtest/t/reindex_concurrent_test.py75 except Exception:STRING
LOWtest/t/reindex_concurrent_test.py103 except Exception:STRING
LOWtest/t/reindex_concurrent_test.py174 except Exception:STRING
LOWtest/t/reindex_concurrent_test.py210 except Exception:STRING
LOWtest/t/undo_reserved_race_test.py122 except Exception as e:STRING
LOWtest/t/undo_reserved_race_test.py183 except Exception:STRING
LOWtest/t/undo_reserved_race_test.py188 except Exception:STRING
MEDIUMtest/t/undo_reserved_race_test.py117def parker():CODE
LOWtest/t/file_operations_test.py36 except Exception as e:CODE
LOWtest/t/file_operations_test.py51 except Exception:CODE
98 more matches not shown…
Unused Imports92 hits · 84 pts
SeverityFileLineSnippetContext
LOWtest/t/concurrent_index_test.py7CODE
LOWtest/t/incomplete_split_test.py4CODE
LOWtest/t/incomplete_split_test.py5CODE
LOWtest/t/incomplete_split_test.py13CODE
LOWtest/t/incomplete_split_test.py14CODE
LOWtest/t/proc_cache_guard_test.py8CODE
LOWtest/t/merge_test.py5CODE
LOWtest/t/merge_test.py6CODE
LOWtest/t/merge_test.py7CODE
LOWtest/t/merge_test.py12CODE
LOWtest/t/merge_test.py13CODE
LOWtest/t/recovery_xid_range_test.py12CODE
LOWtest/t/rewind_time_test.py4CODE
LOWtest/t/rewind_time_test.py5CODE
LOWtest/t/rewind_time_test.py7CODE
LOWtest/t/rewind_time_test.py8CODE
LOWtest/t/rewind_time_test.py11CODE
LOWtest/t/rewind_time_test.py12CODE
LOWtest/t/rewind_time_test.py14CODE
LOWtest/t/rewind_time_test.py15CODE
LOWtest/t/move_database_test.py9CODE
LOWtest/t/move_database_test.py10CODE
LOWtest/t/recovery_opclass_test.py4CODE
LOWtest/t/schema_test.py1CODE
LOWtest/t/undo_reserved_race_test.py5CODE
LOWtest/t/checkpoint_eviction_test.py10CODE
LOWtest/t/checkpoint_eviction_test.py11CODE
LOWtest/t/page_fit_items_test.py4CODE
LOWtest/t/page_fit_items_test.py5CODE
LOWtest/t/page_fit_items_test.py18CODE
LOWtest/t/temp_local_pool_test.py4CODE
LOWtest/t/wal_savepoint_buffer_test.py4CODE
LOWtest/t/eviction_test.py5CODE
LOWtest/t/o_tables_test.py4CODE
LOWtest/t/o_tables_test.py5CODE
LOWtest/t/o_tables_test.py8CODE
LOWtest/t/o_tables_test.py10CODE
LOWtest/t/rewind_xid_evict_large_test.py4CODE
LOWtest/t/rewind_xid_evict_large_test.py5CODE
LOWtest/t/rewind_xid_evict_large_test.py7CODE
LOWtest/t/rewind_xid_evict_large_test.py8CODE
LOWtest/t/rewind_xid_evict_large_test.py12CODE
LOWtest/t/rewind_xid_evict_large_test.py13CODE
LOWtest/t/rewind_xid_evict_large_test.py14CODE
LOWtest/t/rewind_xid_evict_large_test.py16CODE
LOWtest/t/rewind_xid_evict_large_test.py17CODE
LOWtest/t/logical_test.py11CODE
LOWtest/t/types_test.py4CODE
LOWtest/t/transaction_test.py5CODE
LOWtest/t/checkpointer_test.py4CODE
LOWtest/t/checkpointer_test.py5CODE
LOWtest/t/checkpointer_test.py6CODE
LOWtest/t/checkpointer_test.py13CODE
LOWtest/t/checkpointer_test.py15CODE
LOWtest/t/checkpointer_test.py16CODE
LOWtest/t/checkpoint_concurrent_test.py10CODE
LOWtest/t/recovery_test.py7CODE
LOWtest/t/recovery_test.py9CODE
LOWtest/t/recovery_test.py20CODE
LOWtest/t/logical_xid_subxacts_test.py4CODE
32 more matches not shown…
Cross-File Repetition12 hits · 60 pts
SeverityFileLineSnippetContext
HIGHtest/t/checkpoint_eviction_test.py0create extension if not exists orioledb; create table if not exists o_test ( key serial not null, val int not null, primSTRING
HIGHtest/t/eviction_test.py0create extension if not exists orioledb; create table if not exists o_test ( key serial not null, val int not null, primSTRING
HIGHtest/t/files_test.py0create extension if not exists orioledb; create table if not exists o_test ( key serial not null, val int not null, primSTRING
HIGHtest/t/restartpoint_xids_test.py0create extension if not exists orioledb; create table if not exists o_test ( id integer not null, val text ) using oriolSTRING
HIGHtest/t/replication_test.py0create extension if not exists orioledb; create table if not exists o_test ( id integer not null, val text ) using oriolSTRING
HIGHtest/t/files_test.py0create extension if not exists orioledb; create table if not exists o_test ( id integer not null, val text ) using oriolSTRING
HIGHtest/t/s3_inherits_test.py0orioledb.s3_mode = true orioledb.s3_host = '{self.host}:{self.port}/{self.bucket_name}' orioledb.s3_region = '{self.regiSTRING
HIGHtest/t/s3_unlogged_test.py0orioledb.s3_mode = true orioledb.s3_host = '{self.host}:{self.port}/{self.bucket_name}' orioledb.s3_region = '{self.regiSTRING
HIGHtest/t/s3_test.py0orioledb.s3_mode = true orioledb.s3_host = '{self.host}:{self.port}/{self.bucket_name}' orioledb.s3_region = '{self.regiSTRING
HIGHtest/t/recovery_test.py0select oid from pg_database where datname = current_database()STRING
HIGHtest/t/relnode_collision_test.py0select oid from pg_database where datname = current_database()STRING
HIGHtest/t/files_test.py0select oid from pg_database where datname = current_database()STRING
Deep Nesting61 hits · 55 pts
SeverityFileLineSnippetContext
LOWorioledb_s3_loader.py163CODE
LOWorioledb_s3_loader.py257CODE
LOWorioledb_s3_loader.py406CODE
LOWtypedefs_gen.py41CODE
LOWtest/t/concurrent_index_stopevents_test.py235CODE
LOWtest/t/concurrent_index_test.py297CODE
LOWtest/t/indices_build_test.py446CODE
LOWtest/t/indices_build_test.py685CODE
LOWtest/t/page_level_guard_test.py174CODE
LOWtest/t/move_database_test.py977CODE
LOWtest/t/parallel_ordered_scan_test.py203CODE
LOWtest/t/page_fit_items_test.py119CODE
LOWtest/t/page_fit_items_test.py952CODE
LOWtest/t/evict_seq_scan_race_test.py88CODE
LOWtest/t/s3_base_test.py96CODE
LOWtest/t/logical_test.py816CODE
LOWtest/t/logical_test.py903CODE
LOWtest/t/logical_test.py1947CODE
LOWtest/t/logical_test.py2053CODE
LOWtest/t/logical_test.py2260CODE
LOWtest/t/logical_test.py2344CODE
LOWtest/t/logical_test.py2618CODE
LOWtest/t/logical_test.py2762CODE
LOWtest/t/checkpointer_test.py102CODE
LOWtest/t/checkpoint_concurrent_test.py719CODE
LOWtest/t/recovery_test.py2366CODE
LOWtest/t/recovery_test.py2409CODE
LOWtest/t/replication_test.py444CODE
LOWtest/t/replication_test.py530CODE
LOWtest/t/replication_test.py903CODE
LOWtest/t/replication_test.py946CODE
LOWtest/t/replication_test.py1647CODE
LOWtest/t/replication_test.py1843CODE
LOWtest/t/replication_test.py2593CODE
LOWtest/t/replication_test.py2793CODE
LOWtest/t/replication_test.py3110CODE
LOWtest/t/replication_test.py3580CODE
LOWtest/t/parallel_bitmap_scan_test.py354CODE
LOWtest/t/files_test.py163CODE
LOWtest/t/files_test.py760CODE
LOWtest/t/checkpoint_split_base_test.py11CODE
LOWtest/t/logical_streaming_test.py66CODE
LOWtest/t/logical_streaming_test.py109CODE
LOWtest/t/multi_insert_test.py198CODE
LOWtest/t/s3_test.py97CODE
LOWtest/t/evict_stale_descr_test.py213CODE
LOWtest/t/evict_stale_descr_test.py417CODE
LOWtest/t/amcheck_test.py231CODE
LOWtest/t/unlogged_test.py64CODE
LOWci/filter_isolation_diff.py69CODE
LOWci/filter_regression_diff.py221CODE
LOWci/filter_regression_diff.py235CODE
LOWci/filter_regression_diff.py428CODE
LOWci/filter_regression_diff.py460CODE
LOWci/filter_regression_diff.py932CODE
LOWci/filter_regression_diff.py949CODE
LOWci/dump_stuck_pages.py128CODE
LOWci/pgbench.py466CODE
LOWci/pgbench.py562CODE
LOWci/pgbench.py803CODE
1 more matches not shown…
AI Slop Vocabulary4 hits · 11 pts
SeverityFileLineSnippetContext
MEDIUMtest/t/base_test.py447 # Flush just the test-harness-written config files to the blockCOMMENT
MEDIUMtest/t/fuzzy_checkpoint_test.py412 # the DDL we are holding parked -- a test-harness artifact, notCOMMENT
MEDIUM⚡test/t/replication_test.py3118 # The harness hands out two ports per test and the nextCOMMENT
MEDIUMci/check_output.sh22# fresh residuals to print even if the test harness only kept theCOMMENT
Modern AI Meta-Vocabulary3 hits · 10 pts
SeverityFileLineSnippetContext
MEDIUMci/check.sh20# Repeat the tests, not the scaffolding around them. A dispatch asks forCOMMENT
MEDIUM⚡ci/pg_upgrade.sh269# --check aborts. They are pure PG-core test scaffolding, unrelatedCOMMENT
MEDIUM.github/workflows/check.yml254 # type is the test and which is scaffolding. Re-running it wholeCOMMENT
Redundant / Tautological Comments7 hits · 10 pts
SeverityFileLineSnippetContext
LOWcheck_patchset_version.py31 # Check if provided version is numeric (not a hash)COMMENT
LOWcheck_patchset_version.py34 # Check if provided version is part of `git describe --tags`COMMENT
LOWtest/t/eviction_test.py790 # Check if "not loaded" appears anywhere in the outputSTRING
LOWci/docker_matrix.sh234 # Check if the script is run from the correct directoryCOMMENT
LOWci/docker_matrix.sh237 # Check if Docker is installedCOMMENT
LOWci/filter_regression_diff.py388# Check if two condition strings are equal up to commutativity of operandsCOMMENT
LOWci/local_docker_matrix.sh41# Check if the directory exists and contains a git repositoryCOMMENT
Self-Referential Comments2 hits · 6 pts
SeverityFileLineSnippetContext
MEDIUMdocker/init/docker-entrypoint.sh47 # Create the transaction log directory before initdb is run so the directory is owned by the correct userCOMMENT
MEDIUMtest/t/base_test.py115 # Create the log-writes DM target.COMMENT
TODO Padding2 hits · 3 pts
SeverityFileLineSnippetContext
LOWtest/t/rewrite_test.py5 # TODO: Add test with ALTER/ADD COLUMN that rewrites during recovery or replicationCOMMENT
LOWtest/t/rewrite_test.py6 # TODO: Add test with ALTER/ADD COLUMN that rewrites toast treeCOMMENT
Verbosity Indicators6 hits · 2 pts
SeverityFileLineSnippetContext
LOW⚡test/t/replication_test.py1466 # Step 2: insert batch 2 after checkpointSTRING
LOW⚡test/t/replication_test.py1473 # Step 3: rebuild primary keySTRING
LOW⚡test/t/replication_test.py1510 # Step 5: crash replica without checkpointSTRING
LOW⚡test/t/replication_test.py1515 # Step 6: verify all data after recoverySTRING
LOWtest/t/replication_test.py1439 # Step 1: checkpoint on both sidesSTRING
LOWtest/t/replication_test.py1484 # Step 4: replica catches up, then crashSTRING
Structural Annotation Overuse6 hits · 2 pts
SeverityFileLineSnippetContext
LOW⚡test/t/replication_test.py1466 # Step 2: insert batch 2 after checkpointSTRING
LOW⚡test/t/replication_test.py1473 # Step 3: rebuild primary keySTRING
LOW⚡test/t/replication_test.py1510 # Step 5: crash replica without checkpointSTRING
LOW⚡test/t/replication_test.py1515 # Step 6: verify all data after recoverySTRING
LOWtest/t/replication_test.py1439 # Step 1: checkpoint on both sidesSTRING
LOWtest/t/replication_test.py1484 # Step 4: replica catches up, then crashSTRING
AI Structural Patterns1 hit · 1 pts
SeverityFileLineSnippetContext
LOWorioledb_s3_loader.py334CODE