wiki:TracQuery

Trac Ticket Queries

In addition to reports, Trac provides support for custom ticket queries, which can be used to display tickets that meet specified criteria.

To configure and execute a custom query, switch to the View Tickets module from the navigation bar, and select the Custom Query link.

Filters

When you first go to the query page, the default filter will display tickets relevant to you:

  • If logged in then all open tickets, it will display open tickets assigned to you.
  • If not logged in but you have specified a name or email address in the preferences, then it will display all open tickets where your email (or name if email not defined) is in the CC list.
  • If not logged in and no name/email is defined in the preferences, then all open issues are displayed.

Current filters can be removed by clicking the button to the left with the minus sign on the label. New filters are added from the dropdown lists at the bottom corners of the filters box; 'And' conditions on the left, 'Or' conditions on the right. Filters with either a text box or a dropdown menu of options can be added multiple times to perform an Or on the criteria.

For text fields such as Keywords and CC the - operator can be used to negate a match and double quotes (since 1.2.1) can be used to match a phrase. For example, a contains match for word1 word2 -word3 "word4 word5" matches tickets containing word1 and word2, not word3 and word4 word5.

You can use the fields just below the filters box to group the results based on a field, or display the full description for each ticket.

After you have edited your filters, click the Update button to refresh your results.

Keyboard shortcuts are available for manipulating the checkbox filters:

  • Clicking on a filter row label toggles all checkboxes.
  • Pressing the modifier key while clicking on a filter row label inverts the state of all checkboxes.
  • Pressing the modifier key while clicking on a checkbox selects the checkbox and deselects all other checkboxes in the filter. Since 1.2.1 this also works for the Columns checkboxes.

The modifier key is platform and browser dependent. On Mac the modified key is Option/Alt or Command. On Linux the modifier key is Ctrl + Alt. Opera on Windows seems to use Ctrl + Alt, while Alt is effective for other Windows browsers.

Clicking on one of the query results will take you to that ticket. You can navigate through the results by clicking the Next Ticket or Previous Ticket links just below the main menu bar, or click the Back to Query link to return to the query page.

You can safely edit any of the tickets and continue to navigate through the results using the Next/Previous/Back to Query links after saving your results. When you return to the query any tickets which were edited will be displayed with italicized text. If one of the tickets was edited such that it no longer matches the query criteria , the text will also be greyed. Lastly, if a new ticket matching the query criteria has been created, it will be shown in bold.

The query results can be refreshed and cleared of these status indicators by clicking the Update button again.

Saving Queries

Trac allows you to save the query as a named query accessible from the reports module. To save a query ensure that you have Updated the view and then click the Save query button displayed beneath the results. You can also save references to queries in Wiki content, as described below.

Note: one way to easily build queries like the ones below, you can build and test the queries in the Custom report module and when ready - click Save query. This will build the query string for you. All you need to do is remove the extra line breaks.

Note: you must have the REPORT_CREATE permission in order to save queries to the list of default reports. The Save query button will only appear if you are logged in as a user that has been granted this permission. If your account does not have permission to create reports, you can still use the methods below to save a query.

You may want to save some queries so that you can come back to them later. You can do this by making a link to the query from any Wiki page.

[query:status=new|assigned|reopened&version=1.0 Active tickets against 1.0]

Which is displayed as:

Active tickets against 1.0

This uses a very simple query language to specify the criteria, see Query Language.

Alternatively, you can copy the query string of a query and paste that into the Wiki link, including the leading ? character:

[query:?status=new&status=assigned&status=reopened&group=owner Assigned tickets by owner]

Which is displayed as:

Assigned tickets by owner

Customizing the table format

You can also customize the columns displayed in the table format (format=table) by using col=<field>. You can specify multiple fields and what order they are displayed in by placing pipes (|) between the columns:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter)]]

This is displayed as:

Results (1 - 3 of 12888)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#13501 fixed "Schedule As Group" not selected by default Peter Bennett Klaas de Waal
#13498 Duplicate Mythtv Frontend core dumping Fedora 31 dhighley
#13495 Fixed Fix thetvdb Specials mspieth patrickdk77
1 2 3 4 5 6 7 8 9 10 11

Full rows

In table format you can also have full rows by using rows=<field>:

[[TicketQuery(max=3,status=closed,order=id,desc=1,format=table,col=resolution|summary|owner|reporter,rows=description)]]

This is displayed as:

Results (1 - 3 of 12888)

1 2 3 4 5 6 7 8 9 10 11
Ticket Resolution Summary Owner Reporter
#13501 fixed "Schedule As Group" not selected by default Peter Bennett Klaas de Waal
Description

On request of gigem, a detailed description of this issue.

Problem description

In mythtv-setup, after creating a new capture card entry and then configuring it in page "5. Input connections"/"Interactions between inputs", the option "Schedule as Group" is not selected. Also the "Max recordings" is 1.

The default for the "Schedule as Group" should be selected and the "Max recordings" should be 2.

How to reproduce this

  • System: fedora 31 (with mariadb)
  • Today's master (20191106)
  • Create new database from mythtv/mythtv/database/mc.sql
  • Run mythtv-setup, select country Netherlands and language English
  • Run mythtv-setup again, update database to version 1352
  • Go through the following menu steps in mythtv-setup:
    1. Capture cards
      (New capture card)
      New capture card >
      Card type: DVB-T/S/C, ATSC or ISDB-T tuner card
      Select MyGiga? DVB-T2 USB stick
    2. Video sources
      (New video source)
      New video source > (add name, rest is default)
    3. Input connections
      Select video source
      Interactions between inputs >

In this page:

Max recordings: 1
Schedule as group: not selected

Exit and save

This is then the content of database table capturecard:

MariaDB [mythconverg]> select cardid,parentid,cardtype,schedgroup from capturecard;
+--------+----------+----------+------------+
| cardid | parentid | cardtype | schedgroup |
+--------+----------+----------+------------+
|      1 |        0 | DVB      |          0 |
+--------+----------+----------+------------+
1 row in set (0.000 sec)

Analysis:

It is the intention that "Schedule as group" is default selected, as shown by the code in videosource.cpp:160-161 where the value is set true:

        setLabel(QObject::tr("Schedule as group"));
        setValue(true);

It is the intention that "Max recordings" is default 2, as shown by the code in videosource.cpp:64:

static const uint kDefaultMultirecCount = 2;

which is then used in videosource.cpp:3108.

The database schema for capturecard shows this:
MariaDB [mythconverg]> describe capturecard;
+-----------------------+------------------+------+-----+------------+----------------+
| Field                 | Type             | Null | Key | Default    | Extra          |
+-----------------------+------------------+------+-----+------------+----------------+
| cardid                | int(10) unsigned | NO   | PRI | NULL       | auto_increment |
| parentid              | int(10) unsigned | NO   |     | 0          |                |
| videodevice           | varchar(128)     | YES  |     | NULL       |                |
| audiodevice           | varchar(128)     | YES  |     | NULL       |                |
| vbidevice             | varchar(128)     | YES  |     | NULL       |                |
| cardtype              | varchar(32)      | YES  |     | V4L        |                |
| defaultinput          | varchar(32)      | YES  |     | Television |                |
| audioratelimit        | int(11)          | YES  |     | NULL       |                |
| hostname              | varchar(64)      | YES  |     | NULL       |                |
| dvb_swfilter          | int(11)          | YES  |     | 0          |                |
| dvb_sat_type          | int(11)          | NO   |     | 0          |                |
| dvb_wait_for_seqstart | int(11)          | NO   |     | 1          |                |
| skipbtaudio           | tinyint(1)       | YES  |     | 0          |                |
| dvb_on_demand         | tinyint(4)       | NO   |     | 0          |                |
| dvb_diseqc_type       | smallint(6)      | YES  |     | NULL       |                |
| firewire_speed        | int(10) unsigned | NO   |     | 0          |                |
| firewire_model        | varchar(32)      | YES  |     | NULL       |                |
| firewire_connection   | int(10) unsigned | NO   |     | 0          |                |
| signal_timeout        | int(11)          | NO   |     | 1000       |                |
| channel_timeout       | int(11)          | NO   |     | 3000       |                |
| dvb_tuning_delay      | int(10) unsigned | NO   |     | 0          |                |
| contrast              | int(11)          | NO   |     | 0          |                |
| brightness            | int(11)          | NO   |     | 0          |                |
| colour                | int(11)          | NO   |     | 0          |                |
| hue                   | int(11)          | NO   |     | 0          |                |
| diseqcid              | int(10) unsigned | YES  |     | NULL       |                |
| dvb_eitscan           | tinyint(1)       | NO   |     | 1          |                |
| inputname             | varchar(32)      | NO   |     | None       |                |
| sourceid              | int(10) unsigned | NO   |     | 0          |                |
| externalcommand       | varchar(128)     | YES  |     | NULL       |                |
| changer_device        | varchar(128)     | YES  |     | NULL       |                |
| changer_model         | varchar(128)     | YES  |     | NULL       |                |
| tunechan              | varchar(10)      | YES  |     | NULL       |                |
| startchan             | varchar(10)      | YES  |     | NULL       |                |
| displayname           | varchar(64)      | NO   |     |            |                |
| dishnet_eit           | tinyint(1)       | NO   |     | 0          |                |
| recpriority           | int(11)          | NO   |     | 0          |                |
| quicktune             | tinyint(4)       | NO   |     | 0          |                |
| schedorder            | int(10) unsigned | NO   |     | 1          |                |
| livetvorder           | int(10) unsigned | NO   |     | 1          |                |
| reclimit              | int(10) unsigned | NO   |     | 1          |                |
| schedgroup            | tinyint(1)       | NO   |     | 0          |                |
+-----------------------+------------------+------+-----+------------+----------------+
42 rows in set (0.002 sec)


The last two fields are of interest: reclimit is default 1 and schedgroup is default 0.

It appears that the default values in the database do override the default values in the code.

This can be verified by modifying the database schema as follows:

MariaDB [mythconverg]> ALTER TABLE capturecard ALTER reclimit SET DEFAULT 2;
MariaDB [mythconverg]> ALTER TABLE capturecard ALTER schedgroup SET DEFAULT 1;

After this modification, the default for "Schedule as group" is selected and the default "Max recordings" is 2.

The way forward:

I suggest to following approach to resolve this:

  • Modify the database schema so the default values are correct.
  • Remove the C++ code that sets the default values as this code is apparently not working.

Notes:

As bugs go, this one is fairly easy to fix. Given that we are still before the v31 release this is an excellent moment to add a schema change. However, as discussed in IRC/#mythtv, it appears that the default values as described in this ticket are not reproducible everywhere and also there might be discussion on why the C++ code does not work for me. Hence this ticket.

#13498 Duplicate Mythtv Frontend core dumping Fedora 31 dhighley
Description

The Mythtv frontend seems to be consuming too much memory. This happens when attempting to play a recording. Also attempted to play the recording via the web interface. Web interface would bring up the video but would not play. I can play the video file via VLC.

Running mythtv-frontend-30.0-12.20190904git5cde0578d8.fc31.x86_64 on Fedora 31.

Here is the information from the journal log. I would have attached this as a file if I could of figured out how to do that.

Nov 01 11:07:01 douglas mythbackend[1897]: 2019-11-01 11:07:01.089323 I mythdbcon.cpp:430:PurgeIdleConnections New DB connection, total: 7 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: libcec.so.4: cannot open shared object file: No such file or directory Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.269017 I mythtranslation.cpp:62:load Loading en_us translation for module mythfrontend Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.274113 E lirc.cpp:205:Init LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: eno: No such file or directory (2) Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.274137 I jsmenu.cpp:153:ReadConfig No joystick configuration found, not enabling joystick control Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.277462 E cecadapter.cpp:146:Open CECAdapter: Failed to load libcec. Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.277475 I mythudplistener.cpp:32:Enable UDPListener: Enabling Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.277850 I serverpool.cpp:538:bind Binding to UDP 0.0.0.0:6948 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.277889 I serverpool.cpp:538:bind Binding to UDP [::]:6948 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.304736 I

mythmainwindow.cpp:1023:Init UI Screen Resolution: 2560 x 1440

Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.345136 I mythmainwindow.cpp:1119:Init Using the Qt painter Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.346501 I mythuihelper.cpp:932:PruneCacheDir MythUIHelper: Pruning cache directory: /home/dhighley/.mythtv/cache/remotecache Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.347427 I mythuihelper.cpp:987:PruneCacheDir MythUIHelper: Kept 3 files, deleted 8 files, stat error on 0 files Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.347435 I mythuihelper.cpp:932:PruneCacheDir MythUIHelper: Pruning cache directory: /home/dhighley/.mythtv/cache/thumbnails Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.347520 I mythuihelper.cpp:987:PruneCacheDir MythUIHelper: Kept 10 files, deleted 0 files, stat error on 0 files Nov 01 11:07:01 douglas mythbackend[1897]: 2019-11-01 11:07:01.387927 I mainserver.cpp:1779:HandleAnnounce MainServer?: MainServer::ANN Frontend Nov 01 11:07:01 douglas mythbackend[1897]: 2019-11-01 11:07:01.387933 I mainserver.cpp:1781:HandleAnnounce MainServer?: adding: douglas(11a5f30) as a client (events: 0) Nov 01 11:07:01 douglas mythbackend[1897]: 2019-11-01 11:07:01.387960 I backendcontext.cpp:50:SetFrontendConnected BackendContext?: Frontend 'douglas' connected. Nov 01 11:07:01 douglas mythbackend[1897]: 2019-11-01 11:07:01.388828 I mainserver.cpp:1779:HandleAnnounce MainServer?: MainServer::ANN Monitor Nov 01 11:07:01 douglas mythbackend[1897]: 2019-11-01 11:07:01.388833 I mainserver.cpp:1781:HandleAnnounce MainServer?: adding: douglas(e838f0) as a client (events: 1) Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.383073 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/base.xml @ 135 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.383102 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/base.xml @ 143 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.383149 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/base.xml @ 148 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.383187 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/base.xml @ 157 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.383223 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/base.xml @ 162 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.383257 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/base.xml @ 172 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.383281 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/base.xml @ 178 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: : Type: 'fill' Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.386720 I mythcorecontext.cpp:449:ConnectCommandSocket MythCoreContext::ConnectCommandSocket?(): Connecting to backend server: 10.2.2.7:6543 (try 1 of 1) Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.387804 I mythcorecontext.cpp:1674:CheckProtoVersion MythCoreContext::CheckProtoVersion?(): Using protocol version 91 BuzzOff? Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.610968 I mythuiwebbrowser.cpp:1081:LoadUserStyleSheet MythUIWebBrowser: Loading css from - file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.612519 I mythuiwebbrowser.cpp:989:Init MythUIWebBrowser: enabling plugins Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.650744 E AirPlay?/mythraopdevice.cpp:30:Create RAOP Device: Aborting startup - no key found. Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.651051 I AirPlay?/mythairplayserver.cpp:380:Create AirPlay?: Created airplay objects. Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.651216 I serverpool.cpp:414:listen Listening on TCP 0.0.0.0:5100 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.651272 I serverpool.cpp:414:listen Listening on TCP [::]:5100 Nov 01 11:07:01 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:01.652815 I schemawizard.cpp:118:Compare Current MythTV Schema Version (DBSchemaVer): 135 0 Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.321748 N mythmainwindow.cpp:2027:RegisterMediaPlugin Registering Internal as a media playback plugin. Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.342909 I mythtranslation.cpp:62:load Loading en_us translation for module mytharchive Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.347057 N mythmainwindow.cpp:2027:RegisterMediaPlugin Registering WebBrowser? as a media playback plugin. Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.347093 I mythtranslation.cpp:62:load Loading en_us translation for module mythbrowser Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.358439 I mythtranslation.cpp:62:load Loading en_us translation for module mythgallery Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.362715 I mythtranslation.cpp:62:load Loading en_us translation for module mythgame Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.367032 I schemawizard.cpp:118:Compare Current MythMusic Schema Version (MusicDBSchemaVer): 1024 Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.374587 I mythtranslation.cpp:62:load Loading en_us translation for module mythmusic Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.377609 I mythtranslation.cpp:62:load Loading en_us translation for module mythnetvision Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.381052 I mythtranslation.cpp:62:load Loading en_us translation for module mythnews Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.385347 I mythtranslation.cpp:62:load Loading en_us translation for module mythweather Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.388318 I zmclient.cpp:65:setupZMClient ZMClient: no valid IP or port found for mythzmserver Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.388978 I mythtranslation.cpp:62:load Loading en_us translation for module mythzoneminder Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.390053 I serverpool.cpp:414:listen Listening on TCP 0.0.0.0:6546 Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.390410 I serverpool.cpp:414:listen Listening on TCP [::]:6546 Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.418277 N main.cpp:1234:RunMenu Found mainmenu.xml for theme 'blootube-ng' Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.420656 I themechooser.cpp:1042:ThemeUpdateChecker Checking for theme updates every hour Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.420845 I housekeeper.cpp:648:RegisterTask Registering HouseKeeperTask? 'HardwareProfiler?'. Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.421594 I

housekeeper.cpp:722:Start Starting HouseKeeper?.

Nov 01 11:07:02 douglas mythfrontend[126636]: qt.qpa.wayland: Wayland does not support QWindow::requestActivate() Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.556039 I bonjourregister.cpp:114:BonjourCallback Bonjour: Service registration complete: name 'Mythfrontend on douglas' type '_mythfrontend._tcp.' domain: 'local.' Nov 01 11:07:02 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:02.559428 I bonjourregister.cpp:114:BonjourCallback Bonjour: Service registration complete: name 'MythTV on douglas' type '_airplay._tcp.' domain: 'local.' Nov 01 11:07:04 douglas automount[1929]: handle_packet: type = 3 Nov 01 11:07:04 douglas automount[1929]: handle_packet_missing_indirect: token 45, name mythfrontend, request pid 126636 Nov 01 11:07:04 douglas automount[1929]: attempting to mount entry /home/mythfrontend Nov 01 11:07:04 douglas automount[1929]: lookup_mount: lookup(file): looking up mythfrontend Nov 01 11:07:04 douglas automount[1929]: lookup_mount: lookup(sss): looking up mythfrontend Nov 01 11:07:04 douglas automount[1929]: setautomntent: lookup(sss): setautomntent: No such file or directory Nov 01 11:07:04 douglas automount[1929]: key "mythfrontend" not found in map source(s). Nov 01 11:07:04 douglas automount[1929]: dev_ioctl_send_fail: token = 45 Nov 01 11:07:04 douglas automount[1929]: failed to mount /home/mythfrontend Nov 01 11:07:04 douglas automount[1929]: handle_packet: type = 3 Nov 01 11:07:04 douglas automount[1929]: handle_packet_missing_indirect: token 46, name mythfrontend, request pid 126636 Nov 01 11:07:04 douglas automount[1929]: dev_ioctl_send_fail: token = 46 Nov 01 11:07:04 douglas automount[1929]: handle_packet: type = 3 Nov 01 11:07:04 douglas automount[1929]: handle_packet_missing_indirect: token 47, name mythfrontend, request pid 126636 Nov 01 11:07:04 douglas automount[1929]: dev_ioctl_send_fail: token = 47 Nov 01 11:07:04 douglas automount[1929]: handle_packet: type = 3 Nov 01 11:07:04 douglas automount[1929]: handle_packet_missing_indirect: token 48, name mythfrontend, request pid 126636 Nov 01 11:07:04 douglas automount[1929]: dev_ioctl_send_fail: token = 48 Nov 01 11:07:04 douglas automount[1929]: handle_packet: type = 3 Nov 01 11:07:04 douglas automount[1929]: handle_packet_missing_indirect: token 49, name mythfrontend, request pid 126636 Nov 01 11:07:04 douglas automount[1929]: dev_ioctl_send_fail: token = 49 Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:05.625225 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/recordings-ui.xml @ 110 Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:05.625347 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/recordings-ui.xml @ 124 Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:05.626184 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/recordings-ui.xml @ 216 Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:05.626324 E mythuitype.cpp:1294:ParseElement MythUIType: Unknown widget type 'fill' Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Location: /home/dhighley/.mythtv/themes/blootube-ng/recordings-ui.xml @ 230 Nov 01 11:07:05 douglas mythfrontend.desktop[2616]: Name: Type: 'fill' Nov 01 11:07:07 douglas systemd[1]: fprintd.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit fprintd.service has successfully entered the 'dead' state. Nov 01 11:07:07 douglas audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=fprintd comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=success' Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.032953 I tv_play.cpp:1137:TV TV::TV(): Creating TV object Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.070003 N mythmainwindow.cpp:2993:PauseIdleTimer Suspending idle timer Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.072080 I tv_play.cpp:1358:Init TV::Init(): Created TvPlayWindow?. Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.102872 I tv_play.cpp:2316:HandleStateChange TV::HandleStateChange?(): Attempting to change from None to WatchingPreRecorded? Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.121141 E audio/audiooutputalsa.cpp:174:GetPCMInfo ALSA: snd_pcm_info_get_card: Operation not permitted Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.133042 N audioplayer.cpp:166:ReinitAudio AudioPlayer?: Enabling Audio Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.195634 I avformatdecoder.cpp:2219:ScanStreams AFD: codec AC3 has 6 channels Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.195912 I avformatdecoder.cpp:2767:OpenAVCodec AFD: Opened codec 0x13e1800, id(AC3) type(Audio) Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.195932 I avformatdecoder.cpp:2219:ScanStreams AFD: codec AC3 has 2 channels Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.196290 I avformatdecoder.cpp:2767:OpenAVCodec AFD: Opened codec 0x6b26640, id(AC3) type(Audio) Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.199640 I avformatdecoder.cpp:2667:ScanStreams AFD: Using ffmpeg for video decoding Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.199803 I avformatdecoder.cpp:2767:OpenAVCodec AFD: Opened codec 0x774cc80, id(MPEG2VIDEO) type(Video) Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.200496 I audio/audiooutputbase.cpp:825:Reconfigure AOBase: Opening audio device 'pulse' ch 6(6) sr 48000 sf 32 bit floating point reenc 0 Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.392298 E audio/audiooutputalsa.cpp:953:OpenMixer ALSA: no playback control PCM found on mixer device default Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.392304 E audio/audiooutputalsa.cpp:497:OpenDevice ALSA: Unable to open audio mixer. Volume control disabled Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: 2019-11-01 11:07:13.422964 E mythxdisplay.cpp:257:CheckErrors Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: XError type: 0 Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: serial no: 8 Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: err code: 9 (BadDrawable? (invalid Pixmap or Window parameter)) Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: req code: 55 Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: minor code: 0 Nov 01 11:07:13 douglas mythfrontend.desktop[2616]: resource id: 1 Nov 01 11:07:14 douglas mythfrontend.desktop[2616]: Handling Segmentation fault Nov 01 11:07:14 douglas audit[126636]: ANOM_ABEND auid=1000 uid=1000 gid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 pid=126636 comm="mythfrontend" exe="/usr/bin/mythfrontend" sig=11 res=1 Nov 01 11:07:14 douglas systemd[1]: Started Process Core Dump (PID 126729/UID 0). -- Subject: A start job for unit systemd-coredump@… has finished successfully -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- A start job for unit systemd-coredump@… has finished successfully. -- -- The job identifier is 26888. Nov 01 11:07:14 douglas audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=systemd-coredump@3-126729-0 comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res =success' Nov 01 11:07:20 douglas systemd-coredump[126730]: Core file was truncated to 2147483648 bytes. -- Subject: Core file was truncated to 2147483648 bytes. -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- Documentation: man:coredump.conf(5) -- -- The process had more memory mapped than the configured maximum for processing -- and storage by systemd-coredump(8). Only the first 2147483648 bytes were -- saved. This core might still be usable, but various tools like gdb(1) will warn -- about the file being truncated. Nov 01 11:07:20 douglas abrt-dump-journal-core[1308]: Failed to obtain all required information from journald Nov 01 11:07:25 douglas systemd-coredump[126730]: Process 126636 (mythfrontend) of user 1000 dumped core.

Stack trace of thread 126636: #0 0x00007fb2a94a4be3 n/a (n/a)

-- Subject: Process 126636 (mythfrontend) dumped core -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- Documentation: man:core(5) -- -- Process 126636 (mythfrontend) crashed and dumped core. -- -- This usually indicates a programming error in the crashing program and -- should be reported to its vendor as a bug. Nov 01 11:07:25 douglas systemd[1]: systemd-coredump@…: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit systemd-coredump@… has successfully entered the 'dead' state. Nov 01 11:07:25 douglas audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 subj=system_u:system_r:init_t:s0 msg='unit=systemd-coredump@3-126729-0 comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=success' Nov 01 11:07:25 douglas systemd[1]: systemd-coredump@…: Consumed 3.306s CPU time. -- Subject: Resources consumed by unit runtime -- Defined-By: systemd -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The unit systemd-coredump@… completed and consumed the indicated resources. Nov 01 11:07:25 douglas mythbackend[1897]: 2019-11-01 11:07:25.341210 I backendcontext.cpp:96:SetFrontendDisconnected BackendContext?: Frontend 'douglas' disconnected. Nov 01 11:07:25 douglas mythbackend[1897]: 2019-11-01 11:07:25.341220 I mainserver.cpp:7925:connectionClosed Playback sock(11a5f30) 'douglas' disconnected Nov 01 11:07:25 douglas mythbackend[1897]: 2019-11-01 11:07:25.342220 I mainserver.cpp:7925:connectionClosed Monitor sock(e838f0) 'douglas' disconnected Nov 01 11:07:31 douglas abrtd[1286]: Size of '/var/spool/abrt' >= 5000 MB (MaxCrashReportsSize?), deleting old directory 'ccpp-2019-11-01-09:33:38.73737-123718' Nov 01 11:07:31 douglas abrt-server[126748]: Error: No segments found in coredump './coredump' Nov 01 11:07:31 douglas abrt-server[126748]: Can't open file 'core_backtrace' for reading: No such file or directory Nov 01 11:07:31 douglas abrt-server[126748]: Lock file '.lock' is locked by process 3461 Nov 01 11:07:32 douglas abrt-notification[126788]: Process 126636 (mythfrontend) crashed in ??() Nov 01 11:07:38 douglas audit[126786]: USER_AUTH pid=126786 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:auth -- -- The unit systemd-coredump@… completed and consumed the indicated resources. Nov 01 11:07:25 douglas mythbackend[1897]: 2019-11-01 11:07:25.341210 I backendcontext.cpp:96:SetFrontendDisconnected BackendContext?: Frontend 'douglas' disconnected. Nov 01 11:07:25 douglas mythbackend[1897]: 2019-11-01 11:07:25.341220 I mainserver.cpp:7925:connectionClosed Playback sock(11a5f30) 'douglas' disconnected Nov 01 11:07:25 douglas mythbackend[1897]: 2019-11-01 11:07:25.342220 I mainserver.cpp:7925:connectionClosed Monitor sock(e838f0) 'douglas' disconnected Nov 01 11:07:31 douglas abrtd[1286]: Size of '/var/spool/abrt' >= 5000 MB (MaxCrashReportsSize?), deleting old directory 'ccpp-2019-11-01-09:33:38.73737-123718' Nov 01 11:07:31 douglas abrt-server[126748]: Error: No segments found in coredump './coredump' Nov 01 11:07:31 douglas abrt-server[126748]: Can't open file 'core_backtrace' for reading: No such file or directory Nov 01 11:07:31 douglas abrt-server[126748]: Lock file '.lock' is locked by process 3461 Nov 01 11:07:32 douglas abrt-notification[126788]: Process 126636 (mythfrontend) crashed in ??() Nov 01 11:07:38 douglas audit[126786]: USER_AUTH pid=126786 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:authentication grantors=pam_unix acct="root" exe="/usr/bin/su" hostname=douglas addr es=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:accounting grantors=pam_unix,pam_localuser acct="root" exe="/usr/bin/su" hostname=douglas addr=? terminal=pts/0 res=success' Nov 01 11:07:38 douglas su[126786]: (to root) dhighley on pts/0 Nov 01 11:07:38 douglas audit[126786]: CRED_ACQ pid=126786 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:setcred grantors=pam_unix acct="root" exe="/usr/bin/su" hostname=douglas addr=? terminal=pts/0 res=success' Nov 01 11:07:38 douglas su[126786]: pam_unix(su-l:session): session opened for user root by (uid=1000) Nov 01 11:07:38 douglas audit[126786]: USER_START pid=126786 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:session_open grantors=pam_keyinit,pam_keyinit,pam_limits,pam_systemd,pam_unix,pam_xauth acct="root" exe="/usr/bin/su" hostname=douglas addr=? terminal=pts/0 res=success' Nov 01 11:07:38 douglas automount[1929]: st_expire: state 1 path /home Nov 01 11:07:38 douglas automount[1929]: expire_proc: exp_proc = 140167270717184 path /home Nov 01 11:07:38 douglas automount[1929]: expire_proc_indirect: expire /home/dhighley Nov 01 11:07:38 douglas automount[1929]: expire_proc_indirect: 1 remaining in /h Nov 01 11:07:38 douglas su[126786]: pam_unix(su-l:session): session opened for user root by (uid=1000) Nov 01 11:07:38 douglas audit[126786]: USER_START pid=126786 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=PAM:session_open grantors=pam_keyinit,pam_keyinit,pam_limits,pam_systemd,pam_unix,pam_xauth acct="root" exe="/usr/bin/su" hostname=douglas addr=? terminal=pts/0 res=success' Nov 01 11:07:38 douglas automount[1929]: st_expire: state 1 path /home Nov 01 11:07:38 douglas automount[1929]: expire_proc: exp_proc = 140167270717184 path /home Nov 01 11:07:38 douglas automount[1929]: expire_proc_indirect: expire /home/dhighley Nov 01 11:07:38 douglas automount[1929]: expire_proc_indirect: 1 remaining in /home Nov 01 11:07:38 douglas automount[1929]: expire_cleanup: got thid 140167270717184 path /home stat 3 Nov 01 11:07:38 douglas automount[1929]: expire_cleanup: sigchld: exp 140167270717184 finished, switching from 2 to 1 Nov 01 11:07:38 douglas automount[1929]: st_ready: st_ready(): state = 2 path /home Nov 01 11:07:50 douglas mythbackend[1897]: 2019-11-01 11:07:50.167818 N autoexpire.cpp:259:CalcParams AutoExpire?: CalcParams?(): Max required Free Space: 1.0 GB w/freq: 15 min

#13495 Fixed Fix thetvdb Specials mspieth patrickdk77
Description

Since 0.27 the code requires both season and episode to be set, and setting season to 0 is parsed to a false value. 0 is used to mean Specials by thetvdb that the previous 0.26 code understood. Other places in the code handle this correctly. Small change to fix this.

https://github.com/MythTV/mythtv/pull/185

1 2 3 4 5 6 7 8 9 10 11

Query Language

query: TracLinks and the [[TicketQuery]] macro both use a mini “query language” for specifying query filters. Filters are separated by ampersands (&). Each filter consists of the ticket field name, an operator and one or more values. More than one value are separated by a pipe (|), meaning that the filter matches any of the values. To include a literal & or | in a value, escape the character with a backslash (\).

The available operators are:

= the field content exactly matches one of the values
~= the field content contains one or more of the values
^= the field content starts with one of the values
$= the field content ends with one of the values

All of these operators can also be negated:

!= the field content matches none of the values
!~= the field content does not contain any of the values
!^= the field content does not start with any of the values
!$= the field content does not end with any of the values

Filters combining matches and negated matches can be constructed for text fields such as Keywords and CC when using the contains (~=) operator. The - operator is used to negate a match and double quotes (since 1.2.1) are used for whitespace-separated words in a phrase. For example, keywords~=word1 word2 -word3 "word4 word5" matches tickets containing word1 and word2, not word3 and also word4 word5.

status=closed,keywords~=firefox query closed tickets that contain keyword firefox
status=closed,keywords~=opera query closed tickets that contain keyword opera
status=closed,keywords~=firefox opera query closed tickets that contain keywords firefox and opera
status=closed,keywords~=firefox|opera query closed tickets that contain keywords firefox or opera
status=closed,keywords~=firefox,or,keywords~=opera query closed tickets that contain keyword firefox, or (closed or unclosed) tickets that contain keyword opera
status=closed,keywords~=firefox -opera query closed tickets that contain keyword firefox, but not opera
status=closed,keywords~=opera -firefox query closed tickets that contain keyword opera, but no firefox

The date fields created and modified can be constrained by using the = operator and specifying a value containing two dates separated by two dots (..). Either end of the date range can be left empty, meaning that the corresponding end of the range is open. The date parser understands a few natural date specifications like "3 weeks ago", "last month" and "now", as well as Bugzilla-style date specifications like "1d", "2w", "3m" or "4y" for 1 day, 2 weeks, 3 months and 4 years, respectively. Spaces in date specifications can be omitted to avoid having to quote the query string.

created=2007-01-01..2008-01-01 query tickets created in 2007
created=lastmonth..thismonth query tickets created during the previous month
modified=1weekago.. query tickets that have been modified in the last week
modified=..30daysago query tickets that have been inactive for the last 30 days

Note that modified is the last modified time, so modified with a date range shows ticket that were last modified in that date range. If a ticket was modified in the date range, but modified again after the end date, it will not be included in the results.


See also: TracTickets, TracReports, TracGuide, TicketQuery

Last modified 19 months ago Last modified on Apr 24, 2018, 9:56:48 AM