[GitHub] [incubator-superset] rjurney opened a new issue #7400: SQL Lab preview of wb_health_population locks up Superset Flask server until it dies

[GitBox <gi...@apache.org>]

rjurney opened a new issue #7400: SQL Lab preview of wb_health_population locks up Superset Flask server until it dies
URL: https://github.com/apache/incubator-superset/issues/7400
 
 
   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:
   
   ```bash
   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 ](http://rjurneyopen.s3.amazonaws.com/superset_wb_health_error.png)
   
   #### How to reproduce the bug
   
   0. Load the examples
   1. Go to 'SQL Lab'
   2. Click on 'Database': 'main'
   3. Click on 'Schema': 'main'
   3. Type in 'wb_health_population' under 'See table schema'
   4. Click in Preview: `wb_health_population` tab at bottom right
   5. See 'Running...' appear and never go away
   6. Try to use the app in any other way that generates a web request to the server. See the errors occur.
   7. 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.
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org