I have a log file that has many SQL statements/queries/blocks and their resultant output (success or failure) added to each of them. I need to pick up all the statements which caused errors and write them to a separate file.
On most cases, the SQL statement is a single line, like DROP . And if it fails, the error is appended next to it, with a suffix DB2XXXXE (where XXXX is the error code).
Quote:
DROP VIEW SOMEVIEW
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0204N "SCHEMANAME.SOMEVIEW" is an undefined name. SQLSTATE=42704
Now I can get this easily using grep like so.
However, in some cases, the SQL code causing the error might be a big CREATE PROCEDURE.. END PROCEDURE block. In this case, I need to write this entire block, along with the error to a file.
Hi All,
I'm deffently not a Unix specialist so be Gentel.
I need to parse a Log file that looks like that:
2006-06-12 01:00:00,463 ERROR {cleanLoggersFiles} General Error
comverse.compas.shared.exceptions.SystemParametersException: Error in reading parameter FileLocation
at... (4 Replies)
Hi Experts,
Im a new bee for scripting,
I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
I need help in parsing the following log files.
10 Apr 2009 0:16:16 * name: Tuna Belly Format: Well done, Price: 999 only
10 Apr 2009 0:16:16 * name: Roast Beef Format: Raw, Price: 55 c
10 Apr 2009 0:16:16 * name: Pasta Format: Dry, Price: 88.43 only
etcetc
I need to parse this... (8 Replies)
Working on a script that inputs an IP, parses and outputs to another file.
A Sample of the log is as follows:
I need the script to be able to input IP and print the data in an output file in the following format or something similar:
Thanks for any help you can give me! (8 Replies)
Hello all,
I am new to scripting and I have written a script that performs an Rsync on my NAS and then moves on to send me an email with the status etc. The problem is that I think Rsync is taking to long to complete and the IF statement is timing out, as it doesn't appear to move on.
Here... (1 Reply)
I have 1.6 GB (and growing) of files with needed data between the 11th and 34th line (inclusive) of the second column of comma delimited files. There is also a lot of stray white space in the file that needs to be trimmed. They have DOS-like end of lines.
I need to transpose the 11th through... (13 Replies)
Hi,
I am a newbie to scripting.
I have multiple log files (saved as .gz) in a directory that looks like this
01-01-2013 10:00 pn: 123
01-01-2013 10:00 sn: 987
01-01-2013 10:00 Test1
01-01-2013 10:00 Result: Pass
01-01-2013 10:00 Time: 5:00
01-01-2013 10:00 Test2
01-01-2013 10:00... (3 Replies)
I want to parse a log file which i am grepping root user connection but is showing whole day and previous day detail as well.
First i want to see last 2 hours log file then after that i want to search particular string. Lets suppose right now its 5:00PM, So i want to see the log of 3:00PM to... (6 Replies)
Hi,
I have a log file that looks like below and I am wanting to know if there is a better way of parsing it from how I am doing it right now.
I am looking for when an application service is OFFLINE and ONLINE. This log file is getting written into every 30 minutes
... (1 Reply)
Hi,
I need some guidance with understanding this Perl script below. I am not the author of the script and the author has not leave any documentation. I supposed it is meant to be 'easy' if you're a Perl or regex guru. I am having problem understanding what regex to use :confused: The script does... (3 Replies)
Discussion started by: newbie_01
3 Replies
LEARN ABOUT DEBIAN
jifty::plugin::sqlqueries
Jifty::Plugin::SQLQueries(3pm) User Contributed Perl Documentation Jifty::Plugin::SQLQueries(3pm)NAME
Jifty::Plugin::SQLQueries - Inspect your application's SQL queries
DESCRIPTION
This plugin will log each SQL query, its duration, its bind parameters, and its stack trace. Such reports are available at:
http://your.app/__jifty/admin/requests
USAGE
Add the following to your site_config.yml
framework:
Plugins:
- SQLQueries: {}
You can turn on and off the stacktrace, as well as an "EXPLAIN" of each query, using options to the plugin:
framework:
Plugins:
- SQLQueries:
stacktrace: 0
explain: 1
The plugin defaults to logging the stack trace, but not the explain.
METHODS
init
Sets up a "post_init" hook.
inspect_before_request
Clears the query log so we don't log any unrelated previous queries.
inspect_after_request
Stash the query log.
inspect_render_summary
Display how many queries and their total time.
inspect_render_analysis
Render a template with all the detailed information.
post_init
Tells Jifty::DBI to log queries in a way that records stack traces.
prereq_plugins
This plugin depends on Jifty::Plugin::RequestInspector.
COPYRIGHT AND LICENSE
Copyright 2007-2010 Best Practical Solutions
This is free software and may be modified and distributed under the same terms as Perl itself.
perl v5.14.2 2010-12-10 Jifty::Plugin::SQLQueries(3pm)