Hi Ivan ,
My machine is a intel core dual 2Ghz with 4GB RAM and one SATA disk
under linux 64-bit.
I had performance problems too (see other mail from yesterday). What i
did is that i changed log to 0 before the import and back to 1 after.
The problem was gone.
It is only the import - no other access to the database.
Performance is still not good but no segmantation fault :)
The performance problem is because of the hard disk I think. IOwait go
up over 50%.
I set Buffers to 100000 and 200000 always the same.... :(
Thank you.
Peter
On 05/12/2007, Ivan Mikhailov <imikhai...@openlinksw.com> wrote:
> Peter,
>
> Please try to make backup dump, as described in the doc; if it will
> report errors then crash-dump; then restore database from file. What's
> the platform and the compiler, BTW? Were there any queries executed or
> data manipulations in parallel with the import? Did you adjust numbers
> of buffers in configuration file (virtuoso.ini) to use some adequate
> amount of RAM?
>
> Best Regards,
> Ivan Mikhailov.
>
>
> On Tue, 2007-12-04 at 11:47 +0100, pwiederm...@googlemail.com wrote:
> > Hello Ivan,
> >
> > thank you. Good to know that you know the bug and fixed it.
> > I changed the order and i also tryed to change ttlp_mt to ttlp. Always
> > the same error. Sometimes sooner sometimes later.
> > Is it possible to get a patch for Virtuoso 5.0.2 or is that to
> > complicated? This would be very very nice because i get this error
> > frequently also with my own rdf data (lot of xml files converted to
> > rdf turtle)
> >
> > Best Regards,
> > Peter
> >
> > On 04/12/2007, Ivan Mikhailov <imikhai...@openlinksw.com> wrote:
> > > Hello Peter,
> > >
> > > This bug resembles one that is fixed recently in commercial version of
> > > Virtuoso so next release of Virtuoso Open Source will probably contain
> > > the fix. The error is quite seldom (I've sen it only once on a dataset
> > > that is much greater than DBpedia) so you will probably not see it again
> > > it even if you simply re-load same file. For double safety, just load
> > > DBpedia resources in different order.
> > >
> > > Best Regards,
> > > Ivan Mikhailov
> > > OpenLink Software.
> > >
> > > On Tue, 2007-12-04 at 02:47 +0100, pwiederm...@googlemail.com wrote:
> > > > Hi!
> > > >
> > > > I get a error message when i import dbpedia
> > > >
> > > > from the server:
> > > >
> > > > 02:29:03 Server online at 1111 (pid 28382)
> > > > 02:29:54 Checkpoint made, log reused
> > > > 02:30:23 Checkpoint made, log reused
> > > > 02:30:32 GPF: insert.c:678 unmoved row lock
> > > > GPF: insert.c:678 unmoved row lock
> > > > Segmentation fault (core dumped)
> > > >
> > > >
> > > > from the cleint:
> > > >
> > > > *** Error 08S01: [Virtuoso Driver]CL065: Lost connection to server
> > > > at line 0 of Top-Level:
> > > > ttlp_mt (file_to_string_output ('articles_abstract_en.nt'), '',
> > > > 'http://dbpedia.org')
> > > > Loading (02:30:34)
> > > >
> > > > (the command I took from a mail in this mailinglist)
> > > >
> > > > Using virtuoso open source latest version.
> > > >
> > > > before articles_abstract_de.nt is imported correct .
> > > >
> > > > Can you tell me what I can do to solve the error?
> > > >
> > > > Thank you!
> > > > Peter
> > > >
> > > > -------------------------------------------------------------------------
> > > > SF.Net email is sponsored by: The Future of Linux Business White Paper
> > > > from Novell. From the desktop to the data center, Linux is going
> > > > mainstream. Let it simplify your IT future.
> > > > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> > > > _______________________________________________
> > > > Virtuoso-users mailing list
> > > > Virtuoso-users@lists.sourceforge.net
> > > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> > >
> > >
> >
> > -------------------------------------------------------------------------
> > SF.Net email is sponsored by: The Future of Linux Business White Paper
> > from Novell. From the desktop to the data center, Linux is going
> > mainstream. Let it simplify your IT future.
> > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> > _______________________________________________
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
