You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »

The errors we have been experiencing for the last few days have been intermittent and unpredictable. It is also impacting connections from multiple applications used to connect to the Metadb reporting database.


UserDateTimeTool Query or Dashboardproblemresolution?
Sharon Markus4-15-253pmDBeaver EEmultiple queriesConnection Timed Out Errorsdeleted and rebuilt connection setting for Metadb
Sharon Markus4-16-254amTableauFBO dashboardsData Extract failed - unable to connect ran extract manually at 7am
Jean Pajerek4-16-258amDBeaver EE
Connection Timed Out Errors
Natalya Pikulik4-16-258amTableau
Unable to Connect within Tableauran manually around 9:30am and it updated successfully
Natalya Pikulikearly April
DBeaver EE
Idle Connection Messages
Joanne LearyApril 11
MCR204 Tableau Dashboard
data not updating
Joanne Learymonths
metadb log shows warnings about 2 IP addresses


Joanne Leary4-16-259amCloudBeaver AWS
Connection Timed Out Errors
Annie Keville4-16-2510amCloudBeaver AWSMCR126Connection Timed Out ErrorsTried 2 times to run query and got error. On 3rd try, was able to click Restore (to restore the database connection) and run the query successfully
Joanne Leary4-16-25

1:39pm








1:54pm

DBeaver EE and CloudBeaver AWS








DBeaver EE

EE: query to extract holdings notes (very short but uses a cross join). Query is normally very fast running

CloudBeaver: same short query as above; no connection errors, but query kept grinding. Update: query finished in 6.6 minutes

Update for EE: 1:54pm - was able to connect and query ran in .06 sec

EE: Connection time out errors

CloudBeaver: no connection errors but query seemed to be stuck and never finished. Update: query finished in 6.6 minutes.

EE: Tried with metadb_user connection and with jl41 connection; neither worked

CloudBeaver: took 6.6 mins

Sharon Markus4-16-25

2;21pm

DBeaver EE

MCR204

Can't open editor connection

Reason:
Connection to metadb-db-cornell.folio.ebsco.com:5434 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

none

Natalya Pikulik

3:30pm

Dbeaver EE, 

Cloudbeaver



Tableau is OK

100e

Error connecting to database:

Connection attempt timed out.

Error connecting to database:

Connection attempt timed out.

CONNECTED


Joanne Leary4-16-26

4:30pm

CloudBeaver

Short query to get holdings notes from holdings_record table

Firefox browser: kept grinding away; not done yet

Chrome: ran instantly

Chrome (second try a few minutes later): bogged down; however, I was trying to run a different much more complicated query at the same time. That query was probably causing the problem (had many subqueries and data array extracts). Neither query could not execute.







  • No labels