Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

matrix432
Newcomer
Posts: 13
Joined: Wed Feb 08, 2017 10:54 am
Australia

Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by matrix432 » Tue Jul 02, 2019 12:49 am

Hello everyone,

Lately I've done a full system upgrade and upgraded mythtv as well. The logs and everything seems to be fine but when I run livetv, it goes back to the main menu and I've also tried deleting the capture card and re-scan all channels but still having the same issue. The logs say that mysqld has stopped but is still running and all config.xml files are the same with no conficting information. I tried some articles related to mysqld but was unable to resolve the issue with database query when attempting to run livetv.

mythbackend:

Code: Select all

;; This buffer is for text that is not saved, and for Lisp evaluation.
;; To create a file, visit it with C-x C-f and enter text in its buffer.

2019-07-02 08:20:54.763868 C  mythbackend version: tag: v30.0 [v30.0-76a78d844cf] www.mythtv.org
2019-07-02 08:20:54.764019 C  Qt version: compile: 5.12.4, runtime: 5.12.4
2019-07-02 08:20:54.764054 N  Enabled verbose msgs:  general
2019-07-02 08:20:54.764111 N  Setting Log Level to LOG_INFO
2019-07-02 08:20:54.780291 I  Setup Interrupt handler
2019-07-02 08:20:54.780377 I  Setup Terminated handler
2019-07-02 08:20:54.780491 I  Setup Segmentation fault handler
2019-07-02 08:20:54.780574 I  Setup Aborted handler
2019-07-02 08:20:54.780679 I  Setup Bus error handler
2019-07-02 08:20:54.780762 I  Setup Floating point exception handler
2019-07-02 08:20:54.780872 I  Setup Illegal instruction handler
2019-07-02 08:20:54.780961 I  Setup Real-time signal 0 handler
2019-07-02 08:20:54.781081 I  Setup Hangup handler
2019-07-02 08:20:54.782233 N  Using runtime prefix = /usr
2019-07-02 08:20:54.782302 N  Using configuration directory = /home/matrix386/.mythtv
2019-07-02 08:20:54.783003 I  Assumed character encoding: en_US.UTF-8
2019-07-02 08:20:54.784765 I  Added logging to the console
2019-07-02 08:20:54.810663 I  Using a profile name of: 'mythtv@localhost' (Usually the same as this host's name.)
2019-07-02 08:20:54.810992 I  Start up testing connections. DB 127.0.0.1, BE , attempt 0, status dbAwake, Delay: 2000
2019-07-02 08:20:56.132564 N  Setting QT default locale to en_US
2019-07-02 08:20:56.132621 I  Current locale en_US
2019-07-02 08:20:56.248224 N  Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
2019-07-02 08:20:56.342631 I  Loading en_us translation for module mythfrontend
2019-07-02 08:20:56.612512 I  Current MythTV Schema Version (DBSchemaVer): 1350
2019-07-02 08:20:56.613504 I  Loading en_us translation for module mythfrontend
2019-07-02 08:20:56.616116 N  MythBackend: Starting up as the master server.
2019-07-02 08:20:58.005064 I  Found 2 distinct programid authorities
2019-07-02 08:20:58.006259 I  Registering HouseKeeperTask 'LogClean'.
2019-07-02 08:20:58.006518 I  Registering HouseKeeperTask 'DBCleanup'.
2019-07-02 08:20:58.006739 I  Registering HouseKeeperTask 'ThemeUpdateNotifications'.
2019-07-02 08:20:58.006961 I  Registering HouseKeeperTask 'RecordedArtworkUpdate'.
2019-07-02 08:20:58.007798 I  New static DB connectionSchedCon
2019-07-02 08:20:58.013466 I  Registering HouseKeeperTask 'MythFillDB'.
2019-07-02 08:20:58.015926 I  Registering HouseKeeperTask 'JobQueueRecover'.
2019-07-02 08:20:58.016241 I  Registering HouseKeeperTask 'HardwareProfiler'.
2019-07-02 08:20:58.050405 I  Queueing HouseKeeperTask 'ThemeUpdateNotifications'.
2019-07-02 08:20:58.050418 I  Starting HouseKeeper.
2019-07-02 08:20:58.263879 I  Listening on TCP 0.0.0.0:6544
2019-07-02 08:20:58.266886 I  Listening on TCP [::]:6544
2019-07-02 08:20:58.267014 I  Listening on TCP 0.0.0.0:6554
2019-07-02 08:20:58.267122 I  Listening on TCP [::]:6554
2019-07-02 08:20:58.267571 I  Listening on TCP 0.0.0.0:6549
2019-07-02 08:20:58.267692 I  Listening on TCP [::]:6549
2019-07-02 08:21:01.136881 I  Reschedule requested for MATCH 0 0 0 - SchedulerInit
2019-07-02 08:21:01.329707 I  Scheduled 0 items in 0.2 = 0.14 match + 0.01 check + 0.02 place
2019-07-02 08:21:01.332303 I  Scheduler: Seem to be woken up by USER
^[[1;5H2019-07-02 08:21:02.630948 E  Bonjour: Error: -65537
2019-07-02 08:21:02.630964 E  Bonjour: Failed to register service.
2019-07-02 08:21:02.630985 I  Main::Registering HttpStatus Extension
2019-07-02 08:21:02.634716 I  Listening on TCP 0.0.0.0:6543
2019-07-02 08:21:02.634836 I  Listening on TCP [::]:6543
2019-07-02 08:21:02.786535 N  AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2019-07-02 08:22:17.811131 N  Expiring 4 MB for 1032 at 2017-07-13T15:09:17Z => 
2019-07-02 08:22:17.917451 N  Expiring 27 MB for 1001 at 2017-07-13T15:04:18Z => Graceland
2019-07-02 08:22:17.917526 N  Expiring 115 MB for 1024 at 2017-07-13T15:05:13Z => "Al Jazeera newsgrid"
2019-07-02 08:22:17.917583 N  Expiring 4 MB for 1032 at 2017-07-13T15:09:17Z => 
2019-07-02 08:22:17.917679 N  Expiring 33 MB for 1032 at 2017-07-13T15:12:50Z => 
2019-07-02 08:22:17.917736 N  Expiring 24 MB for 1032 at 2017-11-23T00:31:17Z => 
2019-07-02 08:22:17.917793 N  Expiring 70 MB for 1031 at 2017-11-23T00:32:37Z => 
2019-07-02 08:22:17.917848 N  Expiring 119 MB for 1031 at 2017-11-23T00:44:22Z => 
2019-07-02 08:22:17.917905 N  Expiring 39 MB for 1031 at 2017-11-23T01:02:39Z => 
2019-07-02 08:22:17.917964 N  Expiring 890 MB for 1031 at 2017-11-23T01:04:31Z => 
2019-07-02 08:22:17.918020 N  Expiring 949 MB for 1031 at 2017-11-23T01:30:00Z => 
2019-07-02 08:22:17.918075 N  Expiring 40 MB for 1031 at 2017-11-23T02:00:00Z => 
2019-07-02 08:22:17.959921 E  MainServer: ERROR when trying to delete file: myth://matrix/1032_20170713150917.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:17.966474 E  MainServer: ERROR when trying to delete file: myth://matrix/1001_20170713150418.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:17.974418 E  MainServer: ERROR when trying to delete file: myth://matrix/1024_20170713150513.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:17.981353 E  MainServer: ERROR when trying to delete file: myth://matrix/1032_20170713150917.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:17.990661 E  MainServer: ERROR when trying to delete file: myth://matrix/1032_20170713151250.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:18.000065 E  MainServer: ERROR when trying to delete file: myth://matrix/1032_20171123003117.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:18.007550 E  MainServer: ERROR when trying to delete file: myth://matrix/1031_20171123003237.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:18.015114 E  MainServer: ERROR when trying to delete file: myth://matrix/1031_20171123004422.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:18.022616 E  MainServer: ERROR when trying to delete file: myth://matrix/1031_20171123010239.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:18.028815 E  MainServer: ERROR when trying to delete file: myth://matrix/1031_20171123010431.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:18.037717 E  MainServer: ERROR when trying to delete file: myth://matrix/1031_20171123013000.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:18.045653 E  MainServer: ERROR when trying to delete file: myth://matrix/1031_20171123020000.ts. File doesn't exist.  Database metadata will not be removed.
2019-07-02 08:22:24.239541 I  MainServer: MainServer::ANN Playback
2019-07-02 08:22:24.239557 I  MainServer: adding: mythtv@localhost(5571c3c47010) as a client (events: 0)
2019-07-02 08:22:24.248591 I  MainServer: adding: mythtv@localhost(5571c3c2cf80) as a file transfer
2019-07-02 08:22:24.252070 I  FileTransfer sock(5571c3c2cf80) disconnected
2019-07-02 08:22:24.253330 I  Playback sock(5571c3c47010) 'mythtv@localhost' disconnected
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.754470 I  MySQL server disconnected
2019-07-02 08:23:23.754505 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.754824 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.754845 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.755074 I  MySQL server disconnected
2019-07-02 08:23:23.755181 I  MySQL server disconnected
2019-07-02 08:23:23.755206 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.755400 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.755419 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.755615 I  MySQL server disconnected
2019-07-02 08:23:23.755640 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.755836 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.755853 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.756032 I  MySQL server disconnected
2019-07-02 08:23:23.756123 I  MySQL server disconnected
2019-07-02 08:23:23.756145 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.756306 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.756327 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.756617 I  MySQL server disconnected
2019-07-02 08:23:23.756642 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.757635 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.757756 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.758946 I  MySQL server disconnected
2019-07-02 08:23:23.759820 I  MySQL server disconnected
2019-07-02 08:23:23.759842 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.760086 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.760104 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.760286 I  MySQL server disconnected
2019-07-02 08:23:23.760307 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.760454 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.760470 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.760610 I  MySQL server disconnected
2019-07-02 08:23:23.760683 I  MySQL server disconnected
2019-07-02 08:23:23.760701 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.760808 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.760822 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.760958 I  MySQL server disconnected
2019-07-02 08:23:23.760977 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.761110 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.761123 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.761260 I  MySQL server disconnected
2019-07-02 08:23:23.761332 I  MySQL server disconnected
2019-07-02 08:23:23.761349 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.761451 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.761465 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.761599 I  MySQL server disconnected
2019-07-02 08:23:23.761619 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.761785 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.761799 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.761953 I  MySQL server disconnected
2019-07-02 08:23:23.762025 I  MySQL server disconnected
2019-07-02 08:23:23.762043 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.762184 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.762197 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.762364 I  MySQL server disconnected
2019-07-02 08:23:23.762383 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.762553 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.762568 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.762727 I  MySQL server disconnected
2019-07-02 08:23:23.762801 I  MySQL server disconnected
2019-07-02 08:23:23.762818 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.762928 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.762942 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.763185 I  MySQL server disconnected
2019-07-02 08:23:23.763218 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.763593 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.763608 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.764106 I  MySQL server disconnected
2019-07-02 08:23:23.764195 I  MySQL server disconnected
2019-07-02 08:23:23.764214 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.764373 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.764388 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.764554 I  MySQL server disconnected
2019-07-02 08:23:23.764574 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.764713 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.764727 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.764890 I  MySQL server disconnected
2019-07-02 08:23:23.764981 I  MySQL server disconnected
2019-07-02 08:23:23.764999 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.765132 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.765146 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.765298 I  MySQL server disconnected
2019-07-02 08:23:23.765316 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.765491 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.765506 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.765663 I  MySQL server disconnected
2019-07-02 08:23:23.765753 I  MySQL server disconnected
2019-07-02 08:23:23.765772 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.765903 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.765917 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.766075 I  MySQL server disconnected
2019-07-02 08:23:23.766095 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.766231 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.766244 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.766406 I  MySQL server disconnected
2019-07-02 08:23:23.766554 I  MySQL server disconnected
2019-07-02 08:23:23.766574 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.766719 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.766735 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.766874 I  MySQL server disconnected
2019-07-02 08:23:23.766892 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.767063 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.767078 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.767230 I  MySQL server disconnected
2019-07-02 08:23:23.767318 I  MySQL server disconnected
2019-07-02 08:23:23.767337 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.767467 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.767482 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.767653 I  MySQL server disconnected
2019-07-02 08:23:23.767673 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.775994 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.776012 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.782728 I  MySQL server disconnected
2019-07-02 08:23:23.782872 I  MySQL server disconnected
2019-07-02 08:23:23.782902 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.783061 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.783076 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.783300 I  MySQL server disconnected
2019-07-02 08:23:23.783322 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.783473 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.783488 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.783633 I  MySQL server disconnected
2019-07-02 08:23:23.783711 I  MySQL server disconnected
2019-07-02 08:23:23.783729 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.783839 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.788348 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.788714 I  MySQL server disconnected
2019-07-02 08:23:23.788750 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.789000 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.789023 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.789199 I  MySQL server disconnected
2019-07-02 08:23:23.789281 I  MySQL server disconnected
2019-07-02 08:23:23.789309 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.789452 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.789469 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.789624 I  MySQL server disconnected
2019-07-02 08:23:23.789646 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.789929 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.789944 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.790097 I  MySQL server disconnected
2019-07-02 08:23:23.790170 I  MySQL server disconnected
2019-07-02 08:23:23.790188 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.790300 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.790312 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.790452 I  MySQL server disconnected
2019-07-02 08:23:23.790469 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.790602 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.790617 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.790760 I  MySQL server disconnected
2019-07-02 08:23:23.790832 I  MySQL server disconnected
2019-07-02 08:23:23.790850 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.790958 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.790973 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.791115 I  MySQL server disconnected
2019-07-02 08:23:23.791133 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.791263 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.791278 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.791414 I  MySQL server disconnected
2019-07-02 08:23:23.791488 I  MySQL server disconnected
2019-07-02 08:23:23.791505 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.791610 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.791624 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.791761 I  MySQL server disconnected
2019-07-02 08:23:23.791778 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.791910 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.791923 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.792094 I  MySQL server disconnected
2019-07-02 08:23:23.792193 I  MySQL server disconnected
2019-07-02 08:23:23.792211 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.793166 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.793182 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.793613 I  MySQL server disconnected
2019-07-02 08:23:23.793633 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.793828 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.793840 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.794003 I  MySQL server disconnected
2019-07-02 08:23:23.794103 I  MySQL server disconnected
2019-07-02 08:23:23.794117 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.794240 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.794285 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.794450 I  MySQL server disconnected
2019-07-02 08:23:23.794464 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.794633 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.794646 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.794807 I  MySQL server disconnected
2019-07-02 08:23:23.794907 I  MySQL server disconnected
2019-07-02 08:23:23.794920 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.795039 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.795050 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.795265 I  MySQL server disconnected
2019-07-02 08:23:23.795280 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.795448 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.795459 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.795619 I  MySQL server disconnected
2019-07-02 08:23:23.795880 I  MySQL server disconnected
2019-07-02 08:23:23.795904 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.796074 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.796089 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.796248 I  MySQL server disconnected
2019-07-02 08:23:23.796268 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.796500 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.796517 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.796701 I  MySQL server disconnected
2019-07-02 08:23:23.796774 I  MySQL server disconnected
2019-07-02 08:23:23.796793 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.796924 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.796938 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.797091 I  MySQL server disconnected
2019-07-02 08:23:23.797110 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.797275 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.797289 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.797445 I  MySQL server disconnected
2019-07-02 08:23:23.797516 I  MySQL server disconnected
2019-07-02 08:23:23.797534 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.797668 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.797684 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.797848 I  MySQL server disconnected
2019-07-02 08:23:23.797866 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.798004 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.798018 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.798188 I  MySQL server disconnected
2019-07-02 08:23:23.798262 I  MySQL server disconnected
2019-07-02 08:23:23.798280 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.798419 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.798435 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.798593 I  MySQL server disconnected
2019-07-02 08:23:23.798614 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.798774 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.798789 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.800150 I  MySQL server disconnected
2019-07-02 08:23:23.800240 I  MySQL server disconnected
2019-07-02 08:23:23.800261 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.800386 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.800401 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.800539 I  MySQL server disconnected
2019-07-02 08:23:23.800559 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.800698 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.800712 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.800894 I  MySQL server disconnected
2019-07-02 08:23:23.800987 I  MySQL server disconnected
2019-07-02 08:23:23.801147 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.801354 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.801370 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.801536 I  MySQL server disconnected
2019-07-02 08:23:23.801556 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.801728 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.801743 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.801896 I  MySQL server disconnected
2019-07-02 08:23:23.801988 I  MySQL server disconnected
2019-07-02 08:23:23.802005 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.802135 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.802150 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.802307 I  MySQL server disconnected
2019-07-02 08:23:23.802326 E  DB Error (InsertProgram -- lock):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:23.802590 E  [DBManager2] Unable to connect to database!
2019-07-02 08:23:23.802606 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:23:23.802781 I  MySQL server disconnected
2019-07-02 08:23:23.802872 I  MySQL server disconnected
2019-07-02 08:23:23.802891 E  DB Error (RecGroup update):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:23:24.078420 C  Received Segmentation fault: Code 1, PID 608, UID 0, Value 0x00000000
Segmentation fault (core dumped)
mythfrontend

Code: Select all


               +                
               #                
              ###               
             #####              
             ######             
            ; #####;            User: matrix386
           +##.#####            Hostname: matrix
          +##########           Distro: Arch Linux
         #############;         Kernel: 5.1.15-arch1-1-ARCH
        ###############+        Uptime: 0:09
       #######   #######        Window Manager: Openbox
     .######;     ;###;`".      Desktop Environment: LXDE
    .#######;     ;#####.       Shell: /bin/bash
    #########.   .########`     Terminal: dumb
   ######'           '######    Packages: 913
  ;####                 ####;   CPU: Intel(R) Celeron(R) CPU N2840 @ 2.16GHz
  ##'                     '##   RAM: 602 MB / 7857 MB 
 #'                         `#  Disk: 348GB / 491GB

[matrix386@matrix ~]$ mythfrontend
2019-07-02 08:27:46.364987 I  Setup Interrupt handler
2019-07-02 08:27:46.365062 I  Setup Terminated handler
2019-07-02 08:27:46.365080 I  Setup Segmentation fault handler
2019-07-02 08:27:46.365097 I  Setup Aborted handler
2019-07-02 08:27:46.365115 I  Setup Bus error handler
2019-07-02 08:27:46.365131 I  Setup Floating point exception handler
2019-07-02 08:27:46.365148 I  Setup Illegal instruction handler
2019-07-02 08:27:46.365169 I  Setup Real-time signal 0 handler
2019-07-02 08:27:46.365190 I  Setup User defined signal 1 handler
2019-07-02 08:27:46.365206 I  Setup User defined signal 2 handler
2019-07-02 08:27:46.365223 I  Setup Hangup handler
2019-07-02 08:27:46.365439 C  mythfrontend version: tag: v30.0 [v30.0-76a78d844cf] www.mythtv.org
2019-07-02 08:27:46.365456 C  Qt version: compile: 5.12.4, runtime: 5.12.4
2019-07-02 08:27:46.365463 N  Enabled verbose msgs:  general
2019-07-02 08:27:46.365504 N  Setting Log Level to LOG_INFO
2019-07-02 08:27:46.376843 N  Using runtime prefix = /usr
2019-07-02 08:27:46.376847 I  Added logging to the console
2019-07-02 08:27:46.376856 N  Using configuration directory = /home/matrix386/.mythtv
2019-07-02 08:27:46.377060 I  Assumed character encoding: en_US.UTF-8
2019-07-02 08:27:46.378123 I  Loading en_us translation for module mythfrontend
2019-07-02 08:27:46.378841 I  Using a profile name of: 'mythtv@localhost' (Usually the same as this host's name.)
2019-07-02 08:27:46.379027 I  Start up testing connections. DB 127.0.0.1, BE , attempt 0, status dbAwake, Delay: 2000
2019-07-02 08:27:47.431240 N  Setting QT default locale to en_US
2019-07-02 08:27:47.431296 I  Current locale en_US
2019-07-02 08:27:47.431484 N  Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
2019-07-02 08:27:47.458903 I  Starting process signal handler
2019-07-02 08:27:47.462319 I  Starting process manager
2019-07-02 08:27:47.462517 I  Starting IO manager (read)
2019-07-02 08:27:47.462776 I  Starting IO manager (write)
2019-07-02 08:27:47.513335 I  ScreenSaverX11Private: DPMS is active.
2019-07-02 08:27:47.546975 N  Desktop video mode: 1366x768 60.059 Hz
2019-07-02 08:27:47.833971 I  Listening on TCP 0.0.0.0:6547
2019-07-02 08:27:47.836538 I  Listening on TCP [::]:6547
2019-07-02 08:27:50.937982 E  Bonjour: Error: -65537
2019-07-02 08:27:50.937995 E  Bonjour: Failed to register service.
2019-07-02 08:27:50.944912 I  Loading en_us translation for module mythfrontend
2019-07-02 08:27:50.962024 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
			eno: No such file or directory (2)
2019-07-02 08:27:50.962149 I  No joystick configuration found, not enabling joystick control
2019-07-02 08:27:51.336079 E  CECAdapter: Failed to find any CEC devices.
2019-07-02 08:27:51.336344 I  CECAdapter: Closing down CEC.
2019-07-02 08:27:51.336461 I  UDPListener: Enabling
2019-07-02 08:27:51.338607 I  Binding to UDP 0.0.0.0:6948
2019-07-02 08:27:51.338715 I  Binding to UDP [::]:6948
2019-07-02 08:27:51.425337 I  Using Frameless Window
2019-07-02 08:27:51.425349 I  Using Full Screen Window
2019-07-02 08:27:51.486255 I  UI Screen Resolution: 1366 x 768
2019-07-02 08:27:51.498823 I  Using the Qt painter
2019-07-02 08:27:51.504493 I  MythUIHelper: Pruning cache directory: /home/matrix386/.mythtv/cache/remotecache
2019-07-02 08:27:51.504684 I  MythUIHelper: Kept 0 files, deleted 0 files, stat error on 0 files
2019-07-02 08:27:51.504712 I  MythUIHelper: Pruning cache directory: /home/matrix386/.mythtv/cache/thumbnails
2019-07-02 08:27:51.504773 I  MythUIHelper: Kept 0 files, deleted 0 files, stat error on 0 files
2019-07-02 08:27:51.581925 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 26
			Name: 'basemedium'	Type: 'fontdef'
2019-07-02 08:27:51.587163 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 30
			Name: 'basemediumbold'	Type: 'fontdef'
2019-07-02 08:27:51.588766 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 35
			Name: 'baselarge'	Type: 'fontdef'
2019-07-02 08:27:51.590463 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 43
			Name: 'baselargenormal'	Type: 'fontdef'
2019-07-02 08:27:51.592133 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 47
			Name: 'baseextralarge'	Type: 'fontdef'
2019-07-02 08:27:51.593367 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 111
			Name: 'basemedium_normal'	Type: 'fontdef'
2019-07-02 08:27:51.593447 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 114
			Name: 'basemedium_normal_selected'	Type: 'fontdef'
2019-07-02 08:27:51.593535 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 117
			Name: 'basemedium_disabled'	Type: 'fontdef'
2019-07-02 08:27:51.593614 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 120
			Name: 'basemedium_highlight'	Type: 'fontdef'
2019-07-02 08:27:51.593699 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 123
			Name: 'basemedium_normal_button'	Type: 'fontdef'
2019-07-02 08:27:51.593778 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 126
			Name: 'basemedium_selected_button'	Type: 'fontdef'
2019-07-02 08:27:51.593862 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 129
			Name: 'basemedium_disabled_button'	Type: 'fontdef'
libpng warning: iCCP: known incorrect sRGB profile
libpng warning: iCCP: known incorrect sRGB profile
2019-07-02 08:27:51.823405 I  MythUIWebBrowser: Loading css from - file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css
2019-07-02 08:27:51.831305 I  MythUIWebBrowser: enabling plugins
2019-07-02 08:27:51.862041 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2019-07-02 08:27:51.869290 I  MythCoreContext::CheckProtoVersion(): Using protocol version 91 BuzzOff
2019-07-02 08:27:51.938758 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 1178
			Name: 'large'	Type: 'fontdef'
2019-07-02 08:27:51.938854 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/base.xml @ 1184
			Name: 'clock'	Type: 'fontdef'
2019-07-02 08:27:51.962732 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/default/base.xml @ 68
			Name: 'basemediumgrey'	Type: 'fontdef'
2019-07-02 08:27:51.962818 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/default/base.xml @ 72
			Name: 'basemediumgreen'	Type: 'fontdef'
2019-07-02 08:27:51.962899 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/default/base.xml @ 76
			Name: 'basemediumred'	Type: 'fontdef'
2019-07-02 08:27:51.962980 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/default/base.xml @ 80
			Name: 'basemediumyellow'	Type: 'fontdef'
2019-07-02 08:27:52.010598 E  RAOP Device: Aborting startup - no key found.
2019-07-02 08:27:52.014519 I  AirPlay: Created airplay objects.
2019-07-02 08:27:52.022127 I  Current MythTV Schema Version (DBSchemaVer): 1350
2019-07-02 08:27:52.030474 I  Listening on TCP 0.0.0.0:5100
2019-07-02 08:27:52.032392 I  Listening on TCP [::]:5100
2019-07-02 08:27:52.038533 E  Bonjour: Error: -65537
2019-07-02 08:27:52.038546 E  Bonjour: Failed to register service.
2019-07-02 08:27:52.038571 E  AirPlay: Failed to register service.
2019-07-02 08:27:52.675829 N  Registering Internal as a media playback plugin.
2019-07-02 08:27:52.682481 A  MMUnix:CheckMountable: DBus interface error: The name org.freedesktop.UDisks was not provided by any .service files
2019-07-02 08:27:52.685771 W  MMUnix:UDisks2 service found. Media Monitor does not support this yet!
2019-07-02 08:27:52.688984 W  No plugins directory /usr/lib/mythtv/plugins
2019-07-02 08:27:52.696294 E  MythFontProperties: Failed to load 'Liberation Sans', got 'FreeSans' instead
			Location: /usr/share/mythtv/themes/MythCenter/menu-ui.xml @ 7
			Name: 'menufont'	Type: 'fontdef'
2019-07-02 08:27:52.835757 N  Found mainmenu.xml for theme 'MythCenter'
2019-07-02 08:27:52.843093 I  Checking for theme updates every hour
2019-07-02 08:27:52.843580 I  Registering HouseKeeperTask 'HardwareProfiler'.
2019-07-02 08:27:52.846216 I  Starting HouseKeeper.
2019-07-02 08:27:56.740895 E  Error preparing query: SELECT  channum, freqid, channel.sourceid, callsign, name, icon, finetune, videofilters, xmltvid, channel.recpriority, channel.contrast, channel.brightness, channel.colour, channel.hue, tvformat, visible, outputfilters, useonairguide, mplexid, serviceid, atsc_major_chan, atsc_minor_chan, last_record, default_authority, commmethod, tmoffset, iptvid, channel.chanid, GROUP_CONCAT(DISTINCT channelgroup.grpid              ORDER BY channelgroup.grpid), GROUP_CONCAT(DISTINCT capturecard.cardid              ORDER BY livetvorder), MIN(livetvorder) livetvorder FROM channel LEFT JOIN channelgroup ON channel.chanid = channelgroup.chanid LEFT JOIN capturecard  ON capturecard.sourceid = channel.sourceid WHERE channel.visible = :VISIBLE AND channel.livetvorder > 0 GROUP BY channel.chanid ORDER BY callsign = :CALLSIGN1 AND channum = :CHANNUM,          callsign = :CALLSIGN2 DESC,          livetvorder,          channel.recpriority DESC,          chanid 
2019-07-02 08:27:56.740979 E  Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'channel.livetvorder' in 'where clause'

2019-07-02 08:27:56.741871 E  DB Error (ChannelInfo::Load()):
Query was:
SELECT  channum, freqid, channel.sourceid, callsign, name, icon, finetune, videofilters, xmltvid, channel.recpriority, channel.contrast, channel.brightness, channel.colour, channel.hue, tvformat, visible, outputfilters, useonairguide, mplexid, serviceid, atsc_major_chan, atsc_minor_chan, last_record, default_authority, commmethod, tmoffset, iptvid, channel.chanid, GROUP_CONCAT(DISTINCT channelgroup.grpid              ORDER BY channelgroup.grpid), GROUP_CONCAT(DISTINCT capturecard.cardid              ORDER BY livetvorder), MIN(livetvorder) livetvorder FROM channel LEFT JOIN channelgroup ON channel.chanid = channelgroup.chanid LEFT JOIN capturecard  ON capturecard.sourceid = channel.sourceid WHERE channel.visible = 1 AND channel.livetvorder > 0 GROUP BY channel.chanid ORDER BY callsign = '' AND channum = '',          callsign = '' DESC,          livetvorder,          channel.recpriority DESC,          chanid 
Bindings were:
:CALLSIGN1="", :CALLSIGN2="", :CHANNUM="", :VISIBLE=1
Driver error was [2/1054]:
QMYSQL: Unable to execute query
Database error was:
Unknown column 'channel.livetvorder' in 'where clause'

2019-07-02 08:27:56.741979 I  TV::TV(): Creating TV object
2019-07-02 08:27:56.765397 N  Suspending idle timer
2019-07-02 08:27:56.772185 I  TV::Init(): Created TvPlayWindow.
2019-07-02 08:27:56.813032 I  TV::HandleStateChange(): Attempting to change from None to WatchingLiveTV
2019-07-02 08:27:56.816896 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2019-07-02 08:28:03.849699 E  MythSocket(55cd9b3802c0:58): ReadStringList: Error, timed out after 7000 ms.
2019-07-02 08:28:03.849914 E  RemoteEncoder::SendReceiveStringList(): No response.
2019-07-02 08:28:03.852136 E  Error preparing query: SELECT chanid, starttime, endtime, discontinuity, chainpos, hostprefix, cardtype, channame, input FROM tvchain WHERE chainid = :CHAINID ORDER BY chainpos;
2019-07-02 08:28:03.852153 E  Driver error was [2/2006]:
QMYSQL3: Unable to prepare statement
Database error was:
MySQL server has gone away

2019-07-02 08:28:03.852239 I  MySQL server disconnected
2019-07-02 08:28:03.852277 E  GetEntryAt(-1) failed.
2019-07-02 08:28:03.852290 E  It appears that your backend may be misconfigured.  Check your backend logs to determine whether your inputs, lineups, channels, or storage configuration are reporting errors.  This issue is commonly caused by failing to complete all setup steps properly.  You may wish to review the documentation for mythtv-setup.
2019-07-02 08:28:03.852508 E  EntryToProgram(0@1970-01-01T08:00:00) failed to get pginfo
2019-07-02 08:28:03.852525 E  TV::HandleStateChange(): LiveTV not successfully started
2019-07-02 08:28:03.852598 E  TV::HandleStateChange(): LiveTV not successfully started
2019-07-02 08:28:03.854521 I  TV::HandleStateChange(): Main UI disabled.
2019-07-02 08:28:03.854579 I  TV::StartTV(): Entering main playback loop.
2019-07-02 08:28:03.855899 I  ScreenSaverX11Private: DPMS Deactivated 1
2019-07-02 08:28:03.856350 I  TV::StartTV(): Exiting main playback loop.
2019-07-02 08:28:03.868582 E  [DBManager1] Unable to connect to database!
2019-07-02 08:28:03.868632 E  Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111)

2019-07-02 08:28:03.868798 I  MySQL server disconnected
2019-07-02 08:28:03.868875 I  MySQL server disconnected
2019-07-02 08:28:03.868892 E  DB Error (LiveTVChain::DestroyChain):
Query was:

No error type from QSqlError?  Strange...
2019-07-02 08:28:03.869149 N  Resuming idle timer
2019-07-02 08:28:30.635853 E  MythSocket(7efec0015da0:-1): ReadStringList: Connection died.
2019-07-02 08:28:30.636056 N  MythCoreContext::connectionClosed(): Event socket closed.  No connection to the backend.
2019-07-02 08:28:30.636097 E  MythSocket(7efec0015da0:-1): No response.
2019-07-02 08:28:30.636112 N  MythCoreContext::SendReceiveStringList(): Connection to backend server lost
2019-07-02 08:28:30.637632 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2019-07-02 08:28:30.638339 E  MythSocket(7efec002a980:-1): Failed to connect to (127.0.0.1:6543) Connection refused
2019-07-02 08:28:30.638610 E  Connection to master server timed out.
			Either the server is down or the master server settings
			in mythtv-settings does not contain the proper IP address

2019-07-02 08:28:30.638623 C  MythCoreContext::SendReceiveStringList(): Reconnection to backend server failed
2019-07-02 08:28:30.638745 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2019-07-02 08:28:30.639409 E  MythSocket(7efecc18ffe0:-1): Failed to connect to (127.0.0.1:6543) Connection refused
2019-07-02 08:28:30.639547 E  Connection to master server timed out.
			Either the server is down or the master server settings
			in mythtv-settings does not contain the proper IP address

2019-07-02 08:28:30.639652 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2019-07-02 08:28:30.640217 E  MythSocket(55cd9aa438f0:-1): Failed to connect to (127.0.0.1:6543) Connection refused
2019-07-02 08:28:30.640457 E  Connection to master server timed out.
			Either the server is down or the master server settings
			in mythtv-settings does not contain the proper IP address

[matrix386@matrix ~]$ exit

Process shell finished

Last edited by bill6502 on Tue Jul 02, 2019 3:32 pm, edited 1 time in total.
Reason: Added Arch to Subject:

User avatar
bill6502
Developer
Posts: 1335
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV

Post by bill6502 » Tue Jul 02, 2019 3:26 am

Could it be that mysql is restarting? journalctl --unit mysql.service may help (or whatever
you're using, e.g. mariadb.)

There's reference to: channel.livetvorder in one of the messages. That's wrong because
livetvorder is now in the capturecard table, not channel. The logs say you're running v30,
which should be using the correct table.

I think I'd also look in /var/log/mysql/error.log .

matrix432
Newcomer
Posts: 13
Joined: Wed Feb 08, 2017 10:54 am
Australia

Re: Mythbackend crashes when attempt to run LiveTV

Post by matrix432 » Tue Jul 02, 2019 12:13 pm

I've executed `journalctl --unit mariadb.service` in `su` and I've managed to find something. These are the logs I've received this morning when running mythbackend and mythfrontend from mariadb. It seems that ./mythconverg/displayprofiles is corrupted or it could be mariadb saying to report the error. Is there a posibility to revert the database to previous version? Also /var/log/mariadb/error.log and /var/log/mysql/error.log dont exist.

Code: Select all

Jul 02 08:18:06 matrix systemd[1]: Starting MariaDB 10.4.6 database server...
Jul 02 08:18:10 matrix mysqld[3716]: 2019-07-02  8:18:10 0 [Note] /usr/bin/mysqld (mysqld 10.4.6-MariaDB) starting as process 3716 ...
Jul 02 08:18:10 matrix mysqld[3716]: 2019-07-02  8:18:10 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Jul 02 08:18:10 matrix mysqld[3716]: 2019-07-02  8:18:10 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
Jul 02 08:18:10 matrix mysqld[3716]: 2019-07-02  8:18:10 0 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_add>
Jul 02 08:18:10 matrix mysqld[3716]: 2019-07-02  8:18:10 0 [Note] WSREP: Node addr:
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Using Linux native AIO
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Uses event mutexes
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Number of pools: 1
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: Completed initialization of buffer pool
Jul 02 08:18:11 matrix mysqld[3716]: 2019-07-02  8:18:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See t>
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: Waiting for purge to start
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: 10.4.6 started; log sequence number 5988905; transaction id 454407
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] InnoDB: Buffer pool(s) load completed at 190702  8:18:12
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] Server socket created on IP: '::'.
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set>
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Sched>
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please r>
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please r>
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] Reading of all Master_info entries succeeded
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] Added new Master_info '' to hash table
Jul 02 08:18:12 matrix mysqld[3716]: 2019-07-02  8:18:12 0 [Note] /usr/bin/mysqld: ready for connections.
Jul 02 08:18:12 matrix mysqld[3716]: Version: '10.4.6-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Source distribution
Jul 02 08:18:12 matrix systemd[1]: Started MariaDB 10.4.6 database server.
Jul 02 08:20:55 matrix mysqld[3716]: 2019-07-02  8:20:55 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connectio>
Jul 02 08:21:55 matrix mysqld[3716]: 2019-07-02  8:21:55 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connect>
Jul 02 08:22:05 matrix mysqld[3716]: 2019-07-02  8:22:05 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connect>
Jul 02 08:22:07 matrix mysqld[3716]: 2019-07-02  8:22:07 19 [ERROR] mysqld: Table './mythconverg/displayprofiles' is marked as crashed and should be repaired
Jul 02 08:22:07 matrix mysqld[3716]: 2019-07-02  8:22:07 19 [Warning] Checking table:   './mythconverg/displayprofiles'
Jul 02 08:23:19 matrix mysqld[3716]: 190702  8:23:19 [ERROR] mysqld got signal 11 ;
Jul 02 08:23:19 matrix mysqld[3716]: This could be because you hit a bug. It is also possible that this binary
Jul 02 08:23:19 matrix mysqld[3716]: or one of the libraries it was linked against is corrupt, improperly built,
Jul 02 08:23:19 matrix mysqld[3716]: or misconfigured. This error can also be caused by malfunctioning hardware.
Jul 02 08:23:19 matrix mysqld[3716]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Jul 02 08:23:19 matrix mysqld[3716]: We will try our best to scrape up some info that will hopefully help
Jul 02 08:23:19 matrix mysqld[3716]: diagnose the problem, but since we have already crashed,
Jul 02 08:23:19 matrix mysqld[3716]: something is definitely wrong and this may fail.
Jul 02 08:23:19 matrix mysqld[3716]: Server version: 10.4.6-MariaDB
Jul 02 08:23:19 matrix mysqld[3716]: key_buffer_size=134217728
Jul 02 08:23:19 matrix mysqld[3716]: read_buffer_size=131072
Jul 02 08:23:19 matrix mysqld[3716]: max_used_connections=15
Jul 02 08:23:19 matrix mysqld[3716]: max_threads=153
Jul 02 08:23:19 matrix mysqld[3716]: thread_count=21
Jul 02 08:23:19 matrix mysqld[3716]: It is possible that mysqld could use up to
Jul 02 08:23:19 matrix mysqld[3716]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467732 K  bytes of memory
Jul 02 08:23:19 matrix mysqld[3716]: Hope that's ok; if not, decrease some variables in the equation.
Jul 02 08:23:19 matrix mysqld[3716]: Thread pointer: 0x7f984d433008
Jul 02 08:23:19 matrix mysqld[3716]: Attempting backtrace. You can use the following information to find out
Jul 02 08:23:19 matrix mysqld[3716]: where mysqld died. If you see no messages after this, something went
Jul 02 08:23:19 matrix mysqld[3716]: terribly wrong...
Jul 02 08:23:19 matrix mysqld[3716]: stack_bottom = 0x7f984d97c5b8 thread_stack 0x49000
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(my_print_stacktrace+0x2a)[0x560d60eca56a]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(handle_fatal_signal+0x578)[0x560d609e6158]
Jul 02 08:23:19 matrix mysqld[3716]: sigaction.c:0(__restore_rt)[0x7f984f735d00]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z7sortcmpPK6StringS1_PK15charset_info_st+0xe)[0x560d6086b1fe]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZNK26Type_handler_string_result13Item_const_eqEPK10Item_constS2_b+0xc7)[0x560d60926df7]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZN4Item15eq_by_collationEPS_bPK15charset_info_st+0x62)[0x560d60a07f82]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZN9Item_cond14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM+0x279)[0x560d60812d39]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZN13Item_cond_and14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM+0x4a)[0x560d60812a7a]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(+0x68dc5b)[0x560d60813c5b]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZN4JOIN14optimize_innerEv+0x1d8f)[0x560d60842b2f]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZN4JOIN8optimizeEv+0x94)[0x560d60844b04]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st>
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x154)[0x560d608464b4]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(+0x652d8c)[0x560d607d8d8c]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z21mysql_execute_commandP3THD+0x773e)[0x560d607e7eae]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x400)[0x560d607fd8c0]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x84)[0x560d607fda74]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(+0x67865e)[0x560d607fe65e]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x22)[0x560d607fe702]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xc7b)[0x560d607ec0eb]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z10do_commandP3THD+0x151)[0x560d607eecf1]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x22e)[0x560d608d12ae]
Jul 02 08:23:19 matrix mysqld[3716]: /usr/bin/mysqld(handle_one_connection+0x33)[0x560d608d1403]
Jul 02 08:23:19 matrix mysqld[3716]: pthread_create.c:0(start_thread)[0x7f984f72b57f]
Jul 02 08:23:19 matrix mysqld[3716]: :0(__GI___clone)[0x7f984efa80e3]
Jul 02 08:23:19 matrix mysqld[3716]: Trying to get some variables.
Jul 02 08:23:19 matrix mysqld[3716]: Some pointers may be invalid and cause the dump to abort.
Jul 02 08:23:19 matrix mysqld[3716]: Query (0x7f984d490d80): SELECT recordid, category,        (category = ?) AS catmatch,        (category = ?) AS typematch FROM recor>
Jul 02 08:23:19 matrix mysqld[3716]: Connection ID (thread ID): 11
Jul 02 08:23:19 matrix mysqld[3716]: Status: NOT_KILLED
Jul 02 08:23:19 matrix mysqld[3716]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_inters>
Jul 02 08:23:19 matrix mysqld[3716]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Jul 02 08:23:19 matrix mysqld[3716]: information that should help you find out what is causing the crash.
Jul 02 08:23:19 matrix mysqld[3716]: Writing a core file...
Jul 02 08:23:19 matrix mysqld[3716]: Working directory at /var/lib/mysql
Jul 02 08:23:19 matrix mysqld[3716]: Resource Limits:
Jul 02 08:23:19 matrix mysqld[3716]: Limit                     Soft Limit           Hard Limit           Units
Jul 02 08:23:19 matrix mysqld[3716]: Max cpu time              unlimited            unlimited            seconds
Jul 02 08:23:19 matrix mysqld[3716]: Max file size             unlimited            unlimited            bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max data size             unlimited            unlimited            bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max stack size            8388608              unlimited            bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max core file size        unlimited            unlimited            bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max resident set          unlimited            unlimited            bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max processes             31362                31362                processes
Jul 02 08:23:19 matrix mysqld[3716]: Max open files            16364                16364                files
Jul 02 08:23:19 matrix mysqld[3716]: Max locked memory         65536                65536                bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max address space         unlimited            unlimited            bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max file locks            unlimited            unlimited            locks
Jul 02 08:23:19 matrix mysqld[3716]: Max pending signals       31362                31362                signals
Jul 02 08:23:19 matrix mysqld[3716]: Max msgqueue size         819200               819200               bytes
Jul 02 08:23:19 matrix mysqld[3716]: Max nice priority         0                    0
Jul 02 08:23:19 matrix mysqld[3716]: Max realtime priority     0                    0
Jul 02 08:23:19 matrix mysqld[3716]: Max realtime timeout      unlimited            unlimited            us
Jul 02 08:23:19 matrix mysqld[3716]: Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e
Jul 02 08:23:23 matrix systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jul 02 08:23:23 matrix systemd[1]: mariadb.service: Failed with result 'signal'.
Jul 02 08:23:28 matrix systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Jul 02 08:23:28 matrix systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1.
Jul 02 08:23:28 matrix systemd[1]: Stopped MariaDB 10.4.6 database server.
Jul 02 08:23:28 matrix systemd[1]: Starting MariaDB 10.4.6 database server...
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] /usr/bin/mysqld (mysqld 10.4.6-MariaDB) starting as process 4442 ...
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Using Linux native AIO
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Uses event mutexes
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Number of pools: 1
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Completed initialization of buffer pool
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See t>
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5988984
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Waiting for purge to start
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: 10.4.6 started; log sequence number 5988993; transaction id 454407
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] InnoDB: Buffer pool(s) load completed at 190702  8:23:29
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] Server socket created on IP: '::'.
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set>
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Sched>
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please r>
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please r>
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] Reading of all Master_info entries succeeded
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] Added new Master_info '' to hash table
Jul 02 08:23:29 matrix mysqld[4442]: 2019-07-02  8:23:29 0 [Note] /usr/bin/mysqld: ready for connections.
Jul 02 08:23:29 matrix mysqld[4442]: Version: '10.4.6-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Source distribution
Jul 02 08:23:29 matrix systemd[1]: Started MariaDB 10.4.6 database server.
Jul 02 08:27:30 matrix mysqld[4442]: 2019-07-02  8:27:30 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connectio>
Jul 02 08:27:30 matrix mysqld[4442]: 2019-07-02  8:27:30 10 [ERROR] mysqld: Table './mythconverg/settings' is marked as crashed and should be repaired
Jul 02 08:27:30 matrix mysqld[4442]: 2019-07-02  8:27:30 10 [Warning] Checking table:   './mythconverg/settings'
Jul 02 08:27:46 matrix mysqld[4442]: 2019-07-02  8:27:46 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connect>
Jul 02 08:27:52 matrix mysqld[4442]: 2019-07-02  8:27:52 18 [ERROR] mysqld: Table './mythconverg/displayprofiles' is marked as crashed and should be repaired
Jul 02 08:27:52 matrix mysqld[4442]: 2019-07-02  8:27:52 18 [Warning] Checking table:   './mythconverg/displayprofiles'
Jul 02 08:27:57 matrix mysqld[4442]: 190702  8:27:57 [ERROR] mysqld got signal 11 ;
Jul 02 08:27:57 matrix mysqld[4442]: This could be because you hit a bug. It is also possible that this binary
Jul 02 08:27:57 matrix mysqld[4442]: or one of the libraries it was linked against is corrupt, improperly built,
Jul 02 08:27:57 matrix mysqld[4442]: or misconfigured. This error can also be caused by malfunctioning hardware.
Jul 02 08:27:57 matrix mysqld[4442]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Jul 02 08:27:57 matrix mysqld[4442]: We will try our best to scrape up some info that will hopefully help
Jul 02 08:27:57 matrix mysqld[4442]: diagnose the problem, but since we have already crashed,
Jul 02 08:27:57 matrix mysqld[4442]: something is definitely wrong and this may fail.
Jul 02 08:27:57 matrix mysqld[4442]: Server version: 10.4.6-MariaDB
Jul 02 08:27:57 matrix mysqld[4442]: key_buffer_size=134217728
Jul 02 08:27:57 matrix mysqld[4442]: read_buffer_size=131072
Jul 02 08:27:57 matrix mysqld[4442]: max_used_connections=15
Jul 02 08:27:57 matrix mysqld[4442]: max_threads=153
Jul 02 08:27:57 matrix mysqld[4442]: thread_count=21
Jul 02 08:27:57 matrix mysqld[4442]: It is possible that mysqld could use up to
Jul 02 08:27:57 matrix mysqld[4442]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467732 K  bytes of memory
Jul 02 08:27:57 matrix mysqld[4442]: Hope that's ok; if not, decrease some variables in the equation.
Jul 02 08:27:57 matrix mysqld[4442]: Thread pointer: 0x7fc4194585c8
Jul 02 08:27:57 matrix mysqld[4442]: Attempting backtrace. You can use the following information to find out
Jul 02 08:27:57 matrix mysqld[4442]: where mysqld died. If you see no messages after this, something went
Jul 02 08:27:57 matrix mysqld[4442]: terribly wrong...
Jul 02 08:27:57 matrix mysqld[4442]: stack_bottom = 0x7fc41997c5b8 thread_stack 0x49000
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(my_print_stacktrace+0x2a)[0x555730efa56a]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(handle_fatal_signal+0x578)[0x555730a16158]
Jul 02 08:27:57 matrix mysqld[4442]: sigaction.c:0(__restore_rt)[0x7fc41b726d00]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z7sortcmpPK6StringS1_PK15charset_info_st+0xe)[0x55573089b1fe]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZNK26Type_handler_string_result13Item_const_eqEPK10Item_constS2_b+0xc7)[0x555730956df7]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZN4Item15eq_by_collationEPS_bPK15charset_info_st+0x62)[0x555730a37f82]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZN9Item_cond14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM+0x279)[0x555730842d39]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZN13Item_cond_and14add_key_fieldsEP4JOINPP9KEY_FIELDPjyPP14SARGABLE_PARAM+0x4a)[0x555730842a7a]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(+0x68dc5b)[0x555730843c5b]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZN4JOIN14optimize_innerEv+0x1d8f)[0x555730872b2f]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZN4JOIN8optimizeEv+0x94)[0x555730874b04]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st>
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x154)[0x5557308764b4]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(+0x652d8c)[0x555730808d8c]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z21mysql_execute_commandP3THD+0x773e)[0x555730817eae]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x400)[0x55573082d8c0]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x84)[0x55573082da74]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(+0x67865e)[0x55573082e65e]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x22)[0x55573082e702]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xc7b)[0x55573081c0eb]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z10do_commandP3THD+0x151)[0x55573081ecf1]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x22e)[0x5557309012ae]
Jul 02 08:27:57 matrix mysqld[4442]: /usr/bin/mysqld(handle_one_connection+0x33)[0x555730901403]
Jul 02 08:27:57 matrix mysqld[4442]: pthread_create.c:0(start_thread)[0x7fc41b71c57f]
Jul 02 08:27:57 matrix mysqld[4442]: :0(__GI___clone)[0x7fc41af990e3]
Jul 02 08:27:57 matrix mysqld[4442]: Trying to get some variables.
Jul 02 08:27:57 matrix mysqld[4442]: Some pointers may be invalid and cause the dump to abort.
Jul 02 08:27:57 matrix mysqld[4442]: Query (0x7fc4194b1100): SELECT recordid, category,        (category = ?) AS catmatch,        (category = ?) AS typematch FROM recor>
Jul 02 08:27:57 matrix mysqld[4442]: Connection ID (thread ID): 11
Jul 02 08:27:57 matrix mysqld[4442]: Status: NOT_KILLED
Jul 02 08:27:57 matrix mysqld[4442]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_inters>
Jul 02 08:27:57 matrix mysqld[4442]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Jul 02 08:27:57 matrix mysqld[4442]: information that should help you find out what is causing the crash.
Jul 02 08:27:57 matrix mysqld[4442]: Writing a core file...
Jul 02 08:27:57 matrix mysqld[4442]: Working directory at /var/lib/mysql
Jul 02 08:27:57 matrix mysqld[4442]: Resource Limits:
Jul 02 08:27:57 matrix mysqld[4442]: Limit                     Soft Limit           Hard Limit           Units
Jul 02 08:27:57 matrix mysqld[4442]: Max cpu time              unlimited            unlimited            seconds
Jul 02 08:27:57 matrix mysqld[4442]: Max file size             unlimited            unlimited            bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max data size             unlimited            unlimited            bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max stack size            8388608              unlimited            bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max core file size        unlimited            unlimited            bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max resident set          unlimited            unlimited            bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max processes             31362                31362                processes
Jul 02 08:27:57 matrix mysqld[4442]: Max open files            16364                16364                files
Jul 02 08:27:57 matrix mysqld[4442]: Max locked memory         65536                65536                bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max address space         unlimited            unlimited            bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max file locks            unlimited            unlimited            locks
Jul 02 08:27:57 matrix mysqld[4442]: Max pending signals       31362                31362                signals
Jul 02 08:27:57 matrix mysqld[4442]: Max msgqueue size         819200               819200               bytes
Jul 02 08:27:57 matrix mysqld[4442]: Max nice priority         0                    0
Jul 02 08:27:57 matrix mysqld[4442]: Max realtime priority     0                    0
Jul 02 08:27:57 matrix mysqld[4442]: Max realtime timeout      unlimited            unlimited            us
Jul 02 08:27:57 matrix mysqld[4442]: Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e
Jul 02 08:28:01 matrix systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jul 02 08:28:01 matrix systemd[1]: mariadb.service: Failed with result 'signal'.
Jul 02 08:28:06 matrix systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Jul 02 08:28:06 matrix systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 2.
Jul 02 08:28:06 matrix systemd[1]: Stopped MariaDB 10.4.6 database server.
Jul 02 08:28:06 matrix systemd[1]: Starting MariaDB 10.4.6 database server...
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] /usr/bin/mysqld (mysqld 10.4.6-MariaDB) starting as process 4700 ...
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Using Linux native AIO
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Uses event mutexes
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Number of pools: 1
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Completed initialization of buffer pool
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See t>
Jul 02 08:28:07 matrix mysqld[4700]: 2019-07-02  8:28:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5989002
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: Waiting for purge to start
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: 10.4.6 started; log sequence number 5989011; transaction id 454407
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] InnoDB: Buffer pool(s) load completed at 190702  8:28:08
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] Server socket created on IP: '::'.
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set>
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Sched>
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please r>
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 6 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please r>
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] Reading of all Master_info entries succeeded
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] Added new Master_info '' to hash table
Jul 02 08:28:08 matrix mysqld[4700]: 2019-07-02  8:28:08 0 [Note] /usr/bin/mysqld: ready for connections.
Jul 02 08:28:08 matrix mysqld[4700]: Version: '10.4.6-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Source distribution
Jul 02 08:28:08 matrix systemd[1]: Started MariaDB 10.4.6 database server.
Jul 02 10:28:15 matrix mysqld[4700]: 2019-07-02 10:28:15 0 [Note] /usr/bin/mysqld (initiated by: unknown): Normal shutdown
Jul 02 10:28:15 matrix mysqld[4700]: 2019-07-02 10:28:15 0 [Note] InnoDB: FTS optimize thread exiting.
Jul 02 10:28:15 matrix systemd[1]: Stopping MariaDB 10.4.6 database server...
Jul 02 10:28:15 matrix mysqld[4700]: 2019-07-02 10:28:15 0 [Note] InnoDB: Starting shutdown...
Jul 02 10:28:15 matrix mysqld[4700]: 2019-07-02 10:28:15 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Jul 02 10:28:15 matrix mysqld[4700]: 2019-07-02 10:28:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 190702 10:28:15
Jul 02 10:28:17 matrix mysqld[4700]: 2019-07-02 10:28:17 0 [Note] InnoDB: Shutdown completed; log sequence number 5989029; transaction id 454408
Jul 02 10:28:17 matrix mysqld[4700]: 2019-07-02 10:28:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jul 02 10:28:17 matrix mysqld[4700]: 2019-07-02 10:28:17 0 [Note] /usr/bin/mysqld: Shutdown complete
Jul 02 10:28:17 matrix systemd[1]: mariadb.service: Succeeded.
Jul 02 10:28:17 matrix systemd[1]: Stopped MariaDB 10.4.6 database server.

User avatar
bill6502
Developer
Posts: 1335
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV

Post by bill6502 » Tue Jul 02, 2019 2:17 pm

Hi,

The journal says a lot. I'd forget about MythTV for now. MariaDB is is bad shape. Segment Violations with core dumps,
trouble in the mysql DB itself... . And note this:

Code: Select all

It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Maybe help on a DB forum would be best. Or, remove and reinstall MariaDB completely (not necessarily the DB itself,
as that may be recoverable.) Hopefully, you've got MythTV DB backups though.

When I look at my journal for mariadb.service, there are only 8 'normal' lines each time it starts, nothing like the
notes/warnings/errors in yours.

My comment about livetvorder above is correct, however there was a fix for one instance of it just two days after the
initial v30.0 release. The commit you're running on is the initial one. See if Arch has a way to update MythTV and get
fixed. Again, fix MariaDB before worrying about MythTV.

matrix432
Newcomer
Posts: 13
Joined: Wed Feb 08, 2017 10:54 am
Australia

Re: Mythbackend crashes when attempt to run LiveTV

Post by matrix432 » Tue Jul 02, 2019 3:20 pm

I've uninstalled and re-installed mariadb but the error still persists and checked mysql and mariadb databases for such errors on mythconverg, but there are no reports of such error, so I will report it officially on their website according to the received logs. Also the version of mariadb and mythtv on arch are still up to date and I'm going to have to wait for a while until they produce a new compilation package. I can install the latest version of mythtv by using the github repository and executing the 'make' and 'make install' commands, but then it wont be maintained properly by arch as it wont appear in the package list as installed. The error has been searched and came across to a command 'mysqlcheck -uUSER -pPASSWORD --repair --extended user_base' on stackoverflow but this is not a database error as most of the articles online suggest.

User avatar
bill6502
Developer
Posts: 1335
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV

Post by bill6502 » Tue Jul 02, 2019 3:31 pm

I'll change the original Subject to include Arch, just in case it attracts some more eyes. If you
disagree, please remove my changes.

Assuming you've got (or can make) a backup, then you could decouple the MariaDB errors
from MythTV by using mysql and dropping the mythconverg database. I wouldn't do that as
the journal entry about corrupt libraries (etc.) points to a MariaDB issue.

chrismate
Newcomer
Posts: 5
Joined: Fri Jul 19, 2019 9:15 am
France

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by chrismate » Fri Jul 19, 2019 9:58 am

Hello
I've got exactly the same problem with LiveTV.
It all seems to have started going wrong with Mythtv 30 from the AUR. The error messages keep telling me that the backend may be misconfigured but I've tried everything I can think of.
I have completely re-installed Mythtv & Mariadb from scratch to try to solve the problem. No deal.
I've had a working Mythtv for years but I am at a loss at how to get this working.

chrismate
Newcomer
Posts: 5
Joined: Fri Jul 19, 2019 9:15 am
France

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by chrismate » Fri Jul 19, 2019 11:55 am

Hello again
Further info on my recent post:
Following bill6502's comments on the channel.livetvorder & capturecard.livetvorder here is my mythconverg description:

Code: Select all

MariaDB [mythconverg]> desc channel;
+-------------------+-----------------------+------+-----+---------+-------+
| Field             | Type                  | Null | Key | Default | Extra |
+-------------------+-----------------------+------+-----+---------+-------+
| chanid            | int(10) unsigned      | NO   | PRI | 0       |       |
| channum           | varchar(10)           | NO   | MUL |         |       |
| freqid            | varchar(10)           | YES  |     | NULL    |       |
| sourceid          | int(10) unsigned      | YES  | MUL | NULL    |       |
| callsign          | varchar(20)           | NO   |     |         |       |
| name              | varchar(64)           | NO   |     |         |       |
| icon              | varchar(255)          | NO   |     |         |       |
| finetune          | int(11)               | YES  |     | NULL    |       |
| videofilters      | varchar(255)          | NO   |     |         |       |
| xmltvid           | varchar(255)          | NO   |     |         |       |
| recpriority       | int(10)               | NO   |     | 0       |       |
| contrast          | int(11)               | YES  |     | 32768   |       |
| brightness        | int(11)               | YES  |     | 32768   |       |
| colour            | int(11)               | YES  |     | 32768   |       |
| hue               | int(11)               | YES  |     | 32768   |       |
| tvformat          | varchar(10)           | NO   |     | Default |       |
| visible           | tinyint(1)            | NO   | MUL | 1       |       |
| outputfilters     | varchar(255)          | NO   |     |         |       |
| useonairguide     | tinyint(1)            | YES  |     | 0       |       |
| mplexid           | smallint(6)           | YES  |     | NULL    |       |
| serviceid         | mediumint(8) unsigned | YES  |     | NULL    |       |
| tmoffset          | int(11)               | NO   |     | 0       |       |
| atsc_major_chan   | int(10) unsigned      | NO   |     | 0       |       |
| atsc_minor_chan   | int(10) unsigned      | NO   |     | 0       |       |
| last_record       | datetime              | NO   |     | NULL    |       |
| default_authority | varchar(32)           | NO   |     |         |       |
| commmethod        | int(11)               | NO   |     | -1      |       |
| iptvid            | smallint(6) unsigned  | YES  |     | NULL    |       |
+-------------------+-----------------------+------+-----+---------+-------+
28 rows in set (0.006 sec)

MariaDB [mythconverg]> desc 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.007 sec)
I'm not a db man but those dumps suggest to me that the db structure is correct with the 'livetvorder' in the correct 'capturecard' column, and that the problem is with the query within MythTV 30. (It was downloaded from the Arch AUR yesterday and is the regular version not the -git version.)
Anybody have any ideas ?
Hope I have posted this correctly, it's my first time.

User avatar
bill6502
Developer
Posts: 1335
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by bill6502 » Fri Jul 19, 2019 1:37 pm

@chrismate, I see two issues in this thread. The initial one had/has the DB server
failing. I assume that's not your case.

The 2nd is reference to channel.livetvorder. That was a bug that was fixed on: Wed Jan 16 23:36:51 2019 -0600
Ref commit: [07fc9359b3]. That suggests that Arch is distributing an old version of MythTV.

You can get yours version with: mythbackend --version | egrep 'MythTV Version|Library API'
Last edited by bill6502 on Fri Jul 19, 2019 6:10 pm, edited 1 time in total.
Reason: Update commit for v30, not v31

chrismate
Newcomer
Posts: 5
Joined: Fri Jul 19, 2019 9:15 am
France

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by chrismate » Fri Jul 19, 2019 3:36 pm

Thanks bill6502 for the info. I'm on:
MythTV Version : v30.0-76a78d844cf
Library API : 30.20181231-1
I'll try the -git version and see if that works.
Cheers

User avatar
bill6502
Developer
Posts: 1335
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by bill6502 » Fri Jul 19, 2019 6:14 pm

The commit after the one you're running on fixed the issue. If Arch doesn't
provide updates, then git will work.

chrismate
Newcomer
Posts: 5
Joined: Fri Jul 19, 2019 9:15 am
France

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by chrismate » Tue Jul 23, 2019 4:37 pm

Hello
Ok, I have now resolved the channel.livetvorder issue by installing the latest MythTV-git version as you suggested. Thanks.
However, I still cannot play liveTV and I am now having DB crash problems similar to matrix432.
Here is my journalctl from my freshly booted back/front-end machine:
(It's too large for the editor)
journalctl.txt
(93.79 KiB) Downloaded 9 times
and the frontend:

Code: Select all

[mythtv@mythtv-mbe ~]$ /usr/bin/mythfrontend
2019-07-23 16:59:55.117956 I  Setup Interrupt handler
2019-07-23 16:59:55.118059 I  Setup Terminated handler
2019-07-23 16:59:55.118089 I  Setup Segmentation fault handler
2019-07-23 16:59:55.118117 I  Setup Aborted handler
2019-07-23 16:59:55.118143 I  Setup Bus error handler
2019-07-23 16:59:55.118172 I  Setup Floating point exception handler
2019-07-23 16:59:55.118197 I  Setup Illegal instruction handler
2019-07-23 16:59:55.118229 I  Setup Real-time signal 0 handler
2019-07-23 16:59:55.118261 I  Setup User defined signal 1 handler
2019-07-23 16:59:55.118286 I  Setup User defined signal 2 handler
2019-07-23 16:59:55.118311 I  Setup Hangup handler
2019-07-23 16:59:55.118663 C  mythfrontend version: makepkg [v30.0-67-ga4bc92e244-dirty] www.mythtv.org
2019-07-23 16:59:55.118686 C  Qt version: compile: 5.13.0, runtime: 5.13.0
2019-07-23 16:59:55.118694 N  Enabled verbose msgs:  general
2019-07-23 16:59:55.118747 N  Setting Log Level to LOG_INFO
2019-07-23 16:59:55.129876 N  Using runtime prefix = /usr
2019-07-23 16:59:55.129892 N  Using configuration directory = /home/mythtv/.mythtv
2019-07-23 16:59:55.130238 I  Added logging to the console
2019-07-23 16:59:55.130395 I  Assumed character encoding: en_GB.UTF-8
2019-07-23 16:59:55.135635 I  Loading en_gb translation for module mythfrontend
2019-07-23 16:59:55.137311 I  Empty LocalHostName. This is typical.
2019-07-23 16:59:55.137367 I  Using a profile name of: 'mythtv-mbe.advnet.lan' (Usually the same as this host's name.)
2019-07-23 16:59:55.137798 I  Start up testing connections. DB 192.168.8.88, BE , attempt 0, status start, Delay: 2000
2019-07-23 16:59:57.204691 N  Setting QT default locale to en_GB
2019-07-23 16:59:57.204847 I  Current locale en_GB
2019-07-23 16:59:57.205571 N  Reading locale defaults from /usr/share/mythtv//locales/en_gb.xml
2019-07-23 16:59:57.246346 I  Starting process manager
2019-07-23 16:59:57.250209 I  Starting process signal handler
2019-07-23 16:59:57.253132 I  Starting IO manager (read)
2019-07-23 16:59:57.253612 I  Starting IO manager (write)
2019-07-23 16:59:57.351905 I  ScreenSaverX11Private: XScreenSaver support enabled
2019-07-23 16:59:57.358300 I  ScreenSaverX11Private: DPMS is disabled.
2019-07-23 16:59:57.403485 N  Desktop video mode: 1920x1080 60.000 Hz
2019-07-23 16:59:57.902664 I  Listening on TCP 0.0.0.0:6547
2019-07-23 16:59:57.905745 I  Listening on TCP [::]:6547
2019-07-23 17:00:00.416235 E  Bonjour: Error: -65537
2019-07-23 17:00:00.416257 E  Bonjour: Failed to register service.
2019-07-23 17:00:00.424935 I  Loading en_gb translation for module mythfrontend
2019-07-23 17:00:00.446380 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
			eno: No such file or directory (2)
2019-07-23 17:00:00.446515 I  No joystick configuration found, not enabling joystick control
2019-07-23 17:00:00.447531 I  CECAdapter: libCEC support is disabled.
2019-07-23 17:00:00.447633 I  UDPListener: Enabling
2019-07-23 17:00:00.449126 I  Binding to UDP 0.0.0.0:6948
2019-07-23 17:00:00.449386 I  Binding to UDP [::]:6948
2019-07-23 17:00:00.546373 I  UI Screen Resolution: 1920 x 1049
2019-07-23 17:00:00.694334 W  OpenGL: Could not determine whether Sync to VBlank is enabled.
2019-07-23 17:00:00.820366 I  Trying the OpenGL 2.0 render
2019-07-23 17:00:00.825691 I  OpenGL painter using existing OpenGL context.
2019-07-23 17:00:00.901234 I  OpenGL2: GLSL supported
2019-07-23 17:00:00.901343 I  OpenGL: OpenGL vendor  : Intel Open Source Technology Center
2019-07-23 17:00:00.901357 I  OpenGL: OpenGL renderer: Mesa DRI Intel(R) HD Graphics 400 (Braswell) 
2019-07-23 17:00:00.901365 I  OpenGL: OpenGL version : 3.0 Mesa 19.1.2
2019-07-23 17:00:00.901377 I  OpenGL: Max texture size: 16384 x 16384
2019-07-23 17:00:00.901466 I  OpenGL: Max texture units: 8
2019-07-23 17:00:00.901479 I  OpenGL: Direct rendering: Yes
2019-07-23 17:00:00.901493 I  OpenGL: Extensions Supported: 3e1b
2019-07-23 17:00:00.901500 I  OpenGL: PixelBufferObject support available
2019-07-23 17:00:00.909176 I  OpenGL: Initialised MythRenderOpenGL
2019-07-23 17:00:00.927003 I  MythUIHelper: Pruning cache directory: /home/mythtv/.mythtv/cache/remotecache
2019-07-23 17:00:00.930190 I  MythUIHelper: Kept 3 files, deleted 0 files, stat error on 0 files
2019-07-23 17:00:00.930233 I  MythUIHelper: Pruning cache directory: /home/mythtv/.mythtv/cache/thumbnails
2019-07-23 17:00:00.935248 I  MythUIHelper: Kept 22 files, deleted 0 files, stat error on 0 files
2019-07-23 17:00:01.453738 I  MythUIWebBrowser: Loading css from - file:///usr/share/mythtv/themes/default/htmls/mythbrowser.css
2019-07-23 17:00:01.462853 I  MythUIWebBrowser: enabling plugins
2019-07-23 17:00:01.532127 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 192.168.8.88:6543 (try 1 of 5)
2019-07-23 17:00:01.543484 I  MythCoreContext::CheckProtoVersion(): Using protocol version 91 BuzzOff
2019-07-23 17:00:01.717424 I  Current MythTV Schema Version (DBSchemaVer): 1350
2019-07-23 17:00:02.511968 N  Registering Internal as a media playback plugin.
2019-07-23 17:00:02.516379 A  MMUnix:CheckMountable: DBus interface error: The name org.freedesktop.UDisks was not provided by any .service files
2019-07-23 17:00:02.518708 W  MMUnix:UDisks2 service found. Media Monitor does not support this yet!
2019-07-23 17:00:02.525939 W  No plugins directory /usr/lib/mythtv/plugins
2019-07-23 17:00:02.665898 N  Found mainmenu.xml for theme 'MythCenter-wide'
2019-07-23 17:00:02.673729 I  Checking for theme updates every hour
2019-07-23 17:00:02.674411 I  Registering HouseKeeperTask 'HardwareProfiler'.
2019-07-23 17:00:02.677209 I  Starting HouseKeeper.
2019-07-23 17:00:08.080757 I  TV::TV(): Creating TV object
2019-07-23 17:00:08.112671 I  TV::Init(): Created TvPlayWindow.
2019-07-23 17:00:08.145709 I  TV::HandleStateChange(): Attempting to change from None to WatchingLiveTV
2019-07-23 17:00:08.155107 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 192.168.8.88:6543 (try 1 of 5)
2019-07-23 17:00:13.399193 E  Error preparing query: SELECT chanid, starttime, endtime, discontinuity, chainpos, hostprefix, cardtype, channame, input FROM tvchain WHERE chainid = :CHAINID ORDER BY chainpos;
2019-07-23 17:00:13.399256 E  Driver error was [2/2013]:
QMYSQL3: Unable to prepare statement
Database error was:
Lost connection to MySQL server during query

2019-07-23 17:00:13.399647 E  GetEntryAt(-1) failed.
2019-07-23 17:00:13.399655 E  It appears that your backend may be misconfigured.  Check your backend logs to determine whether your inputs, lineups, channels, or storage configuration are reporting errors.  This issue is commonly caused by failing to complete all setup steps properly.  You may wish to review the documentation for mythtv-setup.
2019-07-23 17:00:13.399879 E  EntryToProgram(0@1970-01-01T01:00:00) failed to get pginfo
2019-07-23 17:00:13.399896 E  TV::HandleStateChange(): LiveTV not successfully started
2019-07-23 17:00:13.400603 E  TV::HandleStateChange(): LiveTV not successfully started
2019-07-23 17:00:13.405851 I  TV::HandleStateChange(): Main UI disabled.
2019-07-23 17:00:13.405909 I  TV::StartTV(): Entering main playback loop.
2019-07-23 17:00:13.410506 I  Using WOL to wakeup database server (Try 1 of 5)
2019-07-23 17:00:13.410674 I  Locking input devices
2019-07-23 17:00:20.638194 I  TV::StartTV(): Exiting main playback loop.
2019-07-23 17:00:20.638387 I  Unlocking input devices
I did notice the journalctl entry:

Code: Select all

Jul 23 17:00:13 mythtv-mbe.advnet.lan mythbackend[476]: 2019-07-23 17:00:13.397788 E  TFW(1000_20190723150058.ts:-1): Opening file '1000_20190723150058.ts'.
Jul 23 17:00:13 mythtv-mbe.advnet.lan mythbackend[476]:                         eno: Permission denied (13)
Jul 23 17:00:13 mythtv-mbe.advnet.lan mythbackend[476]: 2019-07-23 17:00:13.397882 E  TVRec[2]: RingBuffer '1000_20190723150058.ts' not open...
but I have given all my storage folders 777 permissions, and they all worked before the upgrade.

Also, I attempted to get the -git version of mariadb but, unfortunately, I couldn't get it to build on my system.
Hope this proves useful.

User avatar
bill6502
Developer
Posts: 1335
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by bill6502 » Wed Jul 24, 2019 3:03 am

Hi,

I'd forget about MythTV until the MariaDB issues are fixed. The Threaded File Writer (TFW)
line just above this has a file name where a full path should be. It's trying to write to whatever
directory the backend was started in. [Even though you mention setting up Storage Directories,
and that setting is stored in the mythconverg database.]

I don't use Arch and looking at the OS tab here: https://smolt.mythtv.org/static/stats/stats.html
no one else is (but this data is only for folks that have opted-in to provide it.) I know I've seen
others using Arch in the past. I'm not suggesting an OS change.

I was hoping that changing the Subject might prompt another Arch user to answer this, but so far, no.

I did search for Arch and MariaDB issues and found this: https://wiki.archlinux.org/index.php/Ma ... leshooting
but my guess is that you've already been there.

The mysqld (MariaDB) core dump and the

Code: Select all

This could be because you hit a bug. It is also possible that this binary
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
lines further suggest an SQL issue.

tjbron
Newcomer
Posts: 2
Joined: Thu Jun 30, 2016 9:17 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by tjbron » Wed Jul 31, 2019 2:20 am

Heya,
Fellow Arch MythTV user here. I guess we are just an underrepresented minority anymore. I'm a bit disheartened to read these posts, as I was hoping to find a solution to the same problem.

User avatar
bill6502
Developer
Posts: 1335
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend crashes when attempt to run LiveTV [Arch installation with MariaDB errors]

Post by bill6502 » Wed Jul 31, 2019 5:31 pm

I've got Arch loaded on a test host with gdm. Got mariadb-10.4.6-1 installed.
Working libmyth* libraries not found (build from source.)

matrix432 is running 10.4.6, is everyone else?

Update, I've updated to 10.4.7. This link has the release notes:

https://mariadb.com/kb/en/library/maria ... changelog/

Post Reply