can you describe what you mean with the DB lock issue?
It's under heavy development and I am happy to check and prioritize this.
Discussion
I am trying to get logs now, give me 5 min please! 🐶🐾🫡
Here are the logs! 🐶🐾🫡
2023/05/16 00:49:49 /build/service.go:103 database is locked (5) (SQLITE_BUSY)
[0.355ms] [rows:0] SELECT * FROM nostr_events WHERE nostr_id = "4859dc6f74f0b43b47e4a1b8b2d04a4593b81a01461b891afc60bfc7f3aae67c"
2023/05/16 00:49:49 /build/service.go:112 database is locked (5) (SQLITE_BUSY)
[0.348ms] [rows:0] SELECT * FROM apps WHERE apps.nostr_pubkey = "71143dc6a4053f80eb86b86266bc986a7977f38612e9ed7e59f592033647d93e" ORDER BY apps.id LIMIT 1
2023/05/16 00:49:49 /build/service.go:70 database is locked (5) (SQLITE_BUSY)
[0.383ms] [rows:0] SELECT * FROM nostr_events WHERE nostr_id = "4859dc6f74f0b43b47e4a1b8b2d04a4593b81a01461b891afc60bfc7f3aae67c" ORDER BY nostr_events.id LIMIT 1
{"level":"error","msg":"database is locked (5) (SQLITE_BUSY)","time":"2023-05-16T00:49:49Z"}
{"eventId":"0a0344730654cd7d837c207166a206735871a89ec017306ac0a4078ba4e390bc","eventKind":23194,"level":"info","msg":"Processing Event","time":"2023-05-16T00:49:50Z"}
2023/05/16 00:49:50 /build/service.go:103 database is locked (5) (SQLITE_BUSY)
[0.362ms] [rows:0] SELECT * FROM nostr_events WHERE nostr_id = "0a0344730654cd7d837c207166a206735871a89ec017306ac0a4078ba4e390bc"
2023/05/16 00:49:50 /build/service.go:112 database is locked (5) (SQLITE_BUSY)
[0.416ms] [rows:0] SELECT * FROM apps WHERE apps.nostr_pubkey = "71143dc6a4053f80eb86b86266bc986a7977f38612e9ed7e59f592033647d93e" ORDER BY apps.id LIMIT 1
2023/05/16 00:49:50 /build/service.go:70 database is locked (5) (SQLITE_BUSY)
[0.334ms] [rows:0] SELECT * FROM nostr_events WHERE nostr_id = "0a0344730654cd7d837c207166a206735871a89ec017306ac0a4078ba4e390bc" ORDER BY nostr_events.id LIMIT 1
{"level":"error","msg":"database is locked (5) (SQLITE_BUSY)","time":"2023-05-16T00:49:50Z"}
that's super helpful. I see you use sqlite is there a chance you can run on PostgreSQL?
I am using the Umbrel store app so not really possible for this install. I will make it standalone after I am back from mines. 🐶🐾🫡
could you share this on a GH issue?
I think we might need to process payment requests sequentially in that case - which should be fine on personal nodes.
I’ll probably even submit a patch, but cannot do it now. Only 8 hours later. Sorry! 🐶🐾🫡🫂
😍
Ok, had a minute to do it!
🐶🐾🫡 https://github.com/getAlby/nostr-wallet-connect/issues/76
hehe, on which planet are you? your 8hours pass quickly :D
thanks for the issue!
PR submitted, but I didn’t test yet. 🐶🐾🤣😂🫡🫂
Seems like a race condition. It gets into that when I schedule a lot of zaps rapidly! 🐶🐾🫡