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 <https://twitter.com/scooterpow> 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
