Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG-python/deployment] Error getting dataset progress when with_users_distribution=True #5776

Open
DavinciEvans opened this issue Jan 6, 2025 · 0 comments
Labels
type: bug Indicates an unexpected problem or unintended behavior

Comments

@DavinciEvans
Copy link

Describe the bug

I use this code to trace my team progress, but it raise httpx.RemoteProtocolError: peer closed connection without sending complete message body (incomplete chunked read)

import argilla as rg

client = rg.Argilla(api_url="<api_url>", api_key="<api_key>")

dataset = client.datasets("my_dataset")

progress = dataset.progress(with_users_distribution=True)

I check the server logs and got this error

sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.ProgrammingError: <class 'asyncpg.exceptions.GroupingError'>: column "users.inserted_at" must appear in the GROUP BY clause or be used in an aggregate function

...

sqlalchemy.exc.ProgrammingError: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.GroupingError'>: column "users.inserted_at" must appear in the GROUP BY clause or be used in an aggregate function

[SQL: SELECT users.username, records.status, responses.status AS status_1, count(responses.id) AS count_1 

FROM responses JOIN records ON records.id = responses.record_id JOIN users ON users.id = responses.user_id 

WHERE records.dataset_id = $1::UUID GROUP BY users.username, records.status, responses.status ORDER BY users.inserted_at ASC]

[parameters: (UUID('a568022e-1467-4c27-93e9-d8c2a8dee650'),)]

please fix it, thank you.

Stacktrace and code to create the bug

No response

Expected behavior

No response

Environment

I use the latest offical docker compose.

Additional context

No response

@frascuchon frascuchon self-assigned this Jan 10, 2025
@frascuchon frascuchon added the type: bug Indicates an unexpected problem or unintended behavior label Jan 10, 2025
@frascuchon frascuchon removed their assignment Jan 10, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: bug Indicates an unexpected problem or unintended behavior
Projects
None yet
Development

No branches or pull requests

2 participants