Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

mats@gmail.com wrote: Hi, This is the beginning of the file: # Dump of graph , as of 2010-06-13 16:21:27 @prefix rdf: . @prefix mo: .

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, This is the beginning of the file: # Dump of graph , as of 2010-06-13 16:21:27 @prefix rdf: . @prefix mo: . < http://musicbrainz.org/music/performance/0001cce4-caaa-4ee3-acef-baa18abf2

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

mats@gmail.com wrote: Hi Hugh, It doesn't load in v5 either. Here's what it contains: 64740608 dc:title "Voice for a Generation" ; 64740609 mo:produced_sound ; 64740610 mo:performer ns3:bd5280cb-5bbd-45c8-9891-a9

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Hugh, It doesn't load in v5 either. Here's what it contains: 64740608 dc:title "Voice for a Generation" ; 64740609 mo:produced_sound < http://musicbrainz.org/music/sound/8fab7a02-7044-446d-90af-92f44f6d14a8> ; 64740610 mo:performer ns3:bd5280cb-5bbd-45c8-9891-a963692c1890 ; 64740611 mo:perform

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Mats, What is on line 64740610 of the file graph01_01.ttl as the error implies it is an invalid triple entry I presume ? Does this load successfully into a v5 instance ? Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, I've also tried to load the dump into vos 6.1.1 this way, but I get the error ERRS_0 37000 SP029 TURTLE RDF loader, line 64740610: syntax error PL LOG: Error in graph01_01.ttl Any ideas? Cheers, Mats On Wed, Jun 2, 2010 at 9:23 AM, Bob Ferris wrote: > > 1. Create a dump graph of t

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Mats, The list of triggers can be determined from the SYS_TRIGGERS table with a query of the form: select * from SYS_TRIGGERS where T_TABLE like 'WS.WS.SYS_DAV_%' Although having just simulated the issue myself locally you actually only need to drop the following triggers to get aro

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, How can I list the names of the triggers on these tables? Cheers, Mats On Thu, Jun 3, 2010 at 1:47 AM, Hugh Williams wrote: > Hi Mats, > > Looks like the same problem as we saw before, which we got around by > dropping all the triggers on the tables WS.WS.SYS_DAV_* > > Best Regards > Hugh W

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Mats, Looks like the same problem as we saw before, which we got around by dropping all the triggers on the tables WS.WS.SYS_DAV_* Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.ope

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

It looks like the MusicBrainz dump makes it try to call a replication procedure. With fn_trace it shows the additional error ERRS_0 42001 SR185 Undefined procedure DB.DBA.REPL_GETDATE Cheers, Mats On Wed, Jun 2, 2010 at 3:37 PM, Hugh Williams wrote: > Hi Mat/Bob, > > Can you please enable the Vi

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Mat/Bob, Can you please enable the Virtuoso trace_on() function as detailed at: http://docs.openlinksw.com/virtuoso/fn_trace_on.html Attempt to access the conductor again, check the virtuoso.log file for any additional errors related to the conductor loading and report these errors.

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, I also get this error with vos 5.0.14. The knowledge base in general seems to work, I could look up different MusicBrainz entries. My further steps are now the following: 1. Create a dump graph of the whole knowledge base (I used the procedures from [1], is that the right way? - This pro

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, I also tried this, but after the restore I'm getting "Error 42000 DA010: Can't store the file '/DAV/VAD/conductor/main_tabs.vspx-m': DAV error -29" when I try to access the conductor. Cheers, Mats On Wed, Jun 2, 2010 at 2:51 AM, Hugh Williams wrote: > Hi Bob, > > Yes, you can just copy the

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Bob, Yes, you can just copy the restore-tmp.db to virtuoso.db, this being what the restart.sh script with the AMIs do, and I should have included in my mini instructions in the previous email: # more restart.sh #!/bin/sh # This script is invoked from Virtuoso PL to restart the server # duri

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Hugh, thanks a lot for that summarized instruction again. Now I end up with a restore-tmp.db of the amount of 59,9 GB, but how to merge the restore-tmp.db with my existing virtuoso.db? Or should I just set restore-tmp.db as default db in my virtuoso.ini? Cheers, Bob PS: I patched also /

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Bob, I have just noticed the "./virtuoso" reference in the run_executable call that is being made which means that "virtuoso" symlink must be created in the directory where the Virtuoso Database resides as is the case to the Virtuoso AMIs and Virtuoso commercial installers the AMIs use, but

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Hugh, I'm running Ubuntu 10.04 x64. I could execute the ./virtuoso-t ... command on my terminal (but with an absolute path to my related vos installation), but (as far as know) you wouldn't have normally a virtuoso(-t) in your db directory. Furthermore, you should also pay attention re. th

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

HI Bob, Assuming you are running on a Unix OS, It would be easiest to create a virtuoso symlink to virtuoso-t and ensure its location is in your PATH environment variable setting such that the "virtuoso" executable can be located as expected and then not need to make any changes to the sql scri

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, I thought I got the code of ec2etxs, which produces the error - it is in DAV/VAD/ec2exts/sql/procedures.sql of the WebDAV repository: _status := run_executable ('/bin/sh', 1, '-c', sprintf( './virtuoso -r "%s" -B "%s" -c restore-tmp.ini >restore.log 2>&1', _b_prefix, _b_dir));

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, sadly I stepped into the next error message: ERROR Failed to reassemble the database. Please check the file restore.log in the database directory. (BUP07) restore.log: /bin/sh: ./virtuoso: not found (I tried it serveral times: started from the init-script and locally)

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Bob Ferris wrote: Hi, Am 19.05.2010 20:43, schrieb Bob Ferris: Hi Kingsley, Am 19.05.2010 17:12, schrieb Kingsley Idehen: Bob Ferris wrote: Hi, I tried to deploy the MusicBrainz backup, which is available for EC2 AMI installation on my local vos-5.0.14/ vos-6.1.1 installation

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, Am 19.05.2010 20:43, schrieb Bob Ferris: Hi Kingsley, Am 19.05.2010 17:12, schrieb Kingsley Idehen: Bob Ferris wrote: Hi, I tried to deploy the MusicBrainz backup, which is available for EC2 AMI installation on my local vos-5.0.14/ vos-6.1.1 installation(s). On both I got the following e

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Kingsley, Am 19.05.2010 17:12, schrieb Kingsley Idehen: Bob Ferris wrote: Hi, I tried to deploy the MusicBrainz backup, which is available for EC2 AMI installation on my local vos-5.0.14/ vos-6.1.1 installation(s). On both I got the following error after it fetched the backup-files (the "co

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Bob Ferris wrote: Hi, I tried to deploy the MusicBrainz backup, which is available for EC2 AMI installation on my local vos-5.0.14/ vos-6.1.1 installation(s). On both I got the following error after it fetched the backup-files (the "continue" step): ERROR SR406: Running of file '/bin/sh' is

[Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, I tried to deploy the MusicBrainz backup, which is available for EC2 AMI installation on my local vos-5.0.14/ vos-6.1.1 installation(s). On both I got the following error after it fetched the backup-files (the "continue" step): ERROR SR406: Running of file '/bin/sh' is not allowed in ru