SQL Row size too large
HI,
I got an SQL dataset that was working well for over a month and yesterday I got the error message:
the database reported a syntax error: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
Looking at the raw data the biggest row contain around 6k character. I don't understant why I have the error message. I also tried the ROW_FORMAT=DYNAMIC and ROW_FORMAT=COMPRESSED but it didn't do anything.
Someone know how to remove the error?
thanks,
Comments
-
Column widths are going to be based on either the data type (LONG vs DATETIME vs etc.) or, for text columns, the width of the longest string found in the column across all rows. So though an individual row may be less than 8126, if you had two rows at 5000 each where 4999 was column A and 1 for column B for the first row and the inverse for the 2nd row (columnB is very wide), column A and B would both want to be 5000, but the sum of those two (10k) is greater than the 8126 limit.
1 -
If it wouldn't be a lot of work to pull your data in between tables, you can split your dataset.
Another workaround is to change anywhere you have from varchar to text data type.
Or you can increase the value of the innodb_log_file_size (https://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html#mysqld-5-6-20-innodb).
10 -
I am getting the same error, happen on a random day with no other input changes.
Nothing I do seems to fix this. changed all fields to Text, Still getting error.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive