Duplicate Recurring Invoices

[girish]

@Dave-Swift Ah ok. So basically, sometime back we had an app with the app store id com.invoiceninja.cloudronapp. This is Invoice Ninja 4 . Later, the Invoice Ninja team published Invoice Ninja 5. These two versions are totally different and incompatible.

When the new version v5 came out, we hid the old version and published it with a new app store id com.invoiceninja.cloudronapp2. If you go to the Updates section of the app, is this the id you see i.e com.invoiceninja.cloudronapp2?

The solution you posted earlier (https://forum.invoiceninja.com/t/recurring-invoices-duplicating/13009/4) is for v4 app and not v5 app (atleast, as far as i can tell , despite it being posted in v5 thread!). I know confusing...

[Dave Swift]

I understand! I'm running com.invoiceninja.cloudronapp2@1.11.18

I apologize I didn't realize the post I linked to was for a different version.

[A Former User]

I personally don't trust InvoiceNinja yet, I'm using it but I've configured my own emails instead of any client email so I can always double check whatever will be sent , I follow the "trust but verify" mindset for too critical procedures like billing, especially because I'm too new to InvoiceNinja . I have indeed some invoices sent in double or with bugs in formatting and data. I have to say not only the docs of InvoiceNinja are not clear, their whole UI is confusing for me.

[Dave Swift]

No solution to this? InvoiceNinja just broken for recurring invoices? Is that the conclusion?

[nebulon]

Have you contacted the upstream project about this issue for version 5 ?

[Dave Swift]

They told me to check crons. I can't see any, so I'm not sure what to do.

Also, I mentioned above in the Cloudron docs it says the cron logs are located at /app/data/storage/logs/cron.log. but that file doesn't exist for me.

[nebulon]

Hm, the package does not actually use cron as such but two long-lived processes working the schedule and queue: https://git.cloudron.io/cloudron/invoiceninja-next-app/-/tree/master/supervisor?ref_type=heads

Are both up and running in your failing instance?

[Dave Swift]

Yes, they're running.

[girish]

@Dave-Swift looks like the docs are quite obsolete. I am cleaning them up now.

[girish]

@Dave-Swift I think I have found the issue. Looks like we active the internal cron and the package also has a cron of it's own. Getting fixed.

[girish]

@Dave-Swift Can you please try with package 1.12.0 ?

[Dave Swift]

@girish Thank you. I will let you know after the next recurring invoice goes out in the beginning of March.

[Dave Swift]

Unfortunately the double billing is still occurring.

[girish]

@Dave-Swift can you check if /app/data/env has INTERNAL_QUEUE_ENABLED=false ?

[Dave Swift]

Yes it does.

[Dave Swift]

Any ideas on how to solve this? I love InvoiceNinja but haven't fully implemented it because of this issue. Should I just try a fresh install?

[Dave Swift]

To investigate further, I performed an analysis of all the running processes on my system using the ps aux command.
Here are the relevant processes I found:

1. Queue Worker Process:

www-data 2129 0.0 0.3 194696 104424 pts/0 S 23:12 0:01 php /app/code/artisan queue:work database

This process is running the Laravel Artisan queue:work command with the database queue connection.

2. Schedule Worker Process:

www-data 37 0.0 0.3 192452 103156 pts/0 S 22:18 0:05 php /app/code/artisan schedule:work

This process is running the Laravel Artisan schedule:work command, responsible for executing scheduled tasks.

Apart from these processes, I found multiple Apache web server processes and a Supervisord process, which I don't think are related to the queue or InvoiceNinja application.

Is the presence of a single queue worker process and a separate schedule worker process expected in the standard InvoiceNinja setup on Cloudron?

Could the schedule worker process be contributing to the duplicate recurring invoices issue, or is it unrelated?

Are there any other processes or configurations I should investigate further to identify the root cause of the duplicate recurring invoices problem?

Thank you for your assistance and guidance in resolving this issue.

[nebulon]

I was reading again through the cron section at https://invoiceninja.github.io/en/self-host-installation/ and I while I don't fully get it, I think the root issue is, that we run both a scheduler and the queue worker and it seems one is sufficient. But I am not 100% sure from those docs.

I have published a new package which disables the scheduler and only relies on the queue. @Dave-Swift can you check if this solves the problem?

[Dave Swift]

Thanks @nebulon. I have installed the update and will let you know when I have enough data. Fingers crossed.

[Dave Swift]

@nebulon My recurring invoices are now not running at all.