nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

query called multiple times

ShlomiW

Hi all, 
 
I have suddenly noticed that when I have a query that contains an error in runs 46 times. 
and each time it returns with the same error message. 
 
The reason that I noticed it is that in some cases that cause the connection to my DB to drop and therefor I can't display any part of my report. 
 
I'm using birt 4.2.1 and Postgresql 9.1 
 
When I'm running the report I see this error message in the Postgresql log file: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
</pre>
 
This is the message that I got when the connection to the DB was drooped. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
IST FATAL: sorry, too many clients already
</pre>
 
And finally this is the query that I used (I know that it's incorrect, but I'm using it to show that birt tries to call it many time and gets the same error message). 
Query: 
<pre class='_prettyXprint _lang-auto _linenums:0'>select age1 from test1</pre>
 
Please help me to figer out how can I fix this issue so that I will not have issue with drooping the connection to the DB when I have an error in one of my SQL queries. 
 
Thanks, Shlomi

Find more posts tagged with

Comments

kclark

What do you have the max connections set to in postgres? Do you have any other applications running that aren't closing the connection after they are done?

ShlomiW

1. I don't know what is the value of "max connections" in postgres, if you could tell me where I can find it I will look for it. 
 
2. The ONLY program that is working with the postgres DB is birt (via eclipse), also note that this is the reason that I added all the "code" parts to my question. because you can definitely see that it's the same query that run each time and that query exists only in my report in birt. 
 
I hope that now my question is more clear, waiting to hear from you again 
Shlomi

Tubal

It would depend on how you have your report set up. 
 
For example, if you have a table based on a dataset parameter inside another table or list, it would call the subtable query once for every record (in this case, 46 records). 
 
I'm not sure why you're getting a too many connections error though. Normally it should close the connection on the completion of a query or an error. 
 
It might help to post your .rptdesign file. 
 
To see your max connections, if you are using pgAdmin, with your db selected, you can go to tools -> server configuration -> postgresql.conf and it will pull up a window with your paramaters. Mine is set to 1000 connections. 
 
If you aren't using pgAdmin, from the psql console in the database you're working with, type <pre class='_prettyXprint _lang-auto _linenums:0'>SHOW max_connections;</pre>

ShlomiW

Hi all,

First of all the "max_connections" value is set to "100".

Second, I have attached here the rptdesign file

ShlomiW

Hi All,

As anyone has any ideas that can help me???

Waiting for you reply
Have a great day
Shlomi

kclark

Have you tried using a query like this to see if you get similar errors? 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>select table1.age1
from table1</pre>

ShlomiW

Hi kclark, 
 
I have tried this, but I still get the same error 6 times in the log file. 
 
 It's important to remember that I'm excepting to get the error message, because my query in incorrect on purpose. 
 
My issue is that I get the same error message 6 time instead of only once. 
 
Waiting for your reply 
Shlomi