# Prisma + SQLite causes an out of memory error on deploy

**URL:** <https://community.fly.io/t/prisma-sqlite-causes-an-out-of-memory-error-on-deploy/11039>\
**Category:** Questions / Help\
**Created:** [February 27, 2023, 4:01am UTC](https://community.fly.io/t/prisma-sqlite-causes-an-out-of-memory-error-on-deploy/11039 "2023-02-27T04:01:02Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![sastreen](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@sastreen](https://community.fly.io/u/sastreen)\
**Post date:** [March 19, 2023, 5:21pm UTC](https://community.fly.io/t/prisma-sqlite-causes-an-out-of-memory-error-on-deploy/11039/4 "2023-03-19T17:21:32Z")

</div>

@polkach Awesome. This helped a lot. I ended with this:

```auto
fallocate -l 256M /swapfile
chmod 0600 /swapfile
mkswap /swapfile
echo 10 > /proc/sys/vm/swappiness
swapon /swapfile
npx prisma migrate deploy
swapoff /swapfile
rm /swapfile
npm run start

```

I’m not sure if it’s necessary to turn the swap off and remove the allocated space. I figured that this would mean the prod app would be using the swapfile too (and thus would have less persistent storage). Does that sound right? I also removed the overcommit since I’m not sure it’s necessary here.

---

_[View the full topic](https://community.fly.io/t/prisma-sqlite-causes-an-out-of-memory-error-on-deploy/11039)._