I have three instances of n8n running – two as docker containers on ubuntu and one installed directly on windows using npm. I logged into two of them today and all the workflows and credentials are missing from the windows instance and one of the two docker instances. The other docker instance is not affected both docker instances running on the same machine. Both of these are running v1.88.0. The windows instance is at v1.85.4. These were all using the sqlite database. The sqlite database file is fairly large so it seems like the data is still there but the workflows are not visible in the ui. Any ideas how to recover these?
EDIT: I ran the command line to export the workflows and it dumped them to json. I reconfigured the windows instance to use postgres and imported the exported workflows and credentials. Didn’t get any errors but also no workflows show up. I can see workflows in the database table in postgres but nothing shows up in the workflow list.