Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".
I haven't seen that before. Is Postgres running on the same machine as
Aggregate? Are you still getting this error or did the error
disappear?
As a quick fix try restarting Postgres and Aggregate to unwedge things
if they still won't communicated.
Cheers,
Waylon
···
On Fri, Jun 15, 2012 at 7:16 AM, Tumaini Kilimba wrote:
> Dear all,
> I spent this morning submitting data from 24 tablets to the Aggregate server
> via the wireless network. I then manually uploaded data from the
> odk/instances folder that I had saved a few days ago on my desktop. This
> worked for approximately 50 submissions, after which the Aggregate server
> would not let me upload any more, giving me "an unexpected error has
> occured" kind of vague error. Looking at the Tomcat logs as well as the
> postgres logs I get the message
>
> "SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
> org.postgresql.util.PSQLException: FATAL: remaining connection slots are
> reserved for non-replication superuser connections".
>
> Has anyone faced a similar problem before?
>
> Thanks in advance,
> Tumaini
>
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en
I'm just wondering if you encountered same experience/can suggest possible solutions:
I tried the "manually upload data" of ODK aggregate. All data entries have been uploaded except for photos.
I can say that this is just a problem of using "manual uploading" since when I upload directly from the device to ODK Aggregate via Internet, the photos will be also uploaded.
Thanks in advance.
Raffy
···
On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
> Dear all,
> I spent this morning submitting data from 24 tablets to the Aggregate server via the wireless network. I then manually uploaded data from the odk/instances folder that I had saved a few days ago on my desktop. This worked for approximately 50 submissions, after which the Aggregate server would not let me upload any more, giving me "an unexpected error has occured" kind of vague error. Looking at the Tomcat logs as well as the postgres logs I get the message
>
>
> "SEVERE: Error in trying to obtain a connection. Retrying in 7000ms org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections".
>
>
> Has anyone faced a similar problem before?
>
>
> Thanks in advance,
> Tumaini
Hello Waylon,
Postgres IS running on the same machine as Aggregate, I have also tried
restarting the postgres service, the tomcat service and even restarting the
physical machine...
Thanks,
Tumaini
···
On Fri, Jun 15, 2012 at 7:36 PM, W. Brunette wrote:
Tumaini,
I haven't seen that before. Is Postgres running on the same machine as
Aggregate? Are you still getting this error or did the error
disappear?
As a quick fix try restarting Postgres and Aggregate to unwedge things
if they still won't communicated.
Cheers,
Waylon
On Fri, Jun 15, 2012 at 7:16 AM, Tumaini Kilimba tkilimba@ihi.or.tz wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server
via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".
Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.
You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.
Yaw
···
--
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.
I'm just wondering if you encountered same experience/can suggest possible solutions:
I tried the "manually upload data" of ODK aggregate. All data entries have been uploaded except for photos.
I can say that this is just a problem of using "manual uploading" since when I upload directly from the device to ODK Aggregate via Internet, the photos will be also uploaded.
Thanks in advance.
Raffy
On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate server via the wireless network. I then manually uploaded data from the odk/instances folder that I had saved a few days ago on my desktop. This worked for approximately 50 submissions, after which the Aggregate server would not let me upload any more, giving me "an unexpected error has occured" kind of vague error. Looking at the Tomcat logs as well as the postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections".
Postgres IS running on the same machine as Aggregate, I have also tried
restarting the postgres service, the tomcat service and even restarting the
physical machine...
Try increasing max_connections (integer) if your machine will allow
that and restart postgres. Whenever the number of active concurrent
connections is at least max_connections minus
superuser_reserved_connections (default 3), new connections will be
accepted only for superusers, and no new replication connections will
be accepted.
OK, though am still puzzled as to why I have 97 concurrent connections to
my Postgres database (max_conections - superuser_reserved_connections =100
3=97), when the only thing that should be accessing postgres as the ODK
Aggregate application, and I would have thought thats just ONE connection,
where are the other 96 coming from?
Thanks,
Tumaini
···
On Saturday, June 16, 2012 5:31:54 PM UTC+3, Ian Lawrence wrote:
>
> Hi
>
>
> > Postgres IS running on the same machine as Aggregate, I have also tried
> > restarting the postgres service, the tomcat service and even restarting
> the
> > physical machine...
>
> Try increasing max_connections (integer) if your machine will allow
> that and restart postgres. Whenever the number of active concurrent
> connections is at least max_connections minus
> superuser_reserved_connections (default 3), new connections will be
> accepted only for superusers, and no new replication connections will
> be accepted.
>
> Regards
>
> --
> http://ianlawrence.info
>
What I did was I transferred first the files to the local drive and then
manually upload the files from hard drive to ODK Aggregate.
Raffy
···
On Sun, Feb 14, 2016 at 3:32 PM, Yaw Anokwa wrote:
Hi Raffy,
Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.
You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
I'm just wondering if you encountered same experience/can suggest
possible solutions:
I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.
I can say that this is just a problem of using "manual uploading" since
when I upload directly from the device to ODK Aggregate via Internet, the
photos will be also uploaded.
Thanks in advance.
Raffy
On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".
Database connections take time to establish, so the server maintains a pool
of established connections and should be using connections from that pool
to interact with the database and then releasing them back into the pool
after it is done. Depending upon the rate at which you're doing this, the
server will grow or shrink this pool.
Your database connections seem as if they are not be being released back
into this pool. I'm not familiar with all the configuration settings in
this area of the code (it could be that you have a very large JVM defined
under Tomcat, and the releases might be tied to garbage collection cycles).
The software uses BoneCP for the connection pool and Spring JDBC for the
connection management. There are undoubtedly configuration settings for
each of these that can tweak the way connections are managed.
Mitch
···
On Mon, Jun 18, 2012 at 10:35 PM, Tumaini Kilimba wrote:
OK, though am still puzzled as to why I have 97 concurrent connections to
my Postgres database (max_conections - superuser_reserved_connections =100
3=97), when the only thing that should be accessing postgres as the ODK
Aggregate application, and I would have thought thats just ONE connection,
where are the other 96 coming from?
Thanks,
Tumaini
On Saturday, June 16, 2012 5:31:54 PM UTC+3, Ian Lawrence wrote:
Hi
Postgres IS running on the same machine as Aggregate, I have also tried
restarting the postgres service, the tomcat service and even restarting
the
physical machine...
Try increasing max_connections (integer) if your machine will allow
that and restart postgres. Whenever the number of active concurrent
connections is at least max_connections minus
superuser_reserved_connections (default 3), new connections will be
accepted only for superusers, and no new replication connections will
be accepted.
Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.
Yaw
···
--
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.
Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.
You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
I'm just wondering if you encountered same experience/can suggest
possible solutions:
I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.
I can say that this is just a problem of using "manual uploading" since
when I upload directly from the device to ODK Aggregate via Internet, the
photos will be also uploaded.
Thanks in advance.
Raffy
On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".
We are using Aggregate since we connected it to a server. Thanks.
Raffy
···
On Mon, Feb 15, 2016 at 3:53 PM, Yaw Anokwa wrote:
Hi Raffy,
Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.
You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
I'm just wondering if you encountered same experience/can suggest
possible solutions:
I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.
I can say that this is just a problem of using "manual uploading"
since
when I upload directly from the device to ODK Aggregate via Internet,
the
photos will be also uploaded.
Thanks in advance.
Raffy
On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from
the
odk/instances folder that I had saved a few days ago on my desktop.
This
worked for approximately 50 submissions, after which the Aggregate
server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as
the
postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots
are
reserved for non-replication superuser connections".
Try pulling forms from the phone using Briefcase and then push them to
the server that way.
Yaw
···
--
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.
Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.
You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
I'm just wondering if you encountered same experience/can suggest
possible solutions:
I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.
I can say that this is just a problem of using "manual uploading"
since
when I upload directly from the device to ODK Aggregate via Internet,
the
photos will be also uploaded.
Thanks in advance.
Raffy
On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the
Aggregate
server via the wireless network. I then manually uploaded data from
the
odk/instances folder that I had saved a few days ago on my desktop.
This
worked for approximately 50 submissions, after which the Aggregate
server
would not let me upload any more, giving me "an unexpected error
has
occured" kind of vague error. Looking at the Tomcat logs as well as
the
postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots
are
reserved for non-replication superuser connections".
Try pulling forms from the phone using Briefcase and then push them to
the server that way.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.
You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.
Yaw
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to https://nafundi.com to get started.
I'm just wondering if you encountered same experience/can suggest
possible solutions:
I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.
I can say that this is just a problem of using "manual uploading"
since
when I upload directly from the device to ODK Aggregate via Internet,
the
photos will be also uploaded.
Thanks in advance.
Raffy
On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the
Aggregate
server via the wireless network. I then manually uploaded data from
the
odk/instances folder that I had saved a few days ago on my desktop.
This
worked for approximately 50 submissions, after which the Aggregate
server
would not let me upload any more, giving me "an unexpected error
has
occured" kind of vague error. Looking at the Tomcat logs as well as
the
postgres logs I get the message
"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots
are
reserved for non-replication superuser connections".