On some phone hotspots and hotel wifi ssh and ftp can be blocked. In the case where ssh is blocked and you pull or push, Local will delete the db but then not be able to replace it. A better functionality would be to check if it can be pushed successfully first to avoid leaving sites in a broken state.
Check this section of the logs which shows the problem:
{"thread":"main","class":"","level":"info","message":"Pushing database to the remote server\n","timestamp":"2020-09-10T15:47:58.414Z"}
{"thread":"main","class":"","level":"info","message":"Success: Exported to 'sites/gdsdev/_wpeprivate/push-1599752878413.sql'.\n","timestamp":"2020-09-10T15:48:09.875Z"}
{"thread":"main","class":"","level":"info","message":"Deleting remote database\n","timestamp":"2020-09-10T15:48:10.070Z"}
{"thread":"main","class":"","level":"info","message":"Success: Database reset.\n","timestamp":"2020-09-10T15:48:22.027Z"}
{"thread":"main","class":"","level":"info","message":"Dumping local database and uploading to target\n","timestamp":"2020-09-10T15:48:22.133Z"}
{"thread":"main","class":"","message":"local+rsync+push+db+gdsdev@gdsdev.ssh.wpengine.net: Permission denied (publickey).\r\n","level":"warn","timestamp":"2020-09-10T15:48:58.617Z"}
{"thread":"main","class":"","message":"rsync: connection unexpectedly closed (0 bytes received so far) [sender]\nrsync error: unexplained error (code 255) at /BuildRoot/Library/Caches/com.apple.xbs/Sources/rsync/rsync-54/rsync/io.c(453) [sender=2.6.9]\n","level":"warn","timestamp":"2020-09-10T15:48:58.618Z"}
{"thread":"main","class":"","level":"info","message":"\u001b[1;31m\rError: \u001b[0mUnable to push: exit status 255\n","timestamp":"2020-09-10T15:48:58.623Z"}
{"thread":"main","class":"","message":"attempting to read the remote table prefix","level":"info","timestamp":"2020-09-10T15:48:58.682Z"}
{"thread":"main","class":"","level":"info","message":"wp_\n","timestamp":"2020-09-10T15:49:12.340Z"}