It's kind of hard to explain so here's a video of it happening, this only happens when the chunk is not loaded (ex. leaving server and opening a single player world for about 4 minutes, then rejoining server) or sometimes when the server reboots or simply just rejoining a server.
Steps to reproduce:
Place down a boat in one chunk, and then on top of it place down another one in a different chunk (see image below)
Reload the world/chunk/restart the server
Expected result: The top boat should stay on top of the hitbox of the bottom boat. as shown in the photo and first part of the video.
Observed result: The top boat slides off of the bottom boat.
This farm is based on this design by Rays works: https://www.youtube.com/watch?v=sT4noYO1xUE&
Related issues
is duplicated by
Attachments
Comments

Please upload a video showcasing the bug in vanilla.
Please also update the description to include steps to reproduce this issue, as well as expected VS observed results.
Additionally, attach any needed commands, datapacks, resourcepacks, screenshots, videos or worlds needed to help reproduce this issue.
As requested, please also update the description to include steps to reproduce this issue, as well as expected VS observed results.

updated to attach steps to reproduce and expected vs observed
Is there a chunk border between the two boats? How exactly did you set up the two boats?

Thank you for solving the issue! YES there is indeed a chunk border line between the boats. The issue is solved after placing both boats in the same chunk! This is why the boat was sliding off...
[media]
I can confirm this bug. The boats fall when relogging.

Can be reproduced in 1.20.6 vanilla server but cannot in 1.20