[BUG] Unhandled AttributeError on empty database queries for GeneralData and CCExtractorVersion
Mantenedores costumam responder em até 4 dias
Avaliação
- Dificuldade
- 3/5
- Tempo estimado
- 1-2 dias
- Facilidade para iniciantes
- 35/100
Direção de pesquisa
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.
Escrita pelo modelo de indexação a partir do texto da issue.
Descrição
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.
- Linguagem predominante
- Python
- Estrelas
- 31
- Forks
- 92
- Merge médio
- 4d 9h
- PRs com merge (30d)
- 29
Preparar o ambiente
- Inclui um Dockerfile ou arquivo Docker Compose
- Tem um modelo de pull request
- Ler o guia de contribuição
Primeiros passos
- Leia a issue inteira e depois o guia de contribuição do projeto.
- Comente na issue dizendo que vai assumir — evita que duas pessoas façam o mesmo trabalho.
- Faça um fork do repositório e trabalhe em uma branch.
- Abra um pull request que referencie o número da issue.
Mais de CCExtractor/sample-platform
-
Dificuldade 3/5 1-2 dias Facilidade para iniciantes 72/100
CCExtractor/sample-platform#1273 · 1 comentário ·
Mantenedores costumam responder em até 4 dias
-
[BUG] `TypeError: 'ContentFile' object is not subscriptable` in mod_upload when creating GitHub issueTalvez já em andamento @garv-sanveria assumiu há 17 dias. Aberta
Dificuldade 2/5 1-3 horas Facilidade para iniciantes 30/100
CCExtractor/sample-platform#1261 ·
Mantenedores costumam responder em até 4 dias
-
[BUG] Missing timeouts on 5 outbound HTTP calls outside mod_ci (follow-up to #943)Talvez já em andamento @devnishantt assumiu há 54 dias. Aberta
Dificuldade 3/5 1-2 dias Facilidade para iniciantes 84/100
CCExtractor/sample-platform#1192 · 2 comentários ·
Mantenedores costumam responder em até 4 dias
-
[Feature Request] Improve comparison algorithm to handle frame offsets intelligently (GSoC Qualification)Talvez livre de novo Um pull request para esta issue foi fechado sem ser mesclado. Aberta
Dificuldade 4/5 3-5 dias Facilidade para iniciantes 48/100
CCExtractor/sample-platform#1079 ·
Mantenedores costumam responder em até 4 dias
-
[BUG] never-worked baseline handling is not fully integrated into trusted CI reportingTalvez livre de novo Um pull request para esta issue foi fechado sem ser mesclado. Aberta
Dificuldade 4/5 3-5 dias Facilidade para iniciantes 42/100
CCExtractor/sample-platform#1057 · 2 comentários ·
Mantenedores costumam responder em até 4 dias
Todas as issues de CCExtractor/sample-platform
Issues semelhantes
-
Dificuldade 2/5 1-3 horas Facilidade para iniciantes 62/100
Mantenedores costumam responder em até 1 dia
-
enhancement
Dificuldade 2/5 1-3 horas Facilidade para iniciantes 68/100
dgunning/edgartools#2019 ·
Mantenedores costumam responder em até 1 dia
-
Dificuldade 2/5 1-3 horas Facilidade para iniciantes 62/100
topoteretes/cognee#6818 · 1 comentário ·
Mantenedores costumam responder em até 1 dia
-
source_verification_agent: no outcome when the publisher confirms a work but its DOI resolves to a different recordTalvez já em andamento @pinjun99 assumiu hoje. Aberta
Dificuldade 2/5 1-3 horas Facilidade para iniciantes 68/100
Imbad0202/academic-research-skills#1159 · 1 comentário ·
Mantenedores costumam responder em até 1 dia
-
[Bug]: DoubleMLData.from_arrays checks the treatment d with force_all_x_finite instead of force_all_d_finiteTalvez já em andamento @leninworld assumiu hoje. Aberta
Dificuldade 1/5 Menos de uma hora Facilidade para iniciantes 88/100
DoubleML/doubleml-for-py#471 ·
Mantenedores costumam responder em até 1 dia