Problem with freeze DB on opening tables - Operating system error number 32 in a file operation

[OtiZ2]

After upgrade to 7.0.4
I am facing a problem with the database and suddenly the whole mysql server is stuck. and does not respond. in the mysqld log only this is displayed.
Only restarting the PC helps.

everything works ok, laragon has admin rights.
but sometimes it just stops working

2025-02-04T16:37:00.165887Z 9046 [ERROR] InnoDB: Operating system error number 32 in a file operation. 2025-02-04T16:37:00.166199Z 9046 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error.

[leokhoa]

@OtiZ2 : Could you provide me with more details.

1. Do you have any antivirus software installed? If so, which one?
2. How long does the issue occur after starting Laragon?
3. If possible, can you share the full log in text format (excluding any sensitive information)?

[leokhoa]

@OtiZ2 : I have released Laragon 7.0.6.
If supports 2 settings:

1. AutoBackup = 0 or -1 (0: Disabled, -1: Enabled). By default, autobackup is enabled
2. BackupInterval = X ( every X hours). By default, it runs every 8 hours

After updating to Laragon 7.0.6, can you add to laragon.ini this value and see if it helps?

AutoBackup=0

This setting will disable Autobackup.

[OtiZ2]

@leokhoa hi, i update laragon to 7.0.6. we will see, I'll be in touch.

1. i use only windows defender
2. same day after upgrade (maybe in hour)

[leokhoa]

@OtiZ2 : Laragon 7 was released some time ago, but there have been few reports of this issue so I think it is happened only on big tables. May I know how big your tables are?

[OtiZ2]

Something about 1G-2G, 5M rows

[leokhoa]

@OtiZ2 : Exactly, that's the point. Thanks for letting me know. l'll work on a solution.

[OtiZ2]

the problem has not appeared again.
Disabled backup helphed to me.

Thx