Timeout problems

[jasenj1]

I'm running OntoWiki on a WAMPServer setup - Windows prepackaged with
- Apache 2.2.11
- MySQL 5.1.36
- PHP 5.3.0

I'm attempting to load an RDF/XML file that is about 12MB in size.
There are only about 10 object types, and the ontology is pretty
simple. I changed the max file sizes in PHP to 20MB and have even
attempted to split the file in half for loading.

However, I still experience timeout issues and errors stating the
MySQL server has gone away.

Also, if I attempt to create an empty Knowledge base I receive the
error: "Error importing knowledge base: Mysqli statement execute
error : No data supplied for parameters in prepared statement". Does
this indicate an incompatibility with PHP 5.3?

[c.riess]

PHP 5.3 should be fine. I'm even running a PHP 5.3.1 RC. Which Version
of Zend Framework are you using? I experienced issues with differrent
Zend Versions, too. Is your OntoWiki a release or tip(trunk)-version?
Currently with 1.9.4 i'm not having any problems. I'm aware of
especially Zend_DB issues in combination with PHP 5.3. (could explain
the DB problems you're having).

regards
Christoph Rieß

[jasenj1]

I'm running the 0.9 binary release - not a tip. The directions for
installing the tip version mention setting up links for the libraries
and I'm not clever enough to know how to do thath under Windows.

[jasenj1]

The PHP Info page on my Windows box says: Zend Engine v2.2.0. Zend
Extension 220060519

I just spent the last few hours trying to get a MAMP install working
on a Mac in our lab. For some reason PHP complains about not being
able to connect to the DB. I know it's running - the management stuff
connects fine. *sigh*

So I have: my development Mac laptop - things run fine. A lab WAMP
install - can't ingest the .rdf that works fine on the Mac. A lab Mac
- can't get PHP to talk to the DB. Ugh. Not a good day.

On Nov 20, 11:30 am, "c.riess" <c.ri...@polizisten-duzer.de> wrote:

[Sebastian Dietzold]

quote jasenj1 (20.11.2009):

> The PHP Info page on my Windows box says: Zend Engine v2.2.0. Zend
> Extension 220060519

ok, this is an misunderstanding. Christoph does not ask for the php
version but Zend Framework version. This is a php framework we use.

To clarify this: Do you have installed a Zend Framwork version yourself?

> I just spent the last few hours trying to get a MAMP install working on
> a Mac in our lab. For some reason PHP complains about not being able to
> connect to the DB. I know it's running - the management stuff connects
> fine. *sigh*

ok, this sounds solveable ...
What do you mean with management stuff?
phpMyAdmin?
Do you use different users for phpMyAdmin and OntoWiki?
Can you paste the error message here?

SD

>
> So I have: my development Mac laptop - things run fine. A lab WAMP
> install - can't ingest the .rdf that works fine on the Mac. A lab Mac
> - can't get PHP to talk to the DB. Ugh. Not a good day.
>
> On Nov 20, 11:30�am, "c.riess" <c.ri...@polizisten-duzer.de> wrote:
>> PHP 5.3 should be fine. I'm even running a PHP 5.3.1 RC. Which Version
>> of Zend Framework are you using?
>

--
Sebastian Dietzold - Department of Computer Science; University of Leipzig
Tel/Fax: +49 341 97 323-66/-29 http://bis.uni-leipzig.de/SebastianDietzold

[Sebastian Dietzold]

quote jasenj1 (20.11.2009):

Hi jasenj1,

I assume you use Version 0.9 with your own Zend version (not the packed
one), right?

This is a ZendDB issue (really!) on how sql queries are interpreted.

For 0.9, we fixed this in Zend which we packed in the archive.

From 0.9.5 on, this is fixed by a workaround in the ZendDB store
implementation in Erfurt.

So please try to use the shipped Zend version.

regards

SD

> Date: Fri, 20 Nov 2009 17:01:36
> From: jasenj1 <jas...@gmail.com>
> Reply-To: ontowi...@googlegroups.com
> To: OntoWiki User Discussion <ontowi...@googlegroups.com>
> Subject: [ontowiki-user] Timeout problems

[jasenj1]

On Nov 20, 11:24 am, Sebastian Dietzold <dietz...@informatik.uni-

leipzig.de> wrote:
>
> I assume you use Version 0.9 with your own Zend version (not the packed
> one), right?

I was using the 0.9 packed version. Had the timeout issues with that.

I've since made the effort to get the trunk/tip version running on my
Windows machine: Put the libraries in the "libraries" directory,
downloaded a copy of Zend 1.9.4 as instructed.

I increased the timeout set inside index.php from 240 to 600 and was
able to get my ontology to import. I also increased some of the mySQL
memory settings - but I don't know what I'm doing, I just doubled a
bunch of them. Now I can browse classes with few instances. But if I
attempt to show a list view with a lot of items, a few of my classes
have 2-5,000 instances, it goes into eternal wait mode.

- Jasen.

[jasenj1]

FWIW, I saw that Zend 1.9.6 is now available and I installed that.
Still having very long waits and time outs when attempting to browse
my ontology, but it does import - possibly due to my raising the
timeouts. This is running on a quad-core machine with 2GB of RAM. If
the developers are interested, I could probably sanitize my data and
make an instance of it available somewhere. I believe there is on the
order of 140,000 triples; the data seems relatively simplistic to me,
but maybe there's something about my structure that gives OntoWiki (or
one of its libraries) fits.

- Jasen.