Hi Hugh,
we started server instance like this:
virtuoso -df -c <ini file path>
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]>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]>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]>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]>> 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]>>
>>>>> 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.>
>>>>>>
>>>>>> On Mon, Sep 1, 2008 at 5:01 PM, Tim Haynes
>>>>>> <[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=/
>>>> ------------------------------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> Dbpedia-discussion mailing list
>>>> [email protected]
>>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>>>
>>>>
>>>
>>>
>>> --
>>> Yrjana Rankka | [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
