[REBOL] Re: SQL, driver or me?
From: tim:johnsons-web at: 23-Jun-2003 20:56
* Hallvard Ystad <[hallvard--ystad--helpinhand--com]> [030623 13:59]:
> Dixit Tim Johnson (21.26 23.06.2003):
> > Hi Hallvard:
> > I use mysql-protocol extensively and have not encountered
> > this problem. And this is a very simple query.
>
> Indeed.
>
> > > Version: 4.0.12-nt
> > I'm guessing that you are attempting to 'talk' to ver
> > 4.0.12 on an NT server? Am I correct? If so, can you run a
> > similar test on a different server and/or version.
>
> I'm on my home machine, a win2k home edition. I'm aiming for deployment on a mac, but
testing, so far, on my home machine.
>
> > Also, have you executed any other queries from this
> > server successfully?
>
> Oh yes. I've put in the 700 rows successfully. If I delete them with the admin tool,
everything behaves normally again. Nothing hangs. But once I put in some rows, it seems
to hang...
>
> I'll try to get it up and running on the mac to test it there. I'll get back to it
once that's clear.
I was hoping that DocKimbel would speak up but I'll advance how
I would begin to approach this:
I'd start with the simplest of tables.
One record, one column.
I would attempt 'select * from table
and if that worked, I would then proceed to increase
the number of records and the number of columns.
... until failure occured...
If that didn't work, then I would try the same with
different OS's both the rebol and MySql end....
Let me know how it goes on the Mac. Are you using
OS (10 I think) with the Unix-style Kernel?
tim
> ~H
>
> > tim
> >
> >> I'm trying to move the rebol pages search thing into an SQL database. For testing
purposes, I have a table of approx. 700 rows. When I try to "SELECT * FROM reburls",
the SQL connection hangs. trace/net on reveals the problem like this:
> >>
> >> URL Parse: root none localhost none none rebindex
> >> Net-log: ["Opening" "tcp" "for" "mySQL"]
> >> connecting to: localhost
> >> Net-log: ["low level read of " 4 "bytes"]
> >> Net-log: ["low level read of " 42 "bytes"]
> >> Net-log: {
> >> ----- Server ------
> >> Version: 4.0.12-nt
> >> Protocol version: 10
> >> Thread ID: 81
> >> Crypt Seed: o!OMs|4.
> >> Capabilities: [
> >> long-flag
> >> connect-with-db
> >> compress
> >> transactions]
> >> -------------------}
> >> Net-log: ["low level read of " 4 "bytes"]
> >> Net-log: ["low level read of " 3 "bytes"]
> >> Net-log: "Connected to server. Handshake OK"
> >> Net-log: "sending ping..."
> >> Net-log: ["low level read of " 4 "bytes"]
> >>
> >> (...)
> >>
> >> Net-log: ["low level read of " 584 "bytes"]
> >> Net-log: ["low level read of " 1341 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >> Net-log: ["low level read of " 0 "bytes"]
> >>
> >> So suddenly, it seems that there are no more bytes to get. The "MySQL Control Center"
from mysql.com does not behave like there's anything wrong, so I don't think MySQL's
got anything to do with it. The question is, is it me or the SQL driver?
> >>
> >> So I tried with LIMIT. "SELECT * FROM reburls LIMIT 1" Works fine. I get one record,
i.e. one row from the table. But "SELECT * FROM reburls LIMIT 2" hangs... And I have
no idea why.
> >>
> >> So am I the problem? What did I do wrong? Or is this a bug in Dockimbel's mysql
driver? (I find it highly probable that I am the problem, but I cannot see how). Any
tips very much appreciated.
> >>
> >> ~H
> >>
> >> Oh, and by the way, the indexer (http://folk.uio.no/hallvary/rebindex/) has indexed
about 10,000 pages now. I fear a great number of them are duplicates (my oh my, such
lousy programming!). And as I am simply using a file to save all these web pages, searching
takes quite some time. A quick search just now took 31 seconds... So...
> >>
> >>
> >> Prętera censeo Carthaginem esse delendam
> >>
> >> --
> >> To unsubscribe from this list, please send an email to
> >> [rebol-request--rebol--com] with "unsubscribe" in the
> >> subject, without the quotes.
> >
> >--
> >Tim Johnson <[tim--johnsons-web--com]>
> > http://www.alaska-internet-solutions.com
> > http://www.johnsons-web.com
> >--
> >To unsubscribe from this list, please send an email to
> >[rebol-request--rebol--com] with "unsubscribe" in the
> >subject, without the quotes.
>
> Prętera censeo Carthaginem esse delendam
>
> --
> To unsubscribe from this list, please send an email to
> [rebol-request--rebol--com] with "unsubscribe" in the
> subject, without the quotes.
--
Tim Johnson <[tim--johnsons-web--com]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
