Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe
Em qui, 27 de set de 2018 às 00:30, Keith Medcalf escreveu: > > Have you checked to make sure the ID that you are using (interactively) is > permitted read/write access to the directory containing the db files and to > the files themselves? I mean *actually* checked that you have permission, > since I doubt that the CGI process is running with the same ID you are > using to logon. > > Good call. I will check but i can write another database file located in the same directory with external tools. The difference of this second db is that is a lot smaller, is not accessed frequently and don't have wal shm files (not sure what is the lock mode) Luiz ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe
Have you checked to make sure the ID that you are using (interactively) is permitted read/write access to the directory containing the db files and to the files themselves? I mean *actually* checked that you have permission, since I doubt that the CGI process is running with the same ID you are using to logon. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Luiz Américo >Sent: Wednesday, 26 September, 2018 20:05 >To: General Discussion of SQLite Database >Subject: [sqlite] Can write to database using API but get an error on >writing with sqlite3.exe > >I have a 1GB database configured to use WAL mode. > >It's accessed by short lived CGI processes, under windows 2008 >server. Each >process usually opens the database, execute a select or >update/insert, >close the connection and finishes. It uses c api >(sqlite3_open, sqlite3_prepare, sqlite3_step) of dll downloaded from >sqlite.org. > >All operations are working fine (reading, writing to the database). >Those >processes are started ~1 to 5 per second > >There's a ~5MB wal and shm file that are being updated frequently > >When i open the same database with sqlite3.exe (or an external tool >like >Sqlite Expert) i can do read commands (select), but when i try to >write to >database (UPDATE / ALTER TABLE) it gives a "Attempt to write a read >only >database" error. > >The tools are executed in the same machine as the datafile > >If i try to open a (smaller, less accessed) database in the same >folder as >the main one all writing operations are allowed in the external tools > >Any hints on what's going on? > >Luiz >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Can write to database using API but get an error on writing with sqlite3.exe
I have a 1GB database configured to use WAL mode. It's accessed by short lived CGI processes, under windows 2008 server. Each process usually opens the database, execute a select or update/insert, close the connection and finishes. It uses c api (sqlite3_open, sqlite3_prepare, sqlite3_step) of dll downloaded from sqlite.org. All operations are working fine (reading, writing to the database). Those processes are started ~1 to 5 per second There's a ~5MB wal and shm file that are being updated frequently When i open the same database with sqlite3.exe (or an external tool like Sqlite Expert) i can do read commands (select), but when i try to write to database (UPDATE / ALTER TABLE) it gives a "Attempt to write a read only database" error. The tools are executed in the same machine as the datafile If i try to open a (smaller, less accessed) database in the same folder as the main one all writing operations are allowed in the external tools Any hints on what's going on? Luiz ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DB To DB Transfer Time
Hello, Thank you for the responses, Stephen and Dominique. I was generally looking for an idea if the transaction time seemed reasonable, given a low end MariaDB server, standard 100Mb LAN, and mid range user processing desktop machine. I realize that the question as answered is; Hard to say! My initial reaction was slow, not good enough. The log db, was created because of the parameters involved in evaluating the transfer had many factors. This allowed a way to track changes in those parameters with results. It also gives additional insight to the testing hardware. SQLite was one of four local file/memory databases evaluated. https://github.com/danap/db_to_filememorydb/blob/master/docs/dblog/db_To_db_Parameters-log.db Again thanks for responses. The idea of using transfers with the SQLite built in tools, .dump, .backup if setup with a similar scenario can provide some reference point to answer my question. danap. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] downloading older versions
From https://www.sqlite.org/chronology.html you should be able to click on the date, then click on the check-in hash number, then click the link after "Downloads:" to download a ZIP, TAR, or SQLAR of the older version. Keep in mind that this gives you a snapshot of the source tree, you would have to build your own amalgamation. I wish this would be a little more intuitive. It would probably be ideal if you could start using the fossil tool. On Wed, Sep 26, 2018 at 2:29 PM David Raymond wrote: > > I think you've got the right idea, but where are you seeing that there was > ever a 3.8.6.1? > I don't see it anywhere on https://www.sqlite.org/changes.html, and 3.8.5 was > in 2014 > > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Mark Wagner > Sent: Wednesday, September 26, 2018 2:24 PM > To: SQLite mailing list > Subject: [sqlite] downloading older versions > > I'm trying to download older versions of sqlite to check the behavior > of various bugs but I'm having trouble finding them. > > For example to get > > SQLite version 3.8.6.1 2017-07-21 03:23:38 > > I have tried: > > https://www.sqlite.org/2017/sqlite-tools-linux-x86-3080601.zip > > Should that have worked? Note that I've tried various "year" > components on the path as well. > > -- Mark > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] downloading older versions
I think you've got the right idea, but where are you seeing that there was ever a 3.8.6.1? I don't see it anywhere on https://www.sqlite.org/changes.html, and 3.8.5 was in 2014 -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Mark Wagner Sent: Wednesday, September 26, 2018 2:24 PM To: SQLite mailing list Subject: [sqlite] downloading older versions I'm trying to download older versions of sqlite to check the behavior of various bugs but I'm having trouble finding them. For example to get SQLite version 3.8.6.1 2017-07-21 03:23:38 I have tried: https://www.sqlite.org/2017/sqlite-tools-linux-x86-3080601.zip Should that have worked? Note that I've tried various "year" components on the path as well. -- Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] downloading older versions
I'm trying to download older versions of sqlite to check the behavior of various bugs but I'm having trouble finding them. For example to get SQLite version 3.8.6.1 2017-07-21 03:23:38 I have tried: https://www.sqlite.org/2017/sqlite-tools-linux-x86-3080601.zip Should that have worked? Note that I've tried various "year" components on the path as well. -- Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DB To DB Transfer Time
On Tue, Sep 25, 2018 at 8:41 PM dmp wrote: > The result for the 50K file db test of SQLite was 370.184 > seconds. Is this a reasonable transfer speed, given the conditions noted? > As Stephen already wrote, impossible to say. Start by contrasting this DB-copy you wrote to other methods: 1) filesystem copy of the DB file (not open by any connection) on the same hardward/disks 2) using sqlite3[.exe]'s .dump piped into another sqlite3 instance to recreate the DB from DB at the destination 3) using sqlite3[.exe]'s .backup, which uses the Backup API you could use in your own code too (assuming available from Java). Now you'd have good reference point to compare against your own Java-based implementation. Completely guessing, but 370s seems to be "slow". Do #1 and/or #2 and/or #3 above, and you'll know for sure. FWIW, --DD PS: There are many ways to implement such a copy, and you're not saying how you implemented it. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)
Sorry, false alarm. That corruption far predates the 3.26 changes (occurred under 3.24). The tool I was using to test didn't show the errors on the old version of the database but a newer tool shows them. Thanks! - Deon -Original Message- From: sqlite-users On Behalf Of Dan Kennedy Sent: Tuesday, September 25, 2018 11:54 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries) On 09/26/2018 01:14 PM, Deon Brewis wrote: > I am receiving an integrity check failure on 3.26 on the 9/19/2018 drop. It's > not everywhere and it may be coincidental, but it may also be related to the > new change where expression indexes aren't updated if their columns aren't > modified. > > I'm getting these integrity check failures: > > wrong # of entries in index A > wrong # of entries in index B > wrong # of entries in index C > > where all 3 of those indexes use expressions. I have a before database, after > database, and an error log from SQLITE. > > Can I send this to someone to investigate? Can you send them to me if you don't want to upload them? "dan AT sqlite.org" if you prefer. Thanks, Dan. > > - Deon > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)
On 09/26/2018 01:14 PM, Deon Brewis wrote: I am receiving an integrity check failure on 3.26 on the 9/19/2018 drop. It's not everywhere and it may be coincidental, but it may also be related to the new change where expression indexes aren't updated if their columns aren't modified. I'm getting these integrity check failures: wrong # of entries in index A wrong # of entries in index B wrong # of entries in index C where all 3 of those indexes use expressions. I have a before database, after database, and an error log from SQLITE. Can I send this to someone to investigate? Can you send them to me if you don't want to upload them? "dan AT sqlite.org" if you prefer. Thanks, Dan. - Deon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)
I am receiving an integrity check failure on 3.26 on the 9/19/2018 drop. It's not everywhere and it may be coincidental, but it may also be related to the new change where expression indexes aren't updated if their columns aren't modified. I'm getting these integrity check failures: wrong # of entries in index A wrong # of entries in index B wrong # of entries in index C where all 3 of those indexes use expressions. I have a before database, after database, and an error log from SQLITE. Can I send this to someone to investigate? - Deon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users