On May 11, Sabo <[EMAIL PROTECTED]> wrote: > It worked fine (106 minutes with 2 dual core opterons and 4GB > of ram).
Was this computer busy doing other CPU-intensive duties? On a monster like that, I was hoping for better performances. :-) > imdbpy2sql.py:727: Warning: Data truncated for column 'person_role' Pardon if I bother you, but have you an idea of how many of these lines were outputted? If you have saved the output (appending "2>&1 | tee output.txt" to the command) can you send it to me (gzipped)? > I seemed to remember it being related to the max_packet_size > variable, so I set it to 32M and it still happened. Does it need > to be higher or is it unrelated? I don't think it's a matter of max_packet_size: sounds like some strings (specifically the 'person_role' and 'note' fields in the 'cast_info' table, on MySQL) were too long and ended up being truncated. Can you check if the database's structure in your system has restrictions of some sort? A simple way is to use phpmyadmin (or the 'mysql' command) to control that the above mentioned fields are "text" without restrictions in length; maybe you can also try to insert a very long string (at least 1024 chars) and see if it was correctly received by the db server. If possible I would like to identify this problem, because I fear some data are lost in the process. By the way I've vague memories of the same error, and if I recall well it was not related to strings length (but I may be wrong) [1] Oh, as a last thing (if you prefer you can answer me privately, on this): are you the Jon Sabo of this one? : http://www.dupontmanual.org/wikis/spectops//FrontPage/Jon%27s_imdb_projects_%28Kevin_Bacon_and_catalog%29 If you are, can you describe (just a brief summary) it? Do you plan to release something based on your work? From the title, it sounds a lot of fun. :-) Thank you again for the bug report and the feedback! +++ [1] a remind for myself: strings truncated at the first non-ascii char? Hmmm... sounds suspicious... ;-) -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
