[mythtv-users] mythconverg/program is marked as crashed

[Mike Perkins]

On 27/01/16 23:39, David L wrote:
> On Tue, Jan 26, 2016 at 11:57 AM, David L <idht4n at gmail.com> wrote:
>
>>
>>
>> On Tue, Jan 26, 2016 at 10:56 AM, Bill Meek <keemllib at gmail.com> wrote:
>>
>>> On 01/26/2016 12:24 PM, David L wrote:
>>> ...
>>>
>>>> However, it does complain about permissions denied for some reason that I
>>>> don't understand:
>>>>
>>>> strace /usr/sbin/mysqld
>>>> <snip>
>>>> gettimeofday({1453831961, 595238}, NULL) = 0
>>>> open("/sdc1/tmp/ibELQk8J", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = -1
>>>> EACCES (Permission denied)
>>>>
>>>
>>>
>>> Could you be getting blocked by apparmor?
>>>
>>
>> Good thought, but I don't think that's it.  I tried uninstalling
>> apparmor.  It didn't help.
>>
>> apparmor_status
>> The program 'apparmor_status' is currently not installed. You can install
>> it by typing:
>> apt-get install apparmor
>>
>> /usr/sbin/mysqld
>> 160126 11:56:04 [Warning] Using unique option prefix key_buffer instead of
>> key_buffer_size is deprecated and will be removed in a future release.
>> Please use the full name instead.
>> 160126 11:56:04 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0ubuntu0.14.04.2)
>> starting as process 13995 ...
>> 160126 11:56:04 [Warning] Using unique option prefix myisam-recover
>> instead of myisam-recover-options is deprecated and will be removed in a
>> future release. Please use the full name instead.
>> 160126 11:56:04 [Note] Plugin 'FEDERATED' is disabled.
>> 160126 11:56:04 InnoDB: The InnoDB memory heap is disabled
>> 160126 11:56:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
>> 160126 11:56:04 InnoDB: Compressed tables use zlib 1.2.8
>> 160126 11:56:04 InnoDB: Using Linux native AIO
>> /usr/sbin/mysqld: Can't create/write to file '/sdc1/tmp/ibMB877h'
>> (Errcode: 13)
>>
>>
>>
> Any other theories why mysqld is having permission denied errors opening
> files in a world rwx directory than has plenty of space and can be written
> to by user mysql from the command line?  I'd like to get my mythtv backend
> running again without a re-install.  The things that I would not want to
> lose are my previously recorded shows and the channel configuration to work
> with Comcast programming (unless mythtv has integrated the scte65scan
> functionality, that is always a hassle).  Anything else can be blown away
> and I don't care.
>
(Fixed top posting)

You managed to manually write to that directory as the mysql user, but is there a wild chance that 
your /mysqld/ process isn't running as user mysql?

Another random thought: Is the /sdc1 partition actually mounted and available when mysqld starts? Is 
there a /tmp directory already created under /sdc1 before the partition is mounted? All kinds of 
weird stuff happens when you overlay directories with mount points.

-- 

Mike Perkins