Davide Alberani wrote:
> Fixed. Now it's all to see if IMDbPY has decent performances
> on a DB2 server... :-)
After running for about 8 hours, the script runs into an error:
[...]
SCANNING actor: Ferguson, Duane (I)
SCANNING actor: Fernández, Florentino (I)
* FLUSHING SQLData...
SCANNING actor: Ferrer, Filipe
* FLUSHING CharactersCache...
SCANNING actor: Fiedler, John (I)
* FLUSHING SQLData...
SCANNING actor: Filipe, Laurent
SCANNING actor: Fintesteanu, Ion
* FLUSHING SQLData...
SCANNING actor: Fitz, Florian David
SCANNING actor: Fleenor, John P.
* FLUSHING SQLData...
SCANNING actor: Flores, Raul
SCANNING actor: Fonda, Henry
* FLUSHING SQLData...
SCANNING actor: Ford, James (I)
SCANNING actor: Forte, Joseph
* FLUSHING SQLData...
SCANNING actor: Fowler, John (II)
SCANNING actor: Francesco, Deejay
* FLUSHING SQLData...
SCANNING actor: Franke, Holger (I)
SCANNING actor: Frawley, William
* FLUSHING SQLData...
SCANNING actor: Fremont, Al
* FLUSHING SQLData...
SCANNING actor: Friedrich, Lothar
SCANNING actor: Fróes, Rogério
* FLUSHING SQLData...
SCANNING actor: Funaki, Sho
SCANNING actor: Fürst, Sigge
* FLUSHING SQLData...
SCANNING actor: Gagnon, J. Léo
SCANNING actor: Gallagher, Noel (II)
* FLUSHING SQLData...
* FLUSHING PersonsCache...
SCANNING actor: Gamboa, Joonee
SCANNING actor: Garcia, Bruno (I)
* FLUSHING SQLData...
SCANNING actor: García-Clamart, Carlos
SCANNING actor: Garren, Nicholas
* FLUSHING SQLData...
SCANNING actor: Gastmann, Constantin
SCANNING actor: Gazey, Craig
* FLUSHING SQLData...
SCANNING actor: Gencebay, Orhan
SCANNING actor: Geray, Steven
* FLUSHING SQLData...
SCANNING actor: Ghira, Alberto
SCANNING actor: Giese, Godehard
* FLUSHING SQLData...
SCANNING actor: Gill, Avtar
SCANNING actor: Ginn, Stewart
* FLUSHING SQLData...
SCANNING actor: Glaser, Paul Michael
SCANNING actor: Glover, Michael-Jerred
* FLUSHING SQLData...
SCANNING actor: Goggins, Walton
SCANNING actor: Gomes, Custódio
* FLUSHING SQLData...
SCANNING actor: González, Carlos A.
SCANNING actor: Goodrow, Garry
* FLUSHING SQLData...
SCANNING actor: Gore II, George
SCANNING actor: Gotsis, Elpidoforos
* FLUSHING SQLData...
SCANNING actor: Grace, Meyer
SCANNING actor: Granata, Ubaldo
* FLUSHING SQLData...
SCANNING actor: Graudus, Konstantin
SCANNING actor: Greco, Joel S.
* FLUSHING SQLData...
SCANNING actor: Greenhalgh, Andy
* FLUSHING SQLData...
SCANNING actor: Grey, David (I)
* FLUSHING CharactersCache...
Traceback (most recent call last):
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
2145, in <module>
run()
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
2041, in run
castLists(_charIDsList=characters_imdbIDs)
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
1212, in castLists
doCast(f, roleid, rolename)
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
1171, in doCast
cid = CACHE_CID.addUnique(role)
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
679, in addUnique
else: return self.add(key, miscData)
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
672, in add
self[key] = c
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
589, in __setitem__
self.flush()
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
613, in flush
self._toDB(quiet)
File "/home/selke/Desktop/imdb/IMDbPY/usr/bin/imdbpy2sql.py", line
888, in _toDB
CURS.executemany(self.sqlstr, self.converter(l))
File
"/home/selke/Desktop/imdb/ibm_db/usr/lib/python2.5/site-packages/ibm_db-0.4.1-py2.5-linux-x86_64.egg/ibm_db_dbi.py",
line 1063, in executemany
self._execute_helper(rows_counter, seq_parameters[index])
File
"/home/selke/Desktop/imdb/ibm_db/usr/lib/python2.5/site-packages/ibm_db-0.4.1-py2.5-linux-x86_64.egg/ibm_db_dbi.py",
line 951, in _execute_helper
raise _get_exception(inst)
ibm_db_dbi.DataError: ibm_db_dbi::DataError: Statement Execute Failed:
[IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001
SQLCODE=-99999
CLI0109E refers to this DB2 error:
<http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.messages.cli.doc/doc/mcli00109e.html>
Can you imagine what happened?
Joachim
--
M. Sc. Joachim Selke
Technische Universität Braunschweig, Institut für Informationssysteme
Mühlenpfordtstraße 23, 38106 Braunschweig, Germany
<http://www.l3s.uni-hannover.de/~selke>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
