[BUG] Unhandled AttributeError on empty database queries for GeneralData and CCExtractorVersion
Los mantenedores suelen responder en 4 días
Evaluación
- Dificultad
- 3/5
- Tiempo estimado
- 1-2 días
- Aptitud para principiantes
- 35/100
Línea de trabajo
The crashes are in the .first().value and .first().commit lookups in mod_home/controllers.py, mod_sample/controllers.py and mod_test/controllers.py. Start by reading those three query sites and the existing tests under tests/test_home, tests/test_sample and tests/test_test. Done means the three routes no longer return HTTP 500 on an unseeded database, and the test endpoint raises TestNotFoundException. The reporter says a fix is already in progress, so check with them before starting.
Escrito por el modelo de indexación a partir del texto del issue.
Descripción
Sample platform commit:
ce8539dab74eb7dbc868b89d18060da258ec3ce9
Contributor Checklist
In raising this issue, I confirm the following:
- I have read and understood the [Contributors Guide](https://github.com/CCExtractor/sample-platform/blob/master/.github/CONTRIBUTING.md).
- I have checked that the bug fix I'm reporting can be replicated, or that the feature I'm suggesting isn't already present.
- I have checked that the issue I'm posting hasn't already been reported.
- I have checked that the issue hasn't already been solved and that no duplicates exist in [closed issues](https://github.com/CCExtractor/sample-platform/issues?q=is%3Aissue+is%3Aclosed) or [open issues](https://github.com/CCExtractor/sample-platform/issues).
- I have checked the Pull Requests tab for existing solutions or implementations related to this issue.
Familiarity with the Project
- I have never visited/used the platform.
- I have used the platform just a couple of times.
- I have used the platform extensively, but have not contributed previously.
- I am an active contributor to the platform.
Summary
When sample-platform is initialized on a fresh installation or against an empty database where GeneralData or CCExtractorVersion records have not yet been seeded, multiple endpoints crash with unhandled AttributeError exceptions:
'NoneType' object has no attribute 'value''NoneType' object has no attribute 'commit'
These exceptions result in HTTP 500 responses instead of graceful handling of missing database records.
Affected Routes & Files
1. Homepage (/)
File: mod_home/controllers.py
The following query directly accesses .value on the result of .first():
GeneralData.query.filter(
GeneralData.key == 'last_commit'
).first().value
If the last_commit entry does not exist, .first() returns None, resulting in an AttributeError.
2. Sample Details (/sample/<id>)
File: mod_sample/controllers.py
Two queries are vulnerable to the same issue:
GeneralData.query.filter(
GeneralData.key == 'last_commit'
).first().value
CCExtractorVersion.query.order_by(
CCExtractorVersion.released.desc()
).first().commit
Both queries can return None when the database hasn't been seeded.
Additionally, passing a None commit hash to Test.query.filter(Test.commit == ...) triggers unnecessary database lookups using WHERE commit IS NULL.
3. Platform Tests (/test/by_platform/<platform>)
File: mod_test/controllers.py
The following query crashes when the platform-specific commit entry is missing:
commit_hash = GeneralData.query.filter(
GeneralData.key == 'fetch_commit_' + platform.value
).first().value
Instead of raising the expected TestNotFoundException, the endpoint returns an unhandled HTTP 500 error.
Expected Behavior
- The homepage (
/) should load gracefully even when thelast_commitdatabase entry is missing. - The sample details page (
/sample/<id>) should handle missing commit information without crashing or performing unnecessary database lookups. - The platform tests endpoint (
/test/by_platform/<platform>) should raiseTestNotFoundExceptionwhen no commit entry exists, allowing the application to render the appropriate 404 response instead of returning HTTP 500.
Proposed Solution
-
Add appropriate
Nonechecks around.first()query results in:mod_home/controllers.pymod_sample/controllers.pymod_test/controllers.py
-
Skip downstream
Test.querylookups inmod_sample/controllers.pywhenever the corresponding commit hashes areNone. -
Raise
TestNotFoundExceptioninmod_test/controllers.pywhen no platform-specific commit entry exists. -
Add unit tests covering unseeded database scenarios in:
tests/test_home/test_controllers.pytests/test_sample/test_controllers.pytests/test_test/test_controllers.py
I have implemented a fix along with the corresponding unit tests and am preparing to submit a PR.
- Lenguaje dominante
- Python
- Estrellas
- 31
- Forks
- 92
- Merge medio
- 4 d 9 h
- PR fusionados (30 d)
- 29
Preparar el entorno
- Incluye un Dockerfile o un archivo de Docker Compose
- Tiene una plantilla de pull request
- Leer la guía de contribución
Primeros pasos
- Lee el issue completo y luego la guía de contribución del proyecto.
- Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
- Haz un fork del repositorio y trabaja en una rama.
- Abre un pull request que haga referencia al número del issue.
Más de CCExtractor/sample-platform
-
Dificultad 3/5 1-2 días Aptitud para principiantes 72/100
CCExtractor/sample-platform#1273 · 1 comentario ·
Los mantenedores suelen responder en 4 días
-
[BUG] `TypeError: 'ContentFile' object is not subscriptable` in mod_upload when creating GitHub issuePosiblemente ocupada @garv-sanveria la tomó hace 16 días. Abierto
Dificultad 2/5 1-3 horas Aptitud para principiantes 30/100
CCExtractor/sample-platform#1261 ·
Los mantenedores suelen responder en 4 días
-
[BUG] Missing timeouts on 5 outbound HTTP calls outside mod_ci (follow-up to #943)Posiblemente ocupada @devnishantt la tomó hace 54 días. Abierto
Dificultad 3/5 1-2 días Aptitud para principiantes 84/100
CCExtractor/sample-platform#1192 · 2 comentarios ·
Los mantenedores suelen responder en 4 días
-
[Feature Request] Improve comparison algorithm to handle frame offsets intelligently (GSoC Qualification)Quizá libre de nuevo Un pull request para esta issue se cerró sin fusionarse. Abierto
Dificultad 4/5 3-5 días Aptitud para principiantes 48/100
CCExtractor/sample-platform#1079 ·
Los mantenedores suelen responder en 4 días
-
[BUG] never-worked baseline handling is not fully integrated into trusted CI reportingQuizá libre de nuevo Un pull request para esta issue se cerró sin fusionarse. Abierto
Dificultad 4/5 3-5 días Aptitud para principiantes 42/100
CCExtractor/sample-platform#1057 · 2 comentarios ·
Los mantenedores suelen responder en 4 días
Todos los issues de CCExtractor/sample-platform
Issues similares
-
[Bug]: DoubleMLData.from_arrays checks the treatment d with force_all_x_finite instead of force_all_d_finitePosiblemente ocupada @leninworld la tomó hoy. Abierto
Dificultad 1/5 Menos de una hora Aptitud para principiantes 88/100
DoubleML/doubleml-for-py#471 ·
Los mantenedores suelen responder en 1 día
-
Dificultad 2/5 1-3 horas Aptitud para principiantes 82/100
python-pillow/Pillow#10590 ·
Los mantenedores suelen responder en 1 día
-
Dificultad 1/5 Menos de una hora Aptitud para principiantes 85/100
-
Dificultad 2/5 1-3 horas Aptitud para principiantes 62/100
Los mantenedores suelen responder en 1 día
-
BUG: ZarrTrace fails in init_trace for models with datetime coordinates (object dtype coord array)Abierto
Dificultad 2/5 1-3 horas Aptitud para principiantes 74/100
Los mantenedores suelen responder en 2 días