Hi there! I'm trying to import the whole IMDB database into mySql, but 
here and there this error appears importing movies, and later on other 
tables too:


SCANNING movies: "Studio Luma" (2014) {Bye Bye Blondie (#4.2)} (movieID: 
2190001)
  * FLUSHING MoviesCache...
  * TOO MANY DATA (100000 items in MoviesCache), recursion: 1
    * SPLITTING (run 1 of 2), recursion: 1
  * FLUSHING MoviesCache...
  * TOO MANY DATA (50000 items in MoviesCache), recursion: 2
    * SPLITTING (run 1 of 2), recursion: 2
  * FLUSHING MoviesCache...
  * TOO MANY DATA (25000 items in MoviesCache), recursion: 3
    * SPLITTING (run 1 of 2), recursion: 3
  * FLUSHING MoviesCache...
  * TOO MANY DATA (12500 items in MoviesCache), recursion: 4
    * SPLITTING (run 1 of 2), recursion: 4
  * FLUSHING MoviesCache...
  * TOO MANY DATA (6250 items in MoviesCache), recursion: 5
    * SPLITTING (run 1 of 2), recursion: 5
  * FLUSHING MoviesCache...
  * TOO MANY DATA (3125 items in MoviesCache), recursion: 6
    * SPLITTING (run 1 of 2), recursion: 6
  * FLUSHING MoviesCache...
    * SPLITTING (run 2 of 2), recursion: 6
  * FLUSHING MoviesCache...
  * TOO MANY DATA (1563 items in MoviesCache), recursion: 7
    * SPLITTING (run 1 of 2), recursion: 7
  * FLUSHING MoviesCache...
    * SPLITTING (run 2 of 2), recursion: 7
  * FLUSHING MoviesCache...
  * TOO MANY DATA (782 items in MoviesCache), recursion: 8
    * SPLITTING (run 1 of 2), recursion: 8
  * FLUSHING MoviesCache...
    * SPLITTING (run 2 of 2), recursion: 8
  * FLUSHING MoviesCache...
  * TOO MANY DATA (391 items in MoviesCache), recursion: 9
    * SPLITTING (run 1 of 2), recursion: 9
  * FLUSHING MoviesCache...
  * TOO MANY DATA (195 items in MoviesCache), recursion: 10
    * SPLITTING (run 1 of 2), recursion: 10
WARNING recursion level exceded trying to flush data
WARNING this batch of data is lost (MoviesCache).
    * SPLITTING (run 2 of 2), recursion: 10
    * SPLITTING (run 2 of 2), recursion: 9
    * SPLITTING (run 2 of 2), recursion: 5
    * SPLITTING (run 2 of 2), recursion: 4
    * SPLITTING (run 2 of 2), recursion: 3
    * SPLITTING (run 2 of 2), recursion: 2
    * SPLITTING (run 2 of 2), recursion: 1

I searched on google and I found a comment on this suggesting to 
increase the max_allowed_packet value in mysql server. I did it (brought 
up to 500M) but still the problem represent itself.
Any other hint?

Many many thanks
Giovanni


------------------------------------------------------------------------------
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

Reply via email to