Solved

Error 33 in MYSQL log

Posted on 2004-09-30
3
429 Views
Last Modified: 2012-05-05
I have received this message in my MYSQL error log and I cannot find anything referencing this error number. Could some one point me in the right direction?


 "   InnoDB: Operating sytem error number 33 in file operation.  "

I keep getting this error in the middle of the night.  Everytime it happens I need to restart all my services again.


Thank you
0
Comment
Question by:AMREP
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
ushastry earned 250 total points
ID: 12197461
Hi,

First backup DB before doing anything here..

If InnoDB prints an operating system error in a file operation, usually the problem is one of the following:

You did not create the InnoDB data file or log directories.
mysqld does not have access rights to create files in those directories.
mysqld does not read the proper `my.cnf' or `my.ini' option file, and consequently does not see the options you specified.
The disk is full or a disk quota is exceeded.
You have created a subdirectory whose name is equal to a data file you specified.
There is a syntax error in innodb_data_home_dir or innodb_data_file_path.
If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, you should delete all files created by InnoDB. This means all data files, all log files, and the small archived log file. In case you already created some InnoDB tables, delete the corresponding `.frm' files for these tables (and any `.ibd' files if you are using multiple tablespaces) from the MySQL database directories as well. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening


33 (ERROR_LOCK_VIOLATION)
The process cannot access the file because another process has locked a portion of the file.

You can go thru this link for more on this..

http://www.goldenweb.it/manuale_mysql/manual_InnoDB.php

0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 12199292
33 (ERROR_LOCK_VIOLATION)

Could it be that you have some backup running during the night?
0
 
LVL 26

Expert Comment

by:ushastry
ID: 12503691
any updates?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now