You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/06/25 14:23:10 UTC

[GitHub] [superset] fxulusoy commented on issue #13080: HELM CHART: After successful deployment and login, internal query with SQL Alchemy fails

fxulusoy commented on issue #13080:
URL: https://github.com/apache/superset/issues/13080#issuecomment-868536763


   I am also experiencing with the same problem. It doesn't happen all time. But it happens quite often. 
   
   Here is the logs from ` superset-init-db` pod:
   
   ```
   INFO:superset.security.manager:Creating missing datasource permissions.                                                                                                                                                                                                                 
    Loaded your LOCAL configuration at [/app/pythonpath/superset_config.py]                                                                                                                                                                                                                 
    Traceback (most recent call last):                                                                                                                                                                                                                                                      
      File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context                                                                                                                                                                               
        cursor, statement, parameters, context                                                                                                                                                                                                                                              
      File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute                                                                                                                                                                                   
        cursor.execute(statement, parameters)                                                                                                                                                                                                                                               
    psycopg2.errors.UndefinedTable: relation "tables" does not exist                                                                                                                                                                                                                        
    LINE 2: FROM tables                                                                                                                                                                                                                                                                     
                 ^                                                                                                                                                                                                                                                                          
    The above exception was the direct cause of the following exception:                                                                                                                                                                                                                    
    Traceback (most recent call last):                                                                                                                                                                                                                                                      
      File "/usr/local/bin/superset", line 33, in <module>                                                                                                                                                                                                                                  
        sys.exit(load_entry_point('apache-superset', 'console_scripts', 'superset')())                                                                                                                                                                                                      
      File "/usr/local/lib/python3.7/site-packages/click/core.py", line 829, in __call__                                                                                                                                                                                                    
        return self.main(*args, **kwargs)                                                                                                                                                                                                                                                   
      File "/usr/local/lib/python3.7/site-packages/flask/cli.py", line 586, in main                                                                                                                                                                                                         
        return super(FlaskGroup, self).main(*args, **kwargs)                                                                                                                                                                                                                                
      File "/usr/local/lib/python3.7/site-packages/click/core.py", line 782, in main                                                                                                                                                                                                        
        rv = self.invoke(ctx)                                                                                                                                                                                                                                                               
      File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1259, in invoke                                                                                                                                                                                                     
        return _process_result(sub_ctx.command.invoke(sub_ctx))                                                                                                                                                                                                                             
      File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1066, in invoke                                                                                                                                                                                                     
        return ctx.invoke(self.callback, **ctx.params)                                                                                                                                                                                                                                      
      File "/usr/local/lib/python3.7/site-packages/click/core.py", line 610, in invoke                                                                                                                                                                                                      
        return callback(*args, **kwargs)                                                                                                                                                                                                                                                    
      File "/usr/local/lib/python3.7/site-packages/click/decorators.py", line 21, in new_func                                                                                                                                                                                               
        return f(get_current_context(), *args, **kwargs)                                                                                                                                                                                                                                    
      File "/usr/local/lib/python3.7/site-packages/flask/cli.py", line 426, in decorator                                                                                                                                                                                                    
        return __ctx.invoke(f, *args, **kwargs)                                                                                                                                                                                                                                             
      File "/usr/local/lib/python3.7/site-packages/click/core.py", line 610, in invoke                                                                                                                                                                                                      
        return callback(*args, **kwargs)                                                                                                                                                                                                                                                    
      File "/usr/local/lib/python3.7/site-packages/click/decorators.py", line 21, in new_func                                                                                                                                                                                               
        return f(get_current_context(), *args, **kwargs)                                                                                                                                                                                                                                    
      File "/usr/local/lib/python3.7/site-packages/flask/cli.py", line 426, in decorator                                                                                                                                                                                                    
        return __ctx.invoke(f, *args, **kwargs)                                                                                                                                                                                                                                             
      File "/usr/local/lib/python3.7/site-packages/click/core.py", line 610, in invoke                                                                                                                                                                                                      
        return callback(*args, **kwargs)                                                                                                                                                                                                                                                    
      File "/app/superset/cli.py", line 90, in init        
      security_manager.sync_role_definitions()                                                                                                                                                                                                                                            
     File "/app/superset/security/manager.py", line 634, in sync_role_definitions                                                                                                                                                                                                          
       self.create_missing_perms()                                                                                                                                                                                                                                                         
     File "/app/superset/security/manager.py", line 576, in create_missing_perms                                                                                                                                                                                                           
       datasources = ConnectorRegistry.get_all_datasources(self.get_session)                                                                                                                                                                                                               
     File "/app/superset/connectors/connector_registry.py", line 73, in get_all_datasources                                                                                                                                                                                                
       datasources.extend(qry.all())                                                                                                                                                                                                                                                       
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3373, in all                                                                                                                                                                                              
       return list(self)                                                                                                                                                                                                                                                                   
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__                                                                                                                                                                                         
       return self._execute_and_instances(context)                                                                                                                                                                                                                                         
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances                                                                                                                                                                           
       result = conn.execute(querycontext.statement, self._params)                                                                                                                                                                                                                         
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1011, in execute                                                                                                                                                                                        
       return meth(self, multiparams, params)                                                                                                                                                                                                                                              
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection                                                                                                                                                                         
       return connection._execute_clauseelement(self, multiparams, params)                                                                                                                                                                                                                 
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement                                                                                                                                                                         
       distilled_params,                                                                                                                                                                                                                                                                   
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context                                                                                                                                                                               
       e, statement, parameters, cursor, context                                                                                                                                                                                                                                           
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception                                                                                                                                                                        
       sqlalchemy_exception, with_traceback=exc_info[2], from_=e                                                                                                                                                                                                                           
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 182, in raise_                                                                                                                                                                                          
       raise exception                                                                                                                                                                                                                                                                     
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context                                                                                                                                                                               
       cursor, statement, parameters, context                                                                                                                                                                                                                                              
     File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute                                                                                                                                                                                   
       cursor.execute(statement, parameters)                                                                                                                                                                                                                                               
   sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "tables" does not exist                                                                                                                                                                                      
   LINE 2: FROM tables                                                                                                                                                                                                                                                                     
                ^                                                                                                                                                                                                                                                                          
   [SQL: SELECT tables.uuid AS tables_uuid, tables.created_on AS tables_created_on, tables.changed_on AS tables_changed_on, tables.id AS tables_id, tables.description AS tables_description, tables.default_endpoint AS tables_default_endpoint, tables.is_featured AS tables_is_featured 
   FROM tables                                                                                                                                                                                                                                                                             
   WHERE tables.is_sqllab_view = false]                                                                                                                                                                                                                                                    
   (Background on this error at: http://sqlalche.me/e/13/f405)                                                                                                                                                                                                                             
   Creating admin user...                                                                                                                                                                                                                                                                  
   logging was configured successfully           
   ```
   
   I see the following error messages when I try to open the login page:
   
   ![Screenshot 2021-06-25 at 16 21 18](https://user-images.githubusercontent.com/1167958/123438926-80c1d580-d5d1-11eb-94e5-aa2e4da62f90.png)
   


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



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