Metacat

Add the check that only the administrator can shrink the connection pool.

Close the sql statements on the four methods - getGUID, getHeadPID, systemMetadataSIDExist and systemMetadataPIDExist.

Close some prepared sql statement in the summarize method.

merge from branch: only check for d1 rightsholder when checking permissions in original metacat code base, otherwise legacy access control tests in metcat begin to fail. https://redmine.dataone.org/issues/7560

include check for d1 rightsholder when checking permissions in original metacat code base. https://redmine.dataone.org/issues/7560

merge from 2.5.x branch: neglected to replace solr schema during 2.5.0 upgrade - this will do it for 2.5.1.

Escape the user names, group name and other information in the xml format.

Add the keyword "select" into the list.

remove "al" prefix from subquery since we are only querying one table and do not need to use a prefix.

merge from 2.5 branch: use subquery to do paging before joining to identifier table. https://redmine.dataone.org/issues/7491