Skip to content

perf: index the PostgreSQL pushes hot paths and slim list projections #10444

perf: index the PostgreSQL pushes hot paths and slim list projections

perf: index the PostgreSQL pushes hot paths and slim list projections #10444

Triggered via pull request August 27, 2026 08:07
Status Failure
Total duration 7m 56s
Artifacts

ci.yml

on: pull_request
Matrix: build-ubuntu
build result
12s
build result
Fit to window
Zoom out
Zoom in

Annotations

39 errors
build-ubuntu (22.x, 8.0)
Process completed with exit code 1.
test/db/postgres/users.integration.test.ts > PostgreSQL Users Integration Tests > findUser > finds a user by username (case-insensitive): src/db/postgres/users.ts#L55
error: relation "users" does not exist ❯ node_modules/pg-pool/index.js:45:11 ❯ findUser src/db/postgres/users.ts:55:18 ❯ test/db/postgres/users.integration.test.ts:64:22 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '107', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by _id: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:73:23 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > createRepo > persists the row and stamps a generated _id: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:48:23 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > deletePush > deletes a push by id: src/db/postgres/pushes.ts#L213
error: relation "pushes" does not exist ❯ node_modules/pg-pool/index.js:45:11 ❯ writeAudit src/db/postgres/pushes.ts:213:3 ❯ test/db/postgres/pushes.integration.test.ts:173:7 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > getPush > retrieves a push by id: src/db/postgres/pushes.ts#L213
error: relation "pushes" does not exist ❯ node_modules/pg-pool/index.js:45:11 ❯ writeAudit src/db/postgres/pushes.ts:213:3 ❯ test/db/postgres/pushes.integration.test.ts:98:7 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
build-ubuntu (24.x, 7.0)
Process completed with exit code 1.
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > permission JSONB > starts with empty arrays: test/db/postgres/repo.integration.test.ts#L103
AssertionError: expected undefined to deeply equal [] - Expected: [] + Received: undefined ❯ test/db/postgres/repo.integration.test.ts:103:37
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by url exactly: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:67:7 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by name (lower-cased lookup): test/db/postgres/repo.integration.test.ts#L62
AssertionError: expected undefined to be 'findme' // Object.is equality - Expected: "findme" + Received: undefined ❯ test/db/postgres/repo.integration.test.ts:62:27
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > createRepo > persists the row and stamps a generated _id: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:48:23 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
build-ubuntu (24.x, 6.0)
Process completed with exit code 1.
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by url exactly: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:67:7 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > createRepo > persists the row and stamps a generated _id: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:48:23 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > getPushes > does not leak _id: src/db/postgres/pushes.ts#L186
error: relation "pushes" does not exist ❯ node_modules/pg-pool/index.js:45:11 ❯ getPushes src/db/postgres/pushes.ts:186:18 ❯ test/db/postgres/pushes.integration.test.ts:162:22 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '36', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > getPush > retrieves a push by id: test/db/postgres/pushes.integration.test.ts#L101
AssertionError: expected undefined to be 'get-push-test' // Object.is equality - Expected: "get-push-test" + Received: undefined ❯ test/db/postgres/pushes.integration.test.ts:101:26
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > writeAudit > strips _id from action before saving: src/db/postgres/pushes.ts#L194
error: relation "pushes" does not exist ❯ node_modules/pg-pool/index.js:45:11 ❯ getPush src/db/postgres/pushes.ts:194:18 ❯ test/db/postgres/pushes.integration.test.ts:87:25 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '18', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
build-ubuntu (22.x, 6.0)
Process completed with exit code 1.
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by _id: test/db/postgres/repo.integration.test.ts#L77
AssertionError: expected undefined to be 'https://example.com/id-test.git' // Object.is equality - Expected: "https://example.com/id-test.git" + Received: undefined ❯ test/db/postgres/repo.integration.test.ts:77:27
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by url exactly: test/db/postgres/repo.integration.test.ts#L69
AssertionError: expected undefined to be 'https://example.com/url-test.git' // Object.is equality - Expected: "https://example.com/url-test.git" + Received: undefined ❯ test/db/postgres/repo.integration.test.ts:69:26
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by name (lower-cased lookup): test/db/postgres/repo.integration.test.ts#L62
AssertionError: expected undefined to be 'findme' // Object.is equality - Expected: "findme" + Received: undefined ❯ test/db/postgres/repo.integration.test.ts:62:27
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > getPush > returns an Action instance: test/db/postgres/pushes.integration.test.ts#L114
TypeError: Cannot convert undefined or null to object ❯ test/db/postgres/pushes.integration.test.ts:114:21
build-ubuntu (22.x, 7.0)
Process completed with exit code 1.
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > createRepo > persists the row and stamps a generated _id: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:48:23 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > getPush > retrieves a push by id: test/db/postgres/pushes.integration.test.ts#L101
AssertionError: expected undefined to be 'get-push-test' // Object.is equality - Expected: "get-push-test" + Received: undefined ❯ test/db/postgres/pushes.integration.test.ts:101:26
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > writeAudit > strips _id from action before saving: src/db/postgres/pushes.ts#L213
error: relation "pushes" does not exist ❯ node_modules/pg-pool/index.js:45:11 ❯ writeAudit src/db/postgres/pushes.ts:213:3 ❯ test/db/postgres/pushes.integration.test.ts:86:7 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '13', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > writeAudit > writes an action to the database: src/db/postgres/pushes.ts#L194
error: relation "pushes" does not exist ❯ node_modules/pg-pool/index.js:45:11 ❯ getPush src/db/postgres/pushes.ts:194:18 ❯ test/db/postgres/pushes.integration.test.ts:57:25 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '18', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
build-ubuntu (24.x, 8.0)
Process completed with exit code 1.
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > getRepo / getRepoByUrl / getRepoById > finds by name (lower-cased lookup): test/db/postgres/repo.integration.test.ts#L62
AssertionError: expected undefined to be 'findme' // Object.is equality - Expected: "findme" + Received: undefined ❯ test/db/postgres/repo.integration.test.ts:62:27
test/db/postgres/repo.integration.test.ts > PostgreSQL Repo Integration Tests > createRepo > persists the row and stamps a generated _id: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ createRepo src/db/postgres/repo.ts:90:18 ❯ test/db/postgres/repo.integration.test.ts:48:23 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > getPush > retrieves a push by id: test/db/postgres/pushes.integration.test.ts#L101
AssertionError: expected undefined to be 'get-push-test' // Object.is equality - Expected: "get-push-test" + Received: undefined ❯ test/db/postgres/pushes.integration.test.ts:101:26
test/db/postgres/pushes.integration.test.ts > PostgreSQL Pushes Integration Tests > writeAudit > upserts an existing action: src/db/postgres/schemaMigrations.ts#L173
error: relation "schema_migrations" does not exist ❯ node_modules/pg/lib/client.js:694:17 ❯ runMigrations src/db/postgres/schemaMigrations.ts:173:22 ❯ connect src/db/postgres/helper.ts:126:3 ❯ query src/db/postgres/helper.ts:134:16 ❯ writeAudit src/db/postgres/pushes.ts:213:3 ❯ test/db/postgres/pushes.integration.test.ts:64:7 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { length: 116, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '21', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', routine: 'parserOpenTable' }
build-windows
Process completed with exit code 1.
test/ssh/security.test.ts > SSH Security Tests: test/ssh/security.test.ts#L41
Error: spawnSync C:\Windows\system32\cmd.exe ETIMEDOUT ❯ test/ssh/security.test.ts:41:9 ⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯ Serialized Error: { errno: -4039, code: 'ETIMEDOUT', syscall: 'spawnSync C:\Windows\system32\cmd.exe', path: 'C:\Windows\system32\cmd.exe', spawnargs: [ '/d', '/s', '/c', '"ssh-keygen -t rsa -b 2048 -m PEM -f test/keys/test_key -N "" -C "test@git-proxy""' ], error: { stack: 'Error: spawnSync C:\Windows\system32\cmd.exe ETIMEDOUT\n at Object.spawnSync (node:internal/child_process:1160:20)\n at spawnSync (node:child_process:928:24)\n at execSync (node:child_process:1009:15)\n at D:/a/git-proxy/git-proxy/test/ssh/security.test.ts:41:9\n at wrapper (file:///D:/a/git-proxy/git-proxy/node_modules/@vitest/runner/dist/chunk-artifact.js:888:28)\n at file:///D:/a/git-proxy/git-proxy/node_modules/@vitest/runner/dist/chunk-artifact.js:294:11\n at file:///D:/a/git-proxy/git-proxy/node_modules/@vitest/runner/dist/chunk-artifact.js:901:10\n at file:///D:/a/git-proxy/git-proxy/node_modules/@vitest/runner/dist/chunk-artifact.js:2305:20\n at new Promise (<anonymous>)\n at runWithTimeout (file:///D:/a/git-proxy/git-proxy/node_modules/@vitest/runner/dist/chunk-artifact.js:2272:10)', message: 'spawnSync C:\Windows\system32\cmd.exe ETIMEDOUT', errno: -4039, code: 'ETIMEDOUT', syscall: 'spawnSync C:\Windows\system32\cmd.exe', path: 'C:\Windows\system32\cmd.exe', spawnargs: [ '/d', '/s', '/c', '"ssh-keygen -t rsa -b 2048 -m PEM -f test/keys/test_key -N "" -C "test@git-proxy""' ], error: [Circular], status: null, signal: 'SIGTERM', output: [ null, '<Buffer(0) ...>', '<Buffer(0) ...>' ], pid: 7092, stdout: '<Buffer(0) ...>', stderr: '<Buffer(0) ...>', constructor: 'Function<Error>', name: 'Error', toString: 'Function<toString>', stacks: [ { method: '', file: 'D:/a/git-proxy/git-proxy/test/ssh/security.test.ts', line: 41, column: 9 } ] }, status: null, signal: 'SIGTERM', output: [ null, '<Buffer(0) ...>', '<Buffer(0) ...>' ], pid: 7092, stdout: '<Buffer(0) ...>', stderr: '<Buffer(0) ...>' }
build result
Process completed with exit code 1.