Troubleshooting PostgreSQL Serialization Issue During Scheduled Ingestions

troubleshoot
1

Original Slack Thread

Hello Community,
Recently I migrate our metadata from MySQL database to PostgreSQL database. After that, we started to use the PostgreSQL instance for our deployment and we had no problemns with users experience. However, we started to have the following(image bellow) problemns during scheduled ingestions. Does anyone know what could cause it?

attachment
attachment1388×419 121 KB

2

Hi, this seems like a serialization issue - could you try the steps in this thread & share how it goes? :slightly_smiling_face: https://datahubspace.slack.com/archives/C029A3M079U/p1685435210367549?thread_ts=1680630315.514719&cid=C029A3M079U

3

Thank you <@U04QRNY4ZHA>!
I followed the steps and it really worked, but I’m afraid this issue will come back when MAE and MCE consumers scale to more than 1 replica.