narrowizard opened a new issue, #8548: URL: https://github.com/apache/incubator-devlake/issues/8548
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened When using Apache DevLake to collect development data from third-party platforms, pipelines are not running as expected. Specifically, a large number of pipelines are created but none are in a running state. The error logs show the following message: ``` time="2025-08-21 04:14:00" level=error msg=" [pipeline service] dequeue failed\n\tcaused by: ERROR: column \"_devlake_pipelines.priority\" must appear in the GROUP BY clause or be used in an aggregate function (SQLSTATE 42803) (500)\n\tWraps: (2) ERROR: column \"_devlake_pipelines.priority\" must appear in the GROUP BY clause or be used in an aggregate function (SQLSTATE 42803)\n\tError types: (1) *hintdetail.withDetail (2) *pgconn.PgError" ``` This issue occurs while using a PostgreSQL database. We suspect it may be related to changes introduced in PR #8534, which could have affected pipeline querying or dequeuing logic. ### What do you expect to happen Pipelines should dequeue and run normally without SQL errors. Created pipelines should transition to a running state as intended, allowing data collection from third-party platforms to proceed successfully. ### How to reproduce 1. Set up Apache DevLake with a PostgreSQL database as the backend. 2. Configure and create multiple pipelines to ingest data from third-party DevOps platforms (e.g., GitHub, Jira, or similar tools). 3. Attempt to run the pipelines. 4. Observe that pipelines remain in a created state without any running, and check the logs for the GROUP BY error on the "_devlake_pipelines.priority" column. ### Anything else Pg version: 17.2 ### Version main ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
