[Bug 634995] [NEW] Wrong INDEX in MySQL database causes mysql_query errors

[Oliver Rompcik]

Public bug reported:

Binary package hint: ndoutils-nagios3-mysql

After connection to the database, /var/log/messages reports a problem
with the database:

ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables 
SET instance_id='1', configfile_id='1', varname='cfg_file', 
varvalue='/etc/nagios3/objects/printer\.cfg''
...
ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables 
SET instance_id='1', configfile_id='1', varname='cfg_file', 
varvalue='/etc/nagios3/objects/windows\.cfg''

This is due to a wrong uniqueness in the DB, a new INDEX eliminates the
Problem:

ALTER TABLE nagios_configfilevariables DROP INDEX instance_id;
ALTER TABLE nagios_configfilevariables ADD INDEX instance_id (instance_id, 
configfile_id, varname);

Bug seems to originate from source 1.4b7, later Versions of ndoutils
(1.4b8 and 1.4b9) seem not to be affected.

** Affects: ndoutils (Ubuntu)
 Importance: Undecided
 Status: New


** Tags: lucid lynx

-- 
Wrong INDEX in MySQL database causes mysql_query errors
https://bugs.launchpad.net/bugs/634995
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 246625] Re: libc6-xen not used by dynamic linker

[Oliver Rompcik]

I can confirm this bug. It does only apply to the i386 platform, as amd64 
doesn't use libc6-xen at all.
Seems hwcap isn't exported the right way.

Removing /lib/tls is not a preferable solution to this problem, this has
been discussed several times. It leads to a very poor performance for
threaded applications. The correct way is to find the bug, which may
hide somewhere in the vdso-code...(?)

Seems this bug has already been detected during hardy-beta and it is not
fixed until now. You should think about renaming LTS to LTB (Long Term
Bugs)...

-- 
libc6-xen not used by dynamic linker
https://bugs.launchpad.net/bugs/246625
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs