On 03/09/2015 11:02 AM, Nico Haslberger wrote: > Am Montag, 9. März 2015 10:47:09 UTC+1 schrieb Stephan Duehr: >> On 03/08/2015 01:54 PM, Nico Haslberger wrote: >>> Am Samstag, 7. März 2015 10:36:57 UTC+1 schrieb Marco van Wieringen: >>>> On 03/ 7/15 10:20 AM, Bruno Friedmann wrote: >>>>> On Friday 06 March 2015 14.21:55 Nico Haslberger wrote: >>>>>> Am Donnerstag, 5. März 2015 21:21:51 UTC+1 schrieb Bruno Friedmann: >>>>>>>>>> Which should use the localhost/socket connection. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> I modified the config as you said. >>>>>>>>> The thing is now: >>>>>>>>> My the fd that is running on the machine where the dir runs is able >>>>>>>>> to backup, but every remote fd terminates with the same sql error :\ >>>>>>>>> >>>>>>>>> greetings >>>>>>>>> Nico >>>>>>>> any other ideas? >>>>>>> you mean that when you do a status client client=remote-fd the console >>>>>>> failed with mysql error? >>>>>>> and not when doing status client=local-fd ??? >>>>>>> >>>>>>> Dude I'm happy to use a real database like postgresql then :-))) >>>>>>> >>>>>>> But I'm still confident this is mostly a configuration trouble, >>>>>>> somewhere somewhat, but where and what depend of your changes. >>>>>>> >>>>>> No the thing is, status is working fine for every client, but when I try >>>>>> to start a backup job of a remote client it is failing with the >>>>>> described sql error. >>>>>> >>>>>> Oh god I hate postgres, but I think I will change to MariaDB, because >>>>>> MySQL is crap since Oracle. :D >>>>>> >>>>>> I´m absolutely speechless for this issue and I have no idea whats wrong >>>>>> here. I didn´t changed my config the issue suddenly appeard one day. >>>>>> >>>>>> greetings >>>>>> Nico >>>>> So it's mostly happening when the director is inserting the files attr in >>>>> the database. But then I don't understand why it would success when it's >>>>> saving the local client. >>>>> >>>>> speechless too. >>>>> >>>> As it gives an error 111 that seems to indicate >>>> >>>> #define ECONNREFUSED 111 /* Connection refused */ >>>> >>>> Given this is a unix socket its most likely that mysql either puts its >>>> socket somewhere >>>> else or for whatever reason cannot open it by the mysql process and as >>>> such you have no >>>> connectivity. Tried the windows approach ? e.g. reboot the server. You >>>> could also have >>>> a look with lsof and see if any of the mysql processes have a unix >>>> socket open and which >>>> one. >>>> >>>> -- >>>> Marco van Wieringen [email protected] >>>> Bareos GmbH & Co. KG Phone: +49-221-63069389 >>>> http://www.bareos.com >>>> >>>> Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 >>>> Komplementär: Bareos Verwaltungs-GmbH >>>> Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, >>>> P. Storz, M. v. Wieringen >>> >>> Yes I rebooted the server several times but no changes: >>> Here is the output of sudo lsof | grep mysql: >>> https://paste.ee/p/zGdmg >>> >>> Now some of the clients are working but: >>> All differential jobs are working fine, but neither the inceremtial jobs >>> are working nor the full backup jobs: >>> >>> Director´s fd Full: >>> https://paste.ee/p/Kp4cA >>> >>> Director´s fd Differential: >>> https://paste.ee/p/bZTvl >>> >>> Director´s fd Incremental: >>> https://paste.ee/p/AQgtk >>> >>> greetings >>> Nico >>> >> >> any error messages in /var/log/mysql/error.log ? >> >> Are automatic unattended updates enabled? As described in >> https://help.ubuntu.com/lts/serverguide/automatic-updates.html >> That would not be a good idea, because it may update mysql >> and restart it, which requires director restart. >> >> Regards >> -- >> Stephan Dühr [email protected] >> Bareos GmbH & Co. KG Phone: +49 221-630693-90 >> http://www.bareos.com >> >> Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 >> Komplementär: Bareos Verwaltungs-GmbH >> Geschäftsführer: S. Dühr, M. Außendorf, >> J. Steffens, Philipp Storz, M. v. Wieringen > > My mysql error.log tells me this: > https://paste.ee/p/BNkpu > No I´m doing my updates manually but this is the only database server that > died after a minor security update... > I´ll switch to mariadb and hope this runs better than the destroyed mysql > (thx to oracle)... > > greetings > Nico >
ok, so whatever caused the corruption, checking the harddisk that contains the mysql data may be a good idea. Probably mariadb wouldn't do any better when there's a hardware problem. Regards -- Stephan Dühr [email protected] Bareos GmbH & Co. KG Phone: +49 221-630693-90 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz, M. v. Wieringen -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
