Hello If it possible I would like to have a look just to try to find out what is going on.
Let me know contacting me directly please. Best regards Gabriele Sent from my iPhone > On 12 May 2020, at 18:23, Scott Powell <scooter...@gmail.com> wrote: > > > I have experienced the same problem log generation problems. we have 3 > stations all on different servers. All run Riv 2.10.3 on Centos 6. eventually > wanting to move to Riv 3.x Centos 7. but so far log generation has been a > hanging point. Have tried both the standalone and server install methods on > several different machines. we might get get two logs generated taking > anywhere from 20 minutes to an hour to generate. the third may never finish. > have come back the next day and it still has not completed. > > have tried mysqltuner suggestions, with and without rddbcheck before > importing into new machine. so far have not stumbled across a fix. > > I have been exporting the database through rdadmin backup, so may try > mysqldump next time. then the only thing i know to do is to run the db > through 2.19x (i have one as a standby) then try it on a 3.x install > > So Chuck and everyone I will continue to follow along and see what ideas > everyone has > > > Scott > > > > > > >> On Mon, May 11, 2020 at 9:16 AM Gabriele Fergola <work...@gmail.com> wrote: >> Chuck >> please try to check what is wrong with mysql and why is hanging to 97% >> login to mysql how root and do: show processlist; >> this command will show you which process is hanging. >> >> if u need more help we can arrange something to check what's wrong >> >> Regards >> >>> Il giorno lun 11 mag 2020 alle ore 15:35 Chuck <dj.chuc...@googlemail.com> >>> ha scritto: >>> Well, my understanding is that rddbcheck does not exist in v3, replaced by >>> a new GUI configuration tool, which does not include the "check"--only >>> Create, Backup, Restore, and Close. >>> >>> I've got over 50,000 carts and my database has been around 400mb for years. >>> Using rddbcheck in v2 did not reduce the size substantially. >>> >>> Tried to step back to v2 over the weekend, but the v2 appliance install did >>> not work, with the "rivendell-install" yum file missing and causing an >>> error. >>> >>> Reinstalled v3.3 appliance and now output levels to the same sound card are >>> about half what they should be (and were on the previous install), and >>> mysqld is back up at 97% CPU. Version 3 is just plain troublesome. >>> >>> --Chuck >>> >>>> On Mo, 2020-05-11 at 21:02 +1200, Geoff Barkman wrote: >>>> Hi there. >>>> I'm not familiar with rivendell 3x versions. But on rivendell 2x versions >>>> if the MySQL database got too big log creations took ages to create. Over >>>> 40 mb in a database slowed it down and a quick fix was to back up the DB >>>> and run rdbcheck to speed it up. >>>> Does that work with rivendell 3x? >>>> Just a thought. >>>> Many thanks >>>> Geoff barkman >>>> >>>> Just a thought? >>>> >>>>> On Mon, May 11, 2020, 7:17 AM Jay Schell <sche...@findlay.edu> wrote: >>>>> Where is the config file located? >>>>> >>>>> Sent from my Verizon, Samsung Galaxy smartphone >>>>> >>>>> From: rivendell-dev-boun...@lists.rivendellaudio.org >>>>> <rivendell-dev-boun...@lists.rivendellaudio.org> on behalf of Workino >>>>> <work...@gmail.com> >>>>> Sent: Sunday, May 10, 2020 2:45:15 PM >>>>> To: Chuck <dj.chuc...@googlemail.com> >>>>> Cc: rivendell-dev@lists.rivendellaudio.org >>>>> <rivendell-dev@lists.rivendellaudio.org> >>>>> Subject: Re: [RDD] Painful log generating times >>>>> >>>>> Hello Chuck, >>>>> The database is on the same computer? If yes the problem can be the >>>>> memory. >>>>> >>>>> If this is the case check the configuration of MySQL and the cache. If >>>>> MySQL starting to swap the answer can become slow. >>>>> >>>>> Regards >>>>> Gabriele >>>>> >>>>> Sent from my iPhone >>>>> >>>>> > On 10 May 2020, at 18:31, Chuck <dj.chuc...@googlemail.com> wrote: >>>>> > >>>>> > I am experiencing lots of problems with v3.3, and one of them is what >>>>> > you mention. However, if I generate logs immediately after rebooting, >>>>> > log creation is amazingly fast--less than 3 minutes. But if the >>>>> > computer has been running for an hour or so, just generating one log >>>>> > can take up to 3 hours. Something is happening during normal operation >>>>> > that messes things up. After the problem surfaces, database backup >>>>> > won't work, and even the Library finally locks up. Oddly, Airplay >>>>> > continues running through it all. Tried totally different hardware, >>>>> > and the problem is there on both, so I doubt it is on the user end. >>>>> > >>>>> > --Chuck >>>>> > >>>>> >> On Sa, 9 May 2020 17:09:47 +0000 >>>>> >> Jay Schell <sche...@findlay.edu> wrote: >>>>> >> >>>>> >> I built a new virtualization server for hosting two Rivendell servers >>>>> >> running completely different stations and audio libraries. The new >>>>> >> servers are version 3 but generating logs is taking FOREVER, I am >>>>> >> talking almost an hour to make one log. This is on an imported v2 >>>>> >> database. Any thoughts on what might be wrong? The new server has >>>>> >> lots of RAM and processing speed so I wonder if it is a database >>>>> >> issue or hard drive performance issue. >>>>> >> >>>>> >> Jay Schell >>>>> >> WLFC-FM Engineer >>>>> > >>>>> > >>>>> > _______________________________________________ >>>>> > Rivendell-dev mailing list >>>>> > Rivendell-dev@lists.rivendellaudio.org >>>>> > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>>> _______________________________________________ >>>>> Rivendell-dev mailing list >>>>> Rivendell-dev@lists.rivendellaudio.org >>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>>> _______________________________________________ >>>>> Rivendell-dev mailing list >>>>> Rivendell-dev@lists.rivendellaudio.org >>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >> _______________________________________________ >> Rivendell-dev mailing list >> Rivendell-dev@lists.rivendellaudio.org >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev