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/10/29 20:30:34 UTC

[GitHub] [superset] jhult opened a new issue #17291: SAWarning: Oracle version - maximum identifier length

jhult opened a new issue #17291:
URL: https://github.com/apache/superset/issues/17291


   A clear and concise description of what the bug is.
   
   #### How to reproduce the bug
   
   ```
   /usr/local/lib/python3.8/site-packages/sqlalchemy/dialects/oracle/base.py:1409: SAWarning: Oracle version (19, 13, 0, 1, 0) is known to have a maximum identifier length of 128, rather than the historical default of 30. SQLAlchemy 1.4 will use 128 for this database; please set max_identifier_length=128 in create_engine() in order to test the application with this new length, or set to 30 in order to assure that 30 continues to be used.  In particular, pay close attention to the behavior of database migrations as dynamically generated names may change. See the section 'Max Identifier Lengths' in the SQLAlchemy Oracle dialect documentation for background.
   ```
   
   ### Expected results
   
   No warning to occur.
   
   ### Actual results
   
   I receive the above warning.
   
   ### Environment
   
   (please complete the following information):
   
   - Docker: Using a Dockerfile similar to this: https://github.com/jhult/superset/commit/ae374f1d6b2830910cf9120c8d8f2aae943265b9
   - browser type and version: All
   - superset version: `superset version`: latest master
   - python version: `python --version`: 3.8.12
   - any feature flags active:
   ```
   FEATURE_FLAGS = {
       "DASHBOARD_NATIVE_FILTERS": True,
       "DASHBOARD_CROSS_FILTERS": True,
       "DASHBOARD_NATIVE_FILTERS_SET": True,
       "DASHBOARD_FILTERS_EXPERIMENTAL": True,
       "ENFORCE_DB_ENCRYPTION_UI": True,
       "DASHBOARD_RBAC": True,
       "OMNIBAR": True,
       "TAGGING_SYSTEM": True,
       "SQLLAB_BACKEND_PERSISTENCE": True,
       "LISTVIEWS_DEFAULT_CARD_VIEW": True,
       "ALERT_REPORTS": True,
       "ENABLE_TEMPLATE_PROCESSING": True,
       "UX_BETA": True
   }
   ```
   
   ### Checklist
   
   - [x] 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.
   - [x] I have checked the issue tracker for the same issue and I haven't found one similar.
   


-- 
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


[GitHub] [superset] sergun commented on issue #17291: SAWarning: Oracle version - maximum identifier length

Posted by GitBox <gi...@apache.org>.
sergun commented on issue #17291:
URL: https://github.com/apache/superset/issues/17291#issuecomment-1084773481


   @jhult do you have other problems likely connected to this issue? I see that sometimes Superset substituces long field names with some numeric preficies like "_1". That causes error messages.
   See https://github.com/apache/superset/issues/19468


-- 
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


[GitHub] [superset] jhult commented on issue #17291: SAWarning: Oracle version - maximum identifier length

Posted by GitBox <gi...@apache.org>.
jhult commented on issue #17291:
URL: https://github.com/apache/superset/issues/17291#issuecomment-1085273476


   @sergun, I don't believe I've seen any other issues that I believe are connected to this.


-- 
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