rendered paste body2007-03-26 01:46:16,796 DEBUG return code=0 process ID=5284 parent process ID=4072 process group ID=5284 session ID=4072 user ID=1000 effective user ID=1000 real group ID=1000 effective group ID=1000
2007-03-26 01:46:16,796 INFO Writing pid to file system 5284
2007-03-26 01:46:16,796 DEBUG Process Pid saved as 5284
2007-03-26 01:46:16,796 INFO Starting the socket Listener
2007-03-26 01:46:16,796 INFO Connection to socket successfull
2007-03-26 01:46:16,796 INFO Listening
2007-03-26 01:46:16,796 INFO Started the socket Listener
2007-03-26 01:46:16,796 INFO Connection to tag socket successfull
2007-03-26 01:46:16,796 INFO Listening for tags
2007-03-26 01:46:16,796 DEBUG Current Directory is/home/prash/daemon
2007-03-26 01:46:16,821 INFO Connecting to the TaG Table
2007-03-26 01:46:16,821 INFO Connected
2007-03-26 01:46:16,821 INFO Table: tagTable does not exists
2007-03-26 01:46:16,821 DEBUG create table tagTable (TAG STRING PRIMARY KEY, FILES STRING);
2007-03-26 01:46:16,889 INFO Tag table created
2007-03-26 01:46:20,267 DEBUG Connection accepted for ('127.0.0.1', 4438) at <socket._socketobject object at 0xb7a0ab1c>
2007-03-26 01:46:20,268 DEBUG Received connection: <socket._socketobject object at 0xb7a0ab1c>
2007-03-26 01:46:20,268 INFO Obtained a query from the Driver
2007-03-26 01:46:20,269 DEBUG <?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event uid="uuid" mountpoint="/home/prash/backup/working/boo" action="start"/></semfs>
2007-03-26 01:46:20,269 DEBUG Got 2 event(s)
2007-03-26 01:46:20,269 INFO Current Executing Query :<?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event uid="uuid" mountpoint="/home/prash/backup/working/boo" action="start"/></semfs>
2007-03-26 01:46:20,270 DEBUG action :start, connection :False
2007-03-26 01:46:20,270 DEBUG mainef7c876f00f3acddd00fa671f52d0b1f mounted at /home/prash/backup/working/boo
2007-03-26 01:46:20,270 INFO Connection Created
2007-03-26 01:46:20,270 INFO starting the query processor
2007-03-26 01:46:20,270 DEBUG Using APSW file /usr/lib/python2.5/site-packages/apsw.so
2007-03-26 01:46:20,270 DEBUG APSW version 3.3.5-r1
2007-03-26 01:46:20,270 DEBUG SQLite version3.3.13
2007-03-26 01:46:20,270 DEBUG Current Directory is/home/prash/daemon
2007-03-26 01:46:20,270 INFO Connecting to the SemFS Indexing Table
2007-03-26 01:46:20,270 INFO Connected
2007-03-26 01:46:20,270 DEBUG Found a plugin -> jpeg.semFS-plugin
2007-03-26 01:46:20,270 INFO Reading the plugin contents to get the module name
2007-03-26 01:46:20,270 INFO Plugin Added to current list...
2007-03-26 01:46:20,271 DEBUG Found a plugin -> mp3.semFS-plugin
2007-03-26 01:46:20,271 INFO Reading the plugin contents to get the module name
2007-03-26 01:46:20,272 INFO Plugin Added to current list...
2007-03-26 01:46:20,273 INFO Table: mainef7c876f00f3acddd00fa671f52d0b1f does not exists
2007-03-26 01:46:20,273 DEBUG create table mainef7c876f00f3acddd00fa671f52d0b1f (FILENAME STRING, INODE INTEGER PRIMARY KEY, PARENTINODE INTEGER, MODE INTEGER, USERID INTEGER, GROUPID INTEGER, SIZE INTEGER, ATIME INTEGER, MTIME INTEGER, CTIME INTEGER, TYPE STRING);
2007-03-26 01:46:20,317 INFO Main table Index created with name mainef7c876f00f3acddd00fa671f52d0b1f
2007-03-26 01:46:20,318 INFO Main table created
2007-03-26 01:46:20,318 DEBUG {'jpeg.semFS-plugin': 'jpeg', 'mp3.semFS-plugin': 'mp3'}
2007-03-26 01:46:20,327 DEBUG {'jpeg': <module 'plugins.jpeg' from '/home/prash/daemon/plugins/jpeg.pyc'>}
2007-03-26 01:46:20,328 DEBUG {'comment': 'STRING', 'orientation': 'INTEGER', 'title': 'INTEGER', 'country': 'STRING', 'height': 'INTEGER', 'hardware': 'STRING', 'width': 'INTEGER', 'keywords': 'STRING', 'date': 'INTEGER', 'caption': 'STRING', 'type': 'STRING', 'thumbnail': 'INTEGER', 'software': 'INTEGER'}
2007-03-26 01:46:20,329 INFO Table: jpeg does not exists
2007-03-26 01:46:20,330 DEBUG create table jpeg (INODE INTEGER PRIMARY KEY, comment STRING,orientation INTEGER,title INTEGER,country STRING,height INTEGER,hardware STRING,width INTEGER,keywords STRING,date INTEGER,caption STRING,type STRING,thumbnail INTEGER,software INTEGER);
2007-03-26 01:46:20,361 INFO Created a table for the plugin
2007-03-26 01:46:20,361 DEBUG {'mp3': <module 'plugins.mp3' from '/home/prash/daemon/plugins/mp3.pyc'>, 'jpeg': <module 'plugins.jpeg' from '/home/prash/daemon/plugins/jpeg.pyc'>}
2007-03-26 01:46:20,361 DEBUG {'album': 'STRING', 'layer': 'STRING', 'version': 'INTEGER', 'protection': 'STRING', 'title': 'STRING', 'artist': 'STRING', 'mode_extension': 'STRING', 'private': 'STRING', 'padding': 'STRING', 'emphasis': 'STRING', 'trackno': 'INTEGER', 'mode': 'STRING', 'length': 'INTEGER', 'samplerate': 'INTEGER', 'copyright': 'STRING', 'bitrate': 'INTEGER', 'original': 'STRING'}
2007-03-26 01:46:20,361 INFO Table: mp3 does not exists
2007-03-26 01:46:20,362 DEBUG create table mp3 (INODE INTEGER PRIMARY KEY, album STRING,layer STRING,version INTEGER,protection STRING,title STRING,artist STRING,mode_extension STRING,private STRING,padding STRING,emphasis STRING,trackno INTEGER,mode STRING,length INTEGER,samplerate INTEGER,copyright STRING,bitrate INTEGER,original STRING);
2007-03-26 01:46:20,378 INFO Created a table for the plugin
2007-03-26 01:46:20,382 INFO Data written on the driver port
2007-03-26 01:46:20,382 DEBUG Connection started Successfully
2007-03-26 01:46:27,749 INFO Obtained a query from the Driver
2007-03-26 01:46:27,750 DEBUG <?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event id="1804289383" action="create"><file>/BOOM.mp3</file><ino>22</ino><pno>2</pno></event></semfs>
2007-03-26 01:46:27,750 DEBUG Got 2 event(s)
2007-03-26 01:46:27,750 INFO Current Executing Query :<?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event id="1804289383" action="create"><file>/BOOM.mp3</file><ino>22</ino><pno>2</pno></event></semfs>
2007-03-26 01:46:27,752 DEBUG action :create, connection :True
2007-03-26 01:46:27,752 DEBUG Updating info of /BOOM.mp3,22,2 in Main Table
2007-03-26 01:46:27,752 DEBUG insert into mainef7c876f00f3acddd00fa671f52d0b1f values('/BOOM.mp3',22,2,'','','','','','','','None');
2007-03-26 01:46:27,780 INFO Inserted into main table
2007-03-26 01:46:27,781 INFO Data written on the driver port
2007-03-26 01:46:27,781 INFO create successfull
2007-03-26 01:46:27,781 INFO Obtained a query from the Driver
2007-03-26 01:46:27,781 DEBUG <?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event id="1804289384" action="write"><ino>22</ino></event></semfs>
2007-03-26 01:46:27,781 DEBUG Got 2 event(s)
2007-03-26 01:46:27,781 INFO Current Executing Query :<?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event id="1804289384" action="write"><ino>22</ino></event></semfs>
2007-03-26 01:46:27,781 DEBUG action :write, connection :True
2007-03-26 01:46:27,781 INFO select PARENTINODE,FILENAME from mainef7c876f00f3acddd00fa671f52d0b1f where INODE = 22
2007-03-26 01:46:27,783 INFO 2,/BOOM.mp3 are the ino and filename of 22
2007-03-26 01:46:27,783 DEBUG /home/prash/backup/working/boo/BOOM.mp3
2007-03-26 01:46:27,942 DEBUG Updating info of /home/prash/backup/working/boo/BOOM.mp3 as an mp3 file
2007-03-26 01:46:27,942 INFO Hoping that nothing is returned
2007-03-26 01:46:28,635 DEBUG {'album': 'BOYS', 'layer': '', 'version': '', 'protection': '', 'title': 'BOOM BOOM', 'artist': '', 'mode_extension': '', 'private': '', 'filename': '/home/prash/backup/working/boo/BOOM.mp3', 'padding': '', 'genre': 'Rock', 'emphasis': '', 'trackno': '3', 'mode': '', 'date': '2003', 'length': '300', 'samplerate': '', 'copyright': '', 'bitrate': '', 'original': ''}
2007-03-26 01:46:28,646 DEBUG 33188, 22, 19, 1, 0, 0, 4826093, 1174853787, 1174853787, 1174853787
2007-03-26 01:46:28,646 DEBUG update mainef7c876f00f3acddd00fa671f52d0b1f set FILENAME = '/BOOM.mp3', PARENTINODE = 2, MODE = 33188, USERID = 22, GROUPID = 19, SIZE = 1, ATIME = 0, MTIME = 0, CTIME = 4826093, TYPE = 'mp3' where INODE = 22;
2007-03-26 01:46:28,671 INFO Inserted into main table
2007-03-26 01:46:28,671 INFO Main Table updated
2007-03-26 01:46:28,671 DEBUG {'album': 'BOYS', 'layer': '', 'version': '', 'protection': '', 'title': 'BOOM BOOM', 'artist': '', 'mode_extension': '', 'private': '', 'filename': '/home/prash/backup/working/boo/BOOM.mp3', 'padding': '', 'genre': 'Rock', 'emphasis': '', 'trackno': '3', 'mode': '', 'date': '2003', 'length': '300', 'samplerate': '', 'copyright': '', 'bitrate': '', 'original': ''}
2007-03-26 01:46:28,671 DEBUG 20
2007-03-26 01:46:28,671 DEBUG insert into mp3 values ('22','BOYS','','','','BOOM BOOM','','','','/home/prash/backup/working/boo/BOOM.mp3','','Rock','','3','','2003','300','','','','');
2007-03-26 01:46:28,671 ERROR While Inserting the Index
Traceback (most recent call last):
File "/home/prash/daemon/utils/queryProcessor.py", line 289, in insertIntoPluginTable
cursor.execute(query)
SQLError: SQLError: table mp3 has 18 columns but 21 values were supplied
2007-03-26 01:46:28,676 INFO Obtained a query from the Driver
2007-03-26 01:46:28,676 DEBUG <?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event id="1804289385" action="write"><ino>22</ino></event></semfs>
2007-03-26 01:46:28,676 DEBUG Got 2 event(s)
2007-03-26 01:46:28,676 INFO Current Executing Query :<?xml version="1.0" encoding="ISO-8859-1"?>
<semfs><event id="1804289385" action="write"><ino>22</ino></event></semfs>
2007-03-26 01:46:28,676 DEBUG action :write, connection :True
2007-03-26 01:46:28,676 INFO select PARENTINODE,FILENAME from mainef7c876f00f3acddd00fa671f52d0b1f where INODE = 22
2007-03-26 01:46:28,677 INFO 2,/BOOM.mp3 are the ino and filename of 22
2007-03-26 01:46:28,678 DEBUG /home/prash/backup/working/boo/BOOM.mp3
2007-03-26 01:46:28,679 DEBUG Updating info of /home/prash/backup/working/boo/BOOM.mp3 as an mp3 file
2007-03-26 01:46:28,680 INFO Hoping that nothing is returned
2007-03-26 01:46:28,812 DEBUG {'album': 'BOYS', 'layer': '', 'version': '', 'protection': '', 'title': 'BOOM BOOM', 'artist': '', 'mode_extension': '', 'private': '', 'filename': '/home/prash/backup/working/boo/BOOM.mp3', 'padding': '', 'genre': 'Rock', 'emphasis': '', 'trackno': '3', 'mode': '', 'date': '2003', 'length': '300', 'samplerate': '', 'copyright': '', 'bitrate': '', 'original': ''}
2007-03-26 01:46:28,813 DEBUG 33188, 22, 19, 1, 0, 0, 4826093, 1174853787, 1174853787, 1174853787
2007-03-26 01:46:28,813 DEBUG update mainef7c876f00f3acddd00fa671f52d0b1f set FILENAME = '/BOOM.mp3', PARENTINODE = 2, MODE = 33188, USERID = 22, GROUPID = 19, SIZE = 1, ATIME = 0, MTIME = 0, CTIME = 4826093, TYPE = 'mp3' where INODE = 22;
2007-03-26 01:46:28,863 INFO Inserted into main table
2007-03-26 01:46:28,863 INFO Main Table updated
2007-03-26 01:46:28,864 DEBUG {'album': 'BOYS', 'layer': '', 'version': '', 'protection': '', 'title': 'BOOM BOOM', 'artist': '', 'mode_extension': '', 'private': '', 'filename': '/home/prash/backup/working/boo/BOOM.mp3', 'padding': '', 'genre': 'Rock', 'emphasis': '', 'trackno': '3', 'mode': '', 'date': '2003', 'length': '300', 'samplerate': '', 'copyright': '', 'bitrate': '', 'original': ''}
2007-03-26 01:46:28,864 DEBUG 20
2007-03-26 01:46:28,866 DEBUG insert into mp3 values ('22','BOYS','','','','BOOM BOOM','','','','/home/prash/backup/working/boo/BOOM.mp3','','Rock','','3','','2003','300','','','','');
2007-03-26 01:46:28,868 ERROR While Inserting the Index
Traceback (most recent call last):
File "/home/prash/daemon/utils/queryProcessor.py", line 289, in insertIntoPluginTable
cursor.execute(query)
SQLError: SQLError: table mp3 has 18 columns but 21 values were supplied