Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

write failed: No space left on device (28)

5 posts in General Discussion Last posting was on 2009-10-10 01:16:19.0Z
Kon T. Amusse Posted on 2009-10-07 13:33:52.0Z
From: "Kon T. Amusse" <kon.t@amusse.invalid>
Newsgroups: sybase.public.ase.general
Subject: write failed: No space left on device (28)
Date: Wed, 7 Oct 2009 15:33:52 +0200
Organization: A noiseless patient Spider
Lines: 11
Message-ID: <hai5c1$ald$1@news.eternal-september.org>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Trace: news.eternal-september.org U2FsdGVkX1/ep8zPZMoRyBXCSpFmcJC3wjf/we+FveIZWUlU9aZtYZSUdMsqj/0Y6yiTgrpfv16vm+aHruCFmD7Xpeb62Y0ZnmDh/Il47Z6d2tr2M4MxY9Z2W48blL3pWtd3vDNX348kYOLjebpVwbV73ixKan7Y
X-Complaints-To: abuse@eternal-september.org
NNTP-Posting-Date: Wed, 7 Oct 2009 13:33:53 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-Auth-Sender: U2FsdGVkX1+G2ZQDaDQsqI/tbMMOjBFJ+vsMMs1k4rxBVasT8QryCQ==
Cancel-Lock: sha1:Ad4G/bXtW3n+WCPt0iLvarhckAk=
X-Priority: 3
X-MSMail-Priority: Normal
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!news-raspail.gip.net!news.gsl.net!gip.net!aotearoa.belnet.be!news.belnet.be!goblin1!goblin2!goblin.stu.neva.ru!feeder.erje.net!feeder.eternal-september.org!eternal-september.org!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28420
Article PK: 77663

I have setup a trial version of 15.0.3 ASE server, and there are some web
applications running.
Very often an error is caused:

write failed: No space left on device (28)

I am really confused, this error happens mostly when doing SELECT from small
tables (about 200 records). Bigger queries seem to work better.
What could it be?
The disks are not full, RAM is more than enough, swap space seems ok...


"Mark A. Parsons" <iron_horse Posted on 2009-10-07 15:50:39.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: write failed: No space left on device (28)
References: <hai5c1$ald$1@news.eternal-september.org>
In-Reply-To: <hai5c1$ald$1@news.eternal-september.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091004-0, 10/04/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4accb8cf$1@forums-1-dub>
Date: 7 Oct 2009 08:50:39 -0700
X-Trace: forums-1-dub 1254930639 10.22.241.152 (7 Oct 2009 08:50:39 -0700)
X-Original-Trace: 7 Oct 2009 08:50:39 -0700, vip152.sybase.com
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28421
Article PK: 77664

Assuming there really are no space issues ...

Take a look at the permissions on your database devices.

Make sure the owner of the dataserver binary has read/write permissions on all database devices.

-------------

If that doesn't help you'll need to provide more details:

- select @@version

- sp_helpdevice

- full text of ASE errorlog entry, to include a few lines before and after the 'write failed' message

- full text of error message(s) generated by query (assumes the query is responsible for initiating the failed write)

Kon T. Amusse wrote:
> I have setup a trial version of 15.0.3 ASE server, and there are some
> web applications running.
> Very often an error is caused:
>
> write failed: No space left on device (28)
>
> I am really confused, this error happens mostly when doing SELECT from
> small tables (about 200 records). Bigger queries seem to work better.
> What could it be?
> The disks are not full, RAM is more than enough, swap space seems ok...
>


Kon T. Amusse Posted on 2009-10-07 18:48:41.0Z
From: "Kon T. Amusse" <kon.t@amusse.invalid>
Newsgroups: sybase.public.ase.general
Subject: Re: write failed: No space left on device (28)
Date: Wed, 7 Oct 2009 20:48:41 +0200
Organization: A noiseless patient Spider
Lines: 79
Message-ID: <hainqa$g0b$1@news.eternal-september.org>
References: <hai5c1$ald$1@news.eternal-september.org> <4accb8cf$1@forums-1-dub>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Trace: news.eternal-september.org U2FsdGVkX19NgMGwClFkp90jhXHYDEW0MEUsSCk64+y7EiSxExw12vTX1AhmSUaLLyoQFLV9WPWKWMDQJ7QJ6Hv1DKJhIZgIYf3c0JfWMlq/m4KDJf+MxrfYxehegFXqxhWc8r0odFcrbesfwY6y/hpGVV+t6AjA
X-Complaints-To: abuse@eternal-september.org
NNTP-Posting-Date: Wed, 7 Oct 2009 18:48:42 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
In-Reply-To: <4accb8cf$1@forums-1-dub>
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-Auth-Sender: U2FsdGVkX18WEiu9c2ij6ijyk/AnjlMHd4YfPZx0QO7My4Cd0No6YA==
Cancel-Lock: sha1:aflHLCDmlOmLlVbQWxwRuu/2bJ8=
X-Priority: 3
X-MSMail-Priority: Normal
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit3.readnews.com!news.glorb.com!feeder.eternal-september.org!eternal-september.org!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28425
Article PK: 77667

All device files are owned by "sybase", so we should have no problems there.

@@version:
Adaptive Server Enterprise/15.0.3/EBF 16374/P/x86_64/Enterprise
Linux/ase1503/2669/64-bit/FBO/Wed Nov 12 16:52:49 2008

sp_helpdevice
device_name physical_name description
status cntrltype vdevno vpn_low vpn_high
----------- ------------- -----------

------ --------- ------ ------- --------
master /SYBASEdata/data/master.dat file system device,
special, dsync on, directio off, default disk, physical disk, 150.00 MB,
Free: 65.00 MB 3 0 0 0 76799
main_dat_dev /SYBASEdata/data/maindatdev.dat file system device,
special, dsync on, directio off, physical disk, 7000.00 MB, Free: 0.00 MB
16386 0 5 0 3583999
main_log_dev /SYBASElogs/logs/mainlogdev.dat file system device,
special, dsync on, directio off, physical disk, 5000.00 MB, Free: 0.00 MB
16386 0 6 0 2559999
sysprocsdev /SYBASEdata/data/sysprocs.dat file system device,
special, dsync on, directio off, physical disk, 200.00 MB, Free: 0.00 MB
16386 0 1 0 102399
systemdbdev /SYBASEdata/data/sybsysdb.dat file system device,
special, dsync on, directio off, physical disk, 10.00 MB, Free: 0.00 MB
16386 0 2 0 5119
tapedump1 /dev/nst0 unknown device type, disk,
dump device
16 2 0 0 20000
tapedump2 /dev/nst1 unknown device type, tape,
625 MB, dump device
16 3 0 0 20000
tempdb_dat_dev /SYBASEdata/data/tempdbdatdev.dat file system device,
special, dsync off, directio off, physical disk, 1500.00 MB, Free: 0.00 MB
2 0 3 0 767999
tempdb_log_dev /SYBASElogs/logs/tempdblogdev.dat file system device,
special, dsync off, directio off, physical disk, 3000.00 MB, Free: 0.00 MB
2 0 4 0 1535999

The query only generates the error message in subject.

"Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in message
news:4accb8cf$1@forums-1-dub...
> Assuming there really are no space issues ...
>
> Take a look at the permissions on your database devices.
>
> Make sure the owner of the dataserver binary has read/write permissions on
> all database devices.
>
> -------------
>
> If that doesn't help you'll need to provide more details:
>
> - select @@version
>
> - sp_helpdevice
>
> - full text of ASE errorlog entry, to include a few lines before and after
> the 'write failed' message
>
> - full text of error message(s) generated by query (assumes the query is
> responsible for initiating the failed write)
>
>
> Kon T. Amusse wrote:
>> I have setup a trial version of 15.0.3 ASE server, and there are some web
>> applications running.
>> Very often an error is caused:
>>
>> write failed: No space left on device (28)
>>
>> I am really confused, this error happens mostly when doing SELECT from
>> small tables (about 200 records). Bigger queries seem to work better.
>> What could it be?
>> The disks are not full, RAM is more than enough, swap space seems ok...
>>


"Mark A. Parsons" <iron_horse Posted on 2009-10-07 19:52:03.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: write failed: No space left on device (28)
References: <hai5c1$ald$1@news.eternal-september.org> <4accb8cf$1@forums-1-dub> <hainqa$g0b$1@news.eternal-september.org>
In-Reply-To: <hainqa$g0b$1@news.eternal-september.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091004-0, 10/04/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4accf163$1@forums-1-dub>
Date: 7 Oct 2009 12:52:03 -0700
X-Trace: forums-1-dub 1254945123 10.22.241.152 (7 Oct 2009 12:52:03 -0700)
X-Original-Trace: 7 Oct 2009 12:52:03 -0700, vip152.sybase.com
Lines: 107
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28428
Article PK: 77671

You also need to check the read/write permissions on the all of the devices/files (and I'd check the read/write
permissions on the parent directories, too).

--------------

And df reports plenty of space?

df -k /SYBASEdata/data
df -k /SYBASElogs/logs

--------------

You mention that the query generates the message ...

Does the query generate the message every time it's run?

Is the message generated at the client side? Or does it show up in the ASE errorlog?

If the message is showing up in the errorlog:

- how did you determine that the query generated the error message?
- please post the complete errorlog entry(s), including the few lines before/after the message

Kon T. Amusse wrote:
> All device files are owned by "sybase", so we should have no problems
> there.
>
> @@version:
> Adaptive Server Enterprise/15.0.3/EBF 16374/P/x86_64/Enterprise
> Linux/ase1503/2669/64-bit/FBO/Wed Nov 12 16:52:49 2008
>
> sp_helpdevice
> device_name physical_name description status
> cntrltype vdevno vpn_low vpn_high
> ----------- -------------
> -----------
>
> ------ --------- ------ ------- -------- master
> /SYBASEdata/data/master.dat file system device, special, dsync on,
> directio off, default disk, physical disk, 150.00 MB, Free: 65.00
> MB 3 0 0 0 76799
> main_dat_dev /SYBASEdata/data/maindatdev.dat file system device,
> special, dsync on, directio off, physical disk, 7000.00 MB, Free: 0.00
> MB 16386 0 5 0 3583999
> main_log_dev /SYBASElogs/logs/mainlogdev.dat file system device,
> special, dsync on, directio off, physical disk, 5000.00 MB, Free: 0.00
> MB 16386 0 6 0 2559999
> sysprocsdev /SYBASEdata/data/sysprocs.dat file system device,
> special, dsync on, directio off, physical disk, 200.00 MB, Free: 0.00 MB
> 16386 0 1 0 102399
> systemdbdev /SYBASEdata/data/sybsysdb.dat file system device,
> special, dsync on, directio off, physical disk, 10.00 MB, Free: 0.00 MB
> 16386 0 2 0 5119
> tapedump1 /dev/nst0 unknown device type,
> disk, dump device 16 2 0 0 20000
> tapedump2 /dev/nst1 unknown device type,
> tape, 625 MB, dump device 16 3 0 0 20000
> tempdb_dat_dev /SYBASEdata/data/tempdbdatdev.dat file system device,
> special, dsync off, directio off, physical disk, 1500.00 MB, Free: 0.00
> MB 2 0 3 0 767999
> tempdb_log_dev /SYBASElogs/logs/tempdblogdev.dat file system device,
> special, dsync off, directio off, physical disk, 3000.00 MB, Free: 0.00
> MB 2 0 4 0 1535999
>
> The query only generates the error message in subject.
>
> "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in
> message news:4accb8cf$1@forums-1-dub...
>> Assuming there really are no space issues ...
>>
>> Take a look at the permissions on your database devices.
>>
>> Make sure the owner of the dataserver binary has read/write
>> permissions on all database devices.
>>
>> -------------
>>
>> If that doesn't help you'll need to provide more details:
>>
>> - select @@version
>>
>> - sp_helpdevice
>>
>> - full text of ASE errorlog entry, to include a few lines before and
>> after the 'write failed' message
>>
>> - full text of error message(s) generated by query (assumes the query
>> is responsible for initiating the failed write)
>>
>>
>> Kon T. Amusse wrote:
>>> I have setup a trial version of 15.0.3 ASE server, and there are some
>>> web applications running.
>>> Very often an error is caused:
>>>
>>> write failed: No space left on device (28)
>>>
>>> I am really confused, this error happens mostly when doing SELECT
>>> from small tables (about 200 records). Bigger queries seem to work
>>> better.
>>> What could it be?
>>> The disks are not full, RAM is more than enough, swap space seems ok...
>>>
>


Jeff Tallman [Sybase] Posted on 2009-10-10 01:16:19.0Z
From: "Jeff Tallman [Sybase]" <jeff.tallman@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: write failed: No space left on device (28)
References: <hai5c1$ald$1@news.eternal-september.org> <4accb8cf$1@forums-1-dub> <hainqa$g0b$1@news.eternal-september.org>
In-Reply-To: <hainqa$g0b$1@news.eternal-september.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4acfe063$1@forums-1-dub>
Date: 9 Oct 2009 18:16:19 -0700
X-Trace: forums-1-dub 1255137379 10.22.241.152 (9 Oct 2009 18:16:19 -0700)
X-Original-Trace: 9 Oct 2009 18:16:19 -0700, vip152.sybase.com
Lines: 94
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28445
Article PK: 77693

...all your devices (except master) show they are full (Free:
0.00MB).....and all have 'dsync on'......the latter is more a
performance issue - use sp_deviceattr and change it to directio=true,
dsync=false....

But my guess is that something you didn't expect filled the log in every
database - did you forget to do log dumps to truncate the logs???

Jeff Tallman
Enterprise Data Management Products Technical Evangelism
jeff.tallman@sybase.com
http://blogs.sybase.com/database

Kon T. Amusse wrote:
> All device files are owned by "sybase", so we should have no problems
> there.
>
> @@version:
> Adaptive Server Enterprise/15.0.3/EBF 16374/P/x86_64/Enterprise
> Linux/ase1503/2669/64-bit/FBO/Wed Nov 12 16:52:49 2008
>
> sp_helpdevice
> device_name physical_name description status
> cntrltype vdevno vpn_low vpn_high
> ----------- -------------
> -----------
>
> ------ --------- ------ ------- -------- master
> /SYBASEdata/data/master.dat file system device, special, dsync on,
> directio off, default disk, physical disk, 150.00 MB, Free: 65.00
> MB 3 0 0 0 76799
> main_dat_dev /SYBASEdata/data/maindatdev.dat file system device,
> special, dsync on, directio off, physical disk, 7000.00 MB, Free: 0.00
> MB 16386 0 5 0 3583999
> main_log_dev /SYBASElogs/logs/mainlogdev.dat file system device,
> special, dsync on, directio off, physical disk, 5000.00 MB, Free: 0.00
> MB 16386 0 6 0 2559999
> sysprocsdev /SYBASEdata/data/sysprocs.dat file system device,
> special, dsync on, directio off, physical disk, 200.00 MB, Free: 0.00 MB
> 16386 0 1 0 102399
> systemdbdev /SYBASEdata/data/sybsysdb.dat file system device,
> special, dsync on, directio off, physical disk, 10.00 MB, Free: 0.00 MB
> 16386 0 2 0 5119
> tapedump1 /dev/nst0 unknown device type,
> disk, dump device 16 2 0 0 20000
> tapedump2 /dev/nst1 unknown device type,
> tape, 625 MB, dump device 16 3 0 0 20000
> tempdb_dat_dev /SYBASEdata/data/tempdbdatdev.dat file system device,
> special, dsync off, directio off, physical disk, 1500.00 MB, Free: 0.00
> MB 2 0 3 0 767999
> tempdb_log_dev /SYBASElogs/logs/tempdblogdev.dat file system device,
> special, dsync off, directio off, physical disk, 3000.00 MB, Free: 0.00
> MB 2 0 4 0 1535999
>
> The query only generates the error message in subject.
>
> "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in
> message news:4accb8cf$1@forums-1-dub...
>> Assuming there really are no space issues ...
>>
>> Take a look at the permissions on your database devices.
>>
>> Make sure the owner of the dataserver binary has read/write
>> permissions on all database devices.
>>
>> -------------
>>
>> If that doesn't help you'll need to provide more details:
>>
>> - select @@version
>>
>> - sp_helpdevice
>>
>> - full text of ASE errorlog entry, to include a few lines before and
>> after the 'write failed' message
>>
>> - full text of error message(s) generated by query (assumes the query
>> is responsible for initiating the failed write)
>>
>>
>> Kon T. Amusse wrote:
>>> I have setup a trial version of 15.0.3 ASE server, and there are some
>>> web applications running.
>>> Very often an error is caused:
>>>
>>> write failed: No space left on device (28)
>>>
>>> I am really confused, this error happens mostly when doing SELECT
>>> from small tables (about 200 records). Bigger queries seem to work
>>> better.
>>> What could it be?
>>> The disks are not full, RAM is more than enough, swap space seems ok...
>>>
>