RE: SET EXPLAIN: Error -534
A user on IDS 7.30.UC2 with 4GL got error -534 "Cannot open EXPLAIN output file / Not owner" whenever SET EXPLAIN ON was issued, from both the 4GL program and dbaccess; it worked on another 7.23 instance and when logged in as user informix. Suggestions about directory permissions and deleting stale sqexplain.out files didn't help (the directory was world-writable). The fix came from a tip that the behaviour depends on who starts the engine: starting the instance as user informix rather than root made SET EXPLAIN work. A follow-up argued the real cause is wrong ownership/setuid bits on oninit, which should be -rwsr-sr-- root:informix.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
You don't have permission to create the file where you are.
Paul Watson
WF Software Ltd
Tel: +44 1436 674729
Fax: +44 1436 678693
www.wfsoftware.com/informix
> -----Original Message-----
> From: euroinvestor@yahoo.com [mailto:euroinvestor@yahoo.com]
> Sent: Wednesday, August 16, 2000 05:09
> To: informix-list@iiug.org
> Subject: SET EXPLAIN: Error -534
>
>
> IDS 7.30.UC2
> D4GL v 3.00
>
> I have the following program:
>
> ######
> database mydb
> main
> set explain on
> end main> ######
>
> Running this program yields the following error:
> ######
> Program stopped at 'x.4gl', line number 6.
> SQL statement error number -534.
> Cannot open EXPLAIN output file.
> SYSTEM error number -1.
> Not owner
> ######
>
> I get the same error when trying to run "SET EXPLAIN" from dbaccess.
> Never had this problem before. If I something has changed, I am not
> aware of it. I also have an instance of IDS 7.23.UC1 and it works ok.
>
> Any pointers/help is appreciated. Thanks for your time.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Yes I do have permission to create files in the current directory.
In article <8ndnuf$duf$1@news.xmission.com>,
"Watson, Paul" <Paul.Watson@aggregate.com> wrote:
>
> You don't have permission to create the file where you are.
>
> Paul Watson
> WF Software Ltd
> Tel: +44 1436 674729
> Fax: +44 1436 678693
> www.wfsoftware.com/informix
>
> > -----Original Message-----
> > From: euroinvestor@yahoo.com [mailto:euroinvestor@yahoo.com]
> > Sent: Wednesday, August 16, 2000 05:09
> > To: informix-list@iiug.org
> > Subject: SET EXPLAIN: Error -534
> >
> >
> > IDS 7.30.UC2
> > D4GL v 3.00
> >
> > I have the following program:
> >
> > ######
> > database mydb
> > main
> > set explain on
> > end main> > ######
> >
> > Running this program yields the following error:
> > ######
> > Program stopped at 'x.4gl', line number 6.
> > SQL statement error number -534.
> > Cannot open EXPLAIN output file.
> > SYSTEM error number -1.
> > Not owner
> > ######
> >
> > I get the same error when trying to run "SET EXPLAIN" from dbaccess.
> > Never had this problem before. If I something has changed, I am not
> > aware of it. I also have an instance of IDS 7.23.UC1 and it works
ok.
> >
> > Any pointers/help is appreciated. Thanks for your time.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
Sent via Deja.com http://www.deja.com/
Before you buy.
I can't remember where 'sqexplain.out' goes to. Is it users current or
home directory...
Perhaps one already exists in whatever directory, but it was created by
someone else, so it won't let you append to it.
kick off:
find / -name sqexplain.out -ls
and delete whichever ones it finds in the hope that this will resolve
the problem!
Good luck.
In article <8ne3di$k47$1@nnrp1.deja.com>, euroinvestor@yahoo.com writes
>Yes I do have permission to create files in the current directory.
>
>In article <8ndnuf$duf$1@news.xmission.com>,
> "Watson, Paul" <Paul.Watson@aggregate.com> wrote:
>>
>> You don't have permission to create the file where you are.
>>
>> Paul Watson
>> WF Software Ltd
>> Tel: +44 1436 674729
>> Fax: +44 1436 678693
>> www.wfsoftware.com/informix
>>
>> > -----Original Message-----
>> > From: euroinvestor@yahoo.com [mailto:euroinvestor@yahoo.com]
>> > Sent: Wednesday, August 16, 2000 05:09
>> > To: informix-list@iiug.org
>> > Subject: SET EXPLAIN: Error -534
>> >
>> >
>> > IDS 7.30.UC2
>> > D4GL v 3.00
>> >
>> > I have the following program:
>> >
>> > ######
>> > database mydb
>> > main
>> > set explain on
>> > end main>> > ######
>> >
>> > Running this program yields the following error:
>> > ######
>> > Program stopped at 'x.4gl', line number 6.
>> > SQL statement error number -534.
>> > Cannot open EXPLAIN output file.
>> > SYSTEM error number -1.
>> > Not owner
>> > ######
>> >
>> > I get the same error when trying to run "SET EXPLAIN" from dbaccess.
>> > Never had this problem before. If I something has changed, I am not
>> > aware of it. I also have an instance of IDS 7.23.UC1 and it works
>ok.
>> >
>> > Any pointers/help is appreciated. Thanks for your time.
>> >
>> >
>> > Sent via Deja.com http://www.deja.com/
>> > Before you buy.
>> >
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Andrew Lennard andy@kontron.demon.co.uk
current directory.
In article <ph9L8eA3Oqm5EwK1@kontron.demon.co.uk>,
Andy Lennard <andy@kontron.demon.co.uk> wrote:
> I can't remember where 'sqexplain.out' goes to. Is it users current or
> home directory...
>
> Perhaps one already exists in whatever directory, but it was created
by
> someone else, so it won't let you append to it.
>
> kick off:
>
> find / -name sqexplain.out -ls
>
> and delete whichever ones it finds in the hope that this will resolve
> the problem!
>
> Good luck.
>
> In article <8ne3di$k47$1@nnrp1.deja.com>, euroinvestor@yahoo.com
writes
> >Yes I do have permission to create files in the current directory.
> >
> >In article <8ndnuf$duf$1@news.xmission.com>,
> > "Watson, Paul" <Paul.Watson@aggregate.com> wrote:
> >>
> >> You don't have permission to create the file where you are.
> >>
> >> Paul Watson
> >> WF Software Ltd
> >> Tel: +44 1436 674729
> >> Fax: +44 1436 678693
> >> www.wfsoftware.com/informix
> >>
> >> > -----Original Message-----
> >> > From: euroinvestor@yahoo.com [mailto:euroinvestor@yahoo.com]
> >> > Sent: Wednesday, August 16, 2000 05:09
> >> > To: informix-list@iiug.org
> >> > Subject: SET EXPLAIN: Error -534
> >> >
> >> >
> >> > IDS 7.30.UC2
> >> > D4GL v 3.00
> >> >
> >> > I have the following program:
> >> >
> >> > ######
> >> > database mydb
> >> > main
> >> > set explain on
> >> > end main> >> > ######
> >> >
> >> > Running this program yields the following error:
> >> > ######
> >> > Program stopped at 'x.4gl', line number 6.
> >> > SQL statement error number -534.
> >> > Cannot open EXPLAIN output file.
> >> > SYSTEM error number -1.
> >> > Not owner
> >> > ######
> >> >
> >> > I get the same error when trying to run "SET EXPLAIN" from
dbaccess.
> >> > Never had this problem before. If I something has changed, I am
not
> >> > aware of it. I also have an instance of IDS 7.23.UC1 and it works
> >ok.
> >> >
> >> > Any pointers/help is appreciated. Thanks for your time.
> >> >
> >> >
> >> > Sent via Deja.com http://www.deja.com/
> >> > Before you buy.
> >> >
> >>
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> Andrew Lennard
andy@kontron.demon.co.uk
>
--
# unrm /
ksh: unrm: not found
# man cpio
Sent via Deja.com http://www.deja.com/
Before you buy.
-Current directory has "drwxrwxrwx" permissions. So I don't think that
would be the problem. Also, this used to work.
-And I don't remember changing anything. Haven't messed with
permissions on the Informix binaries.
-I don't have a temp dbspace set, as someone suggested. So I guess I'll
have to try that.
- I also tried a) removing sqexplain.out and b) creating a zero-length
file with "-rwxrwxrwx" permissions.
-SET EXPLAIN does work when I'm user 'informix', though.
Sorry about cramming all my replies here. I use deja.com from work and
I don't have the news reader interface that sorts message threads.
Every reply seems to be a new post in deja, although one can view the
threads with a link.
In article <8neada$suj$1@nnrp1.deja.com>,
mars1972@my-deja.com wrote:
> current directory.
>
> In article <ph9L8eA3Oqm5EwK1@kontron.demon.co.uk>,
> Andy Lennard <andy@kontron.demon.co.uk> wrote:
> > I can't remember where 'sqexplain.out' goes to. Is it users current
or
> > home directory...
> >
> > Perhaps one already exists in whatever directory, but it was created
> by
> > someone else, so it won't let you append to it.
> >
> > kick off:
> >
> > find / -name sqexplain.out -ls
> >
> > and delete whichever ones it finds in the hope that this will
resolve
> > the problem!
> >
> > Good luck.
> >
> > In article <8ne3di$k47$1@nnrp1.deja.com>, euroinvestor@yahoo.com
> writes
> > >Yes I do have permission to create files in the current directory.
> > >
> > >In article <8ndnuf$duf$1@news.xmission.com>,
> > > "Watson, Paul" <Paul.Watson@aggregate.com> wrote:
> > >>
> > >> You don't have permission to create the file where you are.
> > >>
> > >> Paul Watson
> > >> WF Software Ltd
> > >> Tel: +44 1436 674729
> > >> Fax: +44 1436 678693
> > >> www.wfsoftware.com/informix
> > >>
> > >> > -----Original Message-----
> > >> > From: euroinvestor@yahoo.com [mailto:euroinvestor@yahoo.com]
> > >> > Sent: Wednesday, August 16, 2000 05:09
> > >> > To: informix-list@iiug.org
> > >> > Subject: SET EXPLAIN: Error -534
> > >> >
> > >> >
> > >> > IDS 7.30.UC2
> > >> > D4GL v 3.00
> > >> >
> > >> > I have the following program:
> > >> >
> > >> > ######
> > >> > database mydb
> > >> > main
> > >> > set explain on
> > >> > end main> > >> > ######
> > >> >
> > >> > Running this program yields the following error:
> > >> > ######
> > >> > Program stopped at 'x.4gl', line number 6.
> > >> > SQL statement error number -534.
> > >> > Cannot open EXPLAIN output file.
> > >> > SYSTEM error number -1.
> > >> > Not owner
> > >> > ######
> > >> >
> > >> > I get the same error when trying to run "SET EXPLAIN" from
> dbaccess.
> > >> > Never had this problem before. If I something has changed, I am
> not
> > >> > aware of it. I also have an instance of IDS 7.23.UC1 and it
works
> > >ok.
> > >> >
> > >> > Any pointers/help is appreciated. Thanks for your time.
> > >> >
> > >> >
> > >> > Sent via Deja.com http://www.deja.com/
> > >> > Before you buy.
> > >> >
> > >>
> > >
> > >
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> >
> > Andrew Lennard
> andy@kontron.demon.co.uk
> >
>
> --
> # unrm /
> ksh: unrm: not found
> # man cpio
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
R Srinivasan wrote: > > -Current directory has "drwxrwxrwx" permissions. So I don't think that > would be the problem. Also, this used to work. > -And I don't remember changing anything. Haven't messed with > permissions on the Informix binaries. > -I don't have a temp dbspace set, as someone suggested. So I guess I'll > have to try that. > - I also tried a) removing sqexplain.out and b) creating a zero-length > file with "-rwxrwxrwx" permissions. > -SET EXPLAIN does work when I'm user 'informix', though. I say a report once that said this happens/doesn't happen depending on whether you started the engine as informix or root. -- +----------------------------------------------------------+ David Kleppinger Assoc. Dir. of Admin. Computing Dallas Theological Seminary +----------------------------------------------------------+
And you would be absolutely correct, Sir. Don't ask me why. I really don't know. But it works when the database is started as user 'informix'. Thank you. I love you guys. The power of the Internet. In article <399B0D3D.661CA5D4@dts.edu>, dkleppinger@dts.edu wrote: > R Srinivasan wrote: > > > > -Current directory has "drwxrwxrwx" permissions. So I don't think that > > would be the problem. Also, this used to work. > > -And I don't remember changing anything. Haven't messed with > > permissions on the Informix binaries. > > -I don't have a temp dbspace set, as someone suggested. So I guess I'll > > have to try that. > > - I also tried a) removing sqexplain.out and b) creating a zero- length > > file with "-rwxrwxrwx" permissions. > > -SET EXPLAIN does work when I'm user 'informix', though. > > I say a report once that said this happens/doesn't happen depending on > whether you started the engine as informix or root. > -- > +----------------------------------------------------------+ > David Kleppinger > Assoc. Dir. of Admin. Computing > Dallas Theological Seminary > +----------------------------------------------------------+ > Sent via Deja.com http://www.deja.com/ Before you buy.
This is not good solution. SET EXPLAIN (and everything else) must work in the
same way when root strats engine. I think the reason is in ownership of ONINIT
file. So:
ls -l oninit
have to produce:
-rwsr-sr-- 1 root informix 4654164 Oct 24 1997 oninit
On Thu, 17 Aug 2000 03:44:31 GMT, R Srinivasan <euroinvestor@yahoo.com> wrote:
>And you would be absolutely correct, Sir. Don't ask me why. I really
>don't know. But it works when the database is started as
>user 'informix'. Thank you. I love you guys. The power of the Internet.
>
>In article <399B0D3D.661CA5D4@dts.edu>,
> dkleppinger@dts.edu wrote:
>> R Srinivasan wrote:
>> >
>> > -Current directory has "drwxrwxrwx" permissions. So I don't think
>that
>> > would be the problem. Also, this used to work.
>> > -And I don't remember changing anything. Haven't messed with
>> > permissions on the Informix binaries.
>> > -I don't have a temp dbspace set, as someone suggested. So I guess
>I'll
>> > have to try that.
>> > - I also tried a) removing sqexplain.out and b) creating a zero-
>length
>> > file with "-rwxrwxrwx" permissions.
>> > -SET EXPLAIN does work when I'm user 'informix', though.
>>
>> I say a report once that said this happens/doesn't happen depending on
>> whether you started the engine as informix or root.
>> --
>> +----------------------------------------------------------+
>> David Kleppinger
>> Assoc. Dir. of Admin. Computing
>> Dallas Theological Seminary
>> +----------------------------------------------------------+
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.