Hi Thomas,
This works of me with Virtuoso open source and commercial builds I have on Mac
OS X. What is the version of the Virtuoso Windows open source binary you are
using ( output of "virtuoso-t -?” command ) ?
Below is the output from my Open source test:
De-iMac-232:database hwilliams$ ~/Downloads/isql 1111
Connected to OpenLink Virtuoso
Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> ld_dir('.',
'badiritest.nt','http://hub.abes.fr/journals/wiley2011/20170921');
Done. -- 5 msec.
SQL> select * from load_list;
ll_file
ll_graph
ll_state ll_started ll_done ll_host
ll_work_time ll_error
VARCHAR NOT NULL
VARCHAR
INTEGER TIMESTAMP TIMESTAMP INTEGER INTEGER
VARCHAR
_______________________________________________________________________________
./badiritest.nt
http://hub.abes.fr/journals/wiley2011/20170921
0 NULL NULL NULL NULL
NULL
1 Rows. -- 1 msec.
SQL> rdf_loader_run();
Done. -- 8 msec.
SQL> select * from load_list;
ll_file
ll_graph
ll_state ll_started ll_done ll_host
ll_work_time ll_error
VARCHAR NOT NULL
VARCHAR
INTEGER TIMESTAMP TIMESTAMP INTEGER INTEGER
VARCHAR
_______________________________________________________________________________
./badiritest.nt
http://hub.abes.fr/journals/wiley2011/20170921
2 2017.12.22 17:16.5 309717000 2017.12.22 17:16.5 313513000 0
NULL NULL
1 Rows. -- 1 msec.
SQL> sparql select * from <http://hub.abes.fr/journals/wiley2011/20170921>
where {?s ?p ?o};
s
p
o
LONG VARCHAR
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
http://hub.abes.fr/wiley/periodical/ejoc/2004/volume_2004/issue_21/101002/ejoc200400407/pintodiana
c g a http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://xmlns.com/foaf/0.1/Person
1 Rows. -- 1 msec.
SQL> checkpoint;
Done. -- 44 msec.
SQL> shutdown;
De-iMac-232:database hwilliams$
~/src/git/vos-7-develop/binsrc/virtuoso/virtuoso-t +backup-dump
Fri Dec 22 2017
17:16:44 { Loading plugin 1: Type `plain', file `wikiv' in
`/Users/hwilliams/vos-7-install/hosting'
17:16:44 FAILED plugin 1: Unable to locate file }
17:16:44 { Loading plugin 2: Type `plain', file `mediawiki' in
`/Users/hwilliams/vos-7-install/hosting'
17:16:44 FAILED plugin 2: Unable to locate file }
17:16:44 { Loading plugin 3: Type `plain', file `creolewiki' in
`/Users/hwilliams/vos-7-install/hosting'
17:16:44 FAILED plugin 3: Unable to locate file }
17:16:44 OpenLink Virtuoso Universal Server
17:16:44 Version 07.20.3217-pthreads for Darwin as of Oct 31 2017
17:16:44 uses parts of OpenSSL, PCRE, Html Tidy
17:16:44 Database version 3126
17:16:44 SQL Optimizer enabled (max 1000 layouts)
17:16:45 Compiler unit is timed at 0.000284 msec
17:16:46 Roll forward started
17:16:46 Roll forward complete
17:16:47 PL LOG: Can't get list of vad packages in
/Users/hwilliams/vos-7-install/vad/
17:16:47 Database dump started
17:16:47 Checkpoint finished, log reused
17:16:47 Dumping the schema tables
17:16:47 Dumping the registry
17:16:47 Dumping the schema done
17:16:47 Database dump complete
17:16:47 Server exiting
De-iMac-232:database hwilliams$ rm virtuoso.db
De-iMac-232:database hwilliams$
~/src/git/vos-7-develop/binsrc/virtuoso/virtuoso-t -R -f
Fri Dec 22 2017
17:17:05 { Loading plugin 1: Type `plain', file `wikiv' in
`/Users/hwilliams/vos-7-install/hosting'
17:17:05 FAILED plugin 1: Unable to locate file }
17:17:05 { Loading plugin 2: Type `plain', file `mediawiki' in
`/Users/hwilliams/vos-7-install/hosting'
17:17:05 FAILED plugin 2: Unable to locate file }
17:17:05 { Loading plugin 3: Type `plain', file `creolewiki' in
`/Users/hwilliams/vos-7-install/hosting'
17:17:05 FAILED plugin 3: Unable to locate file }
17:17:05 OpenLink Virtuoso Universal Server
17:17:05 Version 07.20.3217-pthreads for Darwin as of Oct 31 2017
17:17:05 uses parts of OpenSSL, PCRE, Html Tidy
17:17:05 SQL Optimizer enabled (max 1000 layouts)
17:17:05 Roll forward started
17:17:06 Roll forward complete
17:17:06 Checkpoint started
17:17:06 Checkpoint finished, log reused
17:17:06 Checkpoint started
17:17:06 Checkpoint finished, log reused
17:17:06 Server exiting
De-iMac-232:database hwilliams$
~/src/git/vos-7-develop/binsrc/virtuoso/virtuoso-t
De-iMac-232:database hwilliams$ tail -f virtuoso.log
17:17:14 uses parts of OpenSSL, PCRE, Html Tidy
17:17:14 Database version 3126
17:17:14 SQL Optimizer enabled (max 1000 layouts)
17:17:15 Compiler unit is timed at 0.000266 msec
17:17:16 Roll forward started
17:17:16 3 transactions, 185 bytes replayed (100 %)
17:17:16 Roll forward complete
17:17:16 PL LOG: Can't get list of vad packages in
/Users/hwilliams/vos-7-install/vad/
17:17:16 Checkpoint started
17:17:16 Checkpoint finished, log reused
17:17:18 HTTP/WebDAV server online at 8890
17:17:18 Server online at 1111 (pid 10513)
^C
De-iMac-232:database hwilliams$ ~/Downloads/isql 1111
Connected to OpenLink Virtuoso
Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> sparql select * from <http://hub.abes.fr/journals/wiley2011/20170921>
where {?s ?p ?o};
s
p
o
LONG VARCHAR
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
http://hub.abes.fr/wiley/periodical/ejoc/2004/volume_2004/issue_21/101002/ejoc200400407/pintodiana
c g a http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://xmlns.com/foaf/0.1/Person
1 Rows. -- 1 msec.
SQL>
De-iMac-232:database hwilliams$
~/src/git/vos-7-develop/binsrc/virtuoso/virtuoso-t -?
Virtuoso Open Source Edition (Column Store) (multi threaded)
Version 7.2.5-dev.3217-pthreads as of Oct 31 2017
Compiled for Darwin (x86_64-apple-darwin15.6.0)
Copyright (C) 1998-2017 OpenLink Softwar
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 22 Dec 2017, at 15:56, Thomas Michaux <mich...@abes.fr> wrote:
>
> Hello,
>
> we may have found a case where bulk load doesn't report error but invalid
> data has a side effect on the "backup-dump" process, step to reproduce :
>
> 1) - in an empty database : use
> ld_dir('e:/virtuosoBACKUP/test',
> 'badiritest.nt','http://hub.abes.fr/journals/wiley2011/20170921
> <http://hub.abes.fr/journals/wiley2011/20170921>');
>
> with these data in file badiritest.nt
>
> <http://hub.abes.fr/wiley/periodical/ejoc/2004/volume_2004/issue_21/101002/ejoc200400407/pintodiana\u00A0c\u00A0g\u00A0a>
>
> <http://hub.abes.fr/wiley/periodical/ejoc/2004/volume_2004/issue_21/101002/ejoc200400407/pintodiana/u00A0c/u00A0g/u00A0a>
> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
> <http://xmlns.com/foaf/0.1/Person> <http://xmlns.com/foaf/0.1/Person> .
> rdf_loader_run();
>
> checkpoint;
>
> shutdown;
>
> 2) then you can't success to process the "backup-dump" procedure :
>
> virtuoso-t +foreground +configfile "c:\Program Files\OpenLink
> Software\VOS7\virtuoso-opensource\database\virtuoso.ini" +backup-dump
>
> even if data is really in store :
>
> SQL> SPARQL select ?s ?p ?o from
> <http://hub.abes.fr/journals/wiley2011/20170921>
> <http://hub.abes.fr/journals/wiley2011/20170921> {?s ?p ?o};
> s
> p
> o
> LONG VARCHAR
> LONG VARCHAR
> LONG VARCHAR
> _______________________________________________________________________________
>
> http://hub.abes.fr/wiley/periodical/ejoc/2004/volume_2004/issue_21/101002/ejoc200400407/pintodiana
>
> <http://hub.abes.fr/wiley/periodical/ejoc/2004/volume_2004/issue_21/101002/ejoc200400407/pintodiana> c g a
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
> http://xmlns.com/foaf/0.1/Person <http://xmlns.com/foaf/0.1/Person>
>
> 1 Rows. -- 0 msec.
>
>
> tested on windows , need to reproduce under linux.
>
>
> Thanks
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org!
> http://sdm.link/slashdot_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
