[mythtv] mythbackend 0.22-fixes problem with duplicate database connection name

[Roger James]

On 03/03/2010 13:39, Roger James wrote:
> On 02/03/2010 21:02, Jim Stichnoth wrote:
>> On Tue, Mar 2, 2010 at 11:35 AM, Roger James
>> <roger at beardandsandals.co.uk>  wrote:
>>> I think I will just apply your split of m_connID to my 0.22-fixes 
>>> source
>>> leaving out the rest of your patch and see what happens. It looks 
>>> pretty
>>> benign.
>> I think you would be safe applying the entire r23057 changeset
>> (http://svn.mythtv.org/trac/changeset/23057?format=diff&new=23057).
>> I'm not sure why it was never applied to 0.22-fixes.  As an added
>> benefit, those 5-second freeze-ups will go away.
>>
>> Jim
> I am a great believer in minimal changes. I will run with the small 
> fix for a week or so to see what happens and then try the full changeset.
>
> Thanks,
>
> Roger
Hmm, just had a crash in mythfilldatabase. I have had some crashes 
before, but not no one reported this way. I don't know if this is 
related to the change I just made.

/etc/cron.daily/mythtv-backend:
credits element: not writing empty content for actor at /usr/share/perl5/XMLTV.pm line 2110.
*** glibc detected *** mythfilldatabase: corrupted double-linked list: 0x098b50e0 ***
QMutex::lock: mutex lock failure:
======= Backtrace: =========
/lib/i686/cmov/libc.so.6[0xb51630d9]
/lib/i686/cmov/libc.so.6[0xb51643af]
/lib/i686/cmov/libc.so.6(cfree+0x96)[0xb5164826]
/usr/lib/libmysqlclient_r.so.15(my_no_flags_free+0x21)[0xb333eea1]
/usr/lib/libmysqlclient_r.so.15(vio_delete+0x30)[0xb336b1a0]
/usr/lib/libmysqlclient_r.so.15(end_server+0x35)[0xb3366ea5]
/usr/lib/libmysqlclient_r.so.15(mysql_close+0x8a)[0xb3366f5a]
/usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so[0xb34f6018]
/usr/lib/libQtSql.so.4(_ZN12QSqlDatabase5closeEv+0x16)[0xb5fedc06]
/usr/lib/libmythdb-0.22.so.0(_ZN12MSqlDatabaseD1Ev+0x39)[0xb64975e9]
======= Memory map: ========
08048000-080a1000 r-xp 00000000 08:25 241345     /usr/bin/mythfilldatabase
080a1000-080a2000 rw-p 00059000 08:25 241345     /usr/bin/mythfilldatabase
0981e000-0c90b000 rw-p 0981e000 00:00 0          [heap]
b1fff000-b2000000 ---p b1fff000 00:00 0
b2000000-b2800000 rwxp b2000000 00:00 0
b2800000-b2821000 rw-p b2800000 00:00 0
b2821000-b2900000 ---p b2821000 00:00 0
b2965000-b2a95000 r-xp 00000000 08:25 321472     /usr/lib/libdb-4.6.so
b2a95000-b2a98000 rw-p 00130000 08:25 321472     /usr/lib/libdb-4.6.so
b2a98000-b2aa2000 r-xp 00000000 08:21 76834      /lib/i686/cmov/libnss_files-2.7.so
b2aa2000-b2aa4000 rw-p 00009000 08:21 76834      /lib/i686/cmov/libnss_files-2.7.so
b2aa4000-b2aa8000 r-xp 00000000 08:25 322052     /usr/lib/libnss_db-2.2.3.so
b2aa8000-b2aa9000 rw-p 00004000 08:25 322052     /usr/lib/libnss_db-2.2.3.so
b2aa9000-b2aaa000 ---p b2aa9000 00:00 0
b2aaa000-b32aa000 rwxp b2aaa000 00:00 0
b32aa000-b32bf000 r-xp 00000000 08:21 76831      /lib/i686/cmov/libnsl-2.7.so
b32bf000-b32c1000 rw-p 00014000 08:21 76831      /lib/i686/cmov/libnsl-2.7.so
b32c1000-b32c3000 rw-p b32c1000 00:00 0
b32c3000-b32cc000 r-xp 00000000 08:21 76823      /lib/i686/cmov/libcrypt-2.7.so
b32cc000-b32ce000 rw-p 00008000 08:21 76823      /lib/i686/cmov/libcrypt-2.7.so
b32ce000-b32f5000 rw-p b32ce000 00:00 0
b32f5000-b349b000 r-xp 00000000 08:25 321856     /usr/lib/libmysqlclient_r.so.15.0.0
b349b000-b34df000 rw-p 001a5000 08:25 321856     /usr/lib/libmysqlclient_r.so.15.0.0
b34df000-b34e0000 rw-p b34df000 00:00 0
b34f0000-b34f1000 r--p 00000000 08:25 354892     /usr/share/locale/en_GB/LC_MESSAGES/libc.mo
b34f1000-b34ff000 r-xp 00000000 08:25 423134     /usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so
b34ff000-b3500000 rw-p 0000d000 08:25 423134     /usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so
b3500000-b3501000 rw-p b3500000 00:00 0
b3501000-b3507000 r--s 00000000 08:26 207289     /var/cache/fontconfig/945677eb7aeaf62f1d50efc3fb3ec7d8-x86.cache-2
b3507000-b350a000 r--s 00000000 08:26 207268     /var/cache/fontconfig/de156ccd2eddbdc19d37a45b8b2aac9c-x86.cache-2
b350a000-b3511000 r--s 00000000 08:26 207245     /var/cache/fontconfig/d52a8644073d54c13679302ca1180695-x86.cache-2
b3511000-b3567000 r--p 00000000 08:25 144587     /usr/lib/locale/locale-archive
b3567000-b356b000 rw-p b3567000 00:00 0
b356b000-b358f000 r-xp 00000000 08:25 321866     /usr/lib/libexpat.so.1.5.2
b358f000-b3591000 rw-p 00023000 08:25 321866     /usr/lib/libexpat.so.1.5.2
b3591000-b35b9000 r-xp 00000000 08:25 321303     /usr/lib/libpcre.so.3.12.1
b35b9000-b35ba000 rw-p 00027000 08:25 321303     /usr/lib/libpcre.so.3.12.1
b35ba000-b3606000 r-xp 00000000 08:25 322268     /usr/lib/libXt.so.6.0.0
b3606000-b3609000 rw-p 0004c000 08:25 322268     /usr/lib/libXt.so.6.0.0
b3609000-b360a000 rw-p b3609000 00:00 0
b360a000-b360e000 r-xp 00000000 08:25 322037     /usr/lib/libXdmcp.so.6.0.0
b360e000-b360f000 rw-p 00003000 08:25 322037     /usr/lib/libXdmcp.so.6.0.0
b360f000-b367c000 r-xp 00000000 08:25 322393     /usr/lib/libsqlite3.so.0.8.6
b367c000-b367e000 rw-p 0006c000 08:25 322393     /usr/lib/libsqlite3.so.0.8.6
b367e000-b367f000 rw-p b367e000 00:00 0
b367f000-b3686000 r-xp 00000000 08:21 76845      /lib/i686/cmov/librt-2.7.so
b3686000-b3688000 rw-p 00006000 08:21 76845      /lib/i686/cmov/librt-2.7.so
b3688000-b368c000 r-xp 00000000 08:25 321496     /usr/lib/libgthread-2.0.so.0.1600.6
b368c000-b368d000 rw-p 00003000 08:25 321496     /usr/lib/libgthread-2.0.so.0.1600.6
b368d000-b36b7000 r-xp 00000000 08:25 321301     /usr/lib/libfontconfig.so.1.3.0
b36b7000-b36b8000 rw-p 0002a000 08:25 321301     /usr/lib/libfontconfig.so.1.3.0
b36b8000-b36bf000 r-xp 00000000 08:25 322260     /usr/lib/libXi.so.6.0.0
b36bf000-b36c0000 rw-p 00007000 08:25 322260     /usr/lib/libXi.so.6.0.0
b36c0000-b3774000 r-xp 00000000 08:25 321904     /usr/lib/libglib-2.0.so.0.1600.6
b3774000-b3775000 rw-p 000b4000 08:25 321904     /usr/lib/libglib-2.0.so.0.1600.6
b3775000-b3776000 rw-p b3775000 00:00 0
b3776000-b378a000 r-xp 00000000 08:25 321414     /usr/lib/libICE.so.6.3.0
b378a000-b378b000 rw-p 00014000 08:25 321414     /usr/lib/libICE.so.6.3.0
b378b000-b378d000 rw-p b378b000 00:00 0
b378d000-b3794000 r-xp 00000000 08:25 322264     /usr/lib/libSM.so.6.0.0
b3794000-b3795000 rw-p 00006000 08:25 322264     /usr/lib/libSM.so.6.0.0
b3795000-b37b8000 r-xp 00000000 08:25 321584     /usr/lib/libpng12.so.0.27.0
b37b8000-b37b9000 rw-p 00023000 08:25 321584     /usr/lib/libpng12.so.0.27.0
b37b9000-b37ce000 r-xp 00000000 08:25 321642     /usr/lib/libaudio.so.2.4
b37ce000-b37cf000 rw-p 00015000 08:25 321642     /usr/lib/libaudio.so.2.4
b37cf000-b37d0000 r-xp 00000000 08:25 353656     /usr/lib/tls/libnvidia-tls.so.185.18.36
b37d0000-b37d1000 rw-p 00000000 08:25 353656     /usr/lib/tls/libnvidia-tls.so.185.18.36
b37d1000-b37d2000 rw-p b37d1000 00:00 0
b37d2000-b4541000 r-xp 00000000 08:25 321484     /usr/lib/libGLcore.so.185.18.36
b4541000-b472e000 rwxp 00d6e000 08:25 321484     /usr/lib/libGLcore.so.185.18.36
b472e000-b473b000 rwxp b472e000 00:00 0
b473b000-b4743000 r-xp 00000000 08:25 322087     /usr/lib/libXrender.so.1.3.0
b4743000-b4744000 rw-p 00007000 08:25 322087     /usr/lib/libXrender.so.1.3.0
b4744000-b4746000 r-xp 00000000 08:25 322023     /usr/lib/libXau.so.6.0.0
b4746000-b4747000 rw-p 00001000 08:25 322023     /usr/lib/libXau.so.6.0.0
b4747000-b475e000 r-xp 00000000 08:25 322039     /usr/lib/libxcb.so.1.0.0
b475e000-b475f000 rw-p 00017000 08:25 322039     /usr/lib/libxcb.so.1.0.0
b475f000-b4760000 r-xp 00000000 08:25 322043     /usr/lib/libxcb-xlib.so.0.0.0
b4760000-b4761000 rw-p 00000000 08:25 322043     /usr/lib/libxcb-xlib.so.0.0.0
b4761000-b4762000 rw-p b4761000 00:00 0
b4762000-b47d6000 r-xp 00000000 08:25 322564     /usr/lib/libQtOpenGL.so.4.4.3
b47d6000-b47db000 rw-p 00073000 08:25 322564     /usr/lib/libQtOpenGL.so.4.4.3
b47db000-b4fee000 r-xp 00000000 08:25 322477     /usr/lib/libQtWebKit.so.4.4.3
b4fee000-b506f000 rw-p 00813000 08:25 322477     /usr/lib/libQtWebKit.so.4.4.3
b506f000-b5078000 rw-p b506f000 00:00 0
b5078000-b5079000 r-xp 00000000 08:25 321509     /usr/lib/libvdpau.so.185.18.36
b5079000-b507a000 rw-p 00000000 08:25 321509     /usr/lib/libvdpau.so.185.18.36
b507a000-b507b000 rw-p b507a000 00:00 0
b507b000-b507d000 r-xp 00000000 08:21 76825      /lib/i686/cmov/libdl-2.7.so
b507d000-b507f000 rw-p 00001000 08:21 76825      /lib/i686/cmov/libdl-2.7.so
b507f000-b50c1000 r-xp 00000000 08:25 321987     /usr/lib/libmp3lame.so.0.0.0
b50c1000-b50c3000 rw-p 00042000 08:25 321987     /usr/lib/libmp3lame.so.0.0.0
b50c3000-b50f4000 rw-p b50c3000 00:00 0
b50f4000-b5249000 r-xp 00000000 08:21 76782      /lib/i686/cmov/libc-2.7.so
b5249000-b524a000 r--p 00155000 08:21 76782      /lib/i686/cmov/libc-2.7.so
b524a000-b524c000 rw-p 00156000 08:21 76782      /lib/i686/cmov/libc-2.7.so
b524c000-b524f000 rw-p b524c000 00:00 0
b524f000-b525b000 r-xp 00000000 08:21 76342      /lib/libgcc_s.so.1
b525b000-b525c000 rw-p 0000b000 08:21 76342      /lib/libgcc_s.so.1
b525c000-b5280000 r-xp 00000000 08:21 76828      /lib/i686/cmov/libm-2.7.so
b5280000-b5282000 rw-p 00023000 08:21 76828      /lib/i686/cmov/libm-2.7.so
b5282000-b5365000 r-xp 00000000 08:25 321318     /usr/lib/libstdc++.so.6.0.10
b5365000-b5368000 r--p 000e2000 08:25 321318     /usr/lib/libstdc++.so.6.0.10
b5368000-b536a000 rw-p 000e5000 08:25 321318     /usr/lib/libstdc++.so.6.0.10
b536a000-b5371000 rw-p b536a000 00:00 0
b5371000-b5595000 r-xp 00000000 08:25 322002     /usr/lib/libQtCore.so.4.4.3
b5595000-b559d000 rw-p 00223000 08:25 322002     /usr/lib/libQtCore.so.4.4.3
b559d000-b5698000 r-xp 00000000 08:25 322217     /usr/lib/libQtNetwork.so.4.4.3
b5698000-b569c000 rw-p 000fa000 08:25 322217     /usr/lib/libQtNetwork.so.4.4.3
b569c000-b5f75000 r-xp 00000000 08:25 322439     /usr/lib/libQtGui.so.4.4.3
b5f75000-b5f9a000 rw-p 008d8000 08:25 322439     /usr/lib/libQtGui.so.4.4.3
b5f9a000-b5f9b000 rw-p b5f9a000 00:00 0
b5f9b000-b5fdc000 r-xp 00000000 08:25 322300     /usr/lib/libQtXml.so.4.4.3
b5fdc000-b5fde000 rw-p 00041000 08:25 322300     /usr/lib/libQtXml.so.4.4.3
b5fde000-b6018000 r-xp 00000000 08:25 322463     /usr/lib/libQtSql.so.4.4.3
b6018000-b6019000 rw-p 0003a000 08:25 322463     /usr/lib/libQtSql.so.4.4.3
b6019000-b6099000 r-xp 00000000 08:25 321469     /usr/lib/libGL.so.185.18.36
b6099000-b60b1000 rwxp 0007f000 08:25 321469     /usr/lib/libGL.so.185.18.36
b60b1000-b60c0000 rwxp b60b1000 00:00 0
b60c0000-b60c1000 rw-p b60c0000 00:00 0
b60c1000-b6142000 r-xp 00000000 08:25 321500     /usr/lib/libGLU.so.1.3.070004
b6142000-b6143000 rw-p 00081000 08:25 321500     /usr/lib/libGLU.so.1.3.070004
b6143000-b6158000 r-xp 00000000 08:21 76842      /lib/i686/cmov/libpthread-2.7.so
b6158000-b615a000 rw-p 00014000 08:21 76842      /lib/i686/cmov/libpthread-2.7.so
b615a000-b615c000 rw-p b615a000 00:00 0
b615c000-b615f000 r-xp 00000000 08:25 322755     /usr/lib/libXvMC.so.1.0.0
b615f000-b6160000 rw-p 00002000 08:25 322755     /usr/lib/libXvMC.so.1.0.0
b6160000-b6164000 r-xp 00000000 08:25 322757     /usr/lib/libXvMCW.so.1.0.0
b6164000-b6165000 rw-p 00003000 08:25 322757     /usr/lib/libXvMCW.so.1.0.0
b6165000-b616a000 r-xp 00000000 08:25 322301     /usr/lib/libXrandr.so.2.1.0
b616a000-b616b000 rw-p 00005000 08:25 322301     /usr/lib/libXrandr.so.2.1.0
b616b000-b616f000 r-xp 00000000 08:25 322684     /usr/lib/libXv.so.1.0.0
b616f000-b6170000 rw-p 00003000 08:25 322684     /usr/lib/libXv.so.1.0.0
b6170000-b6171000 rw-p b6170000 00:00 0
b6171000-b6175000 r-xp 00000000 08:25 322419     /usr/lib/libXxf86vm.so.1.0.0
b6175000-b6176000 rw-p 00003000 08:25 322419     /usr/lib/libXxf86vm.so.1.0.0
b6176000-b6183000 r-xp 00000000 08:25 322256     /usr/lib/libXext.so.6.4.0
b6183000-b6184000 rw-p 0000c000 08:25 322256     /usr/lib/libXext.so.6.4.0
b6184000-b626f000 r-xp 00000000 08:25 322055     /usr/lib/libX11.so.6.2.0
b626f000-b6273000 rw-p 000ea000 08:25 322055     /usr/lib/libX11.so.6.2.0
b6273000-b6275000 r-xp 00000000 08:25 322294     /usr/lib/libXinerama.so.1.0.0
b6275000-b6276000 rw-p 00001000 08:25 322294     /usr/lib/libXinerama.so.1.0.0
b6276000-b628a000 r-xp 00000000 08:25 321761     /usr/lib/libz.so.1.2.3.3
b628a000-b628b000 rw-p 00013000 08:25 321761     /usr/lib/libz.so.1.2.3.3
b628b000-b62fc000 r-xp 00000000 08:25 321934     /usr/lib/libfreetype.so.6.3.18
b62fc000-b6300000 rw-p 00070000 08:25 321934     /usr/lib/libfreetype.so.6.3.18
b6300000-b6301000 rw-p b6300000 00:00 0
b6301000-b630e000 r-xp 00000000 08:25 321393     /usr/lib/libmythhdhomerun-0.22.so.0.22.0
b630e000-b630f000 rw-p 0000c000 08:25 321393     /usr/lib/libmythhdhomerun-0.22.so.0.22.0
b630f000-b6390000 r-xp 00000000 08:25 321359     /usr/lib/libmythfreemheg-0.22.so.0.22.0
b6390000-b6397000 rw-p 00081000 08:25 321359     /usr/lib/libmythfreemheg-0.22.so.0.22.0
b6397000-b6453000 r-xp 00000000 08:25 321384     /usr/lib/libmythlivemedia-0.22.so.0.22.0
b6453000-b645e000 rw-p 000bb000 08:25 321384     /usr/lib/libmythlivemedia-0.22.so.0.22.0
b645e000-b646b000 rw-p b645e000 00:00 0
b646b000-b6504000 r-xp 00000000 08:25 321958     /usr/lib/libmythdb-0.22.so.0.22.0
b6504000-b6506000 rw-p 00098000 08:25 321958     /usr/lib/libmythdb-0.22.so.0.22.0
b6506000-b668c000 r-xp 00000000 08:25 321419     /usr/lib/libmythui-0.22.so.0.22.0
b668c000-b6692000 rw-p 00186000 08:25 321419     /usr/lib/libmythui-0.22.so.0.22.0
b6692000-b6693000 rw-p b6692000 00:00 0
b6693000-b697d000 r-xp 00000000 08:25 321560     /usr/lib/libmyth-0.22.so.0.22.0
b697d000-b6987000 rw-p 002ea000 08:25 321560     /usr/lib/libmyth-0.22.so.0.22.0
b6987000-b6a37000 r-xp 00000000 08:25 321432     /usr/lib/libmythupnp-0.22.so.0.22.0
b6a37000-b6a39000 rw-p 000af000 08:25 321432     /usr/lib/libmythupnp-0.22.so.0.22.0
b6a39000-b6a72000 r-xp 00000000 08:25 321718     /usr/lib/libmythswscale-0.22.so.0.22.0
b6a72000-b6a73000 rw-p 00039000 08:25 321718     /usr/lib/libmythswscale-0.22.so.0.22.0
b6a73000-b6f5a000 r-xp 00000000 08:25 321426     /usr/lib/libmythavcodec-0.22.so.0.22.0
b6f5a000-b6f64000 rw-p 004e7000 08:25 321426     /usr/lib/libmythavcodec-0.22.so.0.22.0
b6f64000-b7386000 rw-p b6f64000 00:00 0
b7386000-b7394000 r-xp 00000000 08:25 322910     /usr/lib/libmythavutil-0.22.so.0.22.0
b7394000-b7395000 rw-p 0000e000 08:25 322910     /usr/lib/libmythavutil-0.22.so.0.22.0
b7395000-b7399000 rw-p b7395000 00:00 0
b7399000-b7448000 r-xp 00000000 08:25 321653     /usr/lib/libmythavformat-0.22.so.0.22.0
b7448000-b7452000 rw-p 000af000 08:25 321653     /usr/lib/libmythavformat-0.22.so.0.22.0
b7452000-b74a2000 rw-p b7452000 00:00 0
b74a2000-b7f1c000 r-xp 00000000 08:25 322866     /usr/lib/libmythtv-0.22.so.0.22.0
b7f1c000-b7f4c000 rw-p 00a7a000 08:25 322866     /usr/lib/libmythtv-0.22.so.0.22.0
b7f4c000-b7f51000 rw-p b7f4c000 00:00 0
b7f51000-b7f52000 r-xp 00000000 08:25 482704     /usr/lib/gconv/ISO8859-1.so
b7f52000-b7f54000 rw-p 00001000 08:25 482704     /usr/lib/gconv/ISO8859-1.so
b7f54000-b7f56000 r-xp 00000000 08:25 483001     /usr/lib/gconv/UTF-16.so
b7f56000-b7f58000 rw-p 00001000 08:25 483001     /usr/lib/gconv/UTF-16.so
b7f58000-b7f5f000 r--s 00000000 08:25 481985     /usr/lib/gconv/gconv-modules.cache
b7f5f000-b7f60000 rw-p b7f5f000 00:00 0
b7f60000-b7f62000 rwxp 00000000 00:0d 1065       /dev/zero
b7f62000-b7f64000 rw-p b7f62000 00:00 0
b7f64000-b7f65000 r-xp b7f64000 00:00 0          [vdso]
b7f65000-b7f7f000 r-xp 00000000 08:21 76379      /lib/ld-2.7.so
b7f7f000-b7f81000 rw-p 0001a000 08:21 76379      /lib/ld-2.7.so
bfe92000-bfea6000 rwxp bffeb000 00:00 0          [stack]
bfea6000-bfea7000 rw-p bffff000 00:00 0
run-parts: /etc/cron.daily/mythtv-backend exited with return code 134

Any ideas anyone.

On the positive side I have not seen any repeats of the duplicate database connection name problem yet.

Roger