log2sql.rb #2

  • //
  • guest/
  • perforce_software/
  • utils/
  • log_analyzer/
  • log2sql.rb
  • Commits
# Change User Description Committed
#2 25220 Robert Cowham Moved project files to new location: //guest/perforce_software/log-analyzer/psla/...
Required by Swarm project structure for workshop.
#1 23636 Robert Cowham Merge in latests changes to log2sql.py
- much faster
- better at detecting completed commands and out of order vtrack
- full test harness
//guest/robert_cowham/perforce/utils/log_analysis/log2sql.rb
#2 10402 Robert Cowham Pascal's change:
The encode() method is only supported with Ruby 1.9 or greater.
With Ruby 1.8, I cannot (easily) deal with non ASCII characters.
If that matters to users, they need to switch to Ruby 1.9.
#1 10401 Robert Cowham Populate //guest/robert_cowham/perforce/utils/log_analysis/log2sql.rb from //guest/pascal_soccard/Scripts/log2sql.rb.
//guest/pascal_soccard/Scripts/log2sql.rb
#12 8226 Pascal Soccard Increased size of circular list because on busy server, vtrack output
can be logged much later than the completed message. May increase
memory usage.
Database performance improvement by committing insert/update only after
all the rows have been inserted/updated.
This fix was necessary because of the dramatical performance
degradation after upgrading to Ubuntu 12.04 which probably uses
a newer Mysql
#11 8042 Pascal Soccard Fixed endTime for vtrack command
Added support for Broker log parsing
#10 7983 Pascal Soccard Forgot to submit as ktext
#9 7982 Pascal Soccard New improved version, includes now vtrack output parsing (same as
track2sql.php). See script header for more details.
#8 7705 Pascal Soccard Striped 0x0 characters in client value introduced by a buggy P4V version
#7 7647 Pascal Soccard Wrong type in sprintf call of the to_text method
#6 7562 Pascal Soccard "Perforce Server starting" block was incorrectly handled
#5 7483 Pascal Soccard Command parsing was not considering "dm-*" commands
#4 7470 Pascal Soccard Fixed an issue with " in command arguments
#3 7267 Pascal Soccard Fixed few bugs
#2 6471 Pascal Soccard Added new "running" field which gives the number of commands
not completed at the time the command was started
#1 6384 Pascal Soccard Added a Ruby Perforce log analyser