poundifdef / smoothmq

An improved drop-in replacement for SQS
https://www.smoothmq.com
GNU Affero General Public License v3.0
2.04k stars 35 forks source link

Upgrade 0.2.2 database migrations #33

Closed mzehrer closed 1 week ago

mzehrer commented 3 weeks ago

When updating to 0.2.2 I receive the following error:

[0.428ms] [rows:0] ALTER TABLE queues ADD rate_limit real NOT NULL 8:07AM FTL sqlite.go:116 > error="Cannot add a NOT NULL column with default value NULL"

poundifdef commented 2 weeks ago

I apologize for this! I made some big changes to the DB schema from version 0.1 to 0.2, including adding an ORM to manage migrations. You may need to re-create your sqlite DB.

mzehrer commented 2 weeks ago

I already did, no worries. I just wanted to point that out.