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

SQL Lab preview of wb_health_population locks up Superset Flask server until it dies #7400

Open
rjurney opened this issue Apr 28, 2019 · 1 comment

Comments

Projects
None yet
1 participant
@rjurney
Copy link
Contributor

commented Apr 28, 2019

If you select wb_health_population in SQL Lab under 'See table schema' and the preview window tries to do its thing, it will never finish and the server process will freeze and will not serve any other requests until you kill it and restart.

Expected results

I expect to see a preview of the wb_health_table, and for the application to keep running therafter.

Actual results

Instead the application displays 'Running...' and never responds to another web request until you kill it and restart it. The console has the following messages flying by forever, even after an hour:

2019-04-28 13:50:10,724:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,724:DEBUG:root:  None"SP_POP_DPND_YG"
2019-04-28 13:50:10,724:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,724:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,724:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,724:DEBUG:root:  None"SP_POP_GROW"
2019-04-28 13:50:10,724:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,724:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,724:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,724:DEBUG:root:  None"SP_POP_TOTL"
2019-04-28 13:50:10,725:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,725:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,725:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,725:DEBUG:root:  None"SP_POP_TOTL_FE_IN"
2019-04-28 13:50:10,725:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,725:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,725:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,725:DEBUG:root:  None"SP_POP_TOTL_FE_ZS"
2019-04-28 13:50:10,725:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,725:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,725:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,725:DEBUG:root:  None"SP_POP_TOTL_MA_IN"
2019-04-28 13:50:10,726:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,726:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,726:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,726:DEBUG:root:  None"SP_POP_TOTL_MA_ZS"
2019-04-28 13:50:10,726:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,726:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,726:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,726:DEBUG:root:  None"SP_REG_BRTH_RU_ZS"
2019-04-28 13:50:10,726:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,726:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,726:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,726:DEBUG:root:  None"SP_REG_BRTH_UR_ZS"
2019-04-28 13:50:10,726:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,726:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,727:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,727:DEBUG:root:  None"SP_REG_BRTH_ZS"
2019-04-28 13:50:10,727:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,727:DEBUG:root:  Token.Text.Whitespace.Newline

2019-04-28 13:50:10,727:DEBUG:root:  Token.Text.Whitespace
2019-04-28 13:50:10,727:DEBUG:root:  None"SP_REG_DTHS_ZS"
2019-04-28 13:50:10,727:DEBUG:root:  Token.Punctuation,
2019-04-28 13:50:10,727:DEBUG:root:  Token.Text.Whitespace.Newline

... endless stream ...

Screenshots

Error message/Running ... in preview window of SQL Lab

How to reproduce the bug

  1. Load the examples
  2. Go to 'SQL Lab'
  3. Click on 'Database': 'main'
  4. Click on 'Schema': 'main'
  5. Type in 'wb_health_population' under 'See table schema'
  6. Click in Preview: wb_health_population tab at bottom right
  7. See 'Running...' appear and never go away
  8. Try to use the app in any other way that generates a web request to the server. See the errors occur.
  9. Check the console or logs to see the strange column problems...

Environment

  • OS: Ubuntu 18.04, OS X 10.14.4
  • superset version: [release--0.31, b3aa5633]
  • python version: 3.6.7, 3.6.8, 3.7.3
  • node.js version: v11.6.0
  • npm version: 6.5.0

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

  • [*] I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • [*] I have reproduced the issue with at least the latest released version of superset.
  • [*] I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

@issue-label-bot

This comment has been minimized.

Copy link

commented Apr 28, 2019

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.92. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

@issue-label-bot issue-label-bot bot added the #bug label Apr 28, 2019

@mistercrunch mistercrunch referenced this issue Apr 29, 2019

Merged

[fix] Fixing SQL parsing issue #7374

1 of 6 tasks complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.