jiusheng chen wrote: > Hi Hugh, > > we started server instance like this: > virtuoso -df -c <ini file path>
virtuoso -c <config-file> Note: virtuoso -? will show all the options. Kingsley > > is it more safe to make it run on background? like: > nohup virtuoso -df -c <ini file path> > log 2>&1 & > > On Thu, Sep 4, 2008 at 8:31 PM, Hugh Williams > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > Hi Jiusheng, > > Looking the the log provided the only shutdown type messages I see > out of the ordinary today are of the form: > > 16:35:28 INFO: Checkpoint made, log reused > 16:52:55 INFO: Server received signal 1 > 16:52:55 INFO: Initiating quick shutdown > 16:52:55 INFO: Server shutdown complete > > Where the "signal 1" message is normally the result of the server > having been started on foreground mode (-f) from a terminal > session and then being shutdown with a Ctrl C from the command > line. Can you confirm this is how you have been running the > Virtuoso Server ? > > 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 4 Sep 2008, at 12:25, jiusheng chen wrote: > >> >> Hi Hugh, >> >> Thanks for your answer. >> Log file attached. >> There should be only one normal shutdown today, all others can be >> considered as exceptional exit. >> >> On Thu, Sep 4, 2008 at 6:09 PM, Hugh Williams >> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: >> >> Hi Jiusheng, >> >> You can run multiple Virtuoso server instance on the same >> machine without problems provided the port numbers the server >> are running on are unique and the machines has sufficient >> resources for the intended usage scenarios. >> >> I am interested to know about this "server exits for no >> reason" you report, thus can you provide more details on the >> circumstances in which these occur and your Virtuoso log >> (virtuoso.log) where the server may have logged any errors >> etc that resulted in such exits ? >> >> 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 4 Sep 2008, at 10:58, jiusheng chen wrote: >> >>> Hi Guys, >>> >>> Can I run several Virtuoso server instances on the same >>> machine (with different port number)? if any risk exist >>> then? I found sometimes the server instance work well but >>> sometimes exited for no reason. >>> >>> Environment: >>> OS: Debian 2.6.18.1.2007050801 >>> Open source Virtuoso v5.0.8 >>> >>> On Wed, Sep 3, 2008 at 11:22 PM, Yrjänä Rankka >>> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: >>> >>> jiusheng chen wrote: >>> >>> Hi Hugh, >>> >>> To speed up loading large dataset like dbpedia into >>> one PC, if parallel loading (split large data into >>> several segments, loading these segments in >>> parallel) is effective? any further suggestions? >>> >>> Hi Jiusheng, >>> >>> I've usually had about 3 ISQL processes per core loading >>> the data set. I didn't bother to split the dbpedia >>> dataset into any smaller segments than it was to begin with. >>> >>> You'll need RAM - plenty of it. A good rule of thumb >>> would be to give Virtuoso at least 2/3 of total RAM in >>> the system. >>> See section [Parameters] in virtuoso.ini - the ones >>> you're interested about are NumberOfBuffers and >>> MaxDirtyBuffers. >>> >>> A handy tip: you can spawn a new ISQL process when you >>> run a stored procedure/query by using the ampersand in >>> the ISQL command line. I.e. >>> SQL> my_lengthy_stored_proc()& >>> >>> Best Regards, >>> >>> Yrjänä >>> >>> >>> >>> On Wed, Sep 3, 2008 at 5:27 PM, Hugh Williams >>> <[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]> >>> <mailto:[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]>>> wrote: >>> >>> Hi Jiusheng, >>> >>> The isql program has a "shutdown" command that >>> can be used to >>> shutdown the Virtuoso instance it is connected to: >>> >>> $ ./isql 1111 >>> Connected to OpenLink Virtuoso >>> Driver: 05.00.3033 OpenLink Virtuoso ODBC Driver >>> OpenLink Interactive SQL (Virtuoso), version 0.9849b. >>> Type HELP; for help and EXIT; to exit. >>> SQL> shutdown(); >>> $ >>> >>> 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 3 Sep 2008, at 08:09, jiusheng chen wrote: >>> >>> Hi Hugh, >>> >>> Thanks for your reply. >>> >>> Perhaps I got a incorrect impression before. >>> >>> BTW, how to stop the server instance? just >>> kill the virtuoso_t job? >>> >>> On Tue, Sep 2, 2008 at 4:58 PM, Hugh Williams >>> <[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]> >>> <mailto:[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]>>> wrote: >>> >>> Hi Jiusheng, >>> >>> The Virtuoso isql program is a simple >>> Interactive SQL client >>> side tool for accessing a Virtuoso server >>> instance on the >>> specified hostname and port number >>> (localhost, 1111 being >>> defaults), and as such will always assume >>> the specified >>> server has already been started by some >>> other means >>> regardless of version. >>> >>> If their is specific documentation you >>> read that gave the >>> impression that isql starts a Virtuoso >>> instance then please >>> provide a link or details of it such that >>> we can have it >>> corrected or made clear as to what isql >>> does ... >>> >>> 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 2 Sep 2008, at 02:21, jiusheng chen wrote: >>> >>> Thank you, guys. >>> >>> You are right, there needs to start >>> virtuoso-t explicitly >>> before using isql. But it seemed to >>> me this step is not >>> necessary for version 5.0.7. >>> <http://5.0.7.> <http://5.0.7.> >>> >>> >>> On Mon, Sep 1, 2008 at 5:01 PM, Tim >>> Haynes >>> <[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]> >>> <mailto:[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]>>> wrote: >>> >>> jiusheng chen wrote: >>> > Hi Tim, >>> > >>> > I installed it, but seems it >>> doesn't work. >>> > >>> > >>> [EMAIL PROTECTED]:/disk1/sda/datasets$ isql >>> > OpenLink Interactive SQL >>> (Virtuoso), version 0.9849b. >>> > Type HELP; for help and EXIT; >>> to exit. >>> > SQL> select * from >>> DB.DBA.SYS_USERS; >>> > >>> > *** Error S2801: [Virtuoso >>> Driver]CL033: Connect failed to >>> > localhost:1111 = localhost:1111. >>> > at line 1 of Top-Level: >>> > select * from DB.DBA.SYS_USERS >>> > >>> > >>> > Virtuoso was installed with >>> default settings. >>> > >>> Hi, >>> >>> This looks like you haven't >>> started it. From the >>> ${prefix}/var/lib/db/ >>> directory, run virtuoso-t -df to >>> make it start in the >>> foreground and once >>> it claims to be online, isql >>> should work. If not, please >>> include teh server >>> debug output too. >>> >>> Regards, >>> >>> ~Tim >>> -- >>> Tim Haynes >>> Product Development Consultant >>> OpenLink Software >>> <http://www.openlinksw.com/> >>> >>> >>> >>> >>> -- Thanks, >>> Chen Jiusheng >>> >>> >>> >>> >>> >>> -- Thanks, >>> Chen Jiusheng >>> >>> >>> >>> >>> >>> -- >>> Thanks, >>> Chen Jiusheng >>> >>> ------------------------------------------------------------------------ >>> >>> >>> >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your >>> Move Developer's challenge >>> Build the coolest Linux based applications with >>> Moblin SDK & win great prizes >>> Grand prize is a trip for two to an Open Source >>> event anywhere in the world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> <http://moblin-contest.org/redirect.php?banner_id=100&url=/> >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> Dbpedia-discussion mailing list >>> [email protected] >>> <mailto:[email protected]> >>> >>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion >>> >>> >>> >>> >>> -- >>> Yrjana Rankka | [EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]> >>> Developer, Virtuoso Team | http://www.openlinksw.com >>> | Making Technology Work For You >>> >>> >>> >>> >>> >>> -- >>> Thanks, >>> Chen Jiusheng >> >> >> >> >> -- >> Thanks, >> Chen Jiusheng >> <virtuoso.log> > > > > > -- > Thanks, > Chen Jiusheng > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > ------------------------------------------------------------------------ > > _______________________________________________ > Dbpedia-discussion mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion > -- Regards, Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen President & CEO OpenLink Software Web: http://www.openlinksw.com ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Dbpedia-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
