Skip to content
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

LogDNA logging info at Error level for PostgreSQL #104

Open
blaza1 opened this issue Jun 17, 2019 · 7 comments
Open

LogDNA logging info at Error level for PostgreSQL #104

blaza1 opened this issue Jun 17, 2019 · 7 comments
Assignees

Comments

@blaza1
Copy link

blaza1 commented Jun 17, 2019

The docs seems to suggest that postgresql logging is supported by logdna https://docs.logdna.com/docs/ingestion#section-supported-types However the info level message: LOG: incomplete startup packet gets filtered gets marked at Error level:
image
Is this expected behaviour?

@jakedipity
Copy link
Contributor

It's possible that your log is being wrapped by something like syslog or kubernetes and that's where we are deriving the level from. It's also possible that there's an error with our postgresql format. It's hard to say with out more context. Can you send me a direct message on our public slack channel with a link to the offending line?

https://logdna-public.slack.com/messages/D8Y0ZEFS7/

@blaza1
Copy link
Author

blaza1 commented Jul 1, 2019

Ok, thanks for your reply. I've direct messaged you.

@victorbr
Copy link

victorbr commented Dec 8, 2019

It appears LogDNA classifies any message containing the word "error" as a message at ERROR log level. Is this intentional? Can this be turned off? We had to rephrase some of our own messages to use "problem" instead of "error" just because of this but not every message is under our control...

@smusali
Copy link
Contributor

smusali commented Dec 8, 2019

@victorbr, thanks for bringing this up!

It is hard to say without any example and other info whether it is intentional or a bug. We do have parsing for PostgreSQL logs and can you please open a ticket containing information about which tool you are using to get the logs? We could better assist you and clarify the situation if we have more info.

Thanks a lot in advance!

@smusali
Copy link
Contributor

smusali commented Dec 8, 2019

@blaza1, we would like to know whether you are still having the same issues.

@victorbr
Copy link

victorbr commented Dec 11, 2019

It looks it's enough to issue log.info("error") - it doesn't matter what source the line comes from.
For example - the code looks like this:

                } catch (Exception e) {
                    logger.warn("Failed to initialize SAML client " + indirectClient.getName(), e);
                }

And this results in the following output in LogDNA:
image
The only reason the line "Error getting idp Metadata resource" is marked as "Error" is because it contains the word "Error".

P.S. If you think it's separate issue, please let me know - we could open a new one.

@andkon
Copy link

andkon commented Dec 11, 2019

@victorbr thanks for posting this! It's likely related; we're investigating on our end now, and will update here as we go.

@smusali smusali changed the title Logdna logging info at Error level for postgresql LogDNA logging info at Error level for PostgreSQL Dec 18, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

6 participants