[mythtv] mythbackend core dumps first time it schedules after upgrade

[Tony Lill]

Just built 0.18 from last night's cvs. When I run the backend for the
first time, it updates the database correctly from 0.16 (or so it
claims), but core dumps the first time it runs the scheduler. This is
on RedHat 9 (mysql-3.23.58-1.9 and qt-3.1.1-6)

Help!!!

Here's the backtrace

#0  0x4214bb97 in mysql_num_rows () from /usr/lib/mysql/libmysqlclient.so.10
#1  0x413546d2 in QSqlQuery::size() const () from /usr/lib/qt-3.1/lib/libqt-mt.so.3
#2  0x080b5561 in Scheduler::UpdateMatches(int) ()
#3  0x080ae5d2 in Scheduler::RunScheduler() ()
#4  0x080b0f4f in Scheduler::SchedulerThread(void*) ()

Here's the last bit of the log file

2005-04-16 15:20:47.376 New DB scheduler connection
dtv is defined, but isn't attached to a cardinput.
2005-04-16 15:20:47.404 JobQueue::RecoverQueue: Checking for unfinished jobs to recover.
2005-04-16 15:20:47.406 JobQueue::GetJobsInQueue: findJobs search bitmask 4, found 0 total jobs
2005-04-16 15:20:47.421 mythbackend version: 0.18.20050409-1 www.mythtv.org
2005-04-16 15:20:47.424 Enabled verbose msgs :all
2005-04-16 15:20:49.411 Reschedule requested for id -1.
Query 0: /record.search = 0 AND (record.recordid = -1 OR -1 = -1) AND program.manualid = 0 AND program.title = record.title 
2005-04-16 15:20:49.690  |-- Start DB Query 0...
2005-04-16 15:20:49.690  |-- Full DB Query INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime,  IF(search = 5, recordid, 0) FROM record, program  INNER JOIN channel ON (channel.chanid = program.chanid) WHERE record.search = 0 AND (record.recordid = -1 OR -1 = -1) AND program.manualid = 0 AND program.title = record.title  AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10)  OR  ((record.station = channel.callsign)   AND   ((record.type = 3)    OR   ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime))     AND     ((record.type = 2)      OR     ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime)       AND       ((record.type = 5)        OR       ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))         AND         (TIME_TO_SEC(record.endtime) = TIME_TO_SEC(program.endtime))         AND         (TO_DAYS(record.enddate) = TO_DAYS(program.endtime))     !
    )       )      )     )    )   )  ) )) ...

when I ran this query manually, I got

mysql> INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime,  IF(search = 5, recordid, 0) FROM record, program  INNER JOIN channel ON (channel.chanid = program.chanid) WHERE record.search = 0 AND (record.recordid = -1 OR -1 = -1) AND program.manualid = 0 AND program.title = record.title  AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10)  OR  ((record.station = channel.callsign)   AND   ((record.type = 3)    OR   ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime))     AND     ((record.type = 2)      OR     ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime)       AND       ((record.type = 5)        OR       ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))         AND         (TIME_TO_SEC(record.endtime) = TIME_TO_SEC(program.endtime))         AND         (TO_DAYS(record.enddate) = TO_DAYS(program.endtime))         )       )      )     )    )   ) !
 ) ));
Query OK, 3735 rows affected (0.11 sec)
Records: 3735  Duplicates: 0  Warnings: 0

and my config.mak

# Automatically generated by configure - do not modify
PREFIX=/usr/local
QMAKE_CC=gcc
QMAKE_CXX=g++
ARCHFLAGS=-march=pentiumpro
PROFILEFLAGS=
OPTFLAGS=-O3 -Wall -Wno-switch 
ECFLAGS=
ECXXFLAGS=
TARGET_OS=Linux
TARGET_ARCH_X86=yes
TARGET_MMX=yes
HAVE_FREETYPE2=yes

CONFIG_ENCODERS=yes
CONFIG_DECODERS=yes
CONFIG_AC3=yes
CONFIG_PP=yes
CONFIG_VIDEO4LINUX=yes
CONFIG_AUDIO_ALSA_LIBS=-lasound
CONFIG_NETWORK=yes
CONFIG_ZLIB=yes
CONFIG_RISKY=yes
CONFIG_GPL=yes
SRC_PATH='/home/ajlill/src/mythtv'
CONFIG_LIRC_LIBS=-llirc_client
CONFIG_XV_LIBS=-lXinerama -lXv -lX11 -lXext -lXxf86vm -lXrandr
CCONFIG= linux backend release using_oss using_alsa using_ivtv using_lirc using_joystick_menu using_x11 using_xv using_xrandr
CONFIG_DEFINES= MMX USING_IVTV USING_XRANDR