DBI file for _sqlsrv2

[Rob Fitzpatrick]

10.2B08 64-bit, Enterprise RDBMS
CentOS 6.5

I am getting many of these errors in my DB log:
(9450) bkioWrite:Insufficient disk space during write, fd 33, len 8192, offset 209720, file DBI1737807616N9QRjQ

The PID in the error message belongs to a SQL server. The file system where the servers write their temp files has a few GB free, and there aren't many unlinked files there, and they are small. So I'm not sure why I'm seeing "insufficient disk space" errors.

Possibly (a) some unrelated process is also writing data there, and it's gone by the time I see the error and check available disk space, or (b) some SQL user ran a large query which wrote a large amount of data to the DBI file, which is now gone.

At this time there the _sqlsrv2 process doesn't have a handle to a DBI file.

I understand the use of the DBI file by ABL clients. What is written to the DBI file by a SQL server?

[Rob Fitzpatrick]

They're running as root so it shouldn't be a ulimit issue.


-----Original Message-----
From: Tom Bascom [mailto:basco...@gmail.com] On Behalf Of Tom Bascom
Sent: Tuesday November 17, 2015 4:16 PM
To: d...@peg.com
Subject: Re: DBI file for _sqlsrv2

Perhaps ulimit is coming into play?

I have a very vague recollection that SQL servers behave badly under some circumstances/releases and might not be following -T. You may find that those DBI files are being written to / or something inconvenient like that.

--
Tom Bascom
603 396 4886
t...@greenfieldtech.com

[Tim Kuehn]

You answered this back in 2006. :)

http://www.progresstalk.com/threads/bkiowrite-insufficient-disk-space-during-write.96518/

On Tue, Nov 17, 2015 at 4:16 PM, Tom Bascom <t...@greenfieldtech.com> wrote:
> Perhaps ulimit is coming into play?
>
> I have a very vague recollection that SQL servers behave badly under some
> circumstances/releases and might not be following -T. You may find that
> those DBI files are being written to / or something inconvenient like that.
>
>
>
> On 11/17/15 4:01 PM, Rob Fitzpatrick wrote:
>>

> --
> Tom Bascom
> 603 396 4886
> t...@greenfieldtech.com
>
>

--
Tim Kuehn: Senior Consultant - TDK Consulting Services
Course Instructor: Intro to OO Concepts for Procedural Programmers
Sign up on my mailing list to learn about future training
opportunities @ www.tdkcs.com
President - Ontario PUG
Program Committee Chair - PUG Challenge Americas,

Skype: timothy.kuehn
Ph: 519-576-8100
Cell: 519-781-0081

[craig...@amcor.com]

Enough inodes available on the file systems (df -i) ?


Craig Love
Amcor Flexibles Asia Pacific Nunawading
9-19 Rooks Rd Mitcham, VIC 3132
+613 9872 2177

www.amcor.com

______________________________________________________

Amcor - Creating a new world of packaging
______________________________________________________

CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Amcor immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Amcor.

[Rob Fitzpatrick]

Good thought, but I have only 17% in use there.

[Grant Maizels]

We don't do much sql where I'm working, but in the past, I recall sql queries that were poorly formed or sorted generating huge (500 MB) temporary files and sometimes filling our working disk. I don't recall the exact error messages.

Grant

CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Orora immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Orora.

[Rob Fitzpatrick]

Thanks. For the time being I'm going to direct -T on the SQL broker to a partition with more available space.

-----Original Message-----
From: Grant Maizels [mailto:grant....@ororagroup.com]
Sent: Tuesday November 17, 2015 5:23 PM
To: Rob Fitzpatrick; d...@peg.com
Subject: RE: DBI file for _sqlsrv2