Incidentally, I got up this morning after leaving it running all night and
it has moved on. However, it is only up to the Ps after 13 hours. My quad
core is idle, I am using just 32% of my 6GB, there is no network activity,
but my hard drive does seem to be going haywire (though no memory
swapping). Has anyone seen this?
On Sun, May 20, 2012 at 7:06 PM, Eric Lange <e...@teevos.com> wrote:
> Hello,
>
> Has anyone tried running imdbpy2sql.py on Ubuntu 12.04? It was working
> fine under 11.10, but now when I run it, it hangs on FLUSHING MoviesCache:
>
> eric@eric-ubuntu:~/imdb$ ./imdbpy2sql.py -d ./compressed -u
> mysql://root:xxxxxx@localhost/imdb
>
> NOTICE: IF you're using InnoDB tables, data insertion can
> be very slow; you can switch to MyISAM tables - forcing it
> with the --mysql-force-myisam option - OR use the
> --mysql-innodb command line option, but DON'T USE these if
> you're already working on MyISAM tables, because it will
> force MySQL to use InnoDB, and performances will be poor.
>
> IMPORTING psyco... FAILED (not a big deal, everything is alright...)
>
> RUNNING imdbpy2sql.py using the sqlobject ORM
> SAVING imdbID values for movies... DONE! (0 entries)
> SAVING imdbID values for people... DONE! (0 entries)
> SAVING imdbID values for characters... DONE! (0 entries)
> SAVING imdbID values for companies... DONE! (0 entries)
> DROPPING current database... DONE!
> CREATING new tables... DONE!
> # TIME dropping and recreating the database : 0min, 14sec (wall) 0min,
> 0sec (user) 0min, 0sec (system)
> SCANNING movies: !Women Art Revolution (2010) (movieID: 1)
> SCANNING movies: "31 minutos" (2003) {Benjamín Listillo (#1.4)} (movieID:
> 10001)
> SCANNING movies: "A Favorita" (2008) {(#1.81)} (movieID: 20001)
> SCANNING movies: "Access Hollywood Live" (2010) {(2011-05-10)} (movieID:
> 30001)
> SCANNING movies: "Ajuste de Contas" (2000) {(#1.122)} (movieID: 40001)
> SCANNING movies: "All Saints" (1998) {What Lies Beneath (#10.8)} (movieID:
> 50001)
> SCANNING movies: "America's Next Top Model" (2003) {The Girl Who Forgot
> Her Shoes (#3.7)} (movieID: 60001)
> SCANNING movies: "Animal Crackers" (1988) (movieID: 70001)
> SCANNING movies: "Aquí hay tomate" (2003) {(2006-08-09)} (movieID: 80001)
> SCANNING movies: "Ask That Guy with the Glasses" (2008) {(#3.9)} (movieID:
> 90001)
> * FLUSHING MoviesCache...
>
> And then just stays there indefinitely. I have tried it with both mysql
> 5.5 and postgresql 9.1 and have the same problem with both. I tried using
> the -c option (-c /var/tmp) but it will generate the CSVs fine, but then
> fail to write them to the db (for different reasons in both mysql and
> postgresql -- some issue with not being supported or needing to be
> superuser). I also tried downgrading to python 2.6, but ran into problems
> doing that.
>
> Anyone done this successfully?
>
> Thanks,
> Eric
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
