gotrich
unread,May 5, 2011, 11:40:04 AM5/5/11Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to nodejs
Not sure where to post this, but it's an odd issue that my mysql
debugging skills are not up to the challenge.
Doing a big "load data infile" using the felixge drivers works
flawlessly on my osx10.6/mysql5.1 setup. Winning.
Now, switching to my Ubuntu stack, any query that does a "load data
infile" just hangs forever, but everything else works (ie, other
queries, inserts,etc). This is what processlist shows on mysql at the
time. I'm perplexed since the mysql cli runs the same query fine (.04
seconds) as does a python script using mysqldb.
| 12388 | root | localhost:50873 | media | Query | 24 | Reading
from net | load data local infile '/home/ingestion/infiles/351/
media_label.txt' into table media_labe |
Ideas on what would cause this command to just hang (forever, ie 7
hours). The code is basic:
client.query("load data local infile '/home/ingestion/infiles/351/
media_label.txt' into table media_label fields terminated by
'\t';",function(err){
});
Rich