Error sqlite_busy: database is locked

Good morning, I use the n8n to send various information in several different streams and sometimes I come across this error, can anyone help me? Usually I restart the stream but it happens a few times a day on different streams
PS: I’m running on a VPS with 320gb of storage and I don’t even use 30% of the capacity

Hey @Mauricio_Kreling,

Welcome to the community :raised_hands:

We only offer support in English, Are you able to repost your message?

HEY @Jon

OK, THANK YOU VERY MUCH FOR THE INFORMATION

CHANGE MADE TO ENGLISH

1 Like

Thanks, When you say streams what do you mean? Is that like input items or are you working on a sqlite database directly with a community node?

Hi @Mauricio_Kreling - thanks for doing that!

Quick question as well, beyond needing the information Jon asked for - how many connections are you making to the database? A quick look at that error, and it looks like you need to close the connection you’re using before trying to make a new one :+1:

1 Like

@Jon USING Workflows

@EmeraldHerald I’M USING +50 Workflows

SORRY FOR TYPING ERRORS I’M USING GOOGLE TRANSLATOR

How do you have n8n installed? Typically SQLite shouldn’t have that issue unless there is a disk issue.

installed docker-compose guided by documentation on VPS AWS LIGHTSAIL

Ah so we have seen issues with lightsail before which cpu is it using?

1 Like

currently use 16gb RAM, 4VCPU’s, 320GB SSD

how can i solve the problem?

That should be ok, normally most users on lightsail have a really low spec cpu.

Can you share the full workflow and the full error message?

It could be that using an external database is going to be the best option or to monitor the load of your lightsail instance and check the disk usage if that can be done.

@Jon ERROR:
Uploading: image.png…

Hey @Mauricio_Kreling,

The workflow looks incomplete, Some of the nodes seem to reference nodes that are not in the workflow. As another test can you try another workflow and see if that has the same issue?

Good Morning @Jon

Adjusted