Hi Thomas, Don’t know what you mean by " pbs on datas” ???
I assume this spurious chars at the beginning of the strings ? Are you saying this string values where XMLLiteral in vs but are now XMLSchema#string in v7 , which may be the cause ? Did you convert the RDF_QUAD table to column store mode also ? As would be interesting to know if this occurred when it was in v7 row store original mode also … Have you tried dumping and reloading the RDF Quad data as also suggested as an alternative previously ? ie >>>> If you just have RDF Datasets then you could also dump them to file >>>> datasets in nquad form and then reloading into an empty/virtuoso v7 >>>> database as detailed at: >>>> >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad>http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad> >>>> >>>> Then reload with the Virtuoso RDF Bulk loader into the empty v7 database: >>>> >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader>http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader> >>> 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 8 Dec 2015, at 11:55, Thomas Michaux <mich...@abes.fr> wrote: > > in SPARQL : select ?titre (DATATYPE(?titre ))from > <http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV> > <http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV> where > {<http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w> > <http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w> > dcterms:title ?titre} > > V7 result : > > titre callret-1 > "???� rootbVariants of nonlinear normal form observer design" > http://www.w3.org/2001/XMLSchema#string > <http://www.w3.org/2001/XMLSchema#string> > > V6 result: > > titre callret-1 > Variants of nonlinear normal form observer design > http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral > <http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> > > Thomas > > Le 08/12/2015 12:42, Thomas Michaux a écrit : >> when we compare the datatypes from V6 and v7 it seems we'd lost the "strong" >> typing in V6 to a "generic" V7 type >> <http://www.w3.org/2001/XMLSchema#string>http://www.w3.org/2001/XMLSchema#string >> <http://www.w3.org/2001/XMLSchema#string> : >> >> >> SELECT DB.DBA.RDF_DATATYPE_OF_OBJ( "s_1_1_t0"."O") AS "titre_datatype", >> DB.DBA.RDF_LANGUAGE_OF_OBJ( "s_1_1_t0"."O") AS "titre_langage" >> FROM DB.DBA.RDF_QUAD AS "s_1_1_t0" >> WHERE >> "s_1_1_t0"."G" = __i2idn ( __bft( >> 'http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV >> <http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV>' , 1)) >> AND >> "s_1_1_t0"."S" = __i2idn ( __bft( >> 'http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w >> <http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w>' , 1)) >> AND >> "s_1_1_t0"."P" = __i2idn ( __bft( 'http://purl.org/dc/terms/title >> <http://purl.org/dc/terms/title>' , 1)) >> OPTION (QUIETCAST) >> >> >> V7 : >> titre_datatype >> titre_langage >> LONG VARCHAR >> LONG VARCHAR >> _______________________________________________________________________________ >> >> http://www.w3.org/2001/XMLSchema#string >> <http://www.w3.org/2001/XMLSchema#string> >> BLOB 0 chars >> >> 1 Rows. -- 2 msec. >> >> V6 : >> >> titre_datatype >> titre_langage >> LONG VARCHAR >> LONG VARCHAR >> _______________________________________________________________________________ >> >> #i2320000 >> BLOB 0 chars >> >> 1 Rows. -- 1 msec. >> >> >> Thomas >> >> -------- Message transféré -------- >> Sujet : Re: [Virtuoso-users] Problems using +backup-dump from Virtuoso >> 6 to Virtuoso 7 with +restore-crash-dump >> Date : Tue, 8 Dec 2015 11:16:32 +0100 >> De : Thomas Michaux <mich...@abes.fr> <mailto:mich...@abes.fr> >> Pour : virtuoso-users@lists.sourceforge.net >> <mailto:virtuoso-users@lists.sourceforge.net> >> <virtuoso-users@lists.sourceforge.net> >> <mailto:virtuoso-users@lists.sourceforge.net> >> Copie à : Hugh Williams <hwilli...@openlinksw.com> >> <mailto:hwilli...@openlinksw.com> >> >> Important precision, >> >> we have focused this problems on a specific type of literals : >> >> Je dois préciser que le pb concerne des données de type Littéraux XML >> (http://www.w3.org/TR/REC-rdf-syntax/#section-Syntax-XML-literals >> <http://www.w3.org/TR/REC-rdf-syntax/#section-Syntax-XML-literals>) : >> >>> <http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w> >>> <http://www.hub.abes.fr/springerB/ebook/1-85233-134-8/chapter/9/w> >>> <http://purl.org/dc/terms/title> <http://purl.org/dc/terms/title> >>> "Variants of nonlinear normal form observer >>> design"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> >>> <http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral> . >> >> >> Le 08/12/2015 10:39, Thomas Michaux a écrit : >>> Hello, >>> >>> Thanks Hugh, >>> >>> we performed as explained in >>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x >>> >>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x> >>> ( convert the RDF_QUAD table to Column Store ) >>> >>> and it worked... except now we have pbs on datas (which was correct in V6), >>> for exemple : >>> >>> select ?titre from >>> <http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV> >>> <http://www.hub.abes.fr/springer/ebooksLN2011/SPR_EBOOK_642_19NOV> where >>> {?s dcterms:title ?titre} >>>  return in SPARQL query results of the conductor interface in V6 : >>> >>> titre >>> Variants of nonlinear normal form observer design >>> Input/State linearization >>> On achieving Lp (âp) performance with global internal stability for >>> linear plants with saturating actuators >>> Design criteria for uncertain models with structured and unstructured >>> uncertainties >>> Sliding mode control of systems with delayed states and controls >>> On global stabilization of nonlinear dynamical systems >>> On sampled data variable structure control systems >>> Stochastic optimal control problems >>> Modeling, Estimation, and Their Applications for Distributed Parameter >>> Systems >>> Optimal input design ... >>> >>> the same SPARQL query on V7 now returns in the conductor : >>> >>> titre >>> "???� rootbVariants of nonlinear normal form observer design" >>> "???� root2Input/State linearization" >>> "???� root??On achieving Lp (âp) performance with global internal >>> stability for linear plants with saturating actuators" >>> "???� root??Design criteria for uncertain models with structured and >>> unstructured uncertainties" >>> "???� root??Sliding mode control of systems with delayed states and >>> controls" >>> "???� rootlOn global stabilization of nonlinear dynamical systems" >>> "???� rootdOn sampled data variable structure control systems" >>> "???� rootFStochastic optimal control problems" >>> "Modeling, Estimation, and Their Applications for Distributed Parameter >>> Systems" >>> "???� root(Optimal input design" >>> ... >>> >>> Also tried directly SPARQL query in isql client and same divergences, (so >>> it's excluding presentation problems in the conductor i suppose) see >>> attached screenshots. >>> >>> Do you think the faulty part resides in the reindexing process or in the >>> driver accessing the datas in V7 ? >>> >>> Thanks, >>> >>> Thomas Michaux. >>> >>> >>> PS: I'm planning a test to see the datas from V6 into V7 (just copying >>> virtusoso.db) without converting to column store indexes. >>> >>> >>> Le 05/12/2015 03:22, Hugh Williams a écrit : >>>> Hi Thomas, >>>> >>>> That wonât work as the +backup-dump is not compatible even between 6.x >>>> engine numbers which are thus included in the trx file to indicate this >>>> should you attempt to restore / replay with a different database engine >>>> number hence the error you indicating the server version donât match. >>>> >>>> So you have to perform the upgrade by copying the database as is  and >>>> starting with a v7 binary and then convert the RDF_QUAD table to Column >>>> Store mode as indicated at: >>>> >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x>http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x> >>>> >>>> If you just have RDF Datasets then you could also dump them to file >>>> datasets in nquad form and then reloading into an empty/virtuoso v7 >>>> database as detailed at: >>>> >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad>http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDumpNQuad> >>>> >>>> Then reload with the Virtuoso RDF Bulk loader into the empty v7 database: >>>> >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader>http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader >>>> >>>> <http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader> >>>> >>>> >>>> Best Regards >>>> Hugh Williams >>>> Professional Services >>>> OpenLink Software, Inc.    //        >>>> <http://www.openlinksw.com/>http://www.openlinksw.com/ >>>> <http://www.openlinksw.com/> >>>> Weblog  -- >>>> <http://www.openlinksw.com/blogs/>http://www.openlinksw.com/blogs/ >>>> <http://www.openlinksw.com/blogs/> >>>> LinkedIn -- >>>> <http://www.linkedin.com/company/openlink-software/>http://www.linkedin.com/company/openlink-software/ >>>> <http://www.linkedin.com/company/openlink-software/> >>>> Twitter  -- <http://twitter.com/OpenLink>http://twitter.com/OpenLink >>>> <http://twitter.com/OpenLink> >>>> Google+  -- >>>> <http://plus.google.com/100570109519069333827/>http://plus.google.com/100570109519069333827/ >>>> <http://plus.google.com/100570109519069333827/> >>>> Facebook -- >>>> <http://www.facebook.com/OpenLinkSoftware>http://www.facebook.com/OpenLinkSoftware >>>> <http://www.facebook.com/OpenLinkSoftware> >>>> Universal Data Access, Integration, and Management Technology Providers >>>> >>>>> On 4 Dec 2015, at 08:46, Thomas Michaux <mich...@abes.fr >>>>> <mailto:mich...@abes.fr>> wrote: >>>>> >>>>> Hello, >>>>> >>>>> I have a problem trying to build a new .db in Virtuoso 7 from a dump of >>>>> Virtuoso 6  (i.e. we do not want to just copy virtuoso.db to have >>>>> benefits of Column Store mode) : >>>>> >>>>> The dump is built from Virtuoso Open Source Edition (multi threaded) >>>>> Version 6.1.6.3127-pthreads as of Oct 19 2012 >>>>> Compiled for Linux (x86_64-unknown-linux-gnu) >>>>> Copyright (C) 1998-2012 OpenLink Software >>>>> >>>>> after a checkpoint; shutdown; and /usr/local/bin/virtuoso-t +configfile >>>>> /usr/local/var/lib/virtuoso/db/virtuoso.ini +backup-dump >>>>> >>>>> Then we are trying to read this dump transaction file on another host >>>>> with Virtuoso Open Source Edition (Column Store) (multi threaded) >>>>> Version 7.2.2-rc1.3215-pthreads as of Nov 23 2015 >>>>> Compiled for Linux (x86_64-unknown-linux-gnu) >>>>> Copyright (C) 1998-2015 OpenLink Software >>>>> >>>>> with ./virtuoso-t +configfile >>>>> /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.ini >>>>> +restore-crash-dump +foreground >>>>> >>>>> but... >>>>> 19:11:18 Roll forward started >>>>> 19:11:18 The transaction log file has been produced by server version >>>>> '06.01.3127'. The version of this server is '07.20.3215'. If the >>>>> transaction log is empty or you do not want to replay it then delete it >>>>> and start the server again. Otherwise replay the log using the server of >>>>> version '06.01.3127' and make checkpoint and shutdown to ensure that the >>>>> log is empty, then delete it and start using new version. >>>>> 19:11:18 Server exiting >>>>> >>>>> >>>>> Any advices ? >>>>> >>>>> Thanks, >>>>> >>>>> Thomas Michaux >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Go from Idea to Many App Stores Faster with Intel(R) XDK >>>>> Give your users amazing mobile app experiences with Intel(R) XDK. >>>>> Use one codebase in this all-in-one HTML5 development environment. >>>>> Design, debug & build mobile apps & 2D/3D high-impact games for multiple >>>>> OSs. >>>>> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 >>>>> <http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140> >>>>> _______________________________________________ >>>>> Virtuoso-users mailing list >>>>> Virtuoso-users@lists.sourceforge.net >>>>> <mailto:Virtuoso-users@lists.sourceforge.net> >>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>>>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> >>>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Go from Idea to Many App Stores Faster with Intel(R) XDK >>> Give your users amazing mobile app experiences with Intel(R) XDK. >>> Use one codebase in this all-in-one HTML5 development environment. >>> Design, debug & build mobile apps & 2D/3D high-impact games for multiple >>> OSs. >>> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 >>> <http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140> >>> >>> _______________________________________________ >>> Virtuoso-users mailing list >>> Virtuoso-users@lists.sourceforge.net >>> <mailto:Virtuoso-users@lists.sourceforge.net> >>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> >> >> >> >> >> >> ------------------------------------------------------------------------------ >> Go from Idea to Many App Stores Faster with Intel(R) XDK >> Give your users amazing mobile app experiences with Intel(R) XDK. >> Use one codebase in this all-in-one HTML5 development environment. >> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. >> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 >> <http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140> >> >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> <mailto:Virtuoso-users@lists.sourceforge.net> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> >
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users