Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

SQL, driver or me? (was: Re: Re: [ANN] (but what should I call it?))

 [1/6] from: hallvard::ystad::helpinhand::com at: 23-Jun-2003 20:24


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. 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...

 [2/6] from: tim:johnsons-web at: 23-Jun-2003 11:26

Re: SQL, driver or me?


* 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
<<quoted lines omitted: 41>>
> [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

 [3/6] from: hallvard:ystad:helpinhand at: 23-Jun-2003 23:19


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. ~H

 [4/6] 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:
<<quoted lines omitted: 10>>
> 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
<<quoted lines omitted: 69>>
> [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

 [5/6] from: g:santilli:tiscalinet:it at: 24-Jun-2003 10:47

Re: SQL, driver or me? (was: Re: Re: [ANN] (but what should I call it?)


Hi Hallvard, On Monday, June 23, 2003, 8:24:59 PM, you wrote: HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] HY> Net-log: ["low level read of " 0 "bytes"] Never happened to me with Nenad's mysql://, however, by this trace it looks like the buffer for READ-IO was not big enough. Maybe you could search for it in the mysql-protocol source code and see if you can add to the chars allocated for the buffer (i.e. if it does buffer: make string! len you change it to buffer: make string! len + 2). If it doesn't fix the problem, then the problem is somewhere else. ;-) Regards, Gabriele. -- Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer Amigan -- AGI L'Aquila -- REB: http://web.tiscali.it/rebol/index.r

 [6/6] from: Maarten::Koopmans::surfnet::nl at: 25-Jun-2003 9:56

Re: SQL, driver or me?


Me too. --maarten

Notes
  • Quoted lines have been omitted from some messages.
    View the message alone to see the lines that have been omitted