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?

Reply to this note

Please Login to reply.

Discussion

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. 🐶🐾🤣😂🫡🫂

https://github.com/getAlby/nostr-wallet-connect/pull/77

Seems like a race condition. It gets into that when I schedule a lot of zaps rapidly! 🐶🐾🫡