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
