[google-cloud-sql-discuss] Re: Postgres 11 issue: "SSL error: DATA_LENGTH_TOO_LONG"

FYI this was caused by a JDK issue with TLS v1.3, addressed in JDK 11.05. Google will likely upgrade the JDK used for the Cloud Functions JVMs from 11.04 to something newer next week. See https://bugs.openjdk.java.net/browse/JDK-8221253

On Monday, February 24, 2020 at 5:04:40 PM UTC-8, Hans Ravnaas wrote:

Looking for any thoughts on what is going on here:

Environment:

• Java 11 GCP Function to copies data into table
  
• Postgres 11 Cloud SQL using JDBC driver (org.postgresql:postgresql:42.2.5)
• No changes to any code or configuration in 2 weeks.

Prior to this Saturday (2/22), everything was working fine. We are using Postgres' CopyManager to load data into a table: copyManager.copyIn(sql, this.reader);

After 2/22, this started failing with "SSL error: DATA_LENGTH_TOO_LONG". These failures are 100% consistent and still happen. I can see that SQL was restarted by Google a few hours before the issue started and I'm wondering if this is somehow related to whatever maintenance happened, SQL version upgrade? I'm unclear what version we had before Saturday, but it's now 11.6.

Interestingly enough, I can avoid the error if the file loaded into the table is under a certain size:

• 14,052 bytes (16 KB on disk): This fails every time.
  
• 14,051 bytes (16 KB on disk): This works every time.
  

I'd appreciate if someone from Google could confirm what took place during the maintenance window that might be causing this error. We are currently blocked by this as we load much larger datasets into the database than ~14 000 bytes.

NOTE: This is happening across two different GCP projects and SQL servers.

Thanks,

Hans

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/29bcd95a-3c5d-4142-97b4-844c57ac1ee5%40googlegroups.com.