Re: [sqlite] sqlite3 hangs on query
On 15/02/2017 23:36, Richard Hipp wrote: On 2/15/17, Richard Hipp wrote: It is an optimization opportunity, not a bug. That optimization is now on trunk. Very cool! Thanks, - Heiner ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
On 2/15/17, Richard Hipp wrote: > > It is an optimization opportunity, not a bug. > That optimization is now on trunk. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
On 2/15/17, Simon Slavin wrote: > select * from albums, album_asset, cacheReferences, coreInfo, space limit 1; > > It’s using 100% CPU time (on a multicore CPU). It is still a 5-way join. It will terminate after looking at all 20,318,172,864 possible combinations of albums, album_assets, cacheReferences, and coreInfo and realizing that the space table will be empty in every case. It is an optimization opportunity, not a bug. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
On 2/15/2017 1:53 PM, Jens-Heiner Rechtien wrote: Please try the following with the restored database: The query *select * from albums, album_asset, cacheReferences, coreInfo, space limit 1;* will hang as well. Ah, interesting. space is empty, which is what makes the difference. In the query plan, it ends up in the innermost loop. SQLite then goes through the full cross join of all the other tables, only to get to the inner loop and discover that there isn't going to be a row after all. "LIMIT 1" doesn't help any as the query is never going to produce a row. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
On 15 Feb 2017, at 6:53pm, Jens-Heiner Rechtien wrote: > Please try the following with the restored database: > > The query > *select * from albums, album_asset, cacheReferences, coreInfo, space limit 1;* > will hang as well. > > The query > *select * from albums, album_asset, cacheReferences, coreInfo, coreMD5 limit > 1;* > on the other hand runs very fast as only the first rows of each table are > concatenated. Run Time: real 0.005 user 0.000317 sys 0.000248. Interesting. I have verified that these all execute in the expected short times: select * from albums, album_asset, cacheReferences, coreInfo limit 1; select * from albums, album_asset, cacheReferences, coreInfo, coreMD5 limit 1; select * from albums, album_asset, cacheReferences, space limit 1; whereas this one appears to hang: select * from albums, album_asset, cacheReferences, coreInfo, space limit 1; It’s using 100% CPU time (on a multicore CPU). Sampling suggests that the CLI is spending almost all its time doing paging and caching calls. I’m using SQLite version 3.16.0 2016-11-04 19:09:39. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
Hi SQLite team, sorry for replaying to my own email, the subscription to this list came only just through (got eaten by my SPAM folder), so I had to read your friendly replies via the list archive. @Simon: thanks for pointing out that attachments do not work on the list. I should have known this. The dumped database (~800kB) in question can be found here: https://dl.dropboxusercontent.com/u/92394185/db.dump.gz I've checked the database for corruption with a PRAGMA integrity_check, it found nothing. Anyway the problem persists a dump and restore cycle, so I doubt that corruption plays a role here. @Clemens, @Igor, @Richard and @Gunter: I know that the cross join with 19 tables in itself is utter nonsense. The purpose is to name all tables in the database in one query - in the app there is special mechanism in place which intercepts queries, parses for the statement for table names and updates the tables from another data source upfront, before the query is executed. Naming all tables would force this update for whole database. It turned out that the intercepting parser doesn't know about sql comments, so a simple "SELECT current_date -- names>" works just as well. But the problem I reported here is genuine. The query doesn't take that long, the database isn't that sizeable. About 0.3s on my Mac if the select statement is shortened by the *spacefavorite* table. Please try the following with the restored database: The query *select * from albums, album_asset, cacheReferences, coreInfo, space limit 1;* will hang as well. The query *select * from albums, album_asset, cacheReferences, coreInfo, coreMD5 limit 1;* on the other hand runs very fast as only the first rows of each table are concatenated. Run Time: real 0.005 user 0.000317 sys 0.000248. Note that the *space* table is empty, so the expected result of the cross join in the first query would be an empty result set. With a slightly different data set this is just what I get. Thanks, - Heiner On 14/02/2017 13:33, Jens-Heiner Rechtien wrote: Hi SQLite team, please consider the attached dump of a sqlite3 database and the following - admittedly nonsensical, don't ask - query over a restored version of the database: *SELECT count(*) FROM spacefavorite, album_asset, albums, assetProfileLinks, avatarCacheReferences, cacheReferences, comment, conflicts, coreInfo, coreMD5, errors, flags, importSource, missingBinariesOnOz, profileRegistration, quota_exceeded, renditionRevisions, space, space_album LIMIT 1;** * On iOS, MacOS and Linux this query will busy hang and never return. Happens with the command line tool and if used as a prepared statement in our iOS app. Changing certain aspects of the query will resolve the problem: leaving the table "spacefavorite" out of the query, or replacing count(*) with a just an asterisk. I tried the following versions: 3.14.0, 3.16.2 (MacOSX Sierra), 3.13.0, 3.17.0 (Linux Fedora 24), 3.14.0 (iOS 10), always the same behavior. Many thanks for your consideration and especially for your great tool. Heiner -- Jens-Heiner Rechtien mailto:aw...@adobe.com>> Computer Scientist Adobe Systems Engineering GmbH Große Elbstraße 27 22767 Hamburg Registergericht: Hamburg HRB 745 37 Geschäftsführer: Michael D. Jamrosy, Christian Keim, Thomas Mührke, Keith San Felipe ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
Maybe the original intent was to count all the rows in all the tables separately and return a vector of record counts, as a poor man's integrity check to make sure no rows got lost. Like Select (select count() from t1) as t1,(select count() from t2) as t2, ...; -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Richard Hipp Gesendet: Dienstag, 14. Februar 2017 17:04 An: SQLite mailing list Betreff: Re: [sqlite] sqlite3 hangs on query On 2/14/17, Igor Tandetnik wrote: > On 2/14/2017 7:33 AM, Jens-Heiner Rechtien wrote: >> please consider the attached dump of a sqlite3 database and the >> following - admittedly nonsensical, don't ask - query over a restored >> version of the database: >> >> *SELECT count(*) FROM spacefavorite, album_asset, albums, >> assetProfileLinks, avatarCacheReferences, cacheReferences, comment, >> conflicts, coreInfo, coreMD5, errors, flags, importSource, >> missingBinariesOnOz, profileRegistration, quota_exceeded, >> renditionRevisions, space, space_album LIMIT 1;** >> * > > You are asking SQLite to count an enormous number of rows, so don't be > surprised if that takes an enormous amount of time. > > You have a cross-join of 19 tables. Even if each one contains just 2 > rows, that's 2^19 ~ 500K rows to work through. And it grows > exponentially from there. I suppose a query planner optimization is possible here. SQLite could rewrite queries of the form: SELECT count(*) FROM t1,t2,t3,t4,...,tN; Into something like this: SELECT (SELECT count(*) FROM t1)*(SELECT count(*) FROM t2)*...*(SELECT count(*) FROM tN); I say that it is possible to do this. But it seems like a low-value optimization - just something to complicate testing and increase the library footprint without actually adding value. So there is nothing like this on the To-Do list. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: h...@scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
On 2/14/17, Igor Tandetnik wrote: > On 2/14/2017 7:33 AM, Jens-Heiner Rechtien wrote: >> please consider the attached dump of a sqlite3 database and the >> following - admittedly nonsensical, don't ask - query over a restored >> version of the database: >> >> *SELECT count(*) FROM spacefavorite, album_asset, albums, >> assetProfileLinks, avatarCacheReferences, cacheReferences, comment, >> conflicts, coreInfo, coreMD5, errors, flags, importSource, >> missingBinariesOnOz, profileRegistration, quota_exceeded, >> renditionRevisions, space, space_album LIMIT 1;** >> * > > You are asking SQLite to count an enormous number of rows, so don't be > surprised if that takes an enormous amount of time. > > You have a cross-join of 19 tables. Even if each one contains just 2 > rows, that's 2^19 ~ 500K rows to work through. And it grows > exponentially from there. I suppose a query planner optimization is possible here. SQLite could rewrite queries of the form: SELECT count(*) FROM t1,t2,t3,t4,...,tN; Into something like this: SELECT (SELECT count(*) FROM t1)*(SELECT count(*) FROM t2)*...*(SELECT count(*) FROM tN); I say that it is possible to do this. But it seems like a low-value optimization - just something to complicate testing and increase the library footprint without actually adding value. So there is nothing like this on the To-Do list. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
On 2/14/2017 7:33 AM, Jens-Heiner Rechtien wrote: please consider the attached dump of a sqlite3 database and the following - admittedly nonsensical, don't ask - query over a restored version of the database: *SELECT count(*) FROM spacefavorite, album_asset, albums, assetProfileLinks, avatarCacheReferences, cacheReferences, comment, conflicts, coreInfo, coreMD5, errors, flags, importSource, missingBinariesOnOz, profileRegistration, quota_exceeded, renditionRevisions, space, space_album LIMIT 1;** * You are asking SQLite to count an enormous number of rows, so don't be surprised if that takes an enormous amount of time. You have a cross-join of 19 tables. Even if each one contains just 2 rows, that's 2^19 ~ 500K rows to work through. And it grows exponentially from there. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
Jens-Heiner Rechtien wrote: > SELECT count(*) > FROM spacefavorite, album_asset, albums, assetProfileLinks, > avatarCacheReferences, > cacheReferences, comment, conflicts, coreInfo, coreMD5, errors, flags, > importSource, missingBinariesOnOz, profileRegistration, quota_exceeded, > renditionRevisions, space, space_album > LIMIT 1; The "LIMIT 1" does not have any effect because COUNT() returns only one row. > this query will busy hang and never return. It would return if you just waited long enough. This is how your query would be implemented for five tables: sqlite> explain select count(*) from a, b, c, d, e; addr opcode p1p2p3p4 p5 comment - - -- - 0 Init 0 27000 Start at 27 1 Null 0 1 100 r[1..1]=NULL 2 OpenRead 0 3 0 0 00 root=3 iDb=0; a 3 OpenRead 1 2 0 0 00 root=2 iDb=0; b 4 OpenRead 2 4 0 0 00 root=4 iDb=0; c 5 OpenRead 3 5 0 0 00 root=5 iDb=0; d 6 OpenRead 4 6 0 0 00 root=6 iDb=0; e 7 Rewind 0 18000 8 Rewind 1 17000 9 Rewind 2 16000 10 Rewind 3 15000 11Rewind 4 14000 12 AggStep0 0 0 1 count(0) 00 accum=r[1] step(r[0]) 13Next 4 12001 14 Next 3 11001 15Next 2 10001 16 Next 1 9 001 17Next 0 8 001 18Close 0 0 000 ... 23AggFinal 1 0 0 count(0) 00 accum=r[1] N=0 24Copy 1 2 000 r[2]=r[1] 25ResultRow 2 1 000 output=r[2] ... Please note that "," is just the short form of "CROSS JOIN", so this query is implemented as lots of nested loops. > admittedly nonsensical You could speed up this query by deleting the contents of all tables ... Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs on query
On 14 Feb 2017, at 12:33pm, Jens-Heiner Rechtien wrote: > please consider the attached dump of a sqlite3 database and the following - > admittedly nonsensical, don't ask - query over a restored version of the > database Jens, You can’t send attachments to this list. If your dump text is short, you should be able to just past it into a message. If long, please put it on a server somewhere. However, on reading your text I was wondering whether your database is corrupt. Please execute PRAGMA integrity_check; on it and tell us whether it returns an error. You might also try weeding extraneous tables out of your command and see if you can find a shorter version of your command which also hangs. This could mean you could demonstrate the problem without creating so many tables. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3 hangs on query
Hi SQLite team, please consider the attached dump of a sqlite3 database and the following - admittedly nonsensical, don't ask - query over a restored version of the database: *SELECT count(*) FROM spacefavorite, album_asset, albums, assetProfileLinks, avatarCacheReferences, cacheReferences, comment, conflicts, coreInfo, coreMD5, errors, flags, importSource, missingBinariesOnOz, profileRegistration, quota_exceeded, renditionRevisions, space, space_album LIMIT 1;** * On iOS, MacOS and Linux this query will busy hang and never return. Happens with the command line tool and if used as a prepared statement in our iOS app. Changing certain aspects of the query will resolve the problem: leaving the table "spacefavorite" out of the query, or replacing count(*) with a just an asterisk. I tried the following versions: 3.14.0, 3.16.2 (MacOSX Sierra), 3.13.0, 3.17.0 (Linux Fedora 24), 3.14.0 (iOS 10), always the same behavior. Many thanks for your consideration and especially for your great tool. Heiner -- Jens-Heiner Rechtien mailto:aw...@adobe.com>> Computer Scientist Adobe Systems Engineering GmbH Große Elbstraße 27 22767 Hamburg Registergericht: Hamburg HRB 745 37 Geschäftsführer: Michael D. Jamrosy, Christian Keim, Thomas Mührke, Keith San Felipe ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs
On 19/09/14 17:40, Bokassa wrote: > Hi all, > I see my query hanging with this stack: > > dybagme->where > #0 0x00332b00ee00 in __fsync_nocancel () from /lib64/libpthread.so.0 > #1 0x0041b418 in full_fsync (fd=6, fullSync=0, dataOnly=0) at > sqlite3.c:27735 ... > The program itself is in state D waiting for IO. I am writing on a local > disk. I don't use threads. > What can be wrong? SQLite isn't wrong. It uses the fsync api provided by Unix to ensure file/directory contents are written to the storage media (ie would still be there after a power failure). You'll need to look in your OS logs and monitoring tools to find out what is going on. Note that some filesystems are implemented such that asking to fsync a file instead does a sync of the whole filesystem (it is done because of metadata and journalling issues). For example if you were separately extracting lots of files they could get caught up in the fsync. The spec for fsync is that it doesn't return until the file/directory is on storage. Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3 hangs
Hi all, I see my query hanging with this stack: dybagme->where #0 0x00332b00ee00 in __fsync_nocancel () from /lib64/libpthread.so.0 #1 0x0041b418 in full_fsync (fd=6, fullSync=0, dataOnly=0) at sqlite3.c:27735 #2 0x0041b54c in unixSync (id=0x2315650, flags=2) at sqlite3.c:27824 #3 0x00411c7c in sqlite3OsSync (id=0x2315650, flags=2) at sqlite3.c:15816 #4 0x004243c8 in syncJournal (pPager=0x23153f8, newHdr=0) at sqlite3.c:44399 #5 0x00426829 in sqlite3PagerCommitPhaseOne (pPager=0x23153f8, zMaster=0x0, noSync=0) at sqlite3.c:46451 #6 0x0042f967 in sqlite3BtreeCommitPhaseOne (p=0x23157b8, zMaster=0x0) at sqlite3.c:54827 #7 0x0043da85 in vdbeCommit (db=0x23150c8, p=0x234c548) at sqlite3.c:64185 #8 0x0043e48b in sqlite3VdbeHalt (p=0x234c548) at sqlite3.c:64592 #9 0x00443f38 in sqlite3VdbeExec (p=0x234c548) at sqlite3.c:68930 #10 0x00441729 in sqlite3Step (p=0x234c548) at sqlite3.c:66694 #11 0x0044191d in sqlite3_step (pStmt=0x234c548) at sqlite3.c:66760 #12 0x0047362a in sqlite3_exec (db=0x23150c8, zSql=0x6fa820 "update vms set pm_id=41,pm_name='s_40' where vm_id=161", xCallback=0x0, pArg=0x0, pzErrMsg=0x6f6808 ) at sqlite3.c:96874 #13 0x0040b830 in db_update_vm_pm (pm=0x232fbf0, vm=0x234a110) at pack.db.c:653 #14 0x0040b4fa in db_record_sched_decision (link=0x2328150) at pack.db.c:580 #15 0x0040849b in place () at pack.place.c:182 #16 0x004051a5 in try_place () at pack.c:241 #17 0x00405022 in run () at pack.c:184 #18 0x00404d7d in main (argc=1, argv=0x7fffacdedb48) at pack.c:88 it is processing things in a loop and updating. If I do the updates in a transaction it returns no error but the database is not updated. The program itself is in state D waiting for IO. I am writing on a local disk. I don't use threads. What can be wrong? Thanks. David Bigagli ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs
On 11/05/2008 03:35 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Muratet wrote: >>> I guess I'm not making my myself clear. I only have one installed >>> version. > > That is not true. If it was true then you wouldn't have ended up with > 3.3.6 being reported as a version in places! You may think you only > have one version, but the operating system obviously has more. mm -- FWIW, RHEL includes sqlite3 version 3.3.6 as /usr/bin/sqlite3 and the libraries for the same are in /usr/lib/ ls -la /usr/lib/*sqlite* lrwxrwxrwx 1 root root 19 May 18 2007 /usr/lib/libsqlite3.so.0 -> libsqlite3.so.0.8.6 -rwxr-xr-x 1 root root 342168 May 5 2007 /usr/lib/libsqlite3.so.0.8.6 I believe yum is linked to sqlite3 on RHEL ... HTH. -- kjh ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: >> I guess I'm not making my myself clear. I only have one installed >> version. That is not true. If it was true then you wouldn't have ended up with 3.3.6 being reported as a version in places! You may think you only have one version, but the operating system obviously has more. >> Does the version info come from a library somewhere or does it come >> from the executable? When using the shell, the version information comes from the api call sqlite3_libversion() which comes from the library. ie if you are dynamic linking then it comes from the dynamic library. You can use strace to find out what exactly is going on as the process starts. It is best to send output to a file. eg strace -o /tmp/log /usr/local/bin/sqlite3 >> Are there file permissions incorporated into a library somewhere or do >> they come from the executable? IIRC they have changed over time. In the olden days you would mark the shared library readable and executable. Nowadays it looks like all you need is readable. BTW if all you are trying to do is use SQLite with Python then you can bypass all this malarkey and get the Python bindings to use the amalgamation directly. Both APSW and pysqlite can automatically download and use it! Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkRaPQACgkQmOOfHg372QQyxgCgo1ZlwQ2/KoAU/aKavs7/Rt/l j8EAn0AX5qL1FDDkyPh1N8yQ7jB69x3k =fhl5 -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 hangs
On Nov 4, 2008, at 5:21 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Michael Muratet wrote: >> I built sqlite >> from the aggregate code but my python project hangs. > > There is a specific mailing list for Python with SQLite - see > http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite Thanks, I'll check it out > > >> So, I tried to >> use it from the command line and noticed that the version was 3.3.6. > > Since you have multiple versions of SQLite on your system and are > using > it from multiple places (python module, command line shell) you need > to > ensure you are picking up the right thing. I guess I'm not making my myself clear. I only have one installed version. Here's what I did: * make sure all pysqlite bits are deleted (the bits I know about, anyway) * get the aggregate code from the website * do a make distclean and make sure the binary is deleted from /usr/ local/bin * do a fresh build, ./configure -> make -> make install in sqlite3.6.4 * new sqlite3 binary now in /usr/local/bin reports that it is 3.3.6 * new sqlite3 binary in the build directory reports that it is 3.6.4 > This will depend on the > configuration of your specific machine and includes things like > library > paths hard linked into modules, $LD_LIBRARY_PATH, /etc/ld.so.conf etc. Does the version info come from a library somewhere or does it come from the executable? Are there file permissions incorporated into a library somewhere or do they come from the executable? Thanks Mike > > > Roger > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.9 (GNU/Linux) > > iEYEARECAAYFAkkQ2QAACgkQmOOfHg372QSyaACfacT0EfJi9tUDveacErfcRE4y > y/UAoOBklKXBu65ZR3Eu+mKIuLl+L6Kh > =caaA > -END PGP SIGNATURE- > ___ > 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] sqlite3 hangs
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Muratet wrote: > I built sqlite > from the aggregate code but my python project hangs. There is a specific mailing list for Python with SQLite - see http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite > So, I tried to > use it from the command line and noticed that the version was 3.3.6. Since you have multiple versions of SQLite on your system and are using it from multiple places (python module, command line shell) you need to ensure you are picking up the right thing. This will depend on the configuration of your specific machine and includes things like library paths hard linked into modules, $LD_LIBRARY_PATH, /etc/ld.so.conf etc. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkQ2QAACgkQmOOfHg372QSyaACfacT0EfJi9tUDveacErfcRE4y y/UAoOBklKXBu65ZR3Eu+mKIuLl+L6Kh =caaA -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3 hangs
Greetings I have been trying to get sqlite-3.6.4 to work for a python project I'm building on a Dell eight-core running RedHat ES3. I built sqlite from the aggregate code but my python project hangs. So, I tried to use it from the command line and noticed that the version was 3.3.6. It hangs as well. So, I tried the copy in the build directory and it comes up as 3.6.4 and it will work as long as I am logged in as root. I gave up trying to make that work and downloaded the binary for linux and the library sqlite-3.6.4.so.gz. I copied the binary into /usr/ local/bin which is in PATH. It works as long as I am root. If I try to use it as a regular user is hangs. Can anybody suggest where I have gone wrong? I've checked all the file permissions and I can't think of any other reason that would explain this behavior. Thanks Mike ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users