New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
TimeStamp in the every line output gbak.exe utility [CORE1999] #2436
Comments
Modified by: Oleg Matveyev (o_matveev)priority: Major [ 3 ] => Minor [ 4 ] |
Modified by: Oleg Matveyev (o_matveev)Version: 2.0.4 [ 10211 ] Version: 2.1.0 [ 10041 ] Version: 2.1 RC2 [ 10250 ] Version: 2.5 Initial [ 10260 ] Version: 2.1 RC1 [ 10201 ] Version: 1.5.5 [ 10220 ] Version: 2.1 Beta 2 [ 10190 ] Version: 2.0.3 [ 10200 ] Version: 2.0.2 [ 10130 ] Version: 2.1 Beta 1 [ 10141 ] Version: 2.1 Alpha 1 [ 10150 ] Version: 2.0.1 [ 10090 ] Version: 1.5.4 [ 10100 ] Version: 2.0.0 [ 10091 ] Version: 1.0.3 [ 10006 ] Version: 2.1.1 [ 10223 ] Version: 2.5 Alpha 1 [ 10224 ] Version: 2.5 Beta 1 [ 10251 ] Version: 2.1.2 [ 10270 ] Version: 1.5.6 [ 10225 ] Version: 2.0.5 [ 10222 ] Version: 2.5.0 [ 10221 ] Version: 3.0.0 [ 10048 ] |
Modified by: Oleg Matveyev (o_matveev)Version: 2.0.4 [ 10211 ] => Version: 2.1.0 [ 10041 ] => Version: 2.1 RC2 [ 10250 ] => Version: 2.5 Initial [ 10260 ] => Version: 2.1 RC1 [ 10201 ] => Version: 1.5.5 [ 10220 ] => Version: 2.1 Beta 2 [ 10190 ] => Version: 2.0.3 [ 10200 ] => Version: 2.1 Beta 1 [ 10141 ] => Version: 2.1 Alpha 1 [ 10150 ] => Version: 2.0.1 [ 10090 ] => Version: 1.5.4 [ 10100 ] => Version: 2.0.0 [ 10091 ] => Version: 1.0.3 [ 10006 ] => Version: 2.1.1 [ 10223 ] => Version: 2.5 Alpha 1 [ 10224 ] => Version: 2.5 Beta 1 [ 10251 ] => Version: 2.1.2 [ 10270 ] => Version: 1.5.6 [ 10225 ] => Version: 2.0.5 [ 10222 ] => Version: 2.5.0 [ 10221 ] => Version: 2.0.2 [ 10130 ] => |
Modified by: Oleg Matveyev (o_matveev)Version: 3.0.0 [ 10048 ] => |
Commented by: @cincuranet -pi isn't probably the right name. I would rather see something like "show timestamps" or -st. Or just "timestamps" -ts". |
Commented by: Valdir Marcos (valdir_marcos) Could you also calculate the time spent (Finish Timestamp - Start Timestamp) as the last information printed? All those timestamp information would be very helpful. |
Commented by: Brenden Walker (braindead) Just chiming in that we (DRB Systems Inc) would like to see this enhancement implemented. |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad gbak verbose output with runtime statistics gbak now could show some runtime statistics in its verbose output. New command- Mandatory string parameter of STATISTICS switch is used to specify necessary Order and case of characters in parameter value is not important, i.e. "TDRW" For users convenience, two special lines in verbose output is added:
- line with total statistics, printed after end of main process:
In this line both time items have the same meaning as in other lines but New feature is fully supported at Services API. New SPB item is introduced:
and its synonim
Usage where fbsvcmgr utility also updated and supports new SPB tags. Examples: b) show total time since gbak start c) show delta time and page reads d) show all stat items e) sample of gbak output firebird>gbak -v -stat tdrw -r a.fbk a.fdb |
Modified by: @hvladstatus: Open [ 1 ] => Open [ 1 ] Target: 3.0 RC 1 [ 10584 ] Fix Version: 3.0 RC 1 [ 10584 ] Component: API / Client Library [ 10040 ] Component: Engine [ 10000 ] Component: SVCMGR [ 10141 ] Planning Status: Considered for inclusion |
Commented by: @hvlad Depending on users feedback it could be backported into v2.5 |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred Test Details: Restore using FBSVCMGR can produce broken logs! Can`t implement test until CORE4897 will be fixed. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Done successfully Test Details: Restore using FBSVCMGR can produce broken logs! Can`t implement test until CORE4897 will be fixed. => Note: failing of this test can be evidence of regression in fixed CORE4897. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @cincuranet |
Commented by: @hvlad Backported into v2.5.5 |
Modified by: @hvladFix Version: 2.5.5 [ 10670 ] |
Commented by: @pavel-zotov > Vlad Khorsun added a comment - 27/Oct/15 11:25 AM It seems that FBSVCMGR of 2.5.5 does not understand 'res_stat tdrw' as command arguments. command #1C:\MIX\firebird\fb25\bin\fbsvcmgr localhost:service_mgr user SYSDBA password masterkey action_restore bkp_file C:/MIX/firebird/QA/fbt-repo/tmp/tmp_core_1999_25.fbk dbname C:/MIX/firebird/QA/fbt-repo/tmp/tmp_core_1999_25.fd1 res_replace verbose STDOUT: <runs OK, producing verbose output of restoring process>. command #2C:\MIX\firebird\fb25\bin\fbsvcmgr localhost:service_mgr user SYSDBA password masterkey action_restore bkp_file C:/MIX/firebird/QA/fbt-repo/tmp/tmp_core_1999_25.fbk dbname C:/MIX/firebird/QA/fbt-repo/tmp/tmp_core_1999_25.fd1 res_replace verbose res_stat tdrw STDERR: unrecognized service parameter block Checked on Firebird Trace utility version WI-V2.5.5.26949 Firebird 2.5 |
Modified by: @pavel-zotovAttachment: core_1999_25.zip [ 12833 ] |
Commented by: @hvlad Fixed, thanks |
Submitted by: Oleg Matveyev (o_matveev)
Block progress on DNET633
Attachments:
core_1999_25.zip
Votes: 5
Hi, All.
For the best analyze time of database restore, very helpful show date and time in every line output gbak:
17.07.2008 14:16:01 gbak: activating and creating deferred index RDB$PRIMARY1
17.07.2008 14:18:10 gbak: activating and creating deferred index RDB$FOREIGN319
17.07.2008 14:19:15 gbak: committing metadata
17.07.2008 14:20:24 gbak:finishing, closing, and going home
P.S. Output optionaly, by switch -pi (performance info) for gbak.exe
Commits: c2fd343 8b684a4 be4c021 b77bf19 FirebirdSQL/fbt-repository@72c1dcc FirebirdSQL/fbt-repository@a5aa2b2 FirebirdSQL/fbt-repository@b104c93 FirebirdSQL/fbt-repository@12ae8ef
====== Test Details ======
Note: failing of this test can be evidence of regression in fixed CORE4897.
The text was updated successfully, but these errors were encountered: