Error: disk I/O error while creating an index

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Error: disk I/O error while creating an index

Tal Tabakman-2
Hi Simon,


thanks for the response below.

as for your questions:

1. I am using version 3.3.6 of sqlite.

2. My journal mode is memory

3. I am opening a transaction and then do 50000 inserts before
committing and opening a new transaction


given the above, what are the requirnments (disk-wise) when I produce
database with file size of 64 M ?

cheers

Tal

On 13 Dec 2011, at 8:10pm, Tal Tabakman wrote:

>* I discovered that the problem was not in the index creation but in the*>* database creation.*>* *>* it seems that during DB creation, a certain commit failed due to Disk*>* quota and after that indexing failed.*
I assume that SQLite did actually return an error for this, and you
just weren't checking the result codes it returned.  If there was an
error because of disk quota and SQLite returned 0 (not an error) for
every call, please post again because this means there's a bug in the
SQLite library and the SQLite team would want to fix it.

>* strangely I don't understand this disk consumption problem I got.*>* *>* a question I have, given the fact that I have a 64 M DB with a promary*>* key on an integer column (which means that implicit index is being*>* done), what are my overall disk requirements, any rule of thumbs here*>* ?*
It depends on

what version of SQLite you're using,
which journaling mode you're using, and
how you are grouping your INSERT commands into transactions.

You might like to watch a utility show you free space on the disk as
you do your INSERT commands.  Also you should know about various
PRAGMAs like

<http://www.sqlite.org/pragma.html#pragma_journal_size_limit>

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Error: disk I/O error while creating an index

Simon Slavin-3

On 19 Dec 2011, at 7:04pm, Tal Tabakman wrote:

> 1. I am using version 3.3.6 of sqlite.
>
> 2. My journal mode is memory
>
> 3. I am opening a transaction and then do 50000 inserts before
> committing and opening a new transaction
>
>
> given the above, what are the requirnments (disk-wise) when I produce
> database with file size of 64 M ?

I hope another person can answer you.  But I think perhaps you will temporarily need at least enough space to store the 50,000 rows of data twice.  Perhaps an SQLite expert can help.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users