[REBOL] Re: SQL, driver or me?
From: tim:johnsons-web at: 23-Jun-2003 11:26
* Hallvard Ystad <[hallvard--ystad--helpinhand--com]> [030623 10:46]:
> Hi folks,
>
> Dixit Ingo Hohmann (17.56 11.05.2003):
> >For MySQL access you don't need /Pro, DocKimbels /Core driver is available through
softinnov ( http://www.softinnov.com ) at
> >http://rebol.softinnov.org/mysql/
>
> Brilliant! Excellent! Fantastic!
> ..but I have a problem.
Hi Hallvard:
I use mysql-protocol extensively and have not encountered
this problem. And this is a very simple query.
> Version: 4.0.12-nt
I am using version 3.23.41 on my Linux work station, and am using
queries on remote servers on the same version on Linux and Sun
servers.
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.
Also, have you executed any other queries from this
server successfully?
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
