Hi Nicola,
If not already done, you could try running the DB.DBA.VT_INDEX_DB_DBA_RDF_OBJ
() to reindex that data. Note there is also the "DB.DBA.RDF_OBJ_FT_RECOVER ()"
which inserts missing indexes that could be tried running as well indicated at:
http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparqlrulespecifywhatindex
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 20 May 2014, at 11:34, Nicola Vitucci <[email protected]> wrote:
> Hi Hugh,
>
> the "rc2" version is 7.0.0-rc2.3203 (SHA =
> 48f0ef879b913c5d3b306c1f83390079c5416fe6), while the "latest" is
> 7.1.1-dev.3208-pthreads (SHA = 32bc49a3368dc2303e3e4f0825752790f86de867).
>
> Do you think that, rather than reloading the triples (which would take a
> while), using DB.DBA.VT_INDEX_DB_DBA_RDF_OBJ () on the "rc2" version and
> the existing data would make any sense?
>
> Thank you,
>
> Nicola
>
> Il 19/05/2014 23:53, Hugh Williams ha scritto:
>> Hi Nicola,
>>
>> What are the versions of what you describe as "latest version of
>> Virtuoso 7" and "rc2" , please provide the output of "virtuoso-t -?"
>> for both ?
>>
>> I assume they would be the git stable/7 (3207 build) vs the git
>> develop/7 (3208 build) ?
>>
>> I am not sure what you current triple count is but you could consider
>> dumping the triples from the original database to file and reloading
>> them into an empty database with the new binary using the dump and
>> reload scripts at:
>>
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> Weblog -- http://www.openlinksw.com/blogs/
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> Twitter -- http://twitter.com/OpenLink
>> Google+ -- http://plus.google.com/100570109519069333827/
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>>
>> On 19 May 2014, at 14:15, Nicola Vitucci <[email protected]> wrote:
>>
>>> Hi all,
>>>
>>> I recently copied a database created with the latest version of Virtuoso
>>> 7 to an instance using the rc2 version and I got these errors in the log
>>> file:
>>>
>>> ...
>>> 12:59:14 The xpf extension function
>>> http://www.openlinksw.com/virtuoso/xslt/:json-esc-text->DB.DBA.JSON_ESC_TEXT
>>> does not exist. Please delete the corresponding row from
>>> DB.DBA.SYS_XPF_EXTENSIONS and restart the server.
>>> 12:59:15 Roll forward started
>>> 12:59:15 Roll forward complete
>>> 12:59:15 Error executing a server init statement : 22023: SR496:
>>> Property <http://www.openlinksw.com/schemas/virtrdf#qmfHasCheapSqlval>
>>> is not a field of struct qm_format_s, RDF class
>>> <http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat> --
>>> DB.DBA.RDF_QUAD_FT_UPGRADE ()
>>> ...
>>>
>>> Now, if I run any full text search query using bif:contains, I do not
>>> get any results. I also tried the DB.DBA.RDF_AUDIT_METADATA() function
>>> but I don't get any result from it. For the time being I cannot update
>>> the rc2 instance to a more recent version, so is there anything I can do
>>> to restore the full text search capability, possibly without resorting
>>> to rebuild the full text index (which I'm not even sure would work)?
>>>
>>> Thanks,
>>>
>>> Nicola
>>>
>>> ------------------------------------------------------------------------------
>>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>>> Instantly run your Selenium tests across 300+ browser/OS combos.
>>> Get unparalleled scalability from the best Selenium testing platform
>>> available
>>> Simple to use. Nothing to install. Get started now for free."
>>> http://p.sf.net/sfu/SauceLabs
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.
> Get unparalleled scalability from the best Selenium testing platform available
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users