mysql driver error...

thiagotgc

I'm going up a platform... but it's giving an error when connecting to mysql...

INFO: HikariPool-1 - Starting...
WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
ERROR: HikariPool-1 - Exception during pool initialization. - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - SQLNonTransientConnectionException (... < DataManager:126 < *:85 < Context:290 < Main:120 < ...)2021-08-07 13:05:15 ERROR: Main method error - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - SQLNonTransientConnectionException (... < DataManager:126 < *:85 < Context:290 < Main:120 < ...)

thiagotgc

After a reinstallation, the above error has been fixed.

But now, I get the message:

ERROR: Main method error - Row size too large. The maximum row size for the used table type, not counting

Any idea?

aaP_kotakomputer.ceo

On aaPanel mysql config set:

max_allowed_packet=1024M

Then restart mysql server.

thiagotgc

Unfortunately, the error persists...

ERROR: Main method error - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs - SQLSyntaxErrorException (... < DataManager:281 < *:74 < Context:307 < Main:127 < ...)

aaPanel_Jose

thiagotgc
It seems that the length of some fields in your table is too large.

thiagotgc

Currently this as VARCHAR(128), when I change it to TEXT it accepts!

What does it indicate?