[RDD] Database connection fails when adding clocks to grid

David Chamla dchamla at gmail.com
Sun Sep 2 10:57:04 EDT 2012


Hello all,


Sorry for the delay, I was on vacation.

I can confirm that replacing ENGINE=InnoDB with ENGINE=MyISAM in the
SERVICES table of the Rivendell database has solved the issue.

Thank you very much, dealing with grids has now become so much easier :)


Bye,
David

On Mon, Aug 20, 2012 at 1:15 PM, Wayne Merricks
<waynemerricks at thevoiceasia.com> wrote:
> Hi again,
>
> InnoDB didn't replace MyISAM it was just made the default choice if no
> engine was specified (as InnoDB is more fault tolerant amongst other
> things).
>
> However you might be able to work around it by recreating the table.
> Simply copy/paste the SQL from the table tab but remember to replace
> ENGINE=InnoDB with ENGINE=MyISAM.
>
> If I were you, I'd rename the SERVICES table to SERVICES_Inno (or
> something easily understandable years from now).
>
> Then recreate the table with the MyISAM bit then copy back in the
> records from the renamed table (theres a button on the left that says
> Save result as SQL insert script if you're using emma (just above the
> magnifying glass).
>
> This might be something to consider moving forwards in terms of the Riv
> code as it will probably be a more prominent problem the more people
> move onto newer versions of MySQL.
>
> Wayne Merricks
> The Voice Asia
>
> On 19/08/12 21:56, David Chamla wrote:
>> Myself:
>>
>>>>   `CLOCK167` char(64) DEFAULT NULL,
>>>>   PRIMARY KEY (`NAME`)
>>>> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>>>>
>>>> The thing to note (I hope) is that mine shows ENGINE=MyISAM
>>>> which doesn't have this page size limitation (or at least not as small by
>>>> default).  Is your DB also showing MyISAM?
>>> No, it actually shows InnoDB!
>> ... explained by the fact that I user mysql-server-5.5.
>> (MyISAM was apparently replaced by InnoDB from v5.5)
>>
>>
>> David
>> _______________________________________________
>> Rivendell-dev mailing list
>> Rivendell-dev at lists.rivendellaudio.org
>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
>
>
> #######################
> Scanned by MailMarshal
> #######################
>
> ############
>
> Attention:
>
> The information contained in this message is confidential and intended
> for the addressee(s) only. If you have received this message in error
> or there are any problems, please notify the originator immediately.
> The unauthorised use, disclosure, copying or alteration of this message
> is strictly forbidden. Christian Vision or any of its subsidiaries will
> not be liable for direct, special, indirect or consequential damages
> arising from alteration of the contents of this message by a third party
> or as a result of any virus being passed on. Please note that we reserve
> the right to monitor and read any e-mails sent or received by the
> company under the Telecommunications (Lawful Business Practice)
> (Interception of Communications) Regulation 2000. Christian Vision is
> registered in England as a limited company 2842414 and as a charity
> 1031031
>
> ############
> _______________________________________________
> Rivendell-dev mailing list
> Rivendell-dev at lists.rivendellaudio.org
> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev


More information about the Rivendell-dev mailing list