Jason Tackaberry wrote:
> On Wed, 2006-08-02 at 20:16 +0200, Dirk Meyer wrote:
>
>>
>>When I do _load_object_types just after the query it is already
>>broken. One other thing besides your new code changed here: I had to
>>switch from pysqlite 2.0.x to 2.3.1.
>
>
> Do 'SELECT * FROM types' after that query in
> register_object_type_attrs() and output each row.
>
added print "SQL: ", (statement, args) in _do_query
and i also added print _do_query("SELECT * FROM types") the line before
the for where the exception is thrown....
removed ~/.beacon
this is the complete output when i then start beacon. (maybe it gives
you some extra input?)
terrebi freevo # beacon --start --fg --verbose all
INFO server(25): start hardware monitor
INFO beacon(306): connect to thumbnailer ...
INFO beacon(308): connection to thumbnailer established
INFO beacon(311): connect to hwmon ...
INFO beacon(313): connection to hwmon established
INFO server(75): start beacon
SQL: ("SELECT name FROM sqlite_master where name=? and type='table'",
('meta',))
INFO server(60): beacon <-> hwmon connected
SQL: ("SELECT name FROM sqlite_master where name=? and type='table'",
('meta',))
SQL: ("SELECT value FROM meta WHERE attr='version'", ())
SELECT * FROM types : SQL: ('SELECT * from types', ())
[]
SQL: ('SELECT * from types', ())
SELECT * FROM types : SQL: ('SELECT * from types', ())
[]
SQL: ('SELECT * from types', ())
SQL: ('CREATE TABLE objects_dir_tmp (name BLOB,media
INTEGER,parent_type INTEGER,parent_id INTEGER,pickle BLOB,id INTEGER
PRIMARY KEY AUTOINCREMENT)', ())
SQL: ('INSERT OR REPLACE INTO types VALUES(?, ?, ?, ?)', (None, 'dir',
<read-only buffer for 0xb79a9bc0, size -1, offset 0 at 0xb74f01c0>,
<read-only buffer for 0xb74ea0b0, size -1, offset 0 at 0xb74f0200>))
SELECT * FROM types : SQL: ('SELECT * from types', ())
[(1, u'dir', <read-write buffer ptr 0xb78c1840, size 217 at 0xb78c1820>,
<read-write buffer ptr 0xb74dbb30, size 44 at 0xb74dbb10>)]
SQL: ('SELECT * from types', ())
SQL: ('ALTER TABLE objects_dir_tmp RENAME TO objects_dir', ())
SQL: ("CREATE TRIGGER delete_object_dir DELETE ON objects_dir BEGIN
UPDATE meta SET value=value-1 WHERE attr='keywords_objectcount'; END", ())
SQL: ('CREATE INDEX objects_dir_parent_idx on objects_dir (parent_id,
parent_type)', ())
SQL: ('CREATE INDEX objects_dir_media_idx ON objects_dir (media)', ())
SQL: ('CREATE INDEX objects_dir_name_parent_type_parent_id_idx ON
objects_dir (name,parent_type,parent_id)', ())
SQL: ('CREATE TABLE objects_file_tmp (name BLOB,media
INTEGER,parent_type INTEGER,parent_id INTEGER,pickle BLOB,id INTEGER
PRIMARY KEY AUTOINCREMENT)', ())
SQL: ('INSERT OR REPLACE INTO types VALUES(?, ?, ?, ?)', (None, 'file',
<read-only buffer for 0xb79a9bc0, size -1, offset 0 at 0xb74f0800>,
<read-only buffer for 0xb74ea0b0, size -1, offset 0 at 0xb74f0920>))
SELECT * FROM types : SQL: ('SELECT * from types', ())
[(1, u'dir', <read-write buffer ptr 0xb78c1840, size 217 at 0xb78c1820>,
<read-write buffer ptr 0xb74dbb80, size 44 at 0xb74dbb60>), (2, None,
None, None)]
SQL: ('SELECT * from types', ())
ERROR beacon(329): beacon startup
Traceback (most recent call last):
File "/usr/bin/beacon", line 315, in ?
server = kaa.beacon.server.Server(database)
File "/usr/lib/python2.4/site-packages/kaa/beacon/server.py", line
88, in __init__
self._db = Database(dbdir, None)
File "/usr/lib/python2.4/site-packages/kaa/beacon/db.py", line 111,
in __init__
mtime = (int, ATTR_SIMPLE))
File "/usr/lib/python2.4/site-packages/kaa/db.py", line 319, in
register_object_type_attrs
self._load_object_types()
File "/usr/lib/python2.4/site-packages/kaa/db.py", line 360, in
_load_object_types
self._object_types[name] = id, cPickle.loads(str(attrs)),
cPickle.loads(str(idx))
UnpicklingError: could not find MARK
INFO beacon(331): stop beacon
Traceback (most recent call last):
File "/usr/bin/beacon", line 334, in ?
os.waitpid(pid, 0)
KeyboardInterrupt
terrebi freevo #
//NiXZe
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Freevo-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/freevo-devel
