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

Table 'db.semantic_drilldown_values' doesn't exist #97

Closed
YvarRavy opened this issue Feb 10, 2025 · 2 comments
Closed

Table 'db.semantic_drilldown_values' doesn't exist #97

YvarRavy opened this issue Feb 10, 2025 · 2 comments

Comments

@YvarRavy
Copy link
Contributor

/index.php/Speciaal:GegevensBekijken/Projecten   Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'db.semantic_drilldown_values' doesn't exist
Function: Wikimedia\Rdbms\DBConnRef::query
Query: SELECT COUNT(DISTINCT sdv.id) FROM semantic_drilldown_values sdv
        JOIN `wiki_smw_fpt_inst` inst
        ON sdv.id = inst.s_id
        WHERE inst.o_id IN
                (SELECT MIN(smw_id) FROM `wiki_smw_object_ids`
                WHERE smw_namespace = 14 AND (smw_title = 'Actieve_salesfunnel' ))

When trying to use special:BrowseData, i got this error.
when looking in the code i see that this is a temporary table that gets created on the DB_PRIMARY. but then when trying to read values from the temp table the code uses the DB_REPLICA. it seems the case when im on my cluster of DB's that only the master DB has the temp table but my replica doesn't so i get this exception.

the fix seems quite simple.
when using the temporary table just always try and use the DB_PRIMARY to read from it

@paladox
Copy link
Contributor

paladox commented Feb 10, 2025

@YvarRavy are you able to do a pull for that please? Maybe it'll fix the tests as well?

@YvarRavy
Copy link
Contributor Author

@paladox yeah. i'll provide a pull and also check out if the tests are fixed with this

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants