| 00:00.11 | sjansen | Doing ClamAV installs on servers. |
| 00:06.33 | HarleyPig | heh |
| 00:08.08 | sjansen | yeah, no dedication |
| 00:28.27 | HarleyPig | is it possible to push data too fast into a mysql table? |
| 00:29.50 | HarleyPig | I'm getting an "illegal seek" when trying to insert something in a db. |
| 00:31.21 | Jayce^ | uhhhh.. no |
| 00:31.42 | Jayce^ | that sounds like a much more serious problem |
| 00:32.02 | HarleyPig | I didn't think so, but this is a wierd error ... I've got a program dumping values into a table just fine. |
| 00:32.26 | HarleyPig | I have an incoming csv file which I break out and feed to the program and I get an illegal seek. |
| 00:32.45 | Jayce^ | how are you breaking it out? |
| 00:33.40 | Jayce^ | eg. are you sure the error is coming from mysql, or is it coming from the csv? |
| 00:33.47 | HarleyPig | while ( <F> ) { @row = split /^T/ ... |
| 00:34.04 | HarleyPig | $r = `$cmd` ... it's in $r. |
| 00:34.55 | HarleyPig | basically, each column is a known type so I create name value pairs col1=val1 col2=val2 |
| 00:35.25 | HarleyPig | then call the program as prog.pl col1=val1 col2=val2 (it's a cgi that I'm pressing into console service). |
| 00:36.49 | Jayce^ | either you have a database error, or, more likely, it's in your execute, or in reading the csv |
| 00:37.12 | Jayce^ | something in one of your programs resetting the seek point or something? |
| 00:37.22 | HarleyPig | well, to be honest I was always thinking it was in the execute ... I just wanted to eliminate the db option. |
| 00:37.35 | HarleyPig | No, I'm reading the whole file into memory and then closing. |
| 00:37.48 | HarleyPig | err ... then closing the file before doing anything with the data. |
| 00:38.50 | Jayce^ | while <f> isn't reading the whole thing into memory, that's iterating over the handle.. performing a seek each time.. |
| 00:39.35 | HarleyPig | But I'm not calling the external program until the loop is complete ... i think ... let me double check. |
| 00:40.16 | HarleyPig | my bad ... I'm doing |
| 00:40.17 | HarleyPig | <PROTECTED> |
| 00:40.17 | HarleyPig | <PROTECTED> |
| 00:40.17 | HarleyPig | <PROTECTED> |
| 00:40.18 | Jayce^ | try running it without actually doing the command? strike that option out |
| 00:40.33 | HarleyPig | Already did. It works fine. |
| 00:41.58 | Jayce^ | so it runs fine if you don't run the subcommand.. but if you have it in, you get the error.. |
| 00:43.27 | HarleyPig | yeah |
| 00:43.37 | HarleyPig | I'm running the subcommand manually now. |
| 00:44.58 | HarleyPig | ?! It's the external program ... it runs fine from the web and when i debug it from the console. |
| 00:45.01 | HarleyPig | It must be my data. |
| 00:47.03 | HarleyPig | It is, I forgot to add a name=value pair the program is requiring ... but why would it give me seek errors this way? |
| 00:47.11 | HarleyPig | Some days I really hate programming. |
| 00:48.14 | Jayce^ | dunno.. |
| 00:53.33 | *** part/#utah HarleyPig (~harleypig@65.105.156.40) |
| 00:59.00 | emcnabb | what's a good way to kill off all the processes owned by a user? |
| 00:59.11 | emcnabb | I used to use slay, but that doesn't come by default on most systems |
| 00:59.47 | Jayce^ | kill -9 1 |
| 00:59.48 | Jayce^ | :) |
| 00:59.52 | emcnabb | haha |
| 01:28.52 | Jayce^ | LOL... IDI posted on the jobs.perl.org list.. |
| 01:28.59 | Jayce^ | Hanuman, you could go for it :) |
| 01:32.26 | *** join/#utah Newsome (~sorenson@sorenson.dsl.csolutions.net) |
| 01:33.04 | Hanuman | Jayce^: lol - just got it |
| 01:33.20 | Hanuman | I better not tell my wife about it |
| 01:34.13 | Hanuman | Who is Dave Reed? |
| 01:36.07 | *** join/#utah philhans (~philip@128.187.253.211) |
| 01:36.14 | Hanuman | I was actually just running on to IRC to tell you Jayce^ |
| 01:37.01 | Jayce^ | hoovers boss |
| 01:37.11 | Jayce^ | you know he loves that.. |
| 01:37.14 | Jayce^ | guy is a moron |
| 01:37.18 | Hanuman | ah - okay. Is it to replace Hoover by chance? |
| 01:37.44 | Jayce^ | dunno, haven't had a chance to ask him yet |
| 01:37.51 | Jayce^ | think he's in class right now |
| 01:38.24 | Hanuman | I just e-mailed him a couple weeks ago asking to use him as one of my references for my new job - he didn't mention anything. Still doesn't mean it's not for his job. |
| 01:38.45 | Hanuman | Still, I don't know if I could handle working with MLM's again. |
| 01:39.11 | Jayce^ | no, he doesn't want too.. he really wants to go, but also wants to pay for school first |
| 01:39.27 | Jayce^ | I think it's more one of their annual hire and fire type things |
| 01:39.27 | Hanuman | yeah - good point |
| 01:39.44 | Hanuman | question is - how long will it be before they fire you after hiring you? |
| 01:41.09 | Hanuman | They don't have a very good success rate with people coming back to the company staying for very long. |