Richard,
I upped the Xmx to 13500m, and that resolved the Unknown Characther error
that I was having. However, now I am coming acorss this
error: Communications link failure Last packet sent to the server was 350689
ms ago. The query that is giving me the error runs for about five minutes or
so, then throws this error. I'm not sure why the communications link between
the D2R and the server is going down.
I have specified jdbc:keepAlive "3600" and jdbc:keepAliveQuery "SELECT 1"
in my mapping file.
Is there something else that I need to do to keep the communications link
up?
Thanks.
On Thu, Sep 1, 2011 at 10:13 AM, Zach Schweinfurth <
[email protected]> wrote:
> Thanks for the response Richard.
>
> I am testing the BSBM at a scale factor of 284826.
>
>
> On Thu, Sep 1, 2011 at 9:24 AM, Richard Cyganiak <[email protected]>wrote:
>
>> Hi Zach,
>>
>> Once you get an OutOfMemoryError, pretty much anything can happen… The
>> first thing to try is increasing the -Xmx256M setting in the d2r-server
>> script to assign more heap to the JVM.
>>
>> What size of BSBM dataset are you trying?
>>
>> Best,
>> Richard
>>
>>
>> On 31 Aug 2011, at 19:31, Zach Schweinfurth wrote:
>>
>> > On other thing to note, this error seems to always occur after I get a
>> java heap space error. That is, I will run a query, get a java heap space
>> error. Then any other query I run, I will get the unknown character error.
>> >
>> > On Wed, Aug 31, 2011 at 11:42 AM, Zach Schweinfurth <
>> [email protected]> wrote:
>> > Hello.
>> >
>> > I have been working with D2R 0.7 server and the BSBM benchmark
>> relational data set. And I have come across this error while executing
>> sparql queries in D2R server against the mappings I have made: Unknown
>> character set index for field '25959' received from server.:
>> >
>> > The set up of my mysql database is as follows:
>> >
>> > I generated sql files from the BSBM generator, loaded them into a mysql
>> database on mysql server 5.1, running on a virtual Ubuntu 10.04 32 Bit
>> within my server. All I did to load the database was execute the sql files
>> that the BSBM generated created. The sql files from the BSBM generator all
>> seem to set columns and the database itself to a utf8 character set. The
>> mysql server has its default character set as latin1, but as far as I
>> understand that character set is not used if the database itself has set a
>> default character set.
>> >
>> > The set up of my D2R server is as follows:
>> >
>> > Running D2R Server version 0.7 on a virtual Ubuntu 10.04 32 Bit within
>> the same server box the mysql database is running in. I created a mapping
>> file based on the specification. I connect from D2R server to the mysql
>> database, both located within my internal network, fine without any mapping
>> validation errors. Then once I start running queries against the mappings I
>> get the Unknown character set index for field '25959' received from server
>> error. Sometimes I am able to get simple limited queries to return results
>> from the database, but the majority of the queries I run give me the
>> Character Set error.
>> >
>> >
>> > Do you all happen to know of any possible errors I am making or of any
>> sort of settings that may be causing this error?
>> >
>> > Thanks.
>> > --
>> > Zachary Schweinfurth
>> > Ontology Engineer
>> > Revelytix, Inc.
>> >
>> >
>> >
>> >
>> > --
>> > Zachary Schweinfurth
>> > Ontology Engineer
>> > Revelytix, Inc.
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Special Offer -- Download ArcSight Logger for FREE!
>> > Finally, a world-class log management solution at an even better
>> > price-free! And you'll get a free "Love Thy Logs" t-shirt when you
>> > download Logger. Secure your free ArcSight Logger TODAY!
>> >
>> http://p.sf.net/sfu/arcsisghtdev2dev_______________________________________________
>> > d2rq-map-devel mailing list
>> > [email protected]
>> > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>>
>>
>
>
> --
> Zachary Schweinfurth
> Ontology Engineer
> Revelytix, Inc.
>
>
--
Zachary Schweinfurth
Ontology Engineer
Revelytix, Inc.
------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
