[mythtv-users] mysql does not start as service after reboot

R KANNAN rk111810 at gmail.com
Sun Oct 21 20:50:30 UTC 2012


> Message: 19
> Date: Thu, 18 Oct 2012 15:40:29 -0700
> From: Thomas Mashos <thomas at mashos.com>
> To: Discussion about MythTV <mythtv-users at mythtv.org>
> Subject: Re: [mythtv-users] mysql does not start as service after
>         reboot
> Message-ID:
>         <CAMtSsR1v7+dyn9EYQhUvXL4nsGAJVsQsthoNm97Vks+_Jh_vNw at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Thu, Oct 18, 2012 at 3:34 PM, R KANNAN <rk111810 at gmail.com> wrote:
>>> Date: Wed, 17 Oct 2012 18:08:35 -0700
>>> From: Thomas Mashos <thomas at mashos.com>
>>> To: Discussion about MythTV <mythtv-users at mythtv.org>
>>> Subject: Re:
>>> Message-ID:
>>>         <CAMtSsR0R=2EfRucsHYPHCZCsw27efBQjHBnKrJ05AnN1cDrARQ at mail.gmail.com>
>>> Content-Type: text/plain; charset=ISO-8859-1
>>>
>>> On Wed, Oct 17, 2012 at 5:59 PM, R KANNAN <rk111810 at gmail.com> wrote:
>>>> Hello,
>>>>
>>>> Mytbuntu 12.04: For some reason mysql does mot start after reboot.
>>>> When I try start it as service it fails but works fine when I start
>>>> the mysqld daemon.
>>>>
>>>> root at DVR:/etc/init# service mysql start
>>>> start: Job failed to start
>>>> root at DVR:/etc/init# mysqld &
>>>> [1] 2676
>>>> root at DVR:/etc/init# 121017 19:14:55 [Note] Plugin 'FEDERATED' is disabled.
>>>> 121017 19:14:55 InnoDB: The InnoDB memory heap is disabled
>>>> 121017 19:14:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
>>>> 121017 19:14:55 InnoDB: Compressed tables use zlib 1.2.3.4
>>>> 121017 19:14:55 InnoDB: Initializing buffer pool, size = 128.0M
>>>> 121017 19:14:55 InnoDB: Completed initialization of buffer pool
>>>> 121017 19:14:55 InnoDB: highest supported file format is Barracuda.
>>>> 121017 19:14:56  InnoDB: Waiting for the background threads to start
>>>> 121017 19:14:57 InnoDB: 1.1.8 started; log sequence number 84614783
>>>> 121017 19:14:57 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
>>>> 121017 19:14:57 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
>>>> 121017 19:14:57 [Note] Server socket created on IP: '127.0.0.1'.
>>>> 121017 19:14:57 [Note] Event Scheduler: Loaded 0 events
>>>> 121017 19:14:57 [Note] mysqld: ready for connections.
>>>> Version: '5.5.24-0ubuntu0.12.04.1'  socket:
>>>> '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
>>>>
>>>> Any ideas on how I can correct this? Also the backend does not start
>>>> automatically either but starts fine as service. I think it may be
>>>> because of mysql not starting as above.
>>>>
>>>> Thanks
>>>> _______________________________________________
>>>> mythtv-users mailing list
>>>> mythtv-users at mythtv.org
>>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>>
>>> Do the mysql logs indicate why they aren't starting via the service command?
>>>
>>> Thanks,
>>>
>>> Thomas Mashos
>>>
>> I found the following in my syslog:
>>
>> Oct 18 18:23:02 DVR kernel: [10598.240534] init: mysql pre-start
>> process (4992) terminated with status 1
>>
>> My /etc/init/mysql.conf has the following
>>
>> pre-start script
>>     #Sanity checks
>>     [ -r $HOME/my.cnf ]
>>     [ -d /var/run/mysqld ] || install -m 755 -o mysql -g root -d /var/run/mysqld
>>     /lib/init/apparmor-profile-load usr.sbin.mysqld
>>     LC_ALL=C BLOCKSIZE= df --portability /var/lib/mysql/. | tail -n 1
>> | awk '{ exit ($4<4096) }'
>> end script
>>
>> I do not have /var/run/mysqld directory and it seems to have
>>
>> mysqld.pid  mysqld.sock
>>
>> I removed them and restarted the service. But I still get the same error.
>>
>> Thanks
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
> Let me rephrase that.
>
> Do the mysql logs ( located in /var/log/mysql/ ) indicate why they
> aren't starting via the service command?
>
> Thanks,
>
> Thomas Mashos
>
>
> ------------------------------
>
tail /var/log/mysql/error.log gives the following:

120603 17:32:23 [Note] Event Scheduler: Loaded 0 events
120603 17:32:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.62-0ubuntu0.11.10.1'  socket:
'/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
120603 17:35:11 [Note] /usr/sbin/mysqld: Normal shutdown

120603 17:35:11 [Note] Event Scheduler: Purging the queue. 0 events
120603 17:35:11  InnoDB: Starting shutdown...
120603 17:35:13  InnoDB: Shutdown completed; log sequence number 0 83075
120603 17:35:13 [Note] /usr/sbin/mysqld: Shutdown complete

But this file has not been touched since June 3,2012. So not from my
latest mysql service start attempt.


tail /var/log/mysql/mysql.log gives the following

slyshown = ? WHERE chanid    = ? AND       starttime = ?
		  378 Reset stmt	
		  378 Execute	UPDATE program SET title          = 'Home With Lisa
Quinn',     subtitle      = '',     description    = 'A decorating
show that keeps both high design and your pocket book in mind.',
category       = 'How-to',  category_type = 'series',     starttime
  = '2012-10-23 11:30:00', endtime       = '2012-10-23 12:00:00',
closecaptioned = 0,        subtitled     = 0,     stereo         = 0,
  hdtv          = 0,     subtitletypes  = 0,     audioprop      = 0,
videoprop     = 0,     partnumber     = 0,    parttotal     = 0,
syndicatedepisodenumber = '',     airdate        = '0000',
originalairdate='2009-04-27',     listingsource  = 3,     seriesid
  = 'EP01149893',  programid     = 'SH011498930000',
previouslyshown = 1 WHERE chanid    = 1072 AND       starttime =
'2012-10-23 11:30:00'
		  378 Close stmt	
121021 15:21:43	  381 Prepare	SELECT chanid, starttime,
lastupdatetime, recusage, hostname FROM inuseprograms
		  381 Reset stmt	
		  381 Close stmt	
121021 15:22:03	  380 Prepare	SELECT j.id, j.chanid, j.starttime,
j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime,
j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue
j LEFT JOIN recorded r   ON j.chanid = r.chanid AND j.starttime =
r.starttime ORDER BY j.schedruntime, j.id
		  380 Reset stmt	
		  380 Close stmt	

I am not even sure where the log message from mysql are going. I have
in /var/log/syslog

Oct 21 16:38:00 DVR kernel: [  216.952263] init: mysql pre-start
process (2541) terminated with status 1

It looks like according to /etc/mysql/my.cnf

#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#


More information about the mythtv-users mailing list