Postgres outputs warnings in its console

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
dbanet
Bear Rating Trainee
Bear Rating Trainee
Posts: 11
Joined: 28 Jan 2014, 01:37
Location: Moscow, Russia
Contact:

Postgres outputs warnings in its console

Postby dbanet » 08 Mar 2014, 00:55

Code: Select all

WARNING:  nonstandard use of \\ in a string literal at character 131
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

TT-RSS version 1.11
Postgres version 9.0.6

Am I the only one with this? What may be wrong?

Btw, TT-RSS works just fine.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Postgres outputs warnings in its console

Postby fox » 08 Mar 2014, 00:58

It would be much more helpful if you described what tt-rss was doing when that happened. If it was updating a feed, post the url, etc. Provide some context.

e: spelling

dbanet
Bear Rating Trainee
Bear Rating Trainee
Posts: 11
Joined: 28 Jan 2014, 01:37
Location: Moscow, Russia
Contact:

Re: Postgres outputs warnings in its console

Postby dbanet » 08 Mar 2014, 01:25

Hrm. Logging out on all devices and closing the tabs didn't stop the warnings.

Then I stopped the update daemon, and started it again, and then I got a warning in the Postgres console immediately.
AFAICS, it throws a warning every 120 seconds (updating delay), even if there is no new... content? in any feed (not sure about RSS terminology).

AFAICS, nothing else (selecting a feed, deleting a feed, adding a feed) produces this warning.

tob
Bear Rating Trainee
Bear Rating Trainee
Posts: 30
Joined: 08 Feb 2014, 20:35

Re: Postgres outputs warnings in its console

Postby tob » 08 Mar 2014, 03:31

Postgres interprets \\ as \\ but some people write \\ to mean \, so it can be configured to emit a warning.

No matter the configuration, if all strings are properly escaped this doesn't happen, so there might be a few lines in the source just waiting to explode.

Anybody know how to turn on SQL logging?

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Postgres outputs warnings in its console

Postby sleeper_service » 08 Mar 2014, 03:43

like log all queries in postgres? setting

log_min_duration_statement = 0

in your postgresql.conf file will make your log files get very big, quickly.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Postgres outputs warnings in its console

Postby fox » 08 Mar 2014, 14:16

Yeah I second the enabling statement logging idea. Please do that and post the relevant part here (i.e. the queries leading to the warning).

dbanet
Bear Rating Trainee
Bear Rating Trainee
Posts: 11
Joined: 28 Jan 2014, 01:37
Location: Moscow, Russia
Contact:

Re: Postgres outputs warnings in its console

Postby dbanet » 08 Mar 2014, 18:32

Okay, I will post the logs ASAP, but I think not soon -- I have to dig into the configuration file...


Return to “Support”

Who is online

Users browsing this forum: No registered users and 9 guests