Solved

Disk Full Error - transaction rolled back

Posted on 1998-06-24
8
262 Views
Last Modified: 2008-02-01
I verified that there was plenty of memory after getting this error.  It occured when trying to connect ISQL to the database.  Any idea what I should check next?
0
Comment
Question by:rickwinterkorn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 

Author Comment

by:rickwinterkorn
ID: 1098074
Edited text of question
0
 

Expert Comment

by:gilmer
ID: 1098075
Could you give some specs on the system, and the exact error message.
0
 

Expert Comment

by:vsriks
ID: 1098076
Get back to me on the following things.  What does sp_who output give?  if it is under unix what does ps -ef gives.  Also sp_lock shows what types of lock.  lastly give me information on what version (Excat) of dataserver and ISQL version

0
Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

 

Expert Comment

by:kaos87
ID: 1098077
Are you getting this message from a Client connected to a database server?

If yes, the system partition on the server where the database server is installed is very low on space.

If no, (the case you are using a local database) the partition where the database engine and/or database file are on is very low on space.  

I had this problem once and I clear up some unused files to do some space on the hard drive and it was ok after.

0
 

Author Comment

by:rickwinterkorn
ID: 1098078
Kaos87..thanks for the info, I cleared some space in the partition and it works fine now.  
0
 
LVL 1

Expert Comment

by:spacebrain
ID: 1098079
you should reject the answer from vsriks
Koas87 post an answer if rickwinterkorn does
Just a thought like that....
0
 

Author Comment

by:rickwinterkorn
ID: 1098080
Koas87 - Post an answer..or just something ...so that I can accept it as answer and give you credit..Thanks again
0
 

Accepted Solution

by:
kaos87 earned 50 total points
ID: 1098081
Are you getting this message from a Client connected to a database server?

If yes, the system partition on the server where the database server is installed is very low on space.

If no, (the case you are using a local database) the partition where the database engine and/or database file are on is very low on space.   

I had this problem once and I clear up some unused files to do some space on the hard drive and it was ok after.

0

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

628 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