Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#10520 closed Bug Report - General (fixed)

HLS transcode (and likely others) give NULL string db error

Reported by: beirdo Owned by: Chris Pinkham <cpinkham@…>
Priority: minor Milestone: 0.26
Component: MythTV - General Version: Master Head
Severity: low Keywords:
Cc: Ticket locked: no

Description

2012-03-27 19:15:28.759108 E [15286/15286] CoreContext mythdbcon.cpp:648 (exec) - Original query failed, but resend with empty strings in place of NULL strings worked. 
DB Error (MSqlQuery):
Query was:
INSERT INTO inuseprograms  (chanid,         starttime,  recusage,  hostname,   lastupdatetime, rechost,    recdir) VALUES  (?,       ?, ?, ?,   ?,   ?,   ?)
Bindings were:
:CHANID=0, :HOSTNAME="mythbe", :RECDIR="", :RECHOST=NULL, :RECUSAGE="transcoder",
:STARTTIME=2012-03-27T19:15:28, :UPDATETIME=2012-03-27T19:15:28
Driver error was [2/1048]:
QMYSQL3: Unable to execute statement
Database error was:
Column 'rechost' cannot be null

The program works as expected after trying again with "", essentially. A minor inconvenience that messes up the logs, not terribly important.

Change History (3)

comment:1 Changed 12 years ago by Chris Pinkham <cpinkham@…>

Owner: set to Chris Pinkham <cpinkham@…>
Resolution: fixed
Status: newclosed

In e7a6d7e1acd145fb9e7232ad3891b8bd5ce67f12/mythtv:

Squelch an inuseprograms DB warning during HLS transcode.

If the file's hostname isn't known when we go to insert into
inuseprograms, use our own hostname for the rechost column.

Closes #10520.

comment:2 Changed 12 years ago by Chris Pinkham <cpinkham@…>

In 09d9504694eab544f993c0caa8f79872311f1d89/mythtv:

Squelch an inuseprograms DB warning during HLS transcode.

If the file's hostname isn't known when we go to insert into
inuseprograms, use our own hostname for the rechost column.

References #10520. Carries over e7a6d7e from master.

comment:3 Changed 12 years ago by cpinkham

Milestone: unknown0.26
Note: See TracTickets for help on using tickets.