linux-traipu team mailing list archive

[Obleak <802339@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I've noticed some settings are getting duplicated in the settings table.
While most have the same setting, some do not. (SecurityPin, TruncateDeletesSlowly)
I noticed this when auto-enabling a user job (since I can't find the option in settings????)

This is what happens when tables don't have a primary key...

SELECT Count(*)  As Number, MAX(value),GROUP_CONCAT(data)
FROM settings
GROUP BY value,hostname
HAVING Number > 1

returns

Number 	MAX(value) 	GROUP_CONCAT(data)
2 	BackendServerIP 	127.0.0.1,127.0.0.1
2 	BackendServerPort 	6543,6543
2 	BackendStatusPort 	6544,6544
2 	DisableFirewireReset 	0,0
2 	JobAllowCommFlag 	1,1
2 	JobAllowTranscode 	1,1
2 	JobAllowUserJob1 	1,1
2 	JobAllowUserJob2 	0,0
2 	JobAllowUserJob3 	0,0
2 	JobAllowUserJob4 	0,0
2 	JobQueueCheckFrequency 	60,60
2 	JobQueueCPU 	1,1
2 	JobQueueMaxSimultaneousJobs 	2,2
2 	JobQueueWindowEnd 	23:59,23:59
2 	JobQueueWindowStart 	00:00,00:00
2 	MiscStatusScript 	,
2 	MythFillFixProgramIDsHasRunOnce 	1,1
2 	SecurityPin 	0000,
2 	TruncateDeletesSlowly 	1,0

** Affects: mythbuntu
     Importance: Undecided
         Status: New

** Description changed:

  I've noticed some settings are getting duplicated in the settings table.
- While most have the same seeing, some do not. (SecurityPin, TruncateDeletesSlowly)
+ While most have the same setting, some do not. (SecurityPin, TruncateDeletesSlowly)
  I noticed this when auto-enabling a user job (since I can't find the option in settings????)
  
  This is what happens when tables don't have a primary key...
-  
  
  SELECT Count(*)  As Number, MAX(value),GROUP_CONCAT(data)
  FROM settings
  GROUP BY value,hostname
  HAVING Number > 1
  
  returns
  
  Number 	MAX(value) 	GROUP_CONCAT(data)
  2 	BackendServerIP 	127.0.0.1,127.0.0.1
  2 	BackendServerPort 	6543,6543
  2 	BackendStatusPort 	6544,6544
  2 	DisableFirewireReset 	0,0
  2 	JobAllowCommFlag 	1,1
  2 	JobAllowTranscode 	1,1
  2 	JobAllowUserJob1 	1,1
  2 	JobAllowUserJob2 	0,0
  2 	JobAllowUserJob3 	0,0
  2 	JobAllowUserJob4 	0,0
  2 	JobQueueCheckFrequency 	60,60
  2 	JobQueueCPU 	1,1
  2 	JobQueueMaxSimultaneousJobs 	2,2
  2 	JobQueueWindowEnd 	23:59,23:59
  2 	JobQueueWindowStart 	00:00,00:00
  2 	MiscStatusScript 	,
  2 	MythFillFixProgramIDsHasRunOnce 	1,1
  2 	SecurityPin 	0000,
  2 	TruncateDeletesSlowly 	1,0

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Mythbuntu.
https://bugs.launchpad.net/bugs/802339

Title:
  Multiple setting definitions in mythconverg.settings

Status in Mythbuntu, Ubuntu derivative focused upon MythTV:
  New

Bug description:
  I've noticed some settings are getting duplicated in the settings table.
  While most have the same setting, some do not. (SecurityPin, TruncateDeletesSlowly)
  I noticed this when auto-enabling a user job (since I can't find the option in settings????)

  This is what happens when tables don't have a primary key...

  SELECT Count(*)  As Number, MAX(value),GROUP_CONCAT(data)
  FROM settings
  GROUP BY value,hostname
  HAVING Number > 1

  returns

  Number 	MAX(value) 	GROUP_CONCAT(data)
  2 	BackendServerIP 	127.0.0.1,127.0.0.1
  2 	BackendServerPort 	6543,6543
  2 	BackendStatusPort 	6544,6544
  2 	DisableFirewireReset 	0,0
  2 	JobAllowCommFlag 	1,1
  2 	JobAllowTranscode 	1,1
  2 	JobAllowUserJob1 	1,1
  2 	JobAllowUserJob2 	0,0
  2 	JobAllowUserJob3 	0,0
  2 	JobAllowUserJob4 	0,0
  2 	JobQueueCheckFrequency 	60,60
  2 	JobQueueCPU 	1,1
  2 	JobQueueMaxSimultaneousJobs 	2,2
  2 	JobQueueWindowEnd 	23:59,23:59
  2 	JobQueueWindowStart 	00:00,00:00
  2 	MiscStatusScript 	,
  2 	MythFillFixProgramIDsHasRunOnce 	1,1
  2 	SecurityPin 	0000,
  2 	TruncateDeletesSlowly 	1,0

To manage notifications about this bug go to:
https://bugs.launchpad.net/mythbuntu/+bug/802339/+subscriptions