Re: [sqlite] Facing "SQLite ERROR : unable to open database file" error

[Michael Black]

Is there some reason there's the rather poor "unable to open" message
without the actual error message?

Strerror coming to mind if it hasn't disappeared under foot at those places?

I see these questions on the list fairly often and they would all be
answered with an intelligent error messagefrequently permission
oriented.

All such errors should say the file they errored on and the system error
along with it.

At an absolute minimum they should say the filename which would still allow
much better diagnosis rather than trying to guess what's going on.





___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Facing "SQLite ERROR : unable to open database file" error

[Ashok Pitambar]

Got it , Thanks Dan.

On Wed, Jan 16, 2013 at 4:29 PM, Dan Kennedy  wrote:

> On 01/16/2013 05:42 PM, Ashok Pitambar wrote:
>
>> Thanks Dan,
>>
>> I will try by setting this pragma but still I don't understand why it is
>> failing for few query operations.
>>
>
> The temporary files might be statement journals. Which are only required
> by some statements and only if they occur within a BEGIN/COMMIT block.
>
>   
> http://www.sqlite.org/**tempfiles.html#stmtjrnl
>
>
>
>> Regards,
>> Ashok
>>
>>
>>
>> On Wed, Jan 16, 2013 at 1:46 PM, Dan Kennedy
>>  wrote:
>>
>>  On 01/16/2013 02:21 PM, Ashok Pitambar wrote:
>>>
>>>  Hi All,

   I have used sqlite for Database in my client , to speed up
 the
 performance
 I used *"begin"(BEGIN;) *and *"end"(END;)* query transactions to

 include multiple
 transactions in single transaction. This helped in performance by
 reducing
 the time
 taken to write all the transactions but when I used this for some of the
 DB
 operations
 sqlite throws error "unable to open database file".If I remove the
 changes
 it works
 fine.What could be the problem here?


>>> It might be failing to create a temporary file to use for a
>>> statement journal.
>>>
>>>
>>> http://www.sqlite.org/pragma.html#pragma_temp_store
>>> http://www.sqlite.org/pragma.html#pragma_temp_store>
>>> >
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>> 
>>> >
>>>
>>>  __**_
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>>
>>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Facing "SQLite ERROR : unable to open database file" error

[Dan Kennedy]

On 01/16/2013 05:42 PM, Ashok Pitambar wrote:

Thanks Dan,

I will try by setting this pragma but still I don't understand why it is
failing for few query operations.


The temporary files might be statement journals. Which are only required
by some statements and only if they occur within a BEGIN/COMMIT block.

  http://www.sqlite.org/tempfiles.html#stmtjrnl




Regards,
Ashok



On Wed, Jan 16, 2013 at 1:46 PM, Dan Kennedy  wrote:


On 01/16/2013 02:21 PM, Ashok Pitambar wrote:


Hi All,

  I have used sqlite for Database in my client , to speed up
the
performance
I used *"begin"(BEGIN;) *and *"end"(END;)* query transactions to

include multiple
transactions in single transaction. This helped in performance by reducing
the time
taken to write all the transactions but when I used this for some of the
DB
operations
sqlite throws error "unable to open database file".If I remove the changes
it works
fine.What could be the problem here?



It might be failing to create a temporary file to use for a
statement journal.

   
http://www.sqlite.org/pragma.**html#pragma_temp_store
__**_
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Facing "SQLite ERROR : unable to open database file" error

[Ashok Pitambar]

Thanks Dan,

I will try by setting this pragma but still I don't understand why it is
failing for few query operations.

Regards,
Ashok



On Wed, Jan 16, 2013 at 1:46 PM, Dan Kennedy  wrote:

> On 01/16/2013 02:21 PM, Ashok Pitambar wrote:
>
>> Hi All,
>>
>>  I have used sqlite for Database in my client , to speed up
>> the
>> performance
>> I used *"begin"(BEGIN;) *and *"end"(END;)* query transactions to
>>
>> include multiple
>> transactions in single transaction. This helped in performance by reducing
>> the time
>> taken to write all the transactions but when I used this for some of the
>> DB
>> operations
>> sqlite throws error "unable to open database file".If I remove the changes
>> it works
>> fine.What could be the problem here?
>>
>
> It might be failing to create a temporary file to use for a
> statement journal.
>
>   
> http://www.sqlite.org/pragma.**html#pragma_temp_store
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Facing "SQLite ERROR : unable to open database file" error

[Dan Kennedy]

On 01/16/2013 02:21 PM, Ashok Pitambar wrote:

Hi All,

 I have used sqlite for Database in my client , to speed up the
performance
I used *"begin"(BEGIN;) *and *"end"(END;)* query transactions to
include multiple
transactions in single transaction. This helped in performance by reducing
the time
taken to write all the transactions but when I used this for some of the DB
operations
sqlite throws error "unable to open database file".If I remove the changes
it works
fine.What could be the problem here?


It might be failing to create a temporary file to use for a
statement journal.

  http://www.sqlite.org/pragma.html#pragma_temp_store
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Facing "SQLite ERROR : unable to open database file" error

[Ashok Pitambar]

Hi All,

I have used sqlite for Database in my client , to speed up the
performance
I used *"begin"(BEGIN;) *and *"end"(END;)* query transactions to
include multiple
transactions in single transaction. This helped in performance by reducing
the time
taken to write all the transactions but when I used this for some of the DB
operations
sqlite throws error "unable to open database file".If I remove the changes
it works
fine.What could be the problem here?

Thanks &
Regards,
Ashok
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users