Hi Hugh, Thanks. When it occurred it wasn't an intermittent issue, every time I tried to load up the /conductor URL (before I decided to give up trying to debug and restarted) it gave me the same error with nothing more specific in the logs even in trace_on() mode. I did get the output of status at one stage when the bug was occuring but when I went back up the console to try and find it again I think it had disappeared and I had restarted at that point so I couldn't reproduce it.
I looked in at the code around where the message is thrown from and it seems quite complex but I am also not used to reading C code so it might be quite a routine piece of code. Interestingly, there isn't a wiki page devoted to this error message as with some other error messages. [1] would be where it would reside given the codes being used. Cheers, Peter [1] http://wikis.openlinksw..com/dataspace/owiki/wiki/VirtuosoWikiWeb/VirtuosoErrorSR471_42000 > >From: Hugh Williams <hwilli...@openlinksw.com> >To: Peter Ansell <p_ans...@yahoo.com> >Cc: Virtuoso Users List <virtuoso-users@lists.sourceforge.net> >Sent: Tuesday, 11 August, 2009 8:50:56 AM >Subject: Re: [Virtuoso-users] Log enable/disable failure apparently causing >conductor to not display > > >Hi Peter, > > >Strange it intermittently occurs and goes away when the server is restarted, >as I have been trying to force a recreation here and have been unable to do >so. I shall see if development might have an ideas in what scenario this could >possible occur. Should it happen again do let us know, running the status() >command from isql might also be an idea so we have some indication as to the >state of the server at that point ... > > > > >Best Regards >Hugh Williams >Professional Services >OpenLink Software >Web: http://www.openlinksw.com >Support: http://support.openlinksw.com >Forums: http://boards.openlinksw.com/support > > > > >On 10 Aug 2009, at 01:36, Peter Ansell wrote: > >Hi Hugh, >> >>It works again after a server restart so it might be a very intermittent >>issue, but if you can replicate it with a server that is being fairly >>regularly given /sparql INSERT queries with the log_enable 2 pragma >>instruction it would be nice to see if a permanent solution can be found just >>incase it happens again in future. >> >> >>Cheers, >> >>Peter >> >> >>> >>>From: Hugh Williams <hwilli...@openlinksw.com> >>>To: Peter Ansell <p_ans...@yahoo.com> >>>Cc: Virtuoso Users List <virtuoso-users@lists.sourceforge.net> >>>Sent: Monday, 10 August, 2009 9:57:52 AM >>>Subject: Re: [Virtuoso-users] Log enable/disable failure apparently causing >>>conductor to not display >>> >>>Hi Peter, >>> >>> >>>Has this failure to load the conductor just started occurring as I assume >>>you have been using this log_enable option for sometime now ? >>> >>> >>>Are you performing these inserts using the Conductor SPARQL UI to perform >>>your inserts or is a separate program being used for this ? >>> >>> >>>Also, are you saying if the Virtuoso server is restarted the conductor works >>>but then fails to load after the inserts are started ? >>> >>> >>>Best Regards >>>Hugh Williams >>>Professional Services >>>OpenLink Software >>>Web: http://www.openlinksw.com >>>Support: http://support.openlinksw.com >>>Forums: http://boards.openlinksw.com/support >>> >>> >>> >>> >>>On 9 Aug 2009, at 23:35, Peter Ansell wrote: >>> >>>Hi all, >>>> >>>> >>>>I am using a particular server for a large number of constant and >>>>concurrent SPARUL INSERT's and it seems that it has broken itself somehow >>>>because the conductor doesn't show anymore. The SPARQL interface and >>>>INSERTS and CONSTRUCT's are still actually working but it is still worrying >>>>that the conductor could be broken so easily. >>>> >>>> >>>>As I was told to do in a past thread related to concurrency failures I >>>>added "define sql:log-enable 2 " to the front of all of my SPARUL queries >>>>to work around the issue with multiple concurrent SPARUL INSERT queries >>>>breaking the internal Virtuoso locking (or deadlock prevention) model, but >>>>it is possible that it has now broken the conductor. >>>> >>>> >>>>The message I am seeing whenever I try to access the /conductor page is: >>>> >>>> >>>>"Error 42000 >>>> >>>> >>>>SR471: log_enable () called twice to disable the already disabled log output >>>> >>>> >>>>There are no errors at all in the log since the last reboot so the log file >>>>won't be any help, and I am not sure I can replicate the issue after I >>>>reboot the server. The really puzzling thing about this error is that from >>>>a naive point of view it doesn't look fatal but it has fatal consequences! >>>>What could go wrong with someone trying to confirm that the log is disabled >>>>by calling the function again? Does the function have un-log-related >>>>sideeffects? >>>> >>>> >>>>The server version according to the logs is: >>>> >>>> >>>>"17:14:18 OpenLink Virtuoso Universal Server >>>>17:14:18 Version 05.11.3039-pthreads for Linux as of Jul 9 2009" >>>> >>>> >>>> >>>> >>>>Cheers, >>>> >>>> >>>>Peter >>>> >>>> >>>> >>>> >>>> >>>> __________________________________________________________________________________ >>>>Find local businesses and services in your area with Yahoo!7 Local. >>>>Get started: http://local.yahoo.com.au >>>> >>>> >>>> >>>> >>>>------------------------------------------------------------------------------ >>>>Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day >>>>trial. Simplify your report design, integration and deployment - and focus >>>>on >>>>what you do best, core application coding. Discover what's new with >>>>Crystal Reports now. http://p.sf.net/sfu/bobj-july >>>>_______________________________________________ >>>>Virtuoso-users mailing list >>>>Virtuoso-users@lists.sourceforge.net >>>>https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>> >>________________________________ Access Yahoo!7 Mail on your mobile. Anytime. Anywhere. Show me how. >>------------------------------------------------------------------------------ >>Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day >>trial. Simplify your report design, integration and deployment - and focus on >>what you do best, core application coding. Discover what's new with >>Crystal Reports now. >>http://p.sf.net/sfu/bobj-july_______________________________________________ >>Virtuoso-users mailing list >>Virtuoso-users@lists.sourceforge.net >>https://lists.sourceforge.net/lists/listinfo/virtuoso-users > __________________________________________________________________________________ Find local businesses and services in your area with Yahoo!7 Local. Get started: http://local.yahoo.com.au
