dosubot[bot] commented on issue #29853: URL: https://github.com/apache/superset/issues/29853#issuecomment-2267964198
<!-- Answer --> The issue with SQL Lab stopping working and the `int()` function receiving an argument of type 'set' after upgrading to version 4.0.2 is likely related to a bug introduced in the new version. Specifically, the changelog mentions several fixes related to SQL Lab and database interactions, such as: - [#27646](https://github.com/apache/superset/pull/27646) fix: Leverage actual database for rendering Jinjarized SQL - [#27636](https://github.com/apache/superset/pull/27636) fix(sqllab): unable to remove table - [#27391](https://github.com/apache/superset/pull/27391) fix(sqllab): Close already removed tab - [#27313](https://github.com/apache/superset/pull/27313) fix(sqllab): Missing empty query result state - [#27295](https://github.com/apache/superset/pull/27295) fix(sqllab): invalid dump sql shown after closing tab - [#27181](https://github.com/apache/superset/pull/27181) fix(sqllab): typeahead search is broken in db selector <sup>[[1]](https://github.com/apache/superset/blob/master/CHANGELOG/4.0.0.md)</sup>. To resolve the error related to the `int()` function receiving an argument of type 'set', you should check if there are any updates or patches available that address this specific issue. If not, you may need to manually debug the code to identify where the `int()` function is being called with a 'set' type argument and correct it. Here is a general approach to debug and fix the issue: 1. Identify the part of the code where the `int()` function is being called with a 'set' type argument. 2. Ensure that the argument passed to the `int()` function is of a type that can be converted to an integer, such as a string or a number. For example, if you find code like this: ```python value = some_set result = int(value) ``` You should change it to: ```python value = some_set if isinstance(value, set): value = list(value)[0] # or some other logic to extract a single value result = int(value) ``` Additionally, there are configuration changes and migration steps required when upgrading to version 4.0.2 that could impact SQL Lab functionality. Specifically: 1. **Deprecation of Endpoints**: - The endpoints `/superset/sqllab`, `/superset/sqllab/history`, and `/sqllab/my_queries` have been removed. You should use `/sqllab`, `/sqllab/history`, and `/savedqueryview/list/?_flt_0_user={get_user_id()}` instead <sup>[[2]](https://github.com/apache/superset/blob/master/UPDATING.md)</sup>. 2. **Deprecation of `KV_STORE` Feature Flag**: - The `KV_STORE` feature flag and its related assets such as the API endpoint and `keyvalue` table have been deprecated. This affects the `SHARE_QUERIES_VIA_KV_STORE` feature flag, which allows sharing SQL Lab queries without saving the query <sup>[[2]](https://github.com/apache/superset/blob/master/UPDATING.md)</sup>. 3. **Index Addition**: - An index has been added to `query.sql_editor_id` to improve performance, which may cause downtime on large deployments <sup>[[2]](https://github.com/apache/superset/blob/master/UPDATING.md)</sup>. 4. **Database Column Updates**: - Some database columns have been updated to MediumText, which may require migration steps <sup>[[2]](https://github.com/apache/superset/blob/master/UPDATING.md)</sup>. 5. **Removal of Deprecated Redirect Endpoint**: - The deprecated redirect endpoint has been removed, which may affect existing configurations <sup>[[2]](https://github.com/apache/superset/blob/master/UPDATING.md)</sup>. Review the `CHANGELOG.md` and `UPDATING.md` files, back up your databases, and adjust your feature flags and configurations accordingly. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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]
