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
