jinmengcheng opened a new issue, #29836:
URL: https://github.com/apache/superset/issues/29836
### Bug description
Hi Superset developers:
I am trying to upgrade superset 3.0.1 to 4.0.2, main features looks good so
far, but there is a small problem when I am trying to use Tag system, please
check the screenshot as attached, favorite tag feature seems not available,
after check log, error trace shows "user_favorite_tag" table not exists, it
seems "superset db upgrade" not patched revision "e0f6f91c2055" to DB, but the
"superset db history" shows "e0f6f91c2055" has been applied, would you please
take a look?
ENV:
Docker
MacOS/Safari
superset version: 3.0.1 -> 4.0.2
Stack trace:
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py",
line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/sql/elements.py",
line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py",
line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py",
line 1862, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py",
line 2043, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/util/compat.py",
line 207, in raise_
raise exception
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py",
line 1819, in _execute_context
self.dialect.do_execute(
File
"/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line
732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation
"user_favorite_tag" does not exist
LINE 2: FROM user_favorite_tag
^
[SQL: SELECT user_favorite_tag.tag_id AS user_favorite_tag_tag_id
FROM user_favorite_tag
WHERE user_favorite_tag.tag_id IN (%(tag_id_1_1)s, %(tag_id_1_2)s,
%(tag_id_1_3)s, %(tag_id_1_4)s, %(tag_id_1_5)s) AND user_favorite_tag.user_id =
%(user_id_1)s]
<img width="1721" alt="image"
src="https://github.com/user-attachments/assets/77cefc97-f5be-42c5-91b8-2511d36f4d34";>
<img width="1032" alt="image"
src="https://github.com/user-attachments/assets/5b052c8a-b49a-41a2-bee5-17212314e0fe";>
<img width="693" alt="image"
src="https://github.com/user-attachments/assets/0837c64f-61d0-46d7-a096-1e13e2341016";>
<img width="1028" alt="image"
src="https://github.com/user-attachments/assets/8a0b9e52-1c1c-4a65-b6a2-07488a5cd556";>
<img width="1516" alt="image"
src="https://github.com/user-attachments/assets/83ba7d80-c47b-40cc-90e3-ab19bb2f0082";>
### How to reproduce the bug
1. superset 3.0.1 installed on a clean machine, and everything works(make
sure DB tables are created)
2. git clone source code to local
3. run: TAG=4.0.2 docker compose -f docker-compose-non-dev.yml up
4. check DB tables to see if "user_favorite_tag" table exits
### Screenshots/recordings
_No response_
### Superset version
4.0.2
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [X] I have searched Superset docs and Slack and didn't find a solution to
my problem.
- [X] I have searched the GitHub issue tracker and didn't find a similar bug
report.
- [X] I have checked Superset's logs for errors and if I found a relevant
Python stacktrace, I included it here as text in the "additional context"
section.
--
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]
