Re: [Imdbpy-help] MemoryError
fixed it by installing python 2.7 64bit including all dependencies that are needed in 64b. a python dictionary will be capped by the 32b limit, therefore you need more than 64b to allow bigger dictionaries. total ram used in the process is ~2.5GB Ori. On Sun, Oct 23, 2016 at 5:58 PM, Mohamed Ounwrote: > Hello, I'm now having the same problem as Abraham. The same MemoryError > that occurs with the Misc. crew data. I downloaded the package from the > website, and also tried the one on Github. both same problem. > This is what's thrown at me, always at the same stage: > > Traceback (most recent call last): > File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line > 3072, in > run() > File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line > 2958, in run > castLists() > File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line > 1641, in castLists > doCast(f, roleid, rolename) > File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line > 1563, in doCast > pid = CACHE_PID.addUnique(name.strip(), miscData) > File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line > 1017, in addUnique > else: return self.add(key, miscData) > File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line > 1010, in add > self[key] = c > File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line > 922, in __setitem__ > dict.__setitem__(self, key, counter) > MemoryError > > > > > > On Wed, Sep 28, 2016 at 10:47 PM, Abraham Whiskas < > abrahamwhis...@outlook.com> wrote: > >> Hi i'm trying to import the text files into MySQL, however i am getting >> this error: >> >> >> Traceback (most recent call last): >>File "C:\Python27\Scripts\imdbpy2sql.py", line 3072, in >> run() >>File "C:\Python27\Scripts\imdbpy2sql.py", line 2958, in run >> castLists() >>File "C:\Python27\Scripts\imdbpy2sql.py", line 1641, in castLists >> doCast(f, roleid, rolename) >>File "C:\Python27\Scripts\imdbpy2sql.py", line 1563, in doCast >> pid = CACHE_PID.addUnique(name.strip(), miscData) >>File "C:\Python27\Scripts\imdbpy2sql.py", line 1017, in addUnique >> else: return self.add(key, miscData) >>File "C:\Python27\Scripts\imdbpy2sql.py", line 1010, in add >> self[key] = c >>File "C:\Python27\Scripts\imdbpy2sql.py", line 922, in __setitem__ >> dict.__setitem__(self, key, counter) >> MemoryError >> >> >> At first i thought it was an error resulting from the a DB limitation so >> i tried to use the csv option, and the error was still thrown, so it >> should be a limitation of python on my environment. >> >> I'm running this on an Windows 10 64 bits Pro, with an i7 with SSD and >> 16gb ram, so it's not a RAM problem, however the python i have installed >> is 32 bits, which i think is the reason due to memory allocation limits. >> >> Any ideas on how to get the data loaded to the DB? >> >> Thanks >> >> -- >> ___ >> Imdbpy-help mailing list >> Imdbpy-help@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/imdbpy-help >> > > > > -- > *Best Regards, * > *Mohamed Oun* > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > ___ > Imdbpy-help mailing list > Imdbpy-help@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/imdbpy-help > > -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
Re: [Imdbpy-help] MemoryError
Hello, I'm now having the same problem as Abraham. The same MemoryError that occurs with the Misc. crew data. I downloaded the package from the website, and also tried the one on Github. both same problem. This is what's thrown at me, always at the same stage: Traceback (most recent call last): File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line 3072, in run() File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line 2958, in run castLists() File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line 1641, in castLists doCast(f, roleid, rolename) File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line 1563, in doCast pid = CACHE_PID.addUnique(name.strip(), miscData) File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line 1017, in addUnique else: return self.add(key, miscData) File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line 1010, in add self[key] = c File "C:\Python27\Lib\site-packages\imdb\Scripts\imdbpy2sql.py", line 922, in __setitem__ dict.__setitem__(self, key, counter) MemoryError On Wed, Sep 28, 2016 at 10:47 PM, Abraham Whiskas < abrahamwhis...@outlook.com> wrote: > Hi i'm trying to import the text files into MySQL, however i am getting > this error: > > > Traceback (most recent call last): >File "C:\Python27\Scripts\imdbpy2sql.py", line 3072, in > run() >File "C:\Python27\Scripts\imdbpy2sql.py", line 2958, in run > castLists() >File "C:\Python27\Scripts\imdbpy2sql.py", line 1641, in castLists > doCast(f, roleid, rolename) >File "C:\Python27\Scripts\imdbpy2sql.py", line 1563, in doCast > pid = CACHE_PID.addUnique(name.strip(), miscData) >File "C:\Python27\Scripts\imdbpy2sql.py", line 1017, in addUnique > else: return self.add(key, miscData) >File "C:\Python27\Scripts\imdbpy2sql.py", line 1010, in add > self[key] = c >File "C:\Python27\Scripts\imdbpy2sql.py", line 922, in __setitem__ > dict.__setitem__(self, key, counter) > MemoryError > > > At first i thought it was an error resulting from the a DB limitation so > i tried to use the csv option, and the error was still thrown, so it > should be a limitation of python on my environment. > > I'm running this on an Windows 10 64 bits Pro, with an i7 with SSD and > 16gb ram, so it's not a RAM problem, however the python i have installed > is 32 bits, which i think is the reason due to memory allocation limits. > > Any ideas on how to get the data loaded to the DB? > > Thanks > > -- > ___ > Imdbpy-help mailing list > Imdbpy-help@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/imdbpy-help > -- *Best Regards, * *Mohamed Oun* -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
Re: [Imdbpy-help] MemoryError
Hi You're referring to the package? If i'm not mistaken i downloaded it through the website, but as i had some issues installing i'm not 100% sure. Did you manage to reproduce the error? Is the data contained in the "miscellaneous crew" a lot? Thanks On 15-10-2016 09:34, Davide Alberani wrote: > On Thu, Sep 29, 2016 at 1:00 AM, Abraham Whiskas >wrote: >> Sorry, it doesn't work afterall.. so if anyone has any ideas ideas.. > Hi Abraham, > are you using the version from the repository? > > I'll try to reproduce it in the next days. > > -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
Re: [Imdbpy-help] MemoryError
On Thu, Sep 29, 2016 at 1:00 AM, Abraham Whiskaswrote: > Sorry, it doesn't work afterall.. so if anyone has any ideas ideas.. Hi Abraham, are you using the version from the repository? I'll try to reproduce it in the next days. -- Davide Alberani [PGP KeyID: 0x465BFD47] http://www.mimante.net/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
Re: [Imdbpy-help] MemoryError
I managed to track what was causing the error, and it was the "miscellaneous crew" data. After looking through the code, i reduced the sqldata.flushEvery value in function doCast, and apparently it worked. Thanks On 28-09-2016 21:47, Abraham Whiskas wrote: > Hi i'm trying to import the text files into MySQL, however i am getting > this error: > > > Traceback (most recent call last): > File "C:\Python27\Scripts\imdbpy2sql.py", line 3072, in > run() > File "C:\Python27\Scripts\imdbpy2sql.py", line 2958, in run > castLists() > File "C:\Python27\Scripts\imdbpy2sql.py", line 1641, in castLists > doCast(f, roleid, rolename) > File "C:\Python27\Scripts\imdbpy2sql.py", line 1563, in doCast > pid = CACHE_PID.addUnique(name.strip(), miscData) > File "C:\Python27\Scripts\imdbpy2sql.py", line 1017, in addUnique > else: return self.add(key, miscData) > File "C:\Python27\Scripts\imdbpy2sql.py", line 1010, in add > self[key] = c > File "C:\Python27\Scripts\imdbpy2sql.py", line 922, in __setitem__ > dict.__setitem__(self, key, counter) > MemoryError > > > At first i thought it was an error resulting from the a DB limitation so > i tried to use the csv option, and the error was still thrown, so it > should be a limitation of python on my environment. > > I'm running this on an Windows 10 64 bits Pro, with an i7 with SSD and > 16gb ram, so it's not a RAM problem, however the python i have installed > is 32 bits, which i think is the reason due to memory allocation limits. > > Any ideas on how to get the data loaded to the DB? > > Thanks > -- > ___ > Imdbpy-help mailing list > Imdbpy-help@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/imdbpy-help -- ___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help