Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
OtiZ2 opened this issue Feb 4, 2025 · 6 comments
Assignees
Milestone

Comments

@OtiZ2
Copy link

OtiZ2 commented Feb 4, 2025

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.

Image

@leokhoa leokhoa self-assigned this Feb 4, 2025
@leokhoa leokhoa added the bug label Feb 4, 2025
@leokhoa leokhoa added this to the Laragon 7.1 milestone Feb 4, 2025
@leokhoa
Copy link
Owner

leokhoa commented Feb 4, 2025

@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
Copy link
Owner

leokhoa commented Feb 4, 2025

@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
Copy link
Author

OtiZ2 commented Feb 5, 2025

@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
Copy link
Owner

leokhoa commented Feb 5, 2025

@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
Copy link
Author

OtiZ2 commented Feb 5, 2025

Something about 1G-2G, 5M rows

@leokhoa
Copy link
Owner

leokhoa commented Feb 5, 2025

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants