On 18 Nov 2009, at 8:38pm, priimak wrote:
> I understand that. However, that would not present a problem if I access
> database by its symlink for reading only and database directly if I am
> updating isn't?
According to the documentation that could be a problem. The update application
creat
Pavel Ivanov wrote:
>> That should not be a problem if I use symlink to access database for
>> reads only and
>> actual db file name for updating, isn't?
>>
>
> I believe there can be a problem with such scenario. I don't know
> exactly but I doubt that file system can operate with locks on fi
Simon Slavin wrote:
> On 18 Nov 2009, at 7:15pm, priimak wrote:
>
>
>> I see. However, the problem is related to journal been named after the
>> database name.
>> That should not be a problem if I use symlink to access database for
>> reads only and
>> actual db file name for updating, isn't?
> That should not be a problem if I use symlink to access database for
> reads only and
> actual db file name for updating, isn't?
I believe there can be a problem with such scenario. I don't know
exactly but I doubt that file system can operate with locks on file
handle open via symlink and via a
On 18 Nov 2009, at 7:15pm, priimak wrote:
> I see. However, the problem is related to journal been named after the
> database name.
> That should not be a problem if I use symlink to access database for
> reads only and
> actual db file name for updating, isn't?
If you use a symbolic link for
D. Richard Hipp wrote:
> On Nov 18, 2009, at 1:53 PM, priimak wrote:
>
>
>> Hi.
>>
>> I have a strange problem. I have a database a.db.1 and symlink a.db
>> which points to a.db.1
>> When I use command line sqlite3 command I get following.
>>
>> % echo "select max(id) from t;" | sqlite3 a.db.1
>
On Nov 18, 2009, at 1:53 PM, priimak wrote:
> Hi.
>
> I have a strange problem. I have a database a.db.1 and symlink a.db
> which points to a.db.1
> When I use command line sqlite3 command I get following.
>
> % echo "select max(id) from t;" | sqlite3 a.db.1
> SQL error near line 1: disk I/O erro
Hi.
I have a strange problem. I have a database a.db.1 and symlink a.db
which points to a.db.1
When I use command line sqlite3 command I get following.
% echo "select max(id) from t;" | sqlite3 a.db.1
SQL error near line 1: disk I/O error
but
% echo "select max(id) from t;" | sqlite3 a.db
4461
Nuno Lucas-2 wrote:
>
> On 5/23/07, Shilpa Sheoran wrote:
>> Linux 2.6.9
>> and the media is Nand Flash memory.
>> /dir1/dir2/dir3
>>
>> /dir1/dir2 is readonly (cramfs)
>> dir3 is read write (Flash mem). and I'm creating the database in dir3.
>
> There is your problem. The file system on that
Hi! All,
After using strace, we found the root cause.
SQLite will use some temporary files to keep the select (with union all)
result.
See: http://www.sqlite.org/tempfiles.html
In our system, we allocated 32M for /, and there are only 19M after
booting up the system.
SQLite can not get enough s
Hi! All,
We recently got an error "Disk I/O error" while using the select command
on attached DBs.
These DBs have same table format
We only execute select, insert, and attach commands
The environment is as follows:
SQLite: V3.5.6
OS: Linux 2.6.24.2
Platform Power PC (MPC8543)
Memory: 256M
DB Loc
Hello all,
I recently got an error while running a long query with sqlite3 on
Ubuntu Gutsy 7.10:
SQL error: disk I/O error
I googled for a solution but didn't find anything relevant. After a
bit of sleuthing on my machine, I discovered that I was running out of
disk space. I freed up some disk
On 5/23/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote:
Linux 2.6.9
and the media is Nand Flash memory.
/dir1/dir2/dir3
/dir1/dir2 is readonly (cramfs)
dir3 is read write (Flash mem). and I'm creating the database in dir3.
There is your problem. The file system on that directory (I would
guess J
Linux 2.6.9
and the media is Nand Flash memory.
/dir1/dir2/dir3
/dir1/dir2 is readonly (cramfs)
dir3 is read write (Flash mem). and I'm creating the database in dir3.
Somehow I don't have a problem in a tmpfs.
The strace showed no diff between tmpfs and this directory where it is
giving I/O erro
What is the OS you're using and what kind of media is it?
Hard drive or USB key or ???
--- Shilpa Sheoran <[EMAIL PROTECTED]> wrote:
> It seems that rc = fsync(fd); is failing in function
> static int full_fsync(int fd, int fullSync, int dataOnly) in file os_unix.c
> {
> #else /* if !defined(F_F
It seems that rc = fsync(fd); is failing in function
static int full_fsync(int fd, int fullSync, int dataOnly) in file os_unix.c
{
#else /* if !defined(F_FULLSYNC) */
if( dataOnly ){
rc = fdatasync(fd);
}else{
//*this call is failing
rc = fsync(fd);
If you're using Linux, try:
echo "create table t1(a);" |strace ./sqlite3 my.db 2>&1 |less
and examine the output. See where it differs from the successful
tmpfs run.
Newer versions of sqlite3 may have better IO error messages.
> I'm running the command line tool to create sqlite3 db.
> My direc
I'm running the command line tool to create sqlite3 db.
My directory permissions are drwxrwxrwt.
I'm getting the following error.
./sqlite3 newdb
SQLite version 3.3.12
Enter ".help" for instructions
sqlite> create table tbl1(one varchar(10), two smallint);
SQL error: disk I/O error
If I try t
18 matches
Mail list logo