My appliction throwed an exception:Disk full 'Fatal error':disk full when writing to xxx.db

[Former Member]

Hi Everyone,

My application is written in C# language, the version of database software

is SQL Anywhere 11.0.1.

SomeTimes when inserting a data record into database,my application throw the exception:Disk full 'Fatal error':disk full when writing to xxx.db.

But I put the database file(xx.db) in "F" hard disk,its free space is 16G.

Any clue what could be wrong?

Thanks

[Former Member]

Is the C: drive full or almost full?

The SQL Anywhere temp work directory uses the TMP, TMPDIR, or TEMP variables (in this order) if the SATMP Sql Anywhere variable is not set. Set the SATMP variable to point to the F: drive as well and see if the problem still happens.

SATMP environment variable

If the transaction log is also on a full C: drive, this could also cause the error.

Thanks

Mark

[Former Member]

The free space of C: is 20G.

My database only has one file: XXXX.db, no transaction log file.

Thanks

[Former Member]

- What happens if you validate the database using DBVALID.EXE or the VALIDATE DATABASE statement?

- Did you have a 6 digit assertion error being reported as part of this exception?

Thanks

Mark

[Former Member]

Also I would ask on what file system, and how big are the files (.db).

Andreas.