RE: [sqlite] Re: data base locked problem
> "Igor Tandetnik" <[EMAIL PROTECTED]> schrieb am 11.09.2007 13:40:30: > > > > Armin Steinhoff wrote: > > > if we are try to create a new data base with sqlite we see the > > > following error outputs: > > > > > > # sqlite x.db > > > OPEN3 /appl/sbin/x.db > > > OPEN-EX 4 /tmp/sqlite_Iihb60vuQk4Nf9D > > > SQLite version 2.8.0 > > > Enter ".help" for instructions > > > sqlite> create table yy(xx char(10), x int); > > > SQL error: database is locked > > > sqlite> .q > > > CLOSE 3 > > > CLOSE 4 > > > > > > What's the problem ?? > > > > My guess is, the user account you are running under doesn't have > > permissions to create new files under /appl/sbin. > > No, that's not the case. Please see the correct file > descriptors shown by the trace output (OPEN / OPEN-EX) Try using strace or truss to see what the underlying open failure is (if any). > > --Armin > > >The error message is > > somewhat misleading. > > > > Igor Tandetnik > > > > > > > -- > > --- To unsubscribe, send email to > > [EMAIL PROTECTED] > > > -- > > --- > > > > > _ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071=0066 > > > -- > --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- > --- > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Re: data base locked problem
"Igor Tandetnik" <[EMAIL PROTECTED]> schrieb am 11.09.2007 13:40:30: > > Armin Steinhoff wrote: > > if we are try to create a new data base with sqlite > > we see the following error outputs: > > > > # sqlite x.db > > OPEN3 /appl/sbin/x.db > > OPEN-EX 4 /tmp/sqlite_Iihb60vuQk4Nf9D > > SQLite version 2.8.0 > > Enter ".help" for instructions > > sqlite> create table yy(xx char(10), x int); > > SQL error: database is locked > > sqlite> .q > > CLOSE 3 > > CLOSE 4 > > > > What's the problem ?? > > My guess is, the user account you are running under doesn't have > permissions to create new files under /appl/sbin. No, that's not the case. Please see the correct file descriptors shown by the trace output (OPEN / OPEN-EX) --Armin >The error message is > somewhat misleading. > > Igor Tandetnik > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > _ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071=0066 - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re: data base locked problem
Armin Steinhoff wrote: if we are try to create a new data base with sqlite we see the following error outputs: # sqlite x.db OPEN3 /appl/sbin/x.db OPEN-EX 4 /tmp/sqlite_Iihb60vuQk4Nf9D SQLite version 2.8.0 Enter ".help" for instructions sqlite> create table yy(xx char(10), x int); SQL error: database is locked sqlite> .q CLOSE 3 CLOSE 4 What's the problem ?? My guess is, the user account you are running under doesn't have permissions to create new files under /appl/sbin. The error message is somewhat misleading. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] -
