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:37bareos-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:37bareos-dir JobId 3091: Begin pruning Jobs older > than 1 month 15 days . > 2017-10-09 08:26:37bareos-dir JobId 3091: No Jobs found to prune. > 2017-10-09 08:26:37bareos-dir JobId 3091: Begin pruning Files. > 2017-10-09 08:26:37bareos-dir JobId 3091: No Files found to prune. > 2017-10-09 08:26:37bareos-dir JobId 3091: End auto prune. > > 2017-10-09 08:26:36bareos-sd JobId 3091: Elapsed time=00:45:13, > Transfer rate=3.708 M Bytes/second > 2017-10-09 08:00:23dir-fd JobId 3091: python-fd: Starting backup of > /_percona/xtrabackup_checkpoints > 2017-10-09 07:43:54bareos-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:53bareos-dir JobId 3091: Created new Volume > "server.tld-fd-sql-pool01-3142" in catalog. > 2017-10-09 07:43:53bareos-sd JobId 3091: Labeled new Volume > "server.tld-fd-sql-pool01-3142" on device "FileStorage1" > (/datastore/dir2). > 2017-10-09 07:43:53bareos-sd JobId 3091: Wrote label to prelabeled > Volume "server.tld-fd-sql-pool01-3142" on device "FileStorage1" > (/datastore/dir2) > 2017-10-09 07:43:52bareos-sd JobId 3091: User defined maximum volume > capacity 10,737,418,240 exceeded on device "FileStorage1" > (/datastore/dir2). > 2017-10-09 07:43:52bareos-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:20bareos-sd JobId 3091: Volume > "server.tld-fd-sql-pool01-2917" previously written, moving to end of data. > 2017-10-09 07:41:20bareos-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:19bareos-dir JobId 3091: Using Device "FileStorage1" > to write. > 2017-10-09 07:41:17bareos-dir JobId 3091: Start Backup JobId 3091, > Job=server.tld-sql-job01.2017-10-09_07.41.15_53 > 2017-10-09 07:15:34dir-fd JobId 3091: python-fd: Starting backup of > /_percona/xbstream.0000003091 > > ---------- > > 2017-10-09 09:48:21bareos-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:21bareos-dir JobId 3111: Begin pruning Files. > 2017-10-09 09:48:21bareos-dir JobId 3111: No Files found to prune. > 2017-10-09 09:48:21bareos-dir JobId 3111: End auto prune. > > 2017-10-09 09:48:16bareos-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:16bareos-sd JobId 3111: End of all volumes. > 2017-10-09 09:30:13bareos-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:13bareos-sd JobId 3111: Ready to read from volume > "server.tld-fd-sql-pool01-3142" on device "FileStorage1" > (/datastore/dir2). > 2017-10-09 09:30:13bareos-sd JobId 3111: Forward spacing Volume > "server.tld-fd-sql-pool01-3142" to file:block 0:252. > 2017-10-09 09:28:47bareos-sd JobId 3111: Ready to read from volume > "server.tld-fd-sql-pool01-2917" on device "FileStorage1" > (/datastore/dir2). > 2017-10-09 09:28:47bareos-sd JobId 3111: Forward spacing Volume > "server.tld-fd-sql-pool01-2917" to file:block 2:1485141323. > 2017-10-09 09:28:46bareos-dir JobId 3111: Using Device "FileStorage1" > to read. > 2017-10-09 09:28:45bareos-dir JobId 3111: Start Restore Job > RestoreFiles.2017-10-09_09.28.43_42 > 2017-10-09 09:02:01dir-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] <mailto:[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] >> <mailto:[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] >> <mailto:[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] >>> <mailto:[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] >>> <mailto:[email protected]> >>> Bareos GmbH & Co. KG Phone: +49 221 >>> 630693-91 <tel:+49%20221%2063069391> >>> http://www.bareos.com Fax: +49 221 >>> 630693-10 <tel:+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] >>> <mailto:bareos-users%[email protected]>. >>> To post to this group, send email to >>> [email protected] >>> <mailto:[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] >>> <mailto:[email protected]>. >>> >>> To post to this group, send email to >>> [email protected] >>> <mailto:[email protected]>. >>> For more options, visit https://groups.google.com/d/optout. >> >> -- >> With kind regards // Mit freundlichen Grüßen >> --- >> Maik Außendorf >> [email protected] >> <mailto:[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] >> <mailto:[email protected]>. >> To post to this group, send email to >> [email protected] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > With kind regards // Mit freundlichen Grüßen > --- > Maik Außendorf [email protected] > <mailto:[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.
