Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

ORMReload Scanning All databases

Description

We are using Hibernate on our application, and on startup it runs

ORMReload();

We noticed that it was taking longer than usual, and maxing out the DB CPU.

After running SHOW PROCESSLIST; in the DB to see whats going on, we saw the application running queries like:

SHOW DATABASES (Many times) SHOW FULL TABLES FROM `mysql` LIKE `swaccount` SHOW FULL TABLES FROM `information_schema` LIKE `swaccount`

It scans the whole database, and its not even limited to the datasources.

Environment

NAME="Amazon Linux AMI"
VERSION="2018.03"
ID="amzn"
ID_LIKE="rhel fedora"
VERSION_ID="2018.03"
PRETTY_NAME="Amazon Linux AMI 2018.03"
ANSI_COLOR="0;33"
CPE_NAME="cpe:/o:amazon:linux:2018.03:ga"
HOME_URL="http://aws.amazon.com/amazon-linux-ami/"

Attachments

3
  • 22 Nov 2019, 09:17 pm
  • 22 Nov 2019, 09:15 pm
  • 22 Nov 2019, 08:50 pm

Activity

Show:

Miguel Targa 22 November 2019 at 21:17

 

Miguel Targa 22 November 2019 at 21:15

SHOW SCHEMAS is getting called multiple times, resulting on CPU spike

 

Miguel Targa 22 November 2019 at 20:50

 

 

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Original estimate

Time tracking

No time logged

Sprint

Affects versions

Created 22 November 2019 at 13:44
Updated 3 April 2020 at 18:44

Flag notifications