Hi Maik, I will install a new smaller database so that the traces don't get so huge. I will keep you posted
Thanks George On Mon, Oct 9, 2017 at 4:47 PM Maik Aussendorf <[email protected]> wrote: > Hi, > just as you did for restore: create a tracefile run backup job. > > > You've also mentioned a file xtrabackup_checkpoints in your restore, > please send the contents. The plugin grabs the LSN from that file after > having called xtrabackup for creating the backup files.. > > Regards > > Maik > > Am 09.10.2017 um 15:16 schrieb George Kontostanos: > > Hi Maik, > > The job logs: > > 2017-10-09 08:26:37 bareos-dir JobId 3091: Bareos bareos-dir 16.2.4 > (01Jul16): > Build OS: x86_64-redhat-linux-gnu redhat CentOS Linux release 7.0.1406 > (Core) > JobId: 3091 > Job: server.tld-sql-job01.2017-10-09_07.41.15_53 > Backup Level: Full > Client: "server.tld" 16.2.4 (01Jul16) > x86_64-redhat-linux-gnu,redhat,CentOS Linux release 7.0.1406 (Core) > ,CentOS_7,x86_64 > FileSet: "server.tld-data" 2017-10-07 09:01:01 > Pool: "server.tld-fd-sql-pool01" (From command line) > Catalog: "MyCatalog" (From Client resource) > Storage: "ams-bu-1" (From Pool resource) > Scheduled time: 09-Oct-2017 07:41:15 > Start time: 09-Oct-2017 07:41:20 > End time: 09-Oct-2017 08:26:37 > Elapsed time: 45 mins 17 secs > Priority: 10 > FD Files Written: 2 > SD Files Written: 2 > FD Bytes Written: 10,062,426,869 (10.06 GB) > SD Bytes Written: 10,062,427,477 (10.06 GB) > Rate: 3703.5 KB/s > Software Compression: 73.7 % (gzip) > VSS: no > Encryption: no > Accurate: no > Volume name(s): server.tld-fd-sql-pool01-2917|server.tld-fd-sql-pool01-3142 > Volume Session Id: 142 > Volume Session Time: 1502825051 > Last Volume Bytes: 9,412,787,248 (9.412 GB) > Non-fatal FD errors: 0 > SD Errors: 0 > FD termination status: OK > SD termination status: OK > Termination: Backup OK > > 2017-10-09 08:26:37 bareos-dir JobId 3091: Begin pruning Jobs older than > 1 month 15 days . > 2017-10-09 08:26:37 bareos-dir JobId 3091: No Jobs found to prune. > 2017-10-09 08:26:37 bareos-dir JobId 3091: Begin pruning Files. > 2017-10-09 08:26:37 bareos-dir JobId 3091: No Files found to prune. > 2017-10-09 08:26:37 bareos-dir JobId 3091: End auto prune. > > 2017-10-09 08:26:36 bareos-sd JobId 3091: Elapsed time=00:45:13, Transfer > rate=3.708 M Bytes/second > 2017-10-09 08:00:23 dir-fd JobId 3091: python-fd: Starting backup of > /_percona/xtrabackup_checkpoints > 2017-10-09 07:43:54 bareos-sd JobId 3091: New volume > "server.tld-fd-sql-pool01-3142" mounted on device "FileStorage1" > (/datastore/dir2) at 09-Oct-2017 07:43. > 2017-10-09 07:43:53 bareos-dir JobId 3091: Created new Volume > "server.tld-fd-sql-pool01-3142" in catalog. > 2017-10-09 07:43:53 bareos-sd JobId 3091: Labeled new Volume > "server.tld-fd-sql-pool01-3142" on device "FileStorage1" (/datastore/dir2). > 2017-10-09 07:43:53 bareos-sd JobId 3091: Wrote label to prelabeled > Volume "server.tld-fd-sql-pool01-3142" on device "FileStorage1" > (/datastore/dir2) > 2017-10-09 07:43:52 bareos-sd JobId 3091: User defined maximum volume > capacity 10,737,418,240 exceeded on device "FileStorage1" (/datastore/dir2). > 2017-10-09 07:43:52 bareos-sd JobId 3091: End of medium on Volume > "server.tld-fd-sql-pool01-2917" Bytes=10,737,356,084 Blocks=166,440 at > 09-Oct-2017 07:43. > 2017-10-09 07:41:20 bareos-sd JobId 3091: Volume > "server.tld-fd-sql-pool01-2917" previously written, moving to end of data. > 2017-10-09 07:41:20 bareos-sd JobId 3091: Warning: For Volume > "server.tld-fd-sql-pool01-2917": > The sizes do not match! Volume=10075075915 Catalog=10075075115 > Correcting Catalog > 2017-10-09 07:41:19 bareos-dir JobId 3091: Using Device "FileStorage1" to > write. > 2017-10-09 07:41:17 bareos-dir JobId 3091: Start Backup JobId 3091, > Job=server.tld-sql-job01.2017-10-09_07.41.15_53 > 2017-10-09 07:15:34 dir-fd JobId 3091: python-fd: Starting backup of > /_percona/xbstream.0000003091 > > ---------- > > 2017-10-09 09:48:21 bareos-dir JobId 3111: Error: Bareos bareos-dir > 16.2.4 (01Jul16): > Build OS: x86_64-redhat-linux-gnu redhat CentOS Linux release 7.0.1406 > (Core) > JobId: 3111 > Job: RestoreFiles.2017-10-09_09.28.43_42 > Restore Client: server.tld > Start time: 09-Oct-2017 09:28:45 > End time: 09-Oct-2017 09:48:21 > Elapsed time: 19 mins 36 secs > Files Expected: 1 > Files Restored: 1 > Bytes Restored: 38,327,618,793 > Rate: 32591.5 KB/s > FD Errors: 1 > FD termination status: Error > SD termination status: OK > Termination: *** Restore Error *** > > 2017-10-09 09:48:21 bareos-dir JobId 3111: Begin pruning Files. > 2017-10-09 09:48:21 bareos-dir JobId 3111: No Files found to prune. > 2017-10-09 09:48:21 bareos-dir JobId 3111: End auto prune. > > 2017-10-09 09:48:16 bareos-sd JobId 3111: End of Volume at file 2 on > device "FileStorage1" (/datastore/dir2), Volume > "server.tld-fd-sql-pool01-3142" > 2017-10-09 09:48:16 bareos-sd JobId 3111: End of all volumes. > 2017-10-09 09:30:13 bareos-sd JobId 3111: End of Volume at file 2 on > device "FileStorage1" (/datastore/dir2), Volume > "server.tld-fd-sql-pool01-2917" > 2017-10-09 09:30:13 bareos-sd JobId 3111: Ready to read from volume > "server.tld-fd-sql-pool01-3142" on device "FileStorage1" (/datastore/dir2). > 2017-10-09 09:30:13 bareos-sd JobId 3111: Forward spacing Volume > "server.tld-fd-sql-pool01-3142" to file:block 0:252. > 2017-10-09 09:28:47 bareos-sd JobId 3111: Ready to read from volume > "server.tld-fd-sql-pool01-2917" on device "FileStorage1" (/datastore/dir2). > 2017-10-09 09:28:47 bareos-sd JobId 3111: Forward spacing Volume > "server.tld-fd-sql-pool01-2917" to file:block 2:1485141323. > 2017-10-09 09:28:46 bareos-dir JobId 3111: Using Device "FileStorage1" to > read. > 2017-10-09 09:28:45 bareos-dir JobId 3111: Start Restore Job > RestoreFiles.2017-10-09_09.28.43_42 > 2017-10-09 09:02:01 dir-fd JobId 3111: Error: python-fd: No lsn > information found in restore object for file > /tmp/bareos-restores//_percona/xbstream.0000003091 from job 3091 > > I am not sure how to get the debug-logs > > Thanks > > George > > > On Mon, Oct 9, 2017 at 3:56 PM Maik Aussendorf <[email protected]> > wrote: > >> Hello, >> >> please post the joblogs _and_ debug-logs of _both_ the backup job _and_ >> the restore job. >> >> Regards >> >> >> Maik >> >> Am 09.10.2017 um 14:05 schrieb George Kontostanos: >> >> Just some more info of that helps. Although the restore returns an error, >> it appears that there is a full restore in >> /tmp/bareos-restores/_percona/3111 >> >> Inside that directory I can see all mysql data plus the following: >> >> xtrabackup_checkpoints >> >> xtrabackup_info >> >> xtrabackup_logfile: >> >> uuid = e73bedbe-acc7-11e7-841e-00163e7b9c3e >> >> name = >> >> tool_name = xtrabackup >> >> tool_command = --defaults-extra-file=/etc/my.cnf --backup >> --stream=xbstream --extra-lsndir=/tmp/tmpV_6Toz >> >> tool_version = 2.4.8 >> >> ibbackup_version = 2.4.8 >> >> server_version = 5.6.37-82.2 >> >> start_time = 2017-10-09 03:15:34 >> >> end_time = 2017-10-09 04:00:23 >> >> lock_time = 0 >> >> binlog_pos = >> >> innodb_from_lsn = 0 >> >> innodb_to_lsn = 43699025276 >> >> partial = N >> >> incremental = N >> >> format = xbstream >> >> compact = N >> >> compressed = N >> >> encrypted = N >> Which looks valid to me. >> >> Thanks >> >> George >> >> >> >> >> On Mon, Oct 9, 2017 at 1:44 PM George Kontostanos < >> [email protected]> wrote: >> >>> Hi Maik, >>> >>> Thanks for the update. This time I managed to finish the backup. >>> However, the restore produced the same error: >>> >>> Error: python-fd: No lsn information found in restore object for file >>> /tmp/bareos-restores//_percona/xbstream.0000003091 from job 3091 >>> >>> Please see a new trace here: >>> https://drive.google.com/a/netactuate.com/file/d/0B6SfXxoaUYIVVmhLUXRmVHRTWWc/view?usp=sharing >>> >>> Best Regards >>> >>> George >>> >>> On Mon, Oct 9, 2017 at 10:22 AM Maik Aussendorf < >>> [email protected]> wrote: >>> >>>> Hi, >>>> >>>> the mycnf parameter was introduced with one of the latest >>>> pull-requests, and we haven't tested all option combinations. Should work >>>> now. >>>> >>>> In case of problems: get the xtrabackup command from the joblog and >>>> make sure it works, when you start it manually the same way. >>>> >>>> Regards >>>> >>>> Maik >>>> >>>> Am 07.10.2017 um 16:48 schrieb George Kontostanos: >>>> >>>> It did not :) I tried it and got the same error again. >>>> >>>> Thanks >>>> >>>> George >>>> >>>> On Sat, Oct 7, 2017 at 5:42 PM Jörg Steffens <[email protected]> >>>> wrote: >>>> >>>>> On 07.10.2017 at 16:25 wrote George Kontostanos: >>>>> > Indeed there is a space missing here: >>>>> > >>>>> > dir-fd JobId 3009: Fatal error: python-fd: Dump command returned >>>>> > non-zero value: 1, command: "xtrabackup /etc/my.cnf--backup >>>>> > --stream=xbstream --extra-lsndir=/tmp/tmpenhtus" message: >>>>> > >>>>> > The command is the FileSet is: >>>>> > >>>>> > Plugin = >>>>> > >>>>> "python:module_path=/usr/lib64/bareos/plugins:module_name=bareos-fd-percona:mycnf=/etc/my.cnf" >>>>> > >>>>> > Do you think I should try adding a space like: Plugin = >>>>> > >>>>> "python:module_path=/usr/lib64/bareos/plugins:module_name=bareos-fd-percona:mycnf=/etc/my.cnf >>>>> > " ? >>>>> >>>>> Properly this will not help. I assume a bug introduced with the latest >>>>> modifications. I assume, it will be fixed soon. >>>>> >>>>> Jörg >>>>> -- >>>>> Jörg Steffens [email protected] >>>>> Bareos GmbH & Co. KG Phone: +49 221 630693-91 >>>>> <+49%20221%2063069391> >>>>> http://www.bareos.com Fax: +49 221 630693-10 >>>>> <+49%20221%2063069310> >>>>> >>>>> 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örg Steffens, P. Storz >>>>> >>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "bareos-users" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/bareos-users/7pwz9oT0ANE/unsubscribe >>>>> . >>>>> To unsubscribe from this group and all its topics, 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. >>>>> >>>> -- >>>> >>>> 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. >>>> >>>> -- >>>> With kind regards // Mit freundlichen Grüßen >>>> --- >>>> Maik Außendorf [email protected] >>>> >>>> Bareos GmbH & Co. KG Phone: +49221630693-93 >>>> http://www.bareos.com Fax: +49221630693-10 >>>> >>>> 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 >>>> >>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "bareos-users" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/bareos-users/7pwz9oT0ANE/unsubscribe. >>>> To unsubscribe from this group and all its topics, 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. >>>> >>> >> -- >> With kind regards // Mit freundlichen Grüßen >> --- >> Maik Außendorf [email protected] >> Bareos GmbH & Co. KG Phone: +49221630693-93 >> http://www.bareos.com Fax: +49221630693-10 >> >> 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 >> >> > -- > With kind regards // Mit freundlichen Grüßen > --- > Maik Außendorf [email protected] > Bareos GmbH & Co. KG Phone: +49221630693-93 > http://www.bareos.com Fax: +49221630693-10 > > 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 > > -- 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.
