dosubot[bot] commented on issue #34078: URL: https://github.com/apache/superset/issues/34078#issuecomment-3040384680
<!-- Answer --> This error happens because Superset expects the database ID to be an integer, but something is sending a string like `"postgresql-examples-1"` instead. This causes the backend to fail when it tries to filter tables by database ID, resulting in the "invalid input syntax for type integer" error and the Table selector showing "No data" ([reference](https://github.com/apache/superset/issues/33914), [reference](https://github.com/apache/superset/issues/33935)). This isn't a regression in how Superset handles database IDs—recent code and issues confirm that IDs must be integers throughout the frontend and backend. UUIDs are supported as extra fields, but not as the primary key for filtering tables ([code reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/databases/api.py)). The most likely cause is that the frontend, a custom integration, or a corrupted browser state is sending a string instead of the integer ID. To resolve this, try clearing your browser's localStorage/sessionStorage and make sure you don't have any custom code or integrations that might be sending the wrong value. Also, double-check that both your frontend and backend are running the same (latest) version. This class of error is a known robustness gap—there's currently no type validation in the backend to catch this before it hits the database ([reference](https://github.com/apache/superset/issues/33935)). If you continue to see this after a clean start, check for any customizations or plugins that might be interfering with the database selector logic. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/71c0da75-d738-42f2-87be-f849de8c77d8?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/71c0da75-d738-42f2-87be-f849de8c77d8?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/71c0da75-d738-42f2-87be-f849de8c77d8?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/71c0da75-d738-42f2-87be-f849de8c77d8?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/71c0da75-d738-42f2-87be-f849de8c77d8?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/71c0da75-d738-42f2-87be-f849de8c77d8?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/71c0da75-d738-42f2-87be-f849de8c77d8?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [! [Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/34078) -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
