Realtime dropping connection intermittently

[supabase]

Realtime dropping connection intermittently

[awalias]

fixed in 0.7.2

[kiwicopple]

Dubugged these a bit
I think the culprit is this line.

As DELETE transactions don't have change.record to enumerate over (unless the user has set REPLICA IDENTITY FULL in postgres). It does have the "old_record" though (i think), so we might be able to enumerate over that instead

[kiwicopple]

Looks good. The patch for the other issue just a matter of wrapping this block with an if change.record

The reason why (i think) is that this function is getting called when the replication starts, and there are no actual changes in the transaction.

Let's test your changes for now though. Do you need me to push to docker hub?

[awalias]

last remaining thing to fix is 04:33:14.166 [error] GenServer #PID<0.2513.0> terminating ** (KeyError) key :record not found in: %Realtime.Adapters.Changes.DeletedRecord{columns: [%Realtime.Decoder.Messages.Relation.Column{flags: [:key], name: "id", type: "int8", type_modifier: 4294967295}, %Realtime.Decoder.Messages.Relation.Column{flags: [:key], name: "inserted_at", type: "timestamp", type_modifier: 4294967295}, %Realtime.Decoder.Messages.Relation.Column{flags: [:key], name: "updated_at", type: "timestamp", type_modifier: 4294967295}, %Realtime.Decoder.Messages.Relation.Column{flags: [:key], name: "data", type: "jsonb", type_modifier: 4294967295}, %Realtime.Decoder.Messages.Relation.Column{flags: [:key], name: "message", type: "text", type_modifier: 4294967295}, %Realtime.Decoder.Messages.Relation.Column{flags: [:key], name: "user_id", type: "int8", type_modifier: 4294967295}, %Realtime.Decoder.Messages.Relation.Column{flags: [:key], name: "channel_id", type: "int8", type_modifier: 4294967295}], commit_timestamp: ~U[2020-03-16 04:33:14Z], old_record: %{"channel_id" => "1", "data" => nil, "id" => "50", "inserted_at" => "2020-03-16 04:33:14.144909", "message" => "delete test", "updated_at" => "2020-03-16 04:33:14.144909", "user_id" => "1"}, schema: "public", table: "messages", type: "DELETE"}

[awalias]

oh sorry just saw you already posted the fix above, will make the change now, I tested the previous fix and it works well