"Resource temporarily unavailable" error on reading CSV file in web2py app on PythonAnywhere

Question

I have a python web2py app uploaded at PythonAnywhere. App is working fine. I want to read a csv file placed in a folder along with my app and import it into mysql table. When I try to read that CSV file, I get the error saying "[Errno 11] Resource temporarily unavailable".

I am new to python as well as PythonAnywhere and I couldn't understand this issue and can't figure it out how can I overcome this error and read a csv file successfully at server?

Note: I can run this code successfully on my local machine.

What I am doing is this:

path = '/home/user123/web2py/files/'
file_ = path+filename
print file_
with open(file_, "r") as f_obj:
    reader = csv.reader(f_obj)
    fields = reader.next()
    print fields
    self.create_new_table(tablename, fields)

Will appreciate any help in this regard.
Thanx in advance.

It's very unlikely that the code you posted raised the error. Unless it comes from somewhere inside self.create_new_table. Where in your code was the error raised? — Glenn
– Glenn, Commented Jun 8, 2015 at 11:23

Massab · Accepted Answer · 2015-06-10 04:38:38Z

2

I opened server.log file in Web tab and found out that the print statement "print fields" was causing the error .... It tried to print all the column names and at the mid of those column names, it produced this error and stopped execution. I removed such print statements which were trying to print long statements and the error was gone! It seems to be limit in print or something else similar to this, dont know exactly!

answered Jun 10, 2015 at 4:38

Massab

1,0509 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Giles Thomas Over a year ago

(PythonAnywhere dev here) How weird! I've never seen a print statement do anything like that. Glad you worked it out :-)

Massab Over a year ago

I also didn't even think of that, thats why I sufferred from it for almost three days. That was really tragic to find out "print" statements causing that !

Collectives™ on Stack Overflow

"Resource temporarily unavailable" error on reading CSV file in web2py app on PythonAnywhere

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related