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 around it:
SQL> drop trigger WS.WS.WS_WS_SYS_DAV_RES_I_log;
Done. -- 7 msec.
SQL> drop trigger WS.WS.WS_WS_SYS_DAV_RES_D_log;
Done. -- 74 msec.
SQL> drop trigger WS.WS.WS_WS_SYS_DAV_RES_U_log;
Done. -- 2 msec.
SQL>
Restart the Virtuoso Server then the Conductor loads fine ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 3 Jun 2010, at 02:29, [email protected] wrote:
> 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 <[email protected]>
> 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 Williams
> Professional Services
> OpenLink Software
> Web: http://www.openlinksw.com
> Support: http://support.openlinksw.com
> Forums: http://boards.openlinksw.com/support
> Twitter: http://twitter.com/OpenLink
>
> On 2 Jun 2010, at 17:38, [email protected] wrote:
>
>> 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 <[email protected]>
>> wrote:
>> 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.
>> The only time I have seen this error was when a replication job was enabled
>> in the commercial installation which calls a replication procedure not
>> defined in the open source build ( as replication is not supported in open
>> source).
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software
>> Web: http://www.openlinksw.com
>> Support: http://support.openlinksw.com
>> Forums: http://boards.openlinksw.com/support
>> Twitter: http://twitter.com/OpenLink
>>
>> On 2 Jun 2010, at 08:23, Bob Ferris wrote:
>>
>> > 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 process seems a bit
>> > slow on my machine :( )
>> > 2. Load this dump graph into a vos 6.1.1 installation (because a direct
>> > load into 6.1.1 seems not possible (as you also noticed: please use
>> > version 5))
>> >
>> > Cheers,
>> >
>> > Bob
>> >
>> > PS: We came up with the same idea in #openlink-virtuoso channel
>> > yesterday with PvK (that your restart script included the lines you
>> > wrote down, Hugh) ;)
>> >
>> > [1]
>> > http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfdumpandreloadgraphs
>> >
>> > Am 02.06.2010 06:01, schrieb [email protected]:
>> >> 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 <[email protected]
>> >> <mailto:[email protected]>> wrote:
>> >>
>> >> 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
>> >> # during a database restore operation
>> >>
>> >> [ ! -f restore-tmp.db ] && {
>> >> echo "There is no new database to restart with"
>> >> exit 1
>> >> }
>> >>
>> >> # Is there a previous database? If so, move it away
>> >> [ -f virtuoso.db ] && {
>> >>
>> >> # Make sure the server is not running
>> >> [ -f virtuoso.lck ] && {
>> >> while [ -f virtuoso.lck ]; do
>> >> echo "Waiting for the server to complete shut down..."
>> >> sleep 1
>> >> done
>> >> sleep 2
>> >> }
>> >>
>> >> # Make sure the transaction log is truncated - PL takes care of
>> >> this
>> >> [ -s virtuoso.trx ] && {
>> >> echo "The database has not been checkpointed before shutdown"
>> >> exit 1
>> >> }
>> >>
>> >> # Rename the old database
>> >> mv virtuoso.db virtuoso.db~ || exit 1
>> >> }
>> >>
>> >> # Database (if any) has been checkpointed, so this should always be
>> >> safe
>> >> #rm -f virtuoso.log virtuoso.pxa virtuoso.tdb virtuoso.trx
>> >> rm -f virtuoso.pxa virtuoso.tdb virtuoso.trx
>> >>
>> >> # Move the database in place
>> >> mv restore-tmp.db virtuoso.db || {
>> >> echo "Failed to rename restore-tmp.db to virtuoso.db"
>> >> exit 1
>> >> }
>> >>
>> >> Best Regards
>> >> Hugh Williams
>> >> Professional Services
>> >> OpenLink Software
>> >> Web: http://www.openlinksw.com
>> >> Support: http://support.openlinksw.com
>> >> Forums: http://boards.openlinksw.com/support
>> >> Twitter: http://twitter.com/OpenLink
>> >>
>> >> On 1 Jun 2010, at 16:21, Bob Ferris wrote:
>> >>
>> >>> 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 /opt/virtuoso/install/restart.sh with a
>> >> symlink to my
>> >>> local init script. It works so far.
>> >>>
>> >>> Am 20.05.2010 13:47, schrieb Hugh Williams:
>> >>>> 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 it not the case for the open source
>> >> builds as they don't use the commercial packaging structure, thus
>> >> this symlink has to be made manually. The restart.sh script also
>> >> does not exist for the open source builds thus the server has to be
>> >> restarted manually after the restore.
>> >>>>
>> >>>> Basically the ec2ext VAD was originally written for use with the
>> >> Virtuoso prebuilt AMIs and thus makes certain assumptions about the
>> >> configuration. To get this to work with an open source binary the
>> >> following changes need to be manually made:
>> >>>>
>> >>>> 1. A "virtuoso" symlink to the Virtuoso binary executable
>> >> (virtuoso-t) must exist in the directory the database it run/started
>> >> from
>> >>>> 2. The entries "SafeExecitables=0" and "DbaExecitables=/bin/sh"
>> >> needs to be added to the "Parameters" section of the Virtuoso
>> >> Configuration file (virtuoso.ini)
>> >>>> 3. The Virtuoso server will need to be manually restarted after
>> >> the restore
>> >>>>
>> >>>> Note it will also not work on Windows unless cygwin or similar
>> >> is installed such that the the "sh" shell it requires is available ...
>> >>>>
>> >>>> Best Regards
>> >>>> Hugh Williams
>> >>>> Professional Services
>> >>>> OpenLink Software
>> >>>> Web: http://www.openlinksw.com
>> >>>> Support: http://support.openlinksw.com
>> >>>> Forums: http://boards.openlinksw.com/support
>> >>>> Twitter: http://twitter.com/OpenLink
>> >>>>
>> >>>> On 20 May 2010, at 08:43, Bob Ferris wrote:
>> >>>>
>> >>>>> 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. the init script for virtuoso (I used one from the
>> >>>>> conStruct install definition, maybe it is originally from
>> >> OpenLink ;) ).
>> >>>>> In the procedures.sql script it is somewhere
>> >> /opt/install/restart.sh (or
>> >>>>> so).
>> >>>>> Another question: is the restore-tmp.db the temporary datebase
>> >> file,
>> >>>>> which I should configure in virtuoso.ini, or would that dump
>> >> transferred
>> >>>>> into virtuoso.db?
>> >>>>>
>> >>>>> Cheers,
>> >>>>>
>> >>>>> zazi
>> >>>>>
>> >>>>>
>> >>>>> Am 20.05.2010 04:07, schrieb Hugh Williams:
>> >>>>>> 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 scripts or other.
>> >>>>>>
>> >>>>>> Please confirm the OS you are using, and we can try the same
>> >> restore locally ...
>> >>>>>>
>> >>>>>> Best Regards
>> >>>>>> Hugh Williams
>> >>>>>> Professional Services
>> >>>>>> OpenLink Software
>> >>>>>> Web: http://www.openlinksw.com
>> >>>>>> Support: http://support.openlinksw.com
>> >>>>>> Forums: http://boards.openlinksw.com/support
>> >>>>>> Twitter: http://twitter.com/OpenLink
>> >>>>>>
>> >>>>>> On 19 May 2010, at 23:14, Bob Ferris wrote:
>> >>>>>>
>> >>>>>>> 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));
>> >>>>>>>
>> >>>>>>> I changed it to ./virtuoso-t, but restore.log still noticed
>> >> "/bin/sh:
>> >>>>>>> ./virtuoso: not found"
>> >>>>>>>
>> >>>>>>> I tried it serveral times with serveral server restarts. I
>> >> think it did
>> >>>>>>> not update my file, or?
>> >>>>>>>
>> >>>>>>> Cheers,
>> >>>>>>>
>> >>>>>>> zazi
>> >>>>>>>
>> >>>>>>> PS: I also changed the server restart to my local init script
>> >>>>>>>
>> >>>>>>> Am 19.05.2010 23:08, schrieb Bob Ferris:
>> >>>>>>>> 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)
>> >>>>>>>>
>> >>>>>>>> Cheers,
>> >>>>>>>>
>> >>>>>>>> zazi
>> >>>>>>>>
>> >>>>>>>> Am 19.05.2010 23:03, schrieb Kingsley Idehen:
>> >>>>>>>>> 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(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
>> >>>>>>>>>>>>> run_executable(). (42000)
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>> Any chance to change this somewhere?
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>> Cheers,
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>> Bob
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>>
>> >>
>> >> ------------------------------------------------------------------------------
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>> _______________________________________________
>> >>>>>>>>>>>>> Virtuoso-users mailing list
>> >>>>>>>>>>>>> [email protected]
>> >> <mailto:[email protected]>
>> >>>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>> Check you INI for this line (edit accordingly if different):
>> >>>>>>>>>>>>
>> >>>>>>>>>>>> DbaExecutables = /bin/tar,/bin/sh
>> >>>>>>>>>>>>
>> >>>>>>>>>>>>
>> >>>>>>>>>>>> That's how you control what can be executed at the OS
>> >> level (e.g. the
>> >>>>>>>>>>>> backup restore routine).
>> >>>>>>>>>>>>
>> >>>>>>>>>>>>
>> >>>>>>>>>>>>
>> >>>>>>>>>>> Did you mean the virtuoso.ini of my installation or the
>> >>>>>>>>>>> musicbrainz-backup-descriptor.ini? I didn't found this
>> >> parameter at both
>> >>>>>>>>>>> files. I added this parameter continuously to both files,
>> >> without any
>> >>>>>>>>>>> success. At the virtuoso.ini I added it below [Database].
>> >>>>>>>>>>>
>> >>>>>>>>>>> Cheers,
>> >>>>>>>>>>>
>> >>>>>>>>>>> zazi
>> >>>>>>>>>>>
>> >>>>>>>>>>
>> >>>>>>>>>> I found the mistake, there wasn't the following parameter set:
>> >>>>>>>>>>
>> >>>>>>>>>> SafeExecutables = 0
>> >>>>>>>>>
>> >>>>>>>>> Ah!
>> >>>>>>>>>
>> >>>>>>>>> OpenLink Staff: please note re. trouble shooting guide.
>> >> This is a very
>> >>>>>>>>> tricky one!
>> >>>>>>>>>
>> >>>>>>>>> Kingsley
>> >>>>>>>>>> Cheers,
>> >>>>>>>>>>
>> >>>>>>>>>> zazi
>> >>>>>>>
>> >
>> >
>> > ------------------------------------------------------------------------------
>> >
>> > _______________________________________________
>> > Virtuoso-users mailing list
>> > [email protected]
>> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Virtuoso-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Virtuoso-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit. See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
