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

Sun, 28 Apr 2019 14:05:17 -0700 

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:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to