Error purging PostgreSQL database. Reason: ERROR: syntax error at or near “exists”Position: 15PostgreSQL...
What is the wife of a henpecked husband called?
Can a hotel cancel a confirmed reservation?
Is using an 'empty' metaphor considered bad style?
Why did the villain in the first Men in Black movie care about Earth's Cockroaches?
Increment each digit in a number to form a new number
How do I append a character to the end of every line in an Excel cell?
Finding a logistic regression model which can achieve zero error on a training set training data for a binary classification problem with two features
What is the purpose of easy combat scenarios that don't need resource expenditure?
How does Leonard in "Memento" remember reading and writing?
A Missing Symbol for This Logo
If I delete my router's history can my ISP still provide it to my parents?
A curious equality of integrals involving the prime counting function?
Cookies - Should the toggles be on?
kill -0 <PID> は何をするのでしょうか？
Why publish a research paper when a blog post or a lecture slide can have more citation count than a journal paper?
Why is working on the same position for more than 15 years not a red flag?
Absorbing damage with Planeswalker
What's a good word to describe a public place that looks like it wouldn't be rough?
How can my powered armor quickly replace its ceramic plates?
Difference between i++ and (i)++ in C
Dilemma of explaining to interviewer that he is the reason for declining second interview
Should I reinstall Linux when changing the laptop's CPU?
How would an AI self awareness kill switch work?
Can you tell from a blurry photo if focus was too close or too far?
Error purging PostgreSQL database. Reason: ERROR: syntax error at or near “exists”Position: 15
PostgreSQL import CSV File causes Syntax ErrorSyntax Error In Postgresql FunctionPostgreSQL function definition “syntax error at or near +”Syntax error in postgresql querysyntax error on mathematical operation postgresqlPostgreSQL UUID Literal: ERROR: syntax error at or nearsyntax error at or near “IF”Postgres - syntax error near IF when using inside Executesyntax error at or near - INSERTPsycopg2 error at or near %
I am using PostgreSQL database with Tomcat Server. When I checked webpage today, it shows about mentioned alarm with following logs:
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.csta.d.c.k - Purging Devices
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.cs.e.u - No lock folder to check yet
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging and checking for historic archive runs
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging archive \ip-addressarchive3
2018-11-05 01:06:05,643 [1AM Thread] INFO com.swhh.cs.e.au - Purging recordings (except those locked) prior to Nov 5, 2013 1:06:05 AM
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point.
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point and/or spanning the purge point.
2018-11-05 01:06:05,659 [1AM Thread] ERROR com.swhh.cs.a.p - Alarm raised err.database.purge [ERROR: syntax error at or near "exists"
Position: 15] [null]
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Daily House-keeping completed
postgresql
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
bumped to the homepage by Community♦ 19 secs ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am using PostgreSQL database with Tomcat Server. When I checked webpage today, it shows about mentioned alarm with following logs:
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.csta.d.c.k - Purging Devices
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.cs.e.u - No lock folder to check yet
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging and checking for historic archive runs
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging archive \ip-addressarchive3
2018-11-05 01:06:05,643 [1AM Thread] INFO com.swhh.cs.e.au - Purging recordings (except those locked) prior to Nov 5, 2013 1:06:05 AM
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point.
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point and/or spanning the purge point.
2018-11-05 01:06:05,659 [1AM Thread] ERROR com.swhh.cs.a.p - Alarm raised err.database.purge [ERROR: syntax error at or near "exists"
Position: 15] [null]
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Daily House-keeping completed
postgresql
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
bumped to the homepage by Community♦ 19 secs ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
2
edit your question (by clicking on the edit link below it) and show us the SQL statement that generates that error (edit your question do not post code in comments)
– a_horse_with_no_name
Nov 5 '18 at 7:34
1
Check the postgres logs, rather than the Tomcat logs.
– jjanes
Nov 5 '18 at 20:49
add a comment |
I am using PostgreSQL database with Tomcat Server. When I checked webpage today, it shows about mentioned alarm with following logs:
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.csta.d.c.k - Purging Devices
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.cs.e.u - No lock folder to check yet
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging and checking for historic archive runs
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging archive \ip-addressarchive3
2018-11-05 01:06:05,643 [1AM Thread] INFO com.swhh.cs.e.au - Purging recordings (except those locked) prior to Nov 5, 2013 1:06:05 AM
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point.
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point and/or spanning the purge point.
2018-11-05 01:06:05,659 [1AM Thread] ERROR com.swhh.cs.a.p - Alarm raised err.database.purge [ERROR: syntax error at or near "exists"
Position: 15] [null]
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Daily House-keeping completed
postgresql
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
I am using PostgreSQL database with Tomcat Server. When I checked webpage today, it shows about mentioned alarm with following logs:
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.csta.d.c.k - Purging Devices
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] WARN com.swhh.csta.a.n - REFRESH: TSAPI service down.
2018-11-05 01:06:05,628 [1AM Thread] DEBUG com.swhh.cs.e.u - No lock folder to check yet
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging and checking for historic archive runs
2018-11-05 01:06:05,628 [1AM Thread] INFO com.swhh.cs.uarchive.h - Purging archive \ip-addressarchive3
2018-11-05 01:06:05,643 [1AM Thread] INFO com.swhh.cs.e.au - Purging recordings (except those locked) prior to Nov 5, 2013 1:06:05 AM
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point.
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Retaining 0 contacts due to locked records from before purge point and/or spanning the purge point.
2018-11-05 01:06:05,659 [1AM Thread] ERROR com.swhh.cs.a.p - Alarm raised err.database.purge [ERROR: syntax error at or near "exists"
Position: 15] [null]
2018-11-05 01:06:05,659 [1AM Thread] INFO com.swhh.cs.e.au - Daily House-keeping completed
postgresql
postgresql
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
edited Nov 5 '18 at 7:33
a_horse_with_no_name
40.1k776112
40.1k776112
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
asked Nov 5 '18 at 7:26
Yatish BathlaYatish Bathla
1063
1063
bumped to the homepage by Community♦ 19 secs ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 19 secs ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
2
edit your question (by clicking on the edit link below it) and show us the SQL statement that generates that error (edit your question do not post code in comments)
– a_horse_with_no_name
Nov 5 '18 at 7:34
1
Check the postgres logs, rather than the Tomcat logs.
– jjanes
Nov 5 '18 at 20:49
add a comment |
2
edit your question (by clicking on the edit link below it) and show us the SQL statement that generates that error (edit your question do not post code in comments)
– a_horse_with_no_name
Nov 5 '18 at 7:34
1
Check the postgres logs, rather than the Tomcat logs.
– jjanes
Nov 5 '18 at 20:49
2
2
edit your question (by clicking on the edit link below it) and show us the SQL statement that generates that error (edit your question do not post code in comments)
– a_horse_with_no_name
Nov 5 '18 at 7:34
edit your question (by clicking on the edit link below it) and show us the SQL statement that generates that error (edit your question do not post code in comments)
– a_horse_with_no_name
Nov 5 '18 at 7:34
1
1
Check the postgres logs, rather than the Tomcat logs.
– jjanes
Nov 5 '18 at 20:49
Check the postgres logs, rather than the Tomcat logs.
– jjanes
Nov 5 '18 at 20:49
add a comment |
1 Answer
1
active
oldest
votes
After checking postgres logs, I update postgres version from 8 to 9.2 and everything works now.
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f221782%2ferror-purging-postgresql-database-reason-error-syntax-error-at-or-near-exist%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
After checking postgres logs, I update postgres version from 8 to 9.2 and everything works now.
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
add a comment |
After checking postgres logs, I update postgres version from 8 to 9.2 and everything works now.
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
add a comment |
After checking postgres logs, I update postgres version from 8 to 9.2 and everything works now.
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
After checking postgres logs, I update postgres version from 8 to 9.2 and everything works now.
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
answered Nov 7 '18 at 15:24
Yatish BathlaYatish Bathla
1063
1063
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f221782%2ferror-purging-postgresql-database-reason-error-syntax-error-at-or-near-exist%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
edit your question (by clicking on the edit link below it) and show us the SQL statement that generates that error (edit your question do not post code in comments)
– a_horse_with_no_name
Nov 5 '18 at 7:34
1
Check the postgres logs, rather than the Tomcat logs.
– jjanes
Nov 5 '18 at 20:49