AMPS Log Messages

📄️ How do I get more information on an AMPS error?

The AMPS distribution includes a command-line tool, ampserr, that includes information on every error generated by AMPS (and previous versions of AMPS).

📄️ How Can I Tell Where a Connection is Coming From?

Each client connection in AMPS has two distinct names.

📄️ Does AMPS log current process limits?

Yes, provided that AMPS is logging at info level or otherwise logging the 00-0032 message.

📄️ What does it mean when AMPS has detected that it may not be running correctly?

The AMPS server is highly concurrent, which means that the server itself has many threads doing work at the same time.

📄️ How can I keep only the last week of error logs?

There are a number of ways to do this.

📄️ What is the difference between "execution time" and "elapsed time" in the logs?

In the logs, the "execution time" is the time the query required to execute where "elapsed time" is the time from when AMPS first receives the query (it incorporates the time taken for parallel query execution).

📄️ What does a "potential stuck thread" message mean?

By itself, a potential stuck thread message simply indicates that a task is taking significantly longer than the AMPS engine expects.

📄️ What does a "message cache is throttled" warning mean?

As with all warning level messages, this means that AMPS detected a potential problem that can be automatically corrected, but may require operator attention if the problem persists.

📄️ What does "Replication has detected existing connection" mean? Why does AMPS close the connection?

When two AMPS instances replicate directly to each other, AMPS has the ability to use a single connection for replication. The 1E-0063 message indicates that AMPS has detected that it can use a single connection, and is closing the redundant connection.

📄️ Where is the list of all of the error messages in AMPS?

The ampserr utility accepts wildcards for the error numbers to print. You can easily use this to retrieve information about any number of errors.

📄️ What can cause an "unknown command received" or "parse format error"?

AMPS reports messages an 02-0030 message when it receives data on a Transport that does not match the format of the protocol configured for the Transport. At trace level, AMPS will also log information in a 12-0000 message.

📄️ How do I exclude passwords in trace logging?

To exclude passwords from trace logging, you need to remove the trace message that contains the full logon command.