View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 8 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Fri Jan 06, 2012 9:07 am 
Offline
Joined: Tue Dec 20, 2005 1:21 pm
Posts: 12
Location: Northern Virginia
After a recent pacman -Syu which included a lircd upgrade something weird happened. Something that happened once before, but it was in the fog of a major upgrade, so I didn't pursue the issue further.

My settings table is overrun by lircd as if there was a greedy sql update somewhere in an upgrade script. Here's a sample of what I mean:

Code:
+----------------------------------------------------+---------------------+-----------+
| value                                              | data                | hostname  |
+----------------------------------------------------+---------------------+-----------+
| StereoPCM                                          | /var/run/lirc/lircd | specticle |
| LCDHeartBeatOn                                     | /var/run/lirc/lircd | specticle |
| LCDShowGeneric                                     | /var/run/lirc/lircd | specticle |
| TVVidModeResolution0                               | /var/run/lirc/lircd | specticle |
| UseVideoModes                                      | /var/run/lirc/lircd | specticle |
| UseFixedWindowSize                                 | /var/run/lirc/lircd | specticle |
| RunFrontendInWindow                                | /var/run/lirc/lircd | specticle |
| GuiSizeForTV                                       | /var/run/lirc/lircd | specticle |
| ThemePainter                                       | /var/run/lirc/lircd | specticle |
| SelChangeRecThreshold                              | /var/run/lirc/lircd | specticle |
| WatchTVGuide                                       | /var/run/lirc/lircd | specticle |
| EPGShowCategoryColors                              | /var/run/lirc/lircd | specticle |
| BrowseChannelGroup                                 | /var/run/lirc/lircd | specticle |
| ChannelOrdering                                    | /var/run/lirc/lircd | specticle |
| SubtitleCodec                                      | /var/run/lirc/lircd | specticle |
| OSDCC708TextZoom                                   | /var/run/lirc/lircd | specticle |
| OSDSubFont                                         | /var/run/lirc/lircd | specticle |
| Prefer708Captions                                  | /var/run/lirc/lircd | specticle |
| DefaultCCMode                                      | /var/run/lirc/lircd | specticle |
| BrowseAllTuners                                    | /var/run/lirc/lircd | specticle |
| EnableMHEG                                         | /var/run/lirc/lircd | specticle |
| ExactSeeking                                       | /var/run/lirc/lircd | specticle |
| FFRewReposTime                                     | /var/run/lirc/lircd | specticle |
| SmartForward                                       | /var/run/lirc/lircd | specticle |
| PlaybackWLBlackOut                                 | /var/run/lirc/lircd | specticle |
| PlaybackWLMaxAge                                   | /var/run/lirc/lircd | specticle |
| PlaybackWLStart                                    | /var/run/lirc/lircd | specticle |
| DisplayGroupTitleSort                              | /var/run/lirc/lircd | specticle |
| DispRecGroupAsAllProg                              | /var/run/lirc/lircd | specticle |
| RememberRecGroup                                   | /var/run/lirc/lircd | specticle |
| QueryInitialFilter                                 | /var/run/lirc/lircd | specticle |
| PIPLocation                                        | /var/run/lirc/lircd | specticle |
| AdjustFill                                         | /var/run/lirc/lircd | specticle |
| AspectOverride                                     | /var/run/lirc/lircd | specticle |
...


Of course some time in the dark ages of limited hdd space, I turned off database backups, so I'll have to fix it manually. That's fine, this is free, but I'd like to help contribute to a more permanent solution. Anyone else experienced this, or familiar enough with the Arch package system to know where to look?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 06, 2012 9:59 am 
Offline
Site Admin
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
my guess is it's the lirc.install script that did it.
http://linhes.org/bugs/projects/linhes/ ... rc.install

The post_upgrade section of the script will be run everytime the lircd package is updated via pacman.
Whats it's attempting todo is update the location of the lircd socket, but obviously something went wrong.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 06, 2012 10:10 am 
Offline
Site Admin
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
From the look of it, the update setting needs a 2nd where clause.
Otherwise it will do exactly as you saw and update all the settings for that host


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 06, 2012 10:40 am 
Offline
Joined: Tue Dec 20, 2005 1:21 pm
Posts: 12
Location: Northern Virginia
Hah. Ok, yeah that's a pretty simple bug once you pointed out where to look.

Code:
"UPDATE settings SET data = '/var/run/lirc/lircd' WHERE hostname = '${hostname}';"


needs to change to

Code:
"UPDATE settings SET data = '/var/run/lirc/lircd' WHERE value='LircSocket' and hostname = '${hostname}';"


I'm wondering why this hasn't affected lots of other people yet?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 06, 2012 10:43 am 
Offline
Joined: Tue Dec 20, 2005 1:21 pm
Posts: 12
Location: Northern Virginia
I'll be happy to file a bug/patch or commit the change to git if given a writable git url. Guess I should see how to go about creating a repo account before blabbing in the forums.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 06, 2012 11:15 am 
Offline
Site Admin
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
I would create a bug at linhes.org/bugs and someone will apply the change.

Write access to the linhes repo is limited, but read access is not.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 06, 2012 11:47 am 
Offline
Joined: Tue Dec 20, 2005 1:21 pm
Posts: 12
Location: Northern Virginia
Filed Bug #810.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jan 06, 2012 12:36 pm 
Offline
Site Admin
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
Thanks nebulous.

lircd has been updated in both testing and release.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu