[mythtv] frequent PlayBoxTransparency setting DB lookup in mythvideo

[Brad Fritz]

Using CVS from 8/15/04...

While experimenting with mythvideo this evening, I noticed that
after selecting "Browse Videos" there is a loop that runs this
query:

  SELECT data
  FROM settings
  WHERE value = 'PlayBoxTransparency'
  AND hostname = 'mythfe00'

continuously at a rate of several times per second.

  brad at boxer:~$ grep -c SELECT.*PlayBoxTransparency /var/log/mysql.log; \
  > sleep 30; \
  > grep -c SELECT.*PlayBoxTransparency /var/log/mysql.log
  15515
  15762


Are others seeing this behavior?  If so, is it a bug or a feature?
Here's a backtrace of the thread that seems to be causing it:

(gdb) thread
[Current thread is 1 (Thread 16384 (LWP 30324))]
(gdb) bt
#0  UIImageType::LoadImage (this=0x827ee30) at uitypes.cpp:1213
#1  0x422ac7e9 in VideoBrowser::updateInfo ()
   from /usr/lib/mythtv/plugins/libmythvideo.so
#2  0x422ab057 in VideoBrowser::paintEvent ()
   from /usr/lib/mythtv/plugins/libmythvideo.so
#3  0x40edd79e in QWidget::event () from /usr/lib/libqt-mt.so.3
#4  0x40e4abcf in QApplication::internalNotify () from /usr/lib/libqt-mt.so.3
#5  0x40e4a1ce in QApplication::notify () from /usr/lib/libqt-mt.so.3
#6  0x40e14777 in QWidget::repaint () from /usr/lib/libqt-mt.so.3
#7  0x40e4b9f5 in QApplication::sendPostedEvents () from /usr/lib/libqt-mt.so.3
#8  0x40e4b846 in QApplication::sendPostedEvents () from /usr/lib/libqt-mt.so.3
#9  0x40df387a in QEventLoop::processEvents () from /usr/lib/libqt-mt.so.3
#10 0x40e5cf28 in QEventLoop::enterLoop () from /usr/lib/libqt-mt.so.3
#11 0x40e4ae81 in QApplication::enter_loop () from /usr/lib/libqt-mt.so.3
#12 0x4097e27d in MythDialog::exec (this=0x828b288) at mythdialogs.cpp:822
#13 0x42289c7e in runVideoBrowser ()
   from /usr/lib/mythtv/plugins/libmythvideo.so
#14 0x40979d58 in MythMainWindow::ExitToMainMenu (this=0x82631e0)
    at mythdialogs.cpp:312
#15 0x4097d6df in MythMainWindow::customEvent (this=0x82631e0, ce=0x82bdcb8)
    at mythdialogs.cpp:581
#16 0x40ea4d1c in QObject::event () from /usr/lib/libqt-mt.so.3
#17 0x40edd5ef in QWidget::event () from /usr/lib/libqt-mt.so.3
#18 0x40e4abcf in QApplication::internalNotify () from /usr/lib/libqt-mt.so.3
#19 0x40e4a1ce in QApplication::notify () from /usr/lib/libqt-mt.so.3
#20 0x40e4b9c6 in QApplication::sendPostedEvents () from /usr/lib/libqt-mt.so.3
#21 0x40e4b846 in QApplication::sendPostedEvents () from /usr/lib/libqt-mt.so.3
#22 0x40df411d in QEventLoop::processEvents () from /usr/lib/libqt-mt.so.3
#23 0x40e5cf28 in QEventLoop::enterLoop () from /usr/lib/libqt-mt.so.3
#24 0x40e4ae81 in QApplication::enter_loop () from /usr/lib/libqt-mt.so.3
#25 0x4097e27d in MythDialog::exec (this=0x8298290) at mythdialogs.cpp:822
#26 0x0806347d in RunMenu (themedir=
      {static null = {static null = <same as static member of an already seen type>, d = 0x820dd60, static shared_null = 0x820dd60}, d = 0x8271ad0, static shared_null = 0x820dd60}) at main.cpp:542
#27 0x080676f2 in main (argc=1, argv=0x820dd60) at main.cpp:993
#28 0x4153ddc6 in __libc_start_main () from /lib/libc.so.6
#29 0x0805dad1 in _start () at ../sysdeps/i386/elf/start.S:102

--Brad

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20040816/e42420dc/attachment.pgp