doesn't seem to hurt the sponging any but I'm curious what it is and
whether it's evidence of something I'm doing wrong or something I should
worry about in the future?
Quentin
ClearBlueWater.com.au
<=fileSize)...
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
and whose creation statement ("INSERT INTO
<...> WHERE ...") was reported to insert triples but when I interrogate the
graph, it seems to be empty or not really exist.
Any ideas?
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
INTO
" that must be addressed as to get results.
On Tue, May 15, 2012 at 4:58 PM, Quentin wrote:
> Hi,
>
> Are there any circumstances where the graphs tab of Conductor would show
> duplicate graphs?
>
> I have a bulk load of RDF that seems to occasionally create duplic
://www.w3.org/2001/XMLSchema#int>.
Casting to xsd:int doesn't help either, that won't return in reasonable
time either.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
LineDetail ?lidB . ?lidB ont:Code "Y" ;
ont:LineDetailHasQuantity ?dqB . ?dqB ont:Quantity ?qtyB ; ont:LocationCode
?LocationB filter(SAMETERM(?Location,?LocationB))}
} }
I think I just saw that the SAMETERM isn't strictly necessary but it still
feels like a bug to me.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
I would (perhaps naively) expect that the error should be in the uncast
assignment if we are being strictly typed or implicitly cast the variable
to varchar on assignment if we want to be weakly typed.
--
Quentin | Clear Blue Water Pty Ltd
quent
I occasionally get Virtuoso 37000 Error SQ074: syntax error at '#' before
'SELECT
It only seems to happen when copying a query from gmail into conductor. Is
this a known weirdness with utf8 or something?
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearb
0918117864> <
http://example.com/ontology/sdr/chartLevel> "" .
}
When this query is performed in conductor, it times out. When performed by
odbc then it succeeds but takes about 12m40s to execute.
Refactoring as a WITH DELETE {...} INSERT {...} WHERE {...} using
exactly the same
Also:
$ virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 6.1.6.3127-pthreads as of Nov 20 2012
Compiled for Linux (x86_64-pc-linux-gnu)
On 14 June 2013 11:47, Quentin wrote:
> I have a problem that I solved but I'm still not sure why it occurred.
>
> Our
used by a dozen
or so other users without changing the subject. When we want to update a
user's copy of the report, we get this problem.
On 14 June 2013 11:54, Quentin wrote:
> Also:
> $ virtuoso-t -?
> Virtuoso Open Source Edition (multi threaded)
> Version 6.1.6.3127
Day
{} 1stAsWeek 1stAsDay 7thAsWeek 7thAsDay 8thAsWeek 8thAsDay 1 Tuesday 1
Monday 2 Tuesday
It seems like this is just counting weeks from the 1st/Jan and counting a
new week every seven days after that. Are there any plans to provide more
standardised usage of
;
-- source: http://en.wikipedia.org/wiki/ISO_week_date#Calculation
week := floor((dayofyear(targetDate) - ISOweekdaynum +10)/7);
return week;
}
On 18 September 2013 16:47, Quentin wrote:
> There are multiple standards for defining calendar weeks though ISO8601
> though most would have the 2
Is it likely that Virtuoso 7 will come to support xsd:boolean without
integer conversion?
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
November Webinars for C, C++, Fortran Developers
thrown by an sql
function via exec_result_names/exec_result but it seems to ask for quite a
lot of memory and I'm not sure our budget extends to exabytes of ram.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
---
ed on resultset field types.
On 21 November 2013 19:57, Quentin wrote:
> I'm trying to track down a memory issue with apache/php/odbc when talking
> to Virtuoso.
>
> The error is: "PHP Fatal error: Out of memory (allocated 3407872) (tried
> to allocate 18446744073709551
1-dev.3203-pthreads as of Nov 11 2013
Compiled for Linux (x86_64-unknown-linux-gnu)
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
Shape the Mobile Experience: Free Subscription
Software experts and deve
By dataset, I mean a url that represents a graph name.
As in: http://example.org/dataset/TestData/
On 26 November 2013 13:07, Quentin wrote:
> The offending code, that reliably reproduces the crash in my environment,
> is:
> split_and_decode(in_datasets,0,'%3B');
>
&g
eturned.
#FILTER NOT EXISTS { ?o "NONEXISTENT
LITERAL"^^xsd:string .}
} LIMIT 10
==
Am I misinterpreting the implementation of NOT EXISTS?
--
Quentin | Clear Blue Water Pty
below will work:
declare errorCode, errorMessage any;
...
if (errorCode <> 0)
signal (cast(errorCode as VARCHAR), errorMessage);
The state/errorCode variable needs to be an integer for comparison and a
varchar or any in signal().
--
Quentin | Clear Blue Water Pty Ltd
quent...
alue as I had assumed the
'' was set by exec on a successful compilation/execution. In fact, it
seems to be unchanged and the variable was initialised as integer 0 which
broke signal().
On 2 December 2013 22:45, Hugh Williams wrote:
> Hi Quentin,
>
> The example as defined
an be 1 or 3 but I'm not sure what those values actually do.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
Rapidly troubleshoot problems before they affect your business. Most IT
organiz
}
ORDER BY ?dist
=======
I'm pretty sure this is because I used ?s in the t_step parameter instead
of ?anchor but I'm not quite sure why this caused a crash.
This seems to occur on DBPedia also (sorry).
--
Quentin | Clear Blue Water Pty L
x27;step_no') as ?dist ) .
FILTER ( ?anchor = <http://example.org/data/test/DummyClass_1>)
}
ORDER BY ?dist
=====
On 3 December 2013 18:47, Quentin wrote:
>
> Assuming some data as below:
>
> prefix : &l
Interesting, I get that too this morning but last night the server hung for
a while and then reported that it was unavailable. Perhaps it was a
coincidence.
Thank you for the documentation link.
On 3 December 2013 21:40, Hugh Williams wrote:
> Hi Quentin,
>
> Your (crash) query
09:53, Quentin wrote:
> Interesting, I get that too this morning but last night the server hung
> for a while and then reported that it was unavailable. Perhaps it was a
> coincidence.
>
> Thank you for the documentation link.
>
>
> On 3 December 2013 21:40, Hugh Williams wrote
?s ?p ?o .
}
ORDER BY ?s
==
Transitivity in Virtuoso seems very elegant, this replaced pages of code
that was generating complicated nested queries and seems to work very well.
On 3 December 2013 18:48, Quentin wrote:
> Prematurely sent.
>
> The
Linked Data->Graphs tab, I am taken to
User Security and the Graphs sub-tab is inaccessible (the td element
contains no href tag).
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
Sponsored b
rity mechanisms?
Alternatively, if it's not permitted to directly update that table, is
there a way to remove all permissions from a dataset without having to
iterate through all users and apply the removal individually and
redundantly?
--
Quentin | Clear Blue Wate
ption (or signal), can I abort the
transaction and rollback the sparql insert? Or will I find some
results have already been committed?
create procedure test.test.oneTransaction();
{
log_enable (0);
exec('sparql insert.');
test.test.someOtherFunction();
log_enable (1);
commit work;
er in ( ,, ) )
Does this type of construction force temporary tables?
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don&#
ine in the future. So I guess I just implement it
as written and it will work itself out.
On 20 December 2013 01:00, Hugh Williams wrote:
> Hi Quentin,
>
> Development indicate that the correct way is using an "INI" clause ie "?g
> in (, >G2>, …)" , as
ts their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> ___
-
DB.DBA.RDF_QUAD_FT_UPGRADE ()
---
It might not be related to what I was doing, I'm not sure.
On 16 December 2013 10:48, Hugh Williams wrote:
> Hi Quentin,
>
> The log_enable should be removed, and unless there are no other commits or
> rollbacks the
2013 22:33, Hugh Williams wrote:
> Hi Quentin,
>
> Are you running this procedure from isql as if so autocommit mode by
> default and you need to set it to manual commit mode first before running
> the procedure with the command:
>
> set AUTOCOMMIT MANUAL;
>
> Best Regar
from?
And is it also possible to remove an exception handler in order to resignal
an exception state?
On 2 January 2014 13:07, Hugh Williams wrote:
> Hi Quentin,
>
> By "isql" I mean't the Virtuoso command line tool, which is where the "set
> AUTOCOMMIT MANUAL;&qu
local/bin/virtuoso-t() [0x6c25b2]
06:57:57 ERROR: GPF: Dkbox.c:1290 Copy of a freed box
GPF: Dkbox.c:1290 Copy of a freed box
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
CenturyLink Cloud
in ())
?S ?PP ?OO .
filter ( ?PP in ())
}}
=====
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Busin
te from graph {
"aaa"^^xsd:string .
};
> Delete from , 1 (or less) triples -- done
sparql
select * from
{
?S ?P ?O .
}
> Query result: > S
> ANY P
ANY O
ANY > S1 pred aaa----
--
Quentin | Clear Blue Water
m/ThirdClass>))", I get
all the results I expect, all of both S2 and S3.
I'm a bit confused by these results which is unfortunate as it seems quite
a powerful feature if I could get it to work consistently.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
-
uld like to be able
to report the number of entities in the same procedure so as to avoid
unnecessary pagination.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
Managing the Performance of Cloud-Bas
2"^^xsd:string .
"s3"^^xsd:string .
};
test.test.resultsetCrash();
-- The crash has already occurred.
=====
On 5 February 2014 22:03, Hugh Williams wrote:
> Hi Quentin,
>
> Can you provide the complete compilabl
Good to hear.
Am I right in thinking it's not allowed to return two differently named
result sets from the one function?
On 9 February 2014 13:23, Hugh Williams wrote:
> Hi Quentin,
>
> Testing against the latest development archive the server does not crash,
> thus thi
;>>
> >>>> After code:
> >>>> 0: := := artm
> >>>> 4: := := artm
> >>>> 8: BReturn 0
> >>>> s# 112 Subquery Select(, )
> >>>> set no:
> &g
llow core files, normally they're
suppressed by ulimit.
Quentin
On 12 February 2014 02:06, Jerven Bolleman wrote:
> Hi Hugh,
>
> I don't understand how to build the debug release.
> I can't find the lines to patch e.g.
>
>
--
Quentin | Clear B
inksw.com/virtrdf-data-formats#default-iid> of type <
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat> --
DB.DBA.RDF_QUAD_FT_UPGRADE ()
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
0 Select (S, P, O) } No. of rows in result: 20
On 20 February 2014 16:05, Quentin wrote:
> This appears to be an intermittent error that pops up every few weeks,
> restarting the DB usually resolves it though not this time.
>
> The query that fails is of the form:
>
> sparql
on of the same name
12:21:51 INFO: ERRS_0 01V01 QW001 Local declaration of r_o shadows a
definition of the same name
...
12:21:52 ERROR: GPF: colsearch.c:2630 for unique ts, getting range with
more than 1 rows
GPF: colsearch.c:2630 for unique ts, getting range with more than 1 rows
--
Quentin |
de
VARCHAR test+test+test
The result is different to conventional urldecoding done by javascript and
php which would generally return "test test test". The effect is to
require virtuoso specific work-arounds in external interfaces.
--
Quentin | Clear Blue Wate
x27;testUser');
The debug log doesn't offer any clues.
Version 7.1.1-dev.3207-pthreads as of Feb 17 2014
Compiled for Linux (x86_64-unknown-linux-gnu)
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
lease to test against when it does occur.
On 21 February 2014 14:37, Hugh Williams wrote:
> Hi Quentin,
>
> Have you tried running the DB.DBA.RDF_AUDIT_METADATA() function which can
> check for and repair RDF metadata corruption, as detailed at:
>
> http://docs.openlinksw
ats#default-iid> of type <
http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat> --
DB.DBA.RDF_QUAD_FT_UPGRADE ()
Server appears to operate normally otherwise.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearblue
rans Knibbe | Geodan
> wrote:
>
> > On 2013-11-08 7:37, Quentin wrote:
> >> Is it likely that Virtuoso 7 will come to support xsd:boolean without
> >> integer conversion?
> >>
> >>
> > A good question. I have just noticed that when I import boolean
xsd:date and an xsd:time variable in a more efficient
manner than a bunch of nested bif:dateadd or bif:stringdate functions.
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
--
Start Your Socia
missing.
On 26 April 2014 05:31, Ivan Mikhailov wrote:
> Hello Quentin,
>
> It's possible to make such a merge function, but please clarify one
> thing first: what should it do if date and time arguments are in
> different timezones?
>
> Best Regards
>
> Ivan Mikh
Explain() on that query generates the same error, by the way.
On 21 June 2014 13:08, Quentin wrote:
> Hi,
>
> When running a transitive sparql query from a stored procedure, I get this
> error:
> "Virtuoso 37000 Error SP031: SPARQL compiler: Variable
> '_:
n Source Edition (Column Store) (multi threaded)
Version 7.1.0.3207-pthreads as of Mar 19 2014
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2014 OpenLink Software
Can I get some information on what this pragma does?
I assume it's something specific to the data that cau
.
===
sparql
with
insert {
"Two spaces --> <--"^^xsd:string .
};
sparql
with
select *
{
?S ?P ?O .
#filter ( ?O = "Two spaces --> <--"^^xsd:string )
};
===
--
Quentin | Clear Blue Water Pty Lt
m the iodbc package? It's possible that the error is due to an
incorrect odbc configuration or driver and I'd like to check what I'm
supposed to be doing there.
Quentin.
*
INSERT {
rdfs:label \"Test Predicate\" .
}";
$insertQuery2 = "SPAR
box.
Quentin.
On 2015-12-02 00:18, Hugh Williams wrote:
> Hi Quentin,
>
> We are looking into this issue ...
>
> Best Regards
> Hugh Williams
> Professional Services
>
> OpenLink Software, Inc. // http://www.openlinksw.com/ [2]
> Weblog -- http://www.openlinksw.com
ader script to do something like this.
Ideally, just modify the error handler in the bulk loader to call a
specialised loader that loads/parses the input line by line and then
writes any erroneous lines out to an output file for manual correction.
Quentin.
Guiding Hand Solutions.
On 2016-05-02
I'd suggest reviewing the documentation on property paths as well.
https://www.w3.org/2009/sparql/wiki/Feature:PropertyPaths
http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparqlaggregatepathexpressions
On 2016-06-11 07:08, S.M.Shamimul Hasan wrote:
> Greetings,
>
> I am r
the mere presence of the
second subquery causes the error, I guess that the transitive predicates
don't play well with subqueries, that's probably a bug.
Regards,
Quentin
Guiding Hand Solutions
On 2016-06-11 07:08, S.M.Shamimul Hasan wrote:
> Greetings,
>
> I
, write the count at each iteration to the
debug log (http://docs.openlinksw.com/virtuoso/fn_dbg_printf/) and
restart Virtuoso in debug&foreground mode to display the debug
statements.
That will eventually clean up your table.
Regards,
Quentin.
Guiding Hand Solutions
On 2016-08-17 22:54,
at kind of application you have but the above
technique could be ported to other languages than Javascript, I've
authenticated against /sparql-auth in PHP for example.
--
Regards,
Quentin Serrurier.
GuidingHand.Solutions
On 2016-11-03 05:55, Arun Balagopalan wrote:
> Hi all,
>
> I am t
an exception handler to catch that error and set a flag to indicate
that the log was previously disabled. If there's no error/flag set then
proceed to re-enable the log.
There might be better ways of doing it but that should work.
--
Regards,
Quentin Serrurier.
GuidingHand.Solutions
On 2017
taspace/doc/dav/wiki/Main/VirtTipsAndTricksDigestAuthAJAX
--
Regards,
Quentin Serrurier.
GuidingHand.Solutions
On 2017-04-04 21:54, Iker Esnaola wrote:
> Hello,
>
> I am trying to update my Graph by means of the SPARQL endpoint and the
> following query:
>
> DELETE {?s rdf:type "A "}
get a small enough block to inspect and find the
error.
If your bulk loading process is amenable then you can also break it into
quite small batchs and just inspect the problematic batch manually.
--
Regards,
Quentin Serrurier.
GuidingHand.Solutions
On 2017-09-28 19:51, Pasquale Di Donato
ing over string literals would
not be successful unless everything was very carefully typed.
I note that Jason tried xsd types in his queries in the first instance,
so that's probably not actually the issue here.
--
Regards,
Quentin Serrurier.
GuidingHand.Solutions
On 2018-01-25 07:34,
to a naive use
of jdbc?
The exposed tables:
http://bayimg.com/FanimAaDb
http://bayimg.com/gAniBaADB
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
70 matches
Mail list logo
