Problem with recovering sqlite3 after redeploying telegram bot after commiting changes on github.

Hello! I have a problem with my telegram bot. It is a bot for secret santa and it was made on python using telebot. All users and their wished were stored in sqlite3 db that i created in main.py (not on railway). After commiting little changes to code on github my database was deleted. How to restore it? Thank you in advance
4 Replies
Percy
Percy6mo ago
Project ID: N/A
Brody
Brody6mo ago
unfortunately you can't, you stored the sqlite file in the containers ephemeral storage, the containers storage isnt persisted across deployments, going forward id recommend using a database like postgres or storing the sqlite file in a volume https://docs.railway.app/guides/volumes
tedunchained
tedunchained6mo ago
thank you. also i want to redeploy and got always that error: telebot.apihelper.ApiTelegramException: A request to the Telegram API was unsuccessful. Error code: 409. Description: Conflict: terminated by other getUpdates request; make sure that only one bot instance is running but bot is running only on your server. how to fix it? thank you
Brody
Brody6mo ago
try setting RAILWAY_DEPLOYMENT_OVERLAP_SECONDS to 0