Skip to content

fix(insights): HogQL calculation of saved legacy insights v2 #77753

fix(insights): HogQL calculation of saved legacy insights v2

fix(insights): HogQL calculation of saved legacy insights v2 #77753

Triggered via pull request April 17, 2024 20:34
Status Failure
Total duration 21m 55s
Artifacts 1

ci-backend.yml

on: pull_request
Determine need to run backend checks
10s
Determine need to run backend checks
Matrix: async-migrations
Matrix: django
Python code quality checks
2m 14s
Python code quality checks
Validate Django and CH migrations
2m 44s
Validate Django and CH migrations
Calculate running time
0s
Calculate running time
Fit to window
Zoom out
Zoom in

Annotations

16 errors and 49 warnings
Python code quality checks: posthog/schema.py#L1175
Incompatible types in assignment (expression has type "str", variable has type "PropertyOperator | None")
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Unsupported left operand type for + ("PropertyGroupFilter")
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Left operand is of type "list[EventPropertyFilter | PersonPropertyFilter | ElementPropertyFilter | SessionPropertyFilter | CohortPropertyFilter | RecordingDurationFilter | GroupPropertyFilter | FeaturePropertyFilter | HogQLPropertyFilter | EmptyPropertyFilter | DataWarehousePropertyFilter | DataWarehousePersonPropertyFilter] | PropertyGroupFilter | Any | list[EventPropertyFilter | PersonPropertyFilter]"
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Item "HogQLQuery" of "TrendsQuery | FunnelsQuery | RetentionQuery | PathsQuery | StickinessQuery | LifecycleQuery | ActorsQuery | EventsQuery | HogQLQuery | InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationQuery | FunnelCorrelationActorsQuery | InsightActorsQueryOptions | SessionsTimelineQuery | WebOverviewQuery | WebStatsTableQuery | WebTopClicksQuery" has no attribute "properties"
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Item "InsightActorsQuery" of "TrendsQuery | FunnelsQuery | RetentionQuery | PathsQuery | StickinessQuery | LifecycleQuery | ActorsQuery | EventsQuery | HogQLQuery | InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationQuery | FunnelCorrelationActorsQuery | InsightActorsQueryOptions | SessionsTimelineQuery | WebOverviewQuery | WebStatsTableQuery | WebTopClicksQuery" has no attribute "properties"
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Item "FunnelsActorsQuery" of "TrendsQuery | FunnelsQuery | RetentionQuery | PathsQuery | StickinessQuery | LifecycleQuery | ActorsQuery | EventsQuery | HogQLQuery | InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationQuery | FunnelCorrelationActorsQuery | InsightActorsQueryOptions | SessionsTimelineQuery | WebOverviewQuery | WebStatsTableQuery | WebTopClicksQuery" has no attribute "properties"
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Item "FunnelCorrelationQuery" of "TrendsQuery | FunnelsQuery | RetentionQuery | PathsQuery | StickinessQuery | LifecycleQuery | ActorsQuery | EventsQuery | HogQLQuery | InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationQuery | FunnelCorrelationActorsQuery | InsightActorsQueryOptions | SessionsTimelineQuery | WebOverviewQuery | WebStatsTableQuery | WebTopClicksQuery" has no attribute "properties"
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Item "FunnelCorrelationActorsQuery" of "TrendsQuery | FunnelsQuery | RetentionQuery | PathsQuery | StickinessQuery | LifecycleQuery | ActorsQuery | EventsQuery | HogQLQuery | InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationQuery | FunnelCorrelationActorsQuery | InsightActorsQueryOptions | SessionsTimelineQuery | WebOverviewQuery | WebStatsTableQuery | WebTopClicksQuery" has no attribute "properties"
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Item "InsightActorsQueryOptions" of "TrendsQuery | FunnelsQuery | RetentionQuery | PathsQuery | StickinessQuery | LifecycleQuery | ActorsQuery | EventsQuery | HogQLQuery | InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationQuery | FunnelCorrelationActorsQuery | InsightActorsQueryOptions | SessionsTimelineQuery | WebOverviewQuery | WebStatsTableQuery | WebTopClicksQuery" has no attribute "properties"
Python code quality checks: posthog/hogql_queries/query_runner.py#L396
Item "SessionsTimelineQuery" of "TrendsQuery | FunnelsQuery | RetentionQuery | PathsQuery | StickinessQuery | LifecycleQuery | ActorsQuery | EventsQuery | HogQLQuery | InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationQuery | FunnelCorrelationActorsQuery | InsightActorsQueryOptions | SessionsTimelineQuery | WebOverviewQuery | WebStatsTableQuery | WebTopClicksQuery" has no attribute "properties"
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. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Validate Django and CH migrations
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3. 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. 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.12.5.81-alpine
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3. 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)
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. 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.12.5.81-alpine (1/5)
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. 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 (1/5)
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. 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 (1/5)
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. 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.12.5.81-alpine (1/5)
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. 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)
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. 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.12.5.81-alpine (2/5)
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. 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)
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. 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.12.5.81-alpine (2/5)
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. 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.12.5.81-alpine (1/5)
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. 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)
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. 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)
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. 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.12.5.81-alpine (2/5)
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. 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.12.5.81-alpine (5/5)
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. 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)
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. 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)
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. 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.12.5.81-alpine (3/5)
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. 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.12.5.81-alpine (5/5)
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. 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.12.5.81-alpine (5/5)
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. 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.12.5.81-alpine (4/5)
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. 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)
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. 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)
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. 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.12.5.81-alpine (4/5)
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. 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)
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. 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)
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. 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.12.5.81-alpine (3/5)
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. 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.12.5.81-alpine (4/5)
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. 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.12.5.81-alpine (1/5)
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. 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)
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. 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)
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. 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.12.5.81-alpine (3/5)
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. 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 (3/5)
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. 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)
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, 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)
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.12.5.81-alpine (5/5)
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, 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.12.5.81-alpine (5/5)
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)
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, 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.12.5.81-alpine (4/5)
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, 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)
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. 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.12.5.81-alpine (3/5)
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. 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.12.5.81-alpine (2/5)
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, 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.12.5.81-alpine (2/5)
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 (2/5)
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, 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)
No files were found with the provided path: posthog/tasks/test/__emails__. No artifacts will be uploaded.

Artifacts

Produced during runtime
Name Size
email_renders Expired
63.1 KB