Solved

Disk Full Error - transaction rolled back

Posted on 1998-06-24
8
257 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
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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sybase SQL Anywhere 9 346
SyBase SQL Syntax 7 321
How do we check sybase license in ASE 1 2,969
Sybase 15.7 database backup 8 642
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

860 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