Project

General

Profile

Actions

Bug #927

closed

ERROR sqlite3: database is locked

Added by Anonymous about 12 years ago. Updated about 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
04/02/2012
Due date:
% Done:

100%

Estimated time:

Description

Hello,

I have compiled your plugin to run with vdr 1.7.27;
And it won't import the data in the xmltv files, and i can see in the logs that the sqlite3 database is locked
I've tried to understand what caused this but couldn't find out.

Any idea ?

Apr  2 14:14:06 lunatic vdr: [7249] xmltv2vdr: 'kazer' reading from '/var/lib/epgsources/kazer.xmltv'
Apr  2 14:14:06 lunatic vdr: [7249] xmltv2vdr: 'kazer' parsing output
Apr  2 14:14:09 lunatic vdr: [7046] epghander: failed to prepare select channelid,eventid,starttime,duration,title,origtitle,shorttext,description,country,year,credits,category,review,rating,starrating,video,audio,season,episode,mixing,src,eiteventid,eitdescription from epg where eiteventid=41 and channelid='ART1.kazer.org' order by srcidx asc limit 1
Apr  2 14:14:09 lunatic vdr: [7228] Text2Skin: channelInfo display update thread ended (pid=6978, tid=7228)
Apr  2 14:15:04 lunatic vdr: [7090] epghander: failed to prepare select channelid,eventid,starttime,duration,title,origtitle,shorttext,description,country,year,credits,category,review,rating,starrating,video,audio,season,episode,mixing,src,eiteventid,eitdescription from epg where eiteventid=64021 and channelid='FRA2.kazer.org' order by srcidx asc limit 1
Apr  2 14:15:04 lunatic vdr: [7090] epghander: failed to prepare select channelid,eventid,starttime,duration,title,origtitle,shorttext,description,country,year,credits,category,review,rating,starrating,video,audio,season,episode,mixing,src,eiteventid,eitdescription from epg where eiteventid=64528 and channelid='LAC1.kazer.org' order by srcidx asc limit 1
Apr  2 14:15:04 lunatic vdr: [7090] epghander: failed to prepare select channelid,eventid,starttime,duration,title,origtitle,shorttext,description,country,year,credits,category,review,rating,starrating,video,audio,season,episode,mixing,src,eiteventid,eitdescription,abs(starttime-1333368000) as diff from epg where  (starttime>=1333367220 and starttime<=1333368780) and title='Enjeux 2012' and channelid='LAC1.kazer.org'  order by diff,srcidx asc limit 1
Apr  2 14:15:04 lunatic vdr: [7090] epghander: failed to prepare select channelid,eventid,starttime,duration,title,origtitle,shorttext,description,country,year,credits,category,review,rating,starrating,video,audio,season,episode,mixing,src,eiteventid,eitdescription from epg where eiteventid=64177 and channelid='FRA3.kazer.org' order by srcidx asc limit 1
Apr  2 14:15:04 lunatic vdr: [7090] epghander: failed to prepare select channelid,eventid,starttime,duration,title,origtitle,shorttext,description,country,year,credits,category,review,rating,starrating,video,audio,season,episode,mixing,src,eiteventid,eitdescription,abs(starttime-1333368300) as diff from epg where  (starttime>=1333367400 and starttime<=1333369200) and title='Inspecteur Derrick' and channelid='FRA3.kazer.org'  order by diff,srcidx asc limit 1
Apr  2 14:15:15 lunatic vdr: [7249] xmltv2vdr: 'kazer' ERROR sqlite3: database is locked
Apr  2 14:15:15 lunatic vdr: [7249] xmltv2vdr: 'kazer' importing from db
Apr  2 14:15:15 lunatic vdr: [7249] xmltv2vdr importer thread ended (pid=6978, tid=7249)
Actions #1

Updated by Joe_D about 12 years ago

  • Status changed from New to Assigned
  • Target version changed from 0.1.0 to 0.1.1
  • % Done changed from 0 to 30
Actions #2

Updated by Joe_D about 12 years ago

  • % Done changed from 30 to 70

is it possible to get an feedback?

Actions #3

Updated by Joe_D about 12 years ago

  • Status changed from Assigned to Closed
  • % Done changed from 70 to 100

no feedback, so it just close it

Actions

Also available in: Atom PDF