Skip to content

fix(hogql): Optimize querying for date frame in trends actors query #329

fix(hogql): Optimize querying for date frame in trends actors query

fix(hogql): Optimize querying for date frame in trends actors query #329

Triggered via pull request March 21, 2024 08:58
Status Failure
Total duration 21m 34s
Artifacts 1

ci-backend-depot.yml

on: pull_request
Determine need to run backend checks
9s
Determine need to run backend checks
Matrix: async-migrations
Matrix: django
Python code quality checks
2m 42s
Python code quality checks
Validate Django migrations
5m 19s
Validate Django migrations
Calculate running time
6s
Calculate running time
Fit to window
Zoom out
Zoom in

Annotations

3 errors and 52 warnings
Python code quality checks: posthog/hogql_queries/insights/trends/trends_query_builder.py#L191
Item "None" of "JoinExpr | None" has no attribute "sample"
Python code quality checks: posthog/hogql_queries/insights/trends/trends_query_builder.py#L448
Argument 1 to "interval_bounds_from_str" of "QueryDateRange" has incompatible type "str | int"; expected "str"
Python code quality checks
Process completed with exit code 2.
Determine need to run backend checks
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, dorny/paths-filter@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Python code quality checks
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: n1hility/cancel-previous-runs@v3, actions/checkout@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Python code quality checks
Failed to restore:
Django tests – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Validate Django migrations
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Validate Django migrations
Failed to restore:
Django tests – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Async migrations tests - clickhouse/clickhouse-server:23.11.2.11-alpine
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – EE (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (1/5) (depot)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events on), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (2/5) (depot)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (5/5) (depot)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (4/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5) (depot)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, pnpm/action-setup@v2, actions/setup-node@v3, syphar/restore-virtualenv@v1, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Django tests – FOSS (persons-on-events off), Py 3.10.10, clickhouse/clickhouse-server:23.11.2.11-alpine (3/5) (depot)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.
Calculate running time
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: PostHog/[email protected]. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

Artifacts

Produced during runtime
Name Size
email_renders Expired
40.3 KB