Hi,The first time the after a DB start DB.DBA.RDF_GEO_FILL () is called, the error occurs after less than a half a minute.
On consecutive attempts it then only takes a few seconds.
The error occurs independent of whether resources carry the virtuoso specific geo-literals. However, as already mentionend, adding those seems to be a workaround for that issue.
Regards, ClausChanges made to the virtuoso.ini file: (without those changes, the dataset wouldn't load; full ini file attached)
[Database] MaxCheckpointRemap = 5000000 [TempDatabase] MaxCheckpointRemap = 5000000 [Parameters] NumberOfBuffers = 250000 MaxDirtyBuffers = 187500 Output of status: Connected to OpenLink Virtuoso Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver*** Error 40010: [Virtuoso Driver][Virtuoso Server]AQ003: Not allowed to wait for AQ while holding locks
at line 1 of Top-Level: DB.DBA.RDF_GEO_FILL () SQL> status(); REPORT VARCHAR _______________________________________________________________________________ OpenLink Virtuoso VDB Server Version 06.01.3127-pthreads for Linux as of Apr 19 2010 Registered to LinkedGeoData Evaluation (Personal Edition, 500 connections) Started on: 2010/07/13 16:53 GMT+120 Database Status: File size 13656653824, 1667072 pages, 731248 free.250000 buffers, 249997 used, 1612 dirty 0 wired down, repl age 70834 0 w. io 0 w/crsr.
Disk Usage: 281933 reads avg 0 msec, 0% r 0% w last 0 s, 144920 writes,
549 read ahead, batch = 216. Autocompact 21 in 17 out, 18% saved.
Gate: 1189 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
Log = virtuoso.trx, 2223 bytes
VDB: 0 exec 0 fetch 0 transact 0 error
934011 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 1 connects, max 1 concurrent
RPC: 8 calls, 1 pending, 1 max until now, 0 queued, 1 burst reads (12%),
0 second brk=173060096
Checkpoint Remap 0 pages, 0 mapped back. 586 s atomic time.
DB master 1667072 total 731248 free 0 remap 0 mapped back
temp 256 total 251 free
Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
Currently 1 threads running 0 threads waiting 0 threads in vdb.
Pending:
Client 1111:1:-2: Account: dba, 348 bytes in, 383 bytes out, 1 stmts.
PID: 20265, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks:
Running Statements:
Time (msec) Text
151 status()
Replication Status: Server virtuoso-LGD.
virtuoso-LGD virtuoso-LGD 0 OFF.
Hash indexes
45 Rows. -- 175 msec.
SQL>
On 07/13/2010 05:58 PM, Hugh Williams wrote:
Hi Claus, Does this error occur immediate or after a period to time ? At the point of the error if you run the Virtuoso "status()" command from isql are any locks or deadlocks reported ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 13 Jul 2010, at 16:06, Claus Stadler wrote:Hi, When doing SQL> DB.DBA.RDF_GEO_FILL (); on a dataset with about 300mio triples, containing wgs84_pos lat/long and georss:point coordinates (for namespaces, see end of mail), the function exists with the following error: *** Error 40010: [Virtuoso Driver][Virtuoso Server]AQ003: Not allowed to wait for AQ while holding locks Is this a known issue? When adding the virtuoso specific triples like: <...> geo:geometry "POINT(12.0768613 48.5573079)"^^virtrdf:Geometry; to the source data and then loading it (with ttlp), they index properly. (Note: When I added the triples, I changed the wgs84_pos namespace to geo as in the examples[2]- although that shouldn't matter) Version: OpenLink Virtuoso Universal Server (Enterprise Edition) Version 06.01.3127-pthreads as of Apr 19 2010 Compiled for Linux (x86_64-generic-linux-glibc25-64) Hosted Runtime Environments: VDB 12:33:04 OpenLink Virtuoso Universal Server 12:33:04 Version 06.01.3127-pthreads for Linux as of Apr 19 2010 12:33:04 uses parts of OpenSSL, PCRE, Html Tidy 12:33:04 Registered to LinkedGeoData Evaluation 12:33:04 Personal Edition license for 500 connections 12:33:10 Database version 3126 Kind regards, Claus [1] Namespace-prefixes: @prefix wgs84_pos:<http://www.w3.org/2003/01/geo/wgs84_pos#> . @prefix virtrdf:<http://www.openlinksw.com/schemas/virtrdf#> . @prefix georss:<http://www.georss.org/georss/> . [2] http://docs.openlinksw.com/virtuoso/rdfsparqlgeospat.html ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
virtuoso.ini
Description: application/wine-extension-ini
