[GitHub] [superset] Hisssy commented on issue #5072: Limit in "Upload CSV data"

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

Hisssy commented on issue #5072:
URL: https://github.com/apache/superset/issues/5072#issuecomment-1139304245

   I've encountered this problem recently in Superset v1.5.0. In my case, the root cause seems to be encoding incompatibility.
   
   The size of csv file to be uploaded was about 2.1MB (12000 rows) and the error log looked the same as others: 
   
   > /home/me/venv38/lib64/python3.8/site-packages/werkzeug/wrappers/[base_response.py:468](http://base_response.py:468/): UserWarning: The "b'session'" cookie is too large: the value was 19232 bytes but the header required 40 extra bytes. The final size was 19272 bytes but the limit is 4093 bytes. Browsers may silently ignore cookies larger than this.
   
   There's something wrong with the size of the file (2M is not large enough), so I tried to upload a small csv with only 10 lines in it to shrink the cookie size and got the real error in the response:
   > (1366, "Incorrect string value: '\\xE4\\xBD\\xA0\\xE5\\xA5\\xBD' for column 'name' at row 1")
   
   With a little googling, this error might be related to inserting rows containing non-latin charater into latin encoding backend MySQL db. After changing default charset, csv upload worked like a charm.


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