Modify
Warning Please read the Ticket HowTo before creating or commenting on a ticket. Failure to do so may cause your ticket to be rejected or result in a slower response.

Opened 2 years ago

Closed 22 months ago

Last modified 22 months 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.

Attachments (0)

Change History (3)

comment:1 Changed 22 months ago by Chris Pinkham <cpinkham@…>

  • Owner set to Chris Pinkham <cpinkham@…>
  • Resolution set to fixed
  • Status changed from new to closed

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 22 months 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 22 months ago by cpinkham

  • Milestone changed from unknown to 0.26

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'new'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.