horae-browser-checks
checks.x86_64-linux.browser
· build #625
· raw
1initdb: warning: enabling "trust" authentication for local connections2initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.3waiting for server to start.... done4server started52026-10-10T03:49:35.940603Z INFO horae: Running migrations...62026-10-10T03:49:39.699442Z INFO horae: Migrations complete.72026-10-10T03:49:39.770221Z INFO horae::seed: Seeding demo data…82026-10-10T03:49:39.986736Z INFO horae::seed: Seed complete.92026-10-10T03:49:40.005126Z INFO horae::seed: time_entries: 10 rows102026-10-10T03:49:40.005786Z INFO horae::seed: clients: 2 rows11PASS: archived own timer labels survive without granting catalog or global-rate access12PASS: catalog/rate grants never enable unlinked or archived tasks for a new timer; valid start/stop persists13PASS: rail popovers accept clicks and release the resize handle after closing14PASS: scoped project list/detail expose workflow labels without directory access, private notes or rates15PASS: edit and managed-project revocation remove current UI authority without legacy Administrator fallback16PASS: inactive-account and changed-policy responses clear retained detail; retry recovers only the original binding17PASS: keyboard manager removal preserves archived membership and withheld money/notes at desktop and narrow widths18PASS: financial read grants display disabled values and ordinary saves preserve stored fields19PASS: explicit zero, cost reset and lost-acknowledgement replay preserve exact original intent20PASS: current-authority revocation discards old editor state; explicit reload restores a fresh authorized form21PASS: an explicit hours-only budget edit preserves inactive hidden money and recorded history22PASS: scoped report paging, totals, four individual reports, four nested breakdowns, filtered exports, stale/invalid states and policy binding; Chromium 148.0.7778.9623✔ client: pending navigation preserves history until the request is resolved (39.827654ms)24✔ client: dirty navigation requires an explicit discard (1.569766ms)25✔ invoice: pending navigation preserves history until the request is resolved (79.82443ms)26✔ invoice: dirty navigation requires an explicit discard (38.095032ms)27✔ project: pending navigation preserves history until the request is resolved (1.920598ms)28✔ project: dirty navigation requires an explicit discard (19.063205ms)29✔ timesheet: pending navigation preserves history until the request is resolved (21.009782ms)30✔ timesheet: dirty navigation requires an explicit discard (1.538874ms)31✔ scroll-only replacements preserve Dioxus coordinates without prompting (9.102489ms)32✔ the legacy project opt-in and explicit release keep working (10.006067ms)33ℹ tests 1034ℹ suites 035ℹ pass 1036ℹ fail 037ℹ cancelled 038ℹ skipped 039ℹ todo 040ℹ duration_ms 256.86370941PASS: Export: semantics, keyboard, focus return, backdrop and short viewport42PASS: Add entry: semantics, keyboard, focus return, backdrop and short viewport43PASS: ＋ Add row: semantics, keyboard, focus return, backdrop and short viewport44PASS: pending save blocks dismissal; failure preserves input and allows retry45PASS: row deletion is atomic after a stale-client lock and supports retry46PASS: move failure is visible and reconciles with saved data47PASS: resize failure is visible and reconciles with saved data48PASS: reorder failure is visible and reconciles with saved data49PASS: lost response failure is visible and reconciles with saved data50PASS: historical move works without current tracking choices51PASS: historical resize works without current tracking choices52PASS: historical reorder works without current tracking choices53PASS: day-view timer failure is visible54PASS: project scope includes zero-entry active teammates without exposing unrelated hours55PASS: changing person and browser history reload the correct sheet, including an empty teammate56PASS: Day and Week edits carry the selected owner and preserve hidden work57PASS: delegated creation uses the selected person and eligible project/task58PASS: delegated Calendar drawing, day movement and resizing persist exact minutes59PASS: delegated untimed moves and order inversions persist the complete ordered entry set60PASS: delegated modal and Week row deletion preserve unrelated hours and requester timer61PASS: revocation between click and commit rejects the write and preserves the draft/data62PASS: delegated timer leaves the requester timer alone and requires restored tracking eligibility63PASS: only the owner can use terminal recovery after losing project assignment64Timesheet read failed: 403 http://127.0.0.1:8093/api/load_timesheet_page1638606356158383395565PASS: relationship revocation removes the selected sheet without falling back to own data66PASS: header actions, supported metrics and labelled native budget progress67PASS: design heading, compact row typography and inline project type68PASS: filtered empty state resets search, scope and client69PASS: narrow/short layouts, keyboard row actions and export formats70PASS: loading spend is unavailable until the read completes71PASS: failed spend is unavailable; retry restores real amounts72PASS: configured monthly consumption replaces lifetime spend only after loading73PASS: keyboard-accessible scope breakdown exposes overruns without layout overflow74PASS: failed configured budget never falls back to lifetime figures75PASS: empty-state guidance and action visibility for admin76PASS: empty-state guidance and action visibility for manager77PASS: empty-state guidance and action visibility for member78PASS: shared Menu, Combobox, empty-state and navigation-icon defaults are unchanged79PASS: /clients header at 320px80PASS: /clients header at 390px81PASS: /clients header at 768px82PASS: /clients header at 1280px83PASS: /clients header at 1440px84PASS: /projects header at 320px85PASS: /projects header at 390px86PASS: /projects header at 768px87PASS: /projects header at 1280px88PASS: /projects header at 1440px89PASS: /invoices header at 320px90PASS: /invoices header at 390px91PASS: /invoices header at 768px92PASS: /invoices header at 1280px93PASS: /invoices header at 1440px94PASS: /reports header at 320px95PASS: /reports header at 390px96PASS: /reports header at 768px97PASS: /reports header at 1280px98PASS: /reports header at 1440px99PASS: /admin/users header at 320px100PASS: /admin/users header at 390px101PASS: /admin/users header at 768px102PASS: /admin/users header at 1280px103PASS: /admin/users header at 1440px104PASS: /approvals header at 320px105PASS: /approvals header at 390px106PASS: /approvals header at 768px107PASS: /approvals header at 1280px108PASS: /approvals header at 1440px109PASS: /settings header at 320px110PASS: /settings header at 390px111PASS: /settings header at 768px112PASS: /settings header at 1280px113PASS: /settings header at 1440px114PASS: /admin/importers header at 320px115PASS: /admin/importers header at 390px116PASS: /admin/importers header at 768px117PASS: /admin/importers header at 1280px118PASS: /admin/importers header at 1440px119PASS: /timesheet/week/2026-10-05 header at 320px120PASS: /timesheet/week/2026-10-05 header at 390px121PASS: /timesheet/week/2026-10-05 header at 768px122PASS: /timesheet/week/2026-10-05 header at 1280px123PASS: /timesheet/week/2026-10-05 header at 1440px124PASS: /timesheet/day/2026-10-05 header at 320px125PASS: /timesheet/day/2026-10-05 header at 390px126PASS: /timesheet/day/2026-10-05 header at 768px127PASS: /timesheet/day/2026-10-05 header at 1280px128PASS: /timesheet/day/2026-10-05 header at 1440px129PASS: /timesheet/calendar/2026-10-05 header at 320px130PASS: /timesheet/calendar/2026-10-05 header at 390px131PASS: /timesheet/calendar/2026-10-05 header at 768px132PASS: /timesheet/calendar/2026-10-05 header at 1280px133PASS: /timesheet/calendar/2026-10-05 header at 1440px134PASS: project names and badges stay within aligned columns; scrolling to last-row actions opens editing135PASS: small-screen timesheet pager, date picker and view controls remain usable136PASS: admin subnavigation and its content remain reachable on mobile137PASS: day strip scrolls to Sunday and long entry labels do not cover actions138CHECK: late popover initialization restores missing focus without overriding deliberate focus139PASS: late popover initialization restores missing focus without overriding deliberate focus140CHECK: content reflow preserves an open menu while deliberate scrolling still dismisses it141PASS: content reflow preserves an open menu while deliberate scrolling still dismisses it142CHECK: first and last project-row actions are initially visible and clickable143PASS: first and last project-row actions are initially visible and clickable144CHECK: menu keyboard, disabled items, outside click and repeated opening145PASS: menu keyboard, disabled items, outside click and repeated opening146CHECK: scroll and resize dismiss without leaving stale menus or focus147PASS: scroll and resize dismiss without leaving stale menus or focus148CHECK: short-screen menu scrolls internally and supports reverse Tab and Space149PASS: short-screen menu scrolls internally and supports reverse Tab and Space150CHECK: filter and calendar menus keep their callbacks and survive route changes151PASS: filter and calendar menus keep their callbacks and survive route changes152CHECK: Timesheet keeps the shared calendar and week selection behavior153PASS: Timesheet keeps the shared calendar and week selection behavior154PASS: mobile content width, keyboard toggle, Escape/focus restoration and navigation close155PASS: short mobile viewport reaches account navigation and preserves desktop collapse state156PASS: desktop drag width survives mobile and breakpoint transitions157PASS: keyboard selection, mixed/select-all states and Actions count158PASS: search, status and client changes clear selection159PASS: keyboard selection/confirmation and no document overflow in both themes at three widths160PASS: cancel/focus, failure retry, pending guard and archive/reactivate confirmation161PASS: oversized selection cannot submit and members have no bulk controls162PASS: real atomic archive/reactivate, anonymous/member/inactive denial, manager/admin and safe retries163PASS: bulk success restores focus and recovers the list without stale actions164PASS: bulk pending restores focus and recovers the list without stale actions165PASS: bulk pending-navigation restores focus and recovers the list without stale actions166PASS: bulk failure restores focus and recovers the list without stale actions167PASS: client activation failure remains visible with form closed, open and cancelled168PASS: successful form save preserves action error; real status retry clears it and refreshes the row169PASS: archive failure survives menu dismissal; shared edit failure preserves input and safely retries170PASS: failed team removal preserves the draft, safely retries and can be restored through the shared editor171PASS: initial catalog/draft failures show loading and recovery without rendering or saving an empty replacement172PASS: design typography, section spacing, quiet dividers and theme-aware task information173PASS: project types retain native keyboard selection and the designed icon/option-card states174PASS: searchable client selection, pending/error recovery and explicit/inherited currency175PASS: client default-rate currency rejects relabelling, preserves failed input and permits compatible edits176PASS: task and teammate searches handle pending results, keyboard selection, duplicates and retry177PASS: real client, team, task restrictions, billing and invoice defaults survive reload178PASS: all invoice-default errors identify and focus their field, preserve input and recover at three widths179PASS: basic-field rejections retain values, link visible errors and restore focus at three widths180PASS: failed resume and retry preserve the existing draft without a replacement write181PASS: invalid hourly rates and hour/fee budgets retain input and focus their error at three widths182PASS: a stale email configuration rejection can be corrected without sending mail183PASS: task/person rate, cost and budget errors identify their row and preserve other inputs at three widths184PASS: single/monthly fees, empty schedules and individual milestone errors recover without changing another row185PASS: responsive form, conditional panels and Cancel preserve the draft186PASS: edits made while a save is pending are saved after its acknowledgement187PASS: lost acknowledgement retries the same request and preserves newer edits188PASS: real finalized budget reaches the authorized Projects endpoint and display189PASS: a new tagged project reaches reports and both exports; pending/error filters never show stale rows190PASS: project invoice defaults prefill real estimates, stale reviews cannot generate, and editable draft values persist independently191PASS: lost creation response is idempotent and clears the completed draft192PASS: stale tabs cannot overwrite saved input; explicit discard removes only the draft193PASS: invoice selection, partial balances, exact excess, dirty/pending navigation, reload recovery, account-scoped replay, storage failure safety and authorized per-occurrence project balances194PASS: New Project task rates and editor capabilities preserve configured/legacy modes, source currencies, unknown/zero recovery, scoped budgets and keyboard recovery across three widths195PASS: organization admin real-session UI, draft ownership, progress/export scope and financial redaction196PASS: organization manager real-session UI, draft ownership, progress/export scope and financial redaction197PASS: project lead real-session UI, draft ownership, progress/export scope and financial redaction198PASS: project admin real-session UI, draft ownership, progress/export scope and financial redaction199PASS: visible assigned member real-session UI, draft ownership, progress/export scope and financial redaction200PASS: private assigned member real-session UI, draft ownership, progress/export scope and financial redaction201PASS: revoked assignment and outsider identities cannot grant project-wide access202PASS: inactive/anonymous requests are denied and a manager creates a real project without private overrides203PASS: stale client/task/person references and archived task-name conflicts preserve drafts and support field-level recovery at three widths204PASS: saved invalid task names/access identify their row, preserve input and support keyboard recovery at three widths before real finalization205PASS: 390/1 hourly Person/No budget206PASS: 390/1 hourly Task/Hours per task207PASS: 390/1 hourly Project/Total project hours208PASS: 390/1 hourly Person/Hours per person209PASS: 390/1 hourly Task/Fees per task210PASS: 390/1 hourly Project/Total project fees211PASS: 390/1 fixed/no budget212PASS: 390/1 fixed/Single fee213PASS: 390/1 fixed/Milestones214PASS: 390/1 fixed/Monthly215PASS: 390/1 non-billable/No budget216PASS: 390/1 non-billable/Total project hours217PASS: 390/1 non-billable/Hours per task218PASS: 390/1 non-billable/Hours per person219PASS: native Tab order, accessible names, reverse Tab and unclipped focus across all billing/budget branches at 390px and 100% text220PASS: 768/1 hourly Person/No budget221PASS: 768/1 hourly Task/Hours per task222PASS: 768/1 hourly Project/Total project hours223PASS: 768/1 hourly Person/Hours per person224PASS: 768/1 hourly Task/Fees per task225PASS: 768/1 hourly Project/Total project fees226PASS: 768/1 fixed/no budget227PASS: 768/1 fixed/Single fee228PASS: 768/1 fixed/Milestones229PASS: 768/1 fixed/Monthly230PASS: 768/1 non-billable/No budget231PASS: 768/1 non-billable/Total project hours232PASS: 768/1 non-billable/Hours per task233PASS: 768/1 non-billable/Hours per person234PASS: native Tab order, accessible names, reverse Tab and unclipped focus across all billing/budget branches at 768px and 100% text235PASS: 1440/1 hourly Person/No budget236PASS: 1440/1 hourly Task/Hours per task237PASS: 1440/1 hourly Project/Total project hours238PASS: 1440/1 hourly Person/Hours per person239PASS: 1440/1 hourly Task/Fees per task240PASS: 1440/1 hourly Project/Total project fees241PASS: 1440/1 fixed/no budget242PASS: 1440/1 fixed/Single fee243PASS: 1440/1 fixed/Milestones244PASS: 1440/1 fixed/Monthly245PASS: 1440/1 non-billable/No budget246PASS: 1440/1 non-billable/Total project hours247PASS: 1440/1 non-billable/Hours per task248PASS: 1440/1 non-billable/Hours per person249PASS: native Tab order, accessible names, reverse Tab and unclipped focus across all billing/budget branches at 1440px and 100% text250PASS: 1440/2 hourly Person/No budget251PASS: 1440/2 hourly Task/Hours per task252PASS: 1440/2 hourly Project/Total project hours253PASS: 1440/2 hourly Person/Hours per person254PASS: 1440/2 hourly Task/Fees per task255PASS: 1440/2 hourly Project/Total project fees256PASS: 1440/2 fixed/no budget257PASS: 1440/2 fixed/Single fee258PASS: 1440/2 fixed/Milestones259PASS: 1440/2 fixed/Monthly260PASS: 1440/2 non-billable/No budget261PASS: 1440/2 non-billable/Total project hours262PASS: 1440/2 non-billable/Hours per task263PASS: 1440/2 non-billable/Hours per person264PASS: native Tab order, accessible names, reverse Tab and unclipped focus across all billing/budget branches at 1440px and 200% text265PASS: New client266PASS: Who can track to this task?267PASS: restricted task members268PASS: Discard this draft?269PASS: configured email threshold at 390270PASS: configured email threshold at 768271PASS: configured email threshold at 1440272PASS: budget amount and checkbox choices survive draft reload and finalize correctly at 390px273PASS: keyboard-only Time & Materials creation at 390px took 12814ms and survives reopening274PASS: keyboard-only Fixed Fee creation at 390px took 4845ms and survives reopening275PASS: keyboard-only Non-Billable creation at 390px took 4524ms and survives reopening276PASS: budget amount and checkbox choices survive draft reload and finalize correctly at 768px277PASS: keyboard-only Time & Materials creation at 768px took 17914ms and survives reopening278PASS: keyboard-only Fixed Fee creation at 768px took 9492ms and survives reopening279PASS: keyboard-only Non-Billable creation at 768px took 3706ms and survives reopening280PASS: budget amount and checkbox choices survive draft reload and finalize correctly at 1440px281PASS: keyboard-only Time & Materials creation at 1440px took 14188ms and survives reopening282PASS: keyboard-only Fixed Fee creation at 1440px took 10277ms and survives reopening283PASS: keyboard-only Non-Billable creation at 1440px took 2905ms and survives reopening284PASS: modal traversal/Escape restores focus and configured email threshold is keyboard reachable without sending mail285PASS: interrupted response bodies remain retryable without losing newer edits286PASS: shared editor prefills, cancels, saves the same project and survives reload at 390px287PASS: shared editor prefills, cancels, saves the same project and survives reload at 768px288PASS: shared editor prefills, cancels, saves the same project and survives reload at 1440px289PASS: configured editor prefills exact zero, budgets, private notes and invoice defaults; persists changes and preserves identity on no-op290PASS: sidebar, back, forward, reload and replacement navigation preserve dirty edits until explicitly discarded291PASS: lost save acknowledgement blocks navigation and retries the identical committed request without another update292PASS: concurrent edits reject a stale save, retain local input and require confirmation before reloading293PASS: pending creation saves protect sidebar, Back, replacement, reload and full-document exits without losing newer edits294PASS: a lost acknowledgement blocks Forward and exits until the identical retry and newer edits are acknowledged295PASS: explicit Cancel preserves the draft, confirmed discard clears it, and successful creation releases the guard296ExpectError: expect(locator).toContainText(expected) failed297298Locator: getByRole('region', { name: 'Billing', exact: true })299Expected substring: "USD 0.00 / h"300Timeout: 5000ms301Error: element(s) not found302303Call log:304 - Expect "to.have.text" with timeout 5000ms305 - waiting for getByRole('region', { name: 'Billing', exact: true })306307 at captureRawStack (/nix/store/i6xnc927g8yrwq0fws8wbmjvj4y36fq5-playwright-test-1.60.0/lib/node_modules/playwright-core/lib/coreBundle.js:3130:17)308 at callMatcherAsStep (/nix/store/i6xnc927g8yrwq0fws8wbmjvj4y36fq5-playwright-test-1.60.0/lib/node_modules/playwright/lib/matchers/expect.js:12873:57)309 at Object.toContainText (/nix/store/i6xnc927g8yrwq0fws8wbmjvj4y36fq5-playwright-test-1.60.0/lib/node_modules/playwright/lib/matchers/expect.js:12863:23)310 at /nix/store/h6a6z6acf56gy2big205najrm5rvkxdj-horae/tests/browser/clients.cjs:79:78 {311 matcherResult: {312 name: 'toContainText',313 expected: 'USD 0.00 / h',314 message: '\x1B[2mexpect(\x1B[22m\x1B[31mlocator\x1B[39m\x1B[2m).\x1B[22mtoContainText\x1B[2m(\x1B[22m\x1B[32mexpected\x1B[39m\x1B[2m)\x1B[22m failed\n' +315 '\n' +316 "Locator: getByRole('region', { name: 'Billing', exact: true })\n" +317 'Expected substring: \x1B[32m"USD 0.00 / h"\x1B[39m\n' +318 'Timeout: 5000ms\n' +319 'Error: element(s) not found\n' +320 '\n' +321 'Call log:\n' +322 '\x1B[2m - Expect "to.have.text" with timeout 5000ms\x1B[22m\n' +323 "\x1B[2m - waiting for getByRole('region', { name: 'Billing', exact: true })\x1B[22m\n",324 pass: false,325 actual: undefined,326 log: [327 ' - Expect "to.have.text" with timeout 5000ms',328 " - waiting for getByRole('region', { name: 'Billing', exact: true })"329 ],330 timeout: 5000,331 ariaSnapshot: '- complementary "Navigation":\n' +332 ' - text: Horae\n' +333 ' - button "Collapse sidebar": «\n' +334 ' - button "Start timer"\n' +335 ' - text: Track\n' +336 ' - link "Timesheet":\n' +337 ' - /url: /timesheet/week/2026-10-10?span=week&user=\n' +338 ' - img\n' +339 ' - text: Timesheet\n' +340 ' - text: Organize\n' +341 ' - link "Clients":\n' +342 ' - /url: /clients\n' +343 ' - img\n' +344 ' - text: Clients\n' +345 ' - link "Projects":\n' +346 ' - /url: /projects\n' +347 ' - img\n' +348 ' - text: Projects\n' +349 ' - link "Invoices":\n' +350 ' - /url: /invoices\n' +351 ' - img\n' +352 ' - text: Invoices\n' +353 ' - text: Review\n' +354 ' - link "Approvals":\n' +355 ' - /url: /approvals\n' +356 ' - img\n' +357 ' - text: Approvals\n' +358 ' - link "Reports":\n' +359 ' - /url: /reports\n' +360 ' - img\n' +361 ' - text: Reports\n' +362 ' - button "· Not signed in ⌄"\n' +363 '- main:\n' +364 ' - link "Back to Clients":\n' +365 ' - /url: /clients\n' +366 ' - img\n' +367 ' - text: Back to Clients\n' +368 ' - status: Loading client…'369 }370}3712026-10-10T03:49:40.549637Z WARN horae: DEV_LOGIN=1: /auth/dev-login signs anyone in as an admin without a password. Use it for local development only.3722026-10-10T04:14:32.035586Z WARN sqlx::query: slow statement: execution time exceeded alert threshold summary="WITH config AS ( …" db.statement="\n\nWITH config AS (\n SELECT p.id, p.budget_kind, p.budget_minutes, p.budget_amount_cents,\n p.project_type, p.currency, p.rate_cents, p.client_id,\n ps.budget_scope, ps.monthly_reset, ps.include_nonbillable, ps.rate_mode,\n ($4::uuid IS NULL OR $5 OR $6 OR ($7 AND management.id IS NOT NULL)) AS can_read_details,\n ($4::uuid IS NULL OR $5 OR $8 OR ($9 AND management.id IS NOT NULL)) AS can_view_money\n FROM projects p JOIN project_settings ps ON ps.project_id = p.id AND ps.org_id = p.org_id\n JOIN clients parent ON parent.id=p.client_id AND parent.org_id=p.org_id\n LEFT JOIN project_management_assignments management ON management.org_id=p.org_id\n AND management.project_id=p.id AND management.manager_id=$4\n LEFT JOIN assignments member ON member.project_id=p.id AND member.user_id=$4\n WHERE p.org_id = $1 AND ($2::uuid IS NULL OR p.id = $2)\n AND ($4::uuid IS NULL OR CASE WHEN $5 THEN EXISTS (\n SELECT 1 FROM project_read_access access\n WHERE access.org_id = p.org_id AND access.project_id = p.id\n AND access.user_id = $4 AND access.can_view_progress)\n ELSE $6 OR ($7 AND management.id IS NOT NULL)\n OR (member.id IS NOT NULL AND ps.report_visibility='project_members') END)\n ), scopes AS (\n SELECT c.id AS project_id, NULL::uuid AS task_id, NULL::uuid AS user_id,\n NULL::text AS label,\n CASE WHEN c.budget_kind = 'hours' THEN c.budget_minutes ELSE c.budget_amount_cents END AS budget\n FROM config c WHERE c.budget_scope = 'project'\n UNION ALL\n SELECT c.id, pt.task_id, NULL::uuid, t.name,\n CASE WHEN c.budget_kind = 'hours' THEN s.budget_minutes ELSE s.budget_cents END\n FROM config c JOIN project_tasks pt ON pt.project_id = c.id\n JOIN tasks t ON t.id = pt.task_id AND t.org_id = $1\n LEFT JOIN project_task_settings s ON s.project_id = c.id AND s.org_id = $1 AND s.task_id = pt.task_id\n WHERE c.budget_scope = 'task'\n UNION ALL\n SELECT c.id, NULL::uuid, a.user_id, u.name, s.budget_minutes\n FROM config c JOIN assignments a ON a.project_id = c.id\n JOIN users u ON u.id = a.user_id AND u.org_id = $1\n LEFT JOIN project_member_budgets s ON s.project_id = c.id AND s.org_id = $1 AND s.user_id = a.user_id\n WHERE c.budget_scope = 'person' AND c.budget_kind = 'hours'\n ), entries AS (\n SELECT c.id AS project_id, te.task_id, te.user_id,\n CASE WHEN c.budget_kind = 'hours'\n THEN effective_minutes(te.minutes, te.rounded_minutes, o.round_minutes, o.round_dir)::bigint\n WHEN c.can_view_money THEN COALESCE(line.amount_cents, line_amount_cents(\n COALESCE(resolve_project_rate(c.rate_mode, pt.rate_cents, a.rate_cents, c.rate_cents,\n CASE WHEN c.currency = o.default_currency THEN u.billable_rate_cents END,\n CASE WHEN c.currency = cl.currency THEN cl.default_rate_cents END), 0),\n effective_minutes(te.minutes, te.rounded_minutes, o.round_minutes, o.round_dir)))\n ELSE 0\n END AS consumed\n FROM config c JOIN time_entries te ON te.project_id = c.id AND te.org_id = $1\n JOIN organizations o ON o.id = te.org_id\n JOIN users u ON u.id = te.user_id AND u.org_id = te.org_id\n JOIN clients cl ON cl.id = c.client_id AND cl.org_id = te.org_id\n JOIN tasks t ON t.id = te.task_id AND t.org_id = te.org_id\n LEFT JOIN project_tasks pt ON pt.project_id = c.id AND pt.task_id = te.task_id\n LEFT JOIN assignments a ON a.project_id = c.id AND a.user_id = te.user_id\n LEFT JOIN invoices invoice ON invoice.id=te.invoice_id AND invoice.org_id=te.org_id\n LEFT JOIN invoice_line_items line ON line.invoice_id = invoice.id AND line.time_entry_id = te.id\n WHERE c.budget_kind <> 'none' AND (NOT c.monthly_reset OR (\n te.spent_date >= date_trunc('month', $3::date)::date\n AND te.spent_date < (date_trunc('month', $3::date) + interval '1 month')::date))\n AND (te.invoice_id IS NULL OR invoice.id IS NOT NULL)\n AND (c.include_nonbillable OR c.project_type = 'non_billable'\n OR (te.billable AND (te.invoice_id IS NOT NULL OR COALESCE(pt.billable, t.billable_default))))\n )\n SELECT c.id AS \"project_id!\", s.task_id AS \"task_id?\", s.user_id AS \"user_id?\",\n s.label AS \"label?\", c.budget_scope AS \"scope!\", c.currency AS \"currency!\",\n c.budget_kind AS \"kind!: BudgetKind\",\n CASE WHEN c.budget_kind <> 'amount' OR c.can_view_money THEN s.budget END AS \"budget?\",\n c.can_view_money AS \"can_view_money!\", c.can_read_details AS \"can_read_details!\",\n CASE WHEN c.monthly_reset THEN to_char($3::date, 'YYYY-MM') ELSE 'lifetime' END AS \"period_key!\",\n COALESCE(SUM(e.consumed), 0)::bigint AS \"consumed!\"\n FROM config c LEFT JOIN scopes s ON s.project_id = c.id\n LEFT JOIN entries e ON e.project_id = c.id\n AND (s.task_id IS NULL OR e.task_id = s.task_id)\n AND (s.user_id IS NULL OR e.user_id = s.user_id)\n GROUP BY c.id, c.budget_kind, c.budget_scope, c.currency, c.monthly_reset,\n s.task_id, s.user_id, s.label, s.budget, c.can_view_money, c.can_read_details\n ORDER BY c.id, s.label, s.task_id, s.user_id\n" rows_affected=19 rows_returned=19 elapsed=1.029239232s elapsed_secs=1.029239232 slow_threshold=1s3732026-10-10T04:37:50.504566Z WARN sqlx::query: slow statement: execution time exceeded alert threshold summary="SELECT id, org_id, email, …" db.statement="\n\nSELECT id, org_id, email, name, oidc_subject,\n org_role as \"org_role: OrgRole\",\n cost_rate_cents, billable_rate_cents, active,\n created_at as \"created_at: chrono::DateTime<chrono::Utc>\"\n FROM users WHERE id = $1 AND active = true\n" rows_affected=1 rows_returned=1 elapsed=1.531631243s elapsed_secs=1.531631243 slow_threshold=1s3742026-10-10T04:39:34.114664Z WARN sqlx::query: slow statement: execution time exceeded alert threshold summary="WITH visible AS ( …" db.statement="\n\nWITH visible AS (\n SELECT p.*,\n CASE WHEN $3 THEN COALESCE(legacy.can_view_progress, false)\n ELSE $6 OR ($7 AND management.id IS NOT NULL) END AS can_view_money\n FROM projects p\n JOIN clients parent ON parent.id=p.client_id AND parent.org_id=p.org_id\n LEFT JOIN project_read_access legacy ON legacy.org_id=p.org_id\n AND legacy.project_id=p.id AND legacy.user_id=$2\n LEFT JOIN project_management_assignments management ON management.org_id=p.org_id\n AND management.project_id=p.id AND management.manager_id=$2\n LEFT JOIN assignments member ON member.project_id=p.id AND member.user_id=$2\n LEFT JOIN project_settings settings ON settings.org_id=p.org_id AND settings.project_id=p.id\n WHERE p.org_id=$1 AND CASE WHEN $3 THEN COALESCE(legacy.can_view_progress, false)\n ELSE $4 OR ($5 AND management.id IS NOT NULL)\n OR (member.id IS NOT NULL AND COALESCE(settings.report_visibility, 'project_members')='project_members') END\n ), entries AS (\n SELECT p.id AS project_id, te.minutes,\n CASE WHEN p.can_view_money AND te.billable\n AND (te.invoice_id IS NOT NULL OR (p.project_type <> 'non_billable'\n AND COALESCE(pt.billable, t.billable_default)))\n THEN COALESCE(line.amount_cents, line_amount_cents(\n COALESCE(CASE WHEN ps.project_id IS NULL OR p.project_type = 'time_and_materials'\n THEN resolve_project_rate(ps.rate_mode, pt.rate_cents, a.rate_cents, p.rate_cents,\n CASE WHEN ps.project_id IS NULL OR p.currency = o.default_currency THEN u.billable_rate_cents END,\n CASE WHEN p.currency = c.currency THEN c.default_rate_cents END\n ) END, 0),\n effective_minutes(te.minutes, te.rounded_minutes, o.round_minutes, o.round_dir)\n )) END AS amount_cents\n FROM visible p\n JOIN time_entries te ON te.project_id=p.id AND te.org_id=p.org_id\n JOIN clients c ON c.id = p.client_id AND c.org_id=te.org_id\n LEFT JOIN project_settings ps ON ps.project_id = p.id AND ps.org_id=te.org_id\n JOIN tasks t ON t.id = te.task_id AND t.org_id=te.org_id\n LEFT JOIN project_tasks pt ON pt.project_id = te.project_id AND pt.task_id = te.task_id\n LEFT JOIN assignments a ON a.project_id = te.project_id AND a.user_id = te.user_id\n LEFT JOIN invoices invoice ON invoice.id=te.invoice_id AND invoice.org_id=te.org_id\n LEFT JOIN invoice_line_items line ON line.invoice_id = invoice.id AND line.time_entry_id = te.id\n JOIN users u ON u.id = te.user_id AND u.org_id=te.org_id\n JOIN organizations o ON o.id = te.org_id\n WHERE te.invoice_id IS NULL OR invoice.id IS NOT NULL\n )\n SELECT p.id AS \"project_id!\",\n COALESCE(SUM(e.minutes),0)::bigint AS \"spent_minutes!\",\n CASE WHEN p.can_view_money THEN COALESCE(SUM(e.amount_cents),0)::bigint END AS \"spent_cents?\"\n FROM visible p LEFT JOIN entries e ON e.project_id=p.id\n GROUP BY p.id,p.can_view_money\n ORDER BY p.id\n" rows_affected=31 rows_returned=31 elapsed=1.428715834s elapsed_secs=1.4287158340000001 slow_threshold=1s3752026-10-10T04:40:25.405862Z WARN sqlx::query: slow statement: execution time exceeded alert threshold summary="WITH visible AS ( …" db.statement="\n\nWITH visible AS (\n SELECT p.*,\n CASE WHEN $3 THEN COALESCE(legacy.can_view_progress, false)\n ELSE $6 OR ($7 AND management.id IS NOT NULL) END AS can_view_money\n FROM projects p\n JOIN clients parent ON parent.id=p.client_id AND parent.org_id=p.org_id\n LEFT JOIN project_read_access legacy ON legacy.org_id=p.org_id\n AND legacy.project_id=p.id AND legacy.user_id=$2\n LEFT JOIN project_management_assignments management ON management.org_id=p.org_id\n AND management.project_id=p.id AND management.manager_id=$2\n LEFT JOIN assignments member ON member.project_id=p.id AND member.user_id=$2\n LEFT JOIN project_settings settings ON settings.org_id=p.org_id AND settings.project_id=p.id\n WHERE p.org_id=$1 AND CASE WHEN $3 THEN COALESCE(legacy.can_view_progress, false)\n ELSE $4 OR ($5 AND management.id IS NOT NULL)\n OR (member.id IS NOT NULL AND COALESCE(settings.report_visibility, 'project_members')='project_members') END\n ), entries AS (\n SELECT p.id AS project_id, te.minutes,\n CASE WHEN p.can_view_money AND te.billable\n AND (te.invoice_id IS NOT NULL OR (p.project_type <> 'non_billable'\n AND COALESCE(pt.billable, t.billable_default)))\n THEN COALESCE(line.amount_cents, line_amount_cents(\n COALESCE(CASE WHEN ps.project_id IS NULL OR p.project_type = 'time_and_materials'\n THEN resolve_project_rate(ps.rate_mode, pt.rate_cents, a.rate_cents, p.rate_cents,\n CASE WHEN ps.project_id IS NULL OR p.currency = o.default_currency THEN u.billable_rate_cents END,\n CASE WHEN p.currency = c.currency THEN c.default_rate_cents END\n ) END, 0),\n effective_minutes(te.minutes, te.rounded_minutes, o.round_minutes, o.round_dir)\n )) END AS amount_cents\n FROM visible p\n JOIN time_entries te ON te.project_id=p.id AND te.org_id=p.org_id\n JOIN clients c ON c.id = p.client_id AND c.org_id=te.org_id\n LEFT JOIN project_settings ps ON ps.project_id = p.id AND ps.org_id=te.org_id\n JOIN tasks t ON t.id = te.task_id AND t.org_id=te.org_id\n LEFT JOIN project_tasks pt ON pt.project_id = te.project_id AND pt.task_id = te.task_id\n LEFT JOIN assignments a ON a.project_id = te.project_id AND a.user_id = te.user_id\n LEFT JOIN invoices invoice ON invoice.id=te.invoice_id AND invoice.org_id=te.org_id\n LEFT JOIN invoice_line_items line ON line.invoice_id = invoice.id AND line.time_entry_id = te.id\n JOIN users u ON u.id = te.user_id AND u.org_id=te.org_id\n JOIN organizations o ON o.id = te.org_id\n WHERE te.invoice_id IS NULL OR invoice.id IS NOT NULL\n )\n SELECT p.id AS \"project_id!\",\n COALESCE(SUM(e.minutes),0)::bigint AS \"spent_minutes!\",\n CASE WHEN p.can_view_money THEN COALESCE(SUM(e.amount_cents),0)::bigint END AS \"spent_cents?\"\n FROM visible p LEFT JOIN entries e ON e.project_id=p.id\n GROUP BY p.id,p.can_view_money\n ORDER BY p.id\n" rows_affected=32 rows_returned=32 elapsed=1.144860348s elapsed_secs=1.144860348 slow_threshold=1s3762026-10-10 03:49:40.020 UTC [128] FATAL: connection to client lost3772026-10-10 03:53:18.383 UTC [883] LOG: could not send data to client: Broken pipe3782026-10-10 03:53:18.397 UTC [883] FATAL: connection to client lost3792026-10-10 03:53:18.573 UTC [889] LOG: could not send data to client: Broken pipe3802026-10-10 03:53:18.573 UTC [889] FATAL: connection to client lost3812026-10-10 03:53:18.599 UTC [864] LOG: could not send data to client: Broken pipe3822026-10-10 03:53:18.599 UTC [864] FATAL: connection to client lost3832026-10-10 03:53:18.842 UTC [891] LOG: could not send data to client: Broken pipe3842026-10-10 03:53:18.842 UTC [891] FATAL: connection to client lost3852026-10-10 03:53:18.873 UTC [886] LOG: could not send data to client: Broken pipe3862026-10-10 03:53:18.873 UTC [886] FATAL: connection to client lost3872026-10-10 03:53:19.175 UTC [890] LOG: could not send data to client: Broken pipe3882026-10-10 03:53:19.175 UTC [890] FATAL: connection to client lost3892026-10-10 03:53:19.198 UTC [894] LOG: could not send data to client: Broken pipe3902026-10-10 03:53:19.198 UTC [894] FATAL: connection to client lost3912026-10-10 03:53:19.215 UTC [892] LOG: could not send data to client: Broken pipe3922026-10-10 03:53:19.215 UTC [892] FATAL: connection to client lost3932026-10-10 03:53:19.239 UTC [893] LOG: could not send data to client: Broken pipe3942026-10-10 03:53:19.240 UTC [893] FATAL: connection to client lost3952026-10-10 03:53:19.280 UTC [896] LOG: could not send data to client: Broken pipe3962026-10-10 03:53:19.281 UTC [896] FATAL: connection to client lost3972026-10-10 03:53:19.325 UTC [895] LOG: could not send data to client: Broken pipe3982026-10-10 03:53:19.325 UTC [895] FATAL: connection to client lost3992026-10-10 03:53:19.356 UTC [898] LOG: could not send data to client: Broken pipe4002026-10-10 03:53:19.356 UTC [898] FATAL: connection to client lost4012026-10-10 03:53:19.467 UTC [900] LOG: could not send data to client: Broken pipe4022026-10-10 03:53:19.467 UTC [900] FATAL: connection to client lost4032026-10-10 03:53:19.533 UTC [899] LOG: could not send data to client: Broken pipe4042026-10-10 03:53:19.533 UTC [899] FATAL: connection to client lost4052026-10-10 03:53:19.612 UTC [897] LOG: could not send data to client: Broken pipe4062026-10-10 03:53:19.612 UTC [897] FATAL: connection to client lost4072026-10-10 03:53:19.723 UTC [902] LOG: could not send data to client: Broken pipe4082026-10-10 03:53:19.723 UTC [902] FATAL: connection to client lost4092026-10-10 03:53:19.757 UTC [901] LOG: could not send data to client: Broken pipe4102026-10-10 03:53:19.757 UTC [901] FATAL: connection to client lost4112026-10-10 03:53:19.800 UTC [904] LOG: could not send data to client: Broken pipe4122026-10-10 03:53:19.800 UTC [904] FATAL: connection to client lost4132026-10-10 03:53:19.840 UTC [906] LOG: could not send data to client: Broken pipe4142026-10-10 03:53:19.840 UTC [906] FATAL: connection to client lost4152026-10-10 03:53:19.858 UTC [905] LOG: could not send data to client: Broken pipe4162026-10-10 03:53:19.859 UTC [905] FATAL: connection to client lost4172026-10-10 03:53:19.890 UTC [903] LOG: could not send data to client: Broken pipe4182026-10-10 03:53:19.890 UTC [903] FATAL: connection to client lost4192026-10-10 03:53:19.950 UTC [907] LOG: could not send data to client: Broken pipe4202026-10-10 03:53:19.950 UTC [907] FATAL: connection to client lost4212026-10-10 03:53:19.986 UTC [909] LOG: could not send data to client: Broken pipe4222026-10-10 03:53:19.986 UTC [909] FATAL: connection to client lost4232026-10-10 03:53:20.044 UTC [911] LOG: could not send data to client: Broken pipe4242026-10-10 03:53:20.044 UTC [911] FATAL: connection to client lost4252026-10-10 03:53:20.075 UTC [912] LOG: could not send data to client: Broken pipe4262026-10-10 03:53:20.075 UTC [912] FATAL: connection to client lost4272026-10-10 03:53:20.103 UTC [908] LOG: could not send data to client: Broken pipe4282026-10-10 03:53:20.103 UTC [908] FATAL: connection to client lost4292026-10-10 03:53:20.152 UTC [910] LOG: could not send data to client: Broken pipe4302026-10-10 03:53:20.152 UTC [910] FATAL: connection to client lost4312026-10-10 03:53:20.216 UTC [914] LOG: could not send data to client: Broken pipe4322026-10-10 03:53:20.216 UTC [914] FATAL: connection to client lost4332026-10-10 03:53:20.267 UTC [913] LOG: could not send data to client: Broken pipe4342026-10-10 03:53:20.267 UTC [913] FATAL: connection to client lost4352026-10-10 03:53:20.342 UTC [916] LOG: could not send data to client: Broken pipe4362026-10-10 03:53:20.342 UTC [916] FATAL: connection to client lost4372026-10-10 03:53:20.415 UTC [917] LOG: could not send data to client: Broken pipe4382026-10-10 03:53:20.415 UTC [917] FATAL: connection to client lost4392026-10-10 03:53:20.468 UTC [915] LOG: could not send data to client: Broken pipe4402026-10-10 03:53:20.468 UTC [915] FATAL: connection to client lost4412026-10-10 03:53:20.527 UTC [919] LOG: could not send data to client: Broken pipe4422026-10-10 03:53:20.527 UTC [919] FATAL: connection to client lost4432026-10-10 03:53:20.571 UTC [920] LOG: could not send data to client: Broken pipe4442026-10-10 03:53:20.571 UTC [920] FATAL: connection to client lost4452026-10-10 03:53:20.607 UTC [918] LOG: could not send data to client: Broken pipe4462026-10-10 03:53:20.607 UTC [918] FATAL: connection to client lost4472026-10-10 03:53:20.741 UTC [923] LOG: could not send data to client: Broken pipe4482026-10-10 03:53:20.741 UTC [923] FATAL: connection to client lost4492026-10-10 03:54:35.118 UTC [19] LOG: checkpoint starting: time4502026-10-10 03:56:46.686 UTC [19] LOG: checkpoint complete: wrote 1228 buffers (7.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=131.552 s, sync=0.001 s, total=131.569 s; sync files=0, longest=0.000 s, average=0.000 s; distance=6870 kB, estimate=6870 kB; lsn=0/1BD3CE8, redo lsn=0/1BA24C84512026-10-10 03:59:35.790 UTC [19] LOG: checkpoint starting: time4522026-10-10 03:59:40.121 UTC [19] LOG: checkpoint complete: wrote 46 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.317 s, sync=0.001 s, total=4.332 s; sync files=0, longest=0.000 s, average=0.000 s; distance=282 kB, estimate=6212 kB; lsn=0/1BE90D0, redo lsn=0/1BE90784532026-10-10 04:04:35.221 UTC [19] LOG: checkpoint starting: time4542026-10-10 04:04:39.782 UTC [19] LOG: checkpoint complete: wrote 47 buffers (0.3%); 1 WAL file(s) added, 0 removed, 0 recycled; write=4.537 s, sync=0.001 s, total=4.562 s; sync files=0, longest=0.000 s, average=0.000 s; distance=279 kB, estimate=5618 kB; lsn=0/1C34AC8, redo lsn=0/1C2ED804552026-10-10 04:09:35.882 UTC [19] LOG: checkpoint starting: time4562026-10-10 04:09:48.071 UTC [19] LOG: checkpoint complete: wrote 122 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=12.165 s, sync=0.001 s, total=12.190 s; sync files=0, longest=0.000 s, average=0.000 s; distance=306 kB, estimate=5087 kB; lsn=0/1C8A888, redo lsn=0/1C7B8E04572026-10-10 04:14:35.174 UTC [19] LOG: checkpoint starting: time4582026-10-10 04:14:46.999 UTC [19] LOG: checkpoint complete: wrote 117 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.777 s, sync=0.001 s, total=11.825 s; sync files=0, longest=0.000 s, average=0.000 s; distance=477 kB, estimate=4626 kB; lsn=0/1CFDDF8, redo lsn=0/1CF2EA84592026-10-10 04:19:35.109 UTC [19] LOG: checkpoint starting: time4602026-10-10 04:19:38.470 UTC [19] LOG: checkpoint complete: wrote 35 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.336 s, sync=0.001 s, total=3.362 s; sync files=0, longest=0.000 s, average=0.000 s; distance=145 kB, estimate=4178 kB; lsn=0/1D17348, redo lsn=0/1D172F04612026-10-10 04:24:35.573 UTC [19] LOG: checkpoint starting: time4622026-10-10 04:24:36.674 UTC [19] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.066 s, sync=0.001 s, total=1.102 s; sync files=0, longest=0.000 s, average=0.000 s; distance=84 kB, estimate=3769 kB; lsn=0/1D2C5B0, redo lsn=0/1D2C5584632026-10-10 04:29:35.776 UTC [19] LOG: checkpoint starting: time4642026-10-10 04:29:36.125 UTC [19] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.311 s, sync=0.001 s, total=0.349 s; sync files=0, longest=0.000 s, average=0.000 s; distance=49 kB, estimate=3397 kB; lsn=0/1D38CB8, redo lsn=0/1D38C604652026-10-10 04:34:35.225 UTC [19] LOG: checkpoint starting: time4662026-10-10 04:34:36.501 UTC [19] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.263 s, sync=0.001 s, total=1.276 s; sync files=0, longest=0.000 s, average=0.000 s; distance=71 kB, estimate=3064 kB; lsn=0/1D4A9A0, redo lsn=0/1D4A9484672026-10-10 04:39:35.602 UTC [19] LOG: checkpoint starting: time4682026-10-10 04:39:41.844 UTC [19] LOG: checkpoint complete: wrote 64 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.207 s, sync=0.001 s, total=6.242 s; sync files=0, longest=0.000 s, average=0.000 s; distance=332 kB, estimate=2791 kB; lsn=0/1DA2E18, redo lsn=0/1D9DB684692026-10-10 04:40:31.848 UTC [18] LOG: received fast shutdown request4702026-10-10 04:40:31.872 UTC [18] LOG: aborting any active transactions4712026-10-10 04:40:31.888 UTC [18] LOG: background worker "logical replication launcher" (PID 24) exited with exit code 14722026-10-10 04:40:31.892 UTC [19] LOG: shutting down4732026-10-10 04:40:31.898 UTC [19] LOG: checkpoint starting: shutdown immediate4742026-10-10 04:40:32.026 UTC [19] LOG: checkpoint complete: wrote 28 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.102 s, sync=0.001 s, total=0.134 s; sync files=0, longest=0.000 s, average=0.000 s; distance=87 kB, estimate=2521 kB; lsn=0/1DB3AA8, redo lsn=0/1DB3AA84752026-10-10 04:40:32.370 UTC [18] LOG: database system is shut down