The following procedure causes a database crash (regardless of data):
create procedure
test.test.deathByPoorSyntax( )
RETURNS VARCHAR
{
declare str VARCHAR;
SELECT ?subject INTO str FROM (sparql
select ?subject
from <http://q-apidev.clearsight.co/dataset/q-apidev/auth/>
{
?subject a <http://example.com/class1> .
}) as sub;
return str;
}
The cause is the "?subject" in the SQL side of the query. Everything works
fine once the syntax is corrected to "subject".
The debug log is something like:
=============
06:57:57 INFO: COMP_2 dba 220.233.39.18 Internal Compile text: select
test.test.deathByPoorSyntax()
06:57:57 INFO: LTRS_1 <DBA> 220.233.39.18 Internal Commit transact
0x9b9c250 0
06:57:57 INFO: LTRS_2 <DBA> 220.233.39.18 Internal Restart transact
0x9b9c250
06:57:57 INFO: LTRS_1 <DBA> 220.233.39.18 Internal Commit transact
0x9b9c250 0
06:57:57 INFO: LTRS_2 <DBA> 220.233.39.18 Internal Restart transact
0x9b9c250
06:57:57 INFO: LTRS_1 <DBA> 220.233.39.18 Internal Commit transact
0x9b9c250 0
06:57:57 INFO: LTRS_2 <DBA> 220.233.39.18 Internal Restart transact
0x9b9c250
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0xaf9d53]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0xaf9dd6]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0xadfb80]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x67e0bf]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x67f597]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x680ac7]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x68b644]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x6c2585]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x6c2873]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x710d8c]
06:57:57 INFO: /usr/local/bin/virtuoso-t(set_ctr_input+0x38) [0x5c9860]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x6c25cf]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x6ce32c]
06:57:57 INFO: /usr/local/bin/virtuoso-t(bif_exec+0xb1e) [0x5f67ec]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x67e536]
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x686a62]
.... continue for a page or so ....
06:57:57 INFO: /usr/local/bin/virtuoso-t() [0x686a62]
06:57:57 INFO: /usr/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: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
