Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 41047
Status: resolved
Priority: 0/
Queue: DBD-SQLite

Owner: Nobody in particular
Requestors: ansgar [...]

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

CC: 506157 [...]
Subject: Re: Bug#506157: libdbd-sqlite3-perl: unsufficient error message while opening database for writing
Date: Wed, 19 Nov 2008 00:08:33 +0100
To: "Eugene V. Lyubimkin" <jackyf.devel [...]>
From: Ansgar Burchardt <ansgar [...]>
Download (untitled) / with headers
text/plain 1.3k
Hi, I'm forwarding the bug report, the original report is available on the Debian Bug Tracker[1]. Please CC: in replies. "Eugene V. Lyubimkin" <> writes: Show quoted text
> I've spent several days in investigating strange problem and it would be > good to deal somehow with it. > > SQLite database consists of one file. But, is is unsufficient to have > write rights to this database file to perform 'INSERT' statements. At > least, this perl package have requirement user should have write rights > to directory containing this file too. Otherwise, my 'INSERT' statement > ($sth->execute(...)) will fail with error: > > -8<- > DBD::SQLite::st execute failed: unable to open database file(14) at > dbdimp.c line 403 at /var/www/search-site/cgi-bin/register.cgi line 31, > <STDIN> line 1. > ->8- > > I was very confused to see this while having all necessary right on > database file. Please document this or rather extend the error message.
This behavior is documented in the SQLite documentation[2]. The SQLite library may create temporary for various reasons, even when only using SELECT statements (see [2], 2.5). I prepared a small patch adding a note about this in Regards, Ansgar Footnotes: [1] [2] -- PGP: 1024D/595FAD19 739E 2D09 0969 BEA9 9797 B055 DDB0 2FF7 595F AD19
Download dbd-sqlite.diff
text/x-diff 506b

Message body is not shown because sender requested not to inline it.

Confirming patch applied, marking as resolved.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to