On Sat, Feb 2, 2013 at 4:01 PM, Hugh Williams <[email protected]> wrote:
> Hi Andrea,

Hi Hugh,
thanks for your reply


> I doubt the JSO_LOAD_GRAPH error is the cause of the problem, although you
> can try running the RDF_AUDIT_METADATA() function to detect and
> automatically fix most popular sorts of metadata corruption, as detailed at:
>
> http://docs.openlinksw.com/virtuoso/fn_rdf_audit_metadata.html

I went to the installation directory and issued the isql command,
trying the audit-and-fix example command seen in the documentation

root@charles:/usr/local/virtuoso-opensource/bin# ./isql
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> DB.DBA.RDF_AUDIT_METADATA(1, '*');

*** Error S2801: [Virtuoso Driver]CL033: Connect failed to
localhost:1111 = localhost:1111.
at line 1 of Top-Level:
DB.DBA.RDF_AUDIT_METADATA(1, '*')


I think this is because I can't start the server.


> But first the "14:43:05 The transaction log file has been produced by
> different server instance." error at the end of your log is of more concern,
> as it indicates the binary you have restarted with is not the same version
> as the binary it was started with previously (and may also be the cause of
> the JSO_LOAD_GRAPH error as well).
>
> So, the log snippet provided shows you binary version and build date to
> "Version 06.01.3127-pthreads for Linux as of Jan 24 2013" , if you check the
> log for the previous time the server was running successfully is it the same
> version and build date, as I suspect not ?

it is, I'm afraid:

altlabel@charles:~$ less
/usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.log | grep
Version
23:51:40 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
23:53:47 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
19:25:34 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
19:30:08 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
19:35:12 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
19:38:44 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
19:39:57 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
10:07:43 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
14:43:03 Version 06.01.3127-pthreads for Linux as of Jan 24 2013


> I would hazard a guess that you have built your own Virtuoso binary on 24th
> Jan 2013, but your server also has a Debian specific Virtuoso build from
> whenever that distro was made, which is a different version and somehow
> restart has picked up a different binary.

You mean an eventual virtuoso opensource installation from a Debian
package repository to satisfy a package dependency?
If so, I checked, but I think this might not be my case:
root@charles:/home/altlabel# dpkg -l | grep virtuoso
root@charles:/home/altlabel#


> Please check to see if you have multiple "virtuoso-t"  binaries on the
> server and check there complete version with the command:
>
> ./virtuoso-t - ?

root@charles:/usr/local/virtuoso-opensource/bin# ./virtuoso-t - ?
root@charles:/usr/local/virtuoso-opensource/bin#


..I hope my answers were exhaustive.. Do you have further suggestions?
In the mean time, thank you very much for you help!
Kind regards
  Andrea



> On 2 Feb 2013, at 14:08, Andrea Bagnacani - altlabel <[email protected]>
> wrote:
>
> Hi everybody,
> yesterday I mistakenly halted my laptop without issuing
> /etc/init.d/virtuoso stop
> Before shutting down, virtuoso logger registered
>
> 19:10:57 Server received signal 15
> 19:10:57 Initiating quick shutdown
> 19:10:59 Server shutdown complete
>
> Later I restarted it, and run virtuoso-t, giving it the same config
> file I used before I shut down my laptop (running a Debian GNU/Linux
> 7.0 64bit)
>
> 14:43:03 Version 06.01.3127-pthreads for Linux as of Jan 24 2013
> 14:43:03 uses parts of OpenSSL, PCRE, Html Tidy
> 14:43:03 Database version 3126
> 14:43:03 SQL Optimizer enabled (max 1000 layouts)
> 14:43:04 Compiler unit is timed at 0.000609 msec
> 14:43:04 Error executing a server init statement : 22023:
> JSO_LOAD_GRAPH has not found expected metadata in the graph --
> DB.DBA.RDF_INIT_SINGLE_SERVER ()
>
> I googled the error that has been reported, but I only found the
> actual source code that echoes that error, and I wasn't able to
> understand it.
> Then the log continues
>
> 14:43:04 built-in procedure "repl_undot_name" overruled by the RDBMS
> 14:43:04 built-in procedure "REPL_FQNAME" overruled by the RDBMS
> 14:43:04 built-in procedure "REPL_COLTYPE_PS" overruled by the RDBMS
> 14:43:04 built-in procedure "REPL_COLTYPE" overruled by the RDBMS
> 14:43:05 Roll forward started
> 14:43:05 The transaction log file has been produced by different
> server instance.
> 14:43:05 Server exiting
>
> Can anybody help me with the error that has been issued?
> Thank you for your patience
>  Andrea
>
> --
> Andrea Bagnacani - altlabel
> web: bagnacan.web.cs.unibo.it
> twitter: @altlabel
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_jan
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>



-- 
Andrea Bagnacani - altlabel
web: bagnacan.web.cs.unibo.it
twitter: @altlabel

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to