I have ASA 9.0.2 server and I have redirected the server
error log from DBConsole to a log file (using -o option
during server startup).

I see that the server log contains many blank lines (lines
with only timestamp on them). Does anyone know why such
lines exist in the server log ? (note, this is *NOT* a
transaction log).

Sample as below :--


I. 10/25 16:15:08. Finished checkpoint of "myserver"
(mydb8.db) at Thu Oct 25 2007 16:15
I. 10/25 16:15:09. Starting checkpoint of "myserver"
(mydb8.db) at Thu Oct 25 2007 16:15
I. 10/25 16:15:10. Finished checkpoint of "myserver"
(mydb8.db) at Thu Oct 25 2007 16:15
I. 10/25 16:15:11.
I. 10/25 16:15:11.
I. 10/25 16:15:11.
I. 10/25 16:15:11.
I. 10/25 16:15:11.
I. 10/25 16:15:12.
I. 10/25 16:15:12.
I. 10/25 16:15:12.
I. 10/25 16:15:12.
I. 10/25 16:15:13.
I. 10/25 16:15:13.
I. 10/25 16:15:14.
I. 10/25 16:15:15.
I. 10/25 16:15:16.
I. 10/25 16:15:18. Finished checkpoint of "myserver"
(mydb8.db) at Thu Oct 25 2007 16:15
I. 10/25 16:15:19. Starting checkpoint of "myserver"
(mydb8.db) at Thu Oct 25 2007 16:15
I. 10/25 16:15:20. Finished checkpoint of "myserver"
(mydb8.db) at Thu Oct 25 2007 16:15


thanks for help.

If that is consecutive lines from the log, I would hazzard a
guess some statement inside of some trigger, procedure,
event, function, .... , or via a client connection is behaving
as a
message ''; -- note that is an empty (or blank) string
-- and not a double quote character

An other possibility could be Java code doing much the
same thing via System.out.println()'s.

Running the server with a -zr sql may tell you more about
which connections are active around this time and what
they might be doing then. Scheduled or System Events
need to be investigated using a different approach.


<MD> wrote

One *possibility* is that you have some piece of application code or
database procedure/event/trigger that executes the following
statement:

MESSAGE ' ' TO CONSOLE;

NULL or '' won't actually get written, but ' ' will.

Breck

On 25 Oct 2007 08:50:58 -0700, MD wrote:

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com