Dear all,
I already wrote to this mailing list for a problem with an H2 database growing substantially without apparent reasons. This created a very slow geonetwork website. The suggestion I received was to move to PostgreSQL for a production environment, which I did.
Today, again, I have a very slow geonetwork, resulting often in a Out of Memory error when I try to reach the landing page. Checking the database, I noticed that the settings table weight 391Mb, which seems a lot as there are only 118 rows in the table!
My question is: Is this a 'normal' size for a working geonetwork database, considering that I have around 200 metadata records (mostly harvested)?
One 'strange' info I find in the setting table is the system/publication/doi/doipassword value which is an encrypted password, but it is more than 65.000 characters. It seems quite a lot.
Thanks for your help!
Best regards,
Nicolas de Ville
Hi Nicolas,
sounds like your passwords are encoded, re-encoded and again and again ...
Check the startup notice about the encryptor.properties file that must be
preserved on each updates:
2022-02-04 13:05:48,101 INFO [geonetwork.encryptor] - Password database
encryptor initialized - Keep the file
/WEB-INF/data/config/encryptor.properties safe and make a backup. When
upgrading to a newer version of GeoNetwork the file must be restored,
otherwise GeoNetwork will not be able to decrypt passwords already stored
in the database.
2022-02-04 13:05:48,117 INFO [geonetwork.encryptor] - Password database
encryptor - encrypting passwords stored in the database
https://geonetwork-opensource.org/manuals/4.0.x/en/maintainer-guide/updating/index.html?highlight=encryptor%20properties
Reset the password in the settings table
UPDATE Settings SET value = '' WHERE name LIKE '%password%';
Restart and populate them again from the admin.
Once encoded, they should not change on restart.
HTH.
Francois
Le ven. 4 févr. 2022 à 12:59, Nicolas De Ville De Goyet via
GeoNetwork-users <geonetwork-users@lists.sourceforge.net> a écrit :
Dear all,
I already wrote to this mailing list for a problem with an H2 database
growing substantially without apparent reasons. This created a very slow
geonetwork website. The suggestion I received was to move to PostgreSQL
for a production environment, which I did.
Today, again, I have a very slow geonetwork, resulting often in a Out of
Memory error when I try to reach the landing page. Checking the
database, I noticed that the settings table weight 391Mb, which seems a
lot as there are only 118 rows in the table!
My question is: Is this a 'normal' size for a working geonetwork
database, considering that I have around 200 metadata records (mostly
harvested)?
One 'strange' info I find in the setting table is the
system/publication/doi/doipassword value which is an encrypted password,
but it is more than 65.000 characters. It seems quite a lot.
Thanks for your help!
Best regards,
Nicolas de Ville
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
Dear François,
Thank you for your answer. It seems this long password was indeed the issue. After deleting it geonetwork is back to its normal speed.
Best,
Nicolas
On 4/02/22 13:11, Francois Prunayre wrote:
Hi Nicolas,
sounds like your passwords are encoded, re-encoded and again and again ...
Check the startup notice about the encryptor.properties file that must be preserved on each updates:
2022-02-04 13:05:48,101 INFO [geonetwork.encryptor] - Password database encryptor initialized - Keep the file /WEB-INF/data/config/encryptor.properties safe and make a backup. When upgrading to a newer version of GeoNetwork the file must be restored, otherwise GeoNetwork will not be able to decrypt passwords already stored in the database.
2022-02-04 13:05:48,117 INFO [geonetwork.encryptor] - Password database encryptor - encrypting passwords stored in the database
https://geonetwork-opensource.org/manuals/4.0.x/en/maintainer-guide/updating/index.html?highlight=encryptor%20properties <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgeonetwork-opensource.org%2Fmanuals%2F4.0.x%2Fen%2Fmaintainer-guide%2Fupdating%2Findex.html%3Fhighlight%3Dencryptor%2520properties&data=04|01|ndeville%40naturalsciences.be|a91222db10ab4d7ecb4408d9e7d77c11|4da8d35db472419c9e15665786aadbfb|1|0|637795734952051107|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=hQipwSA2sD2nlk2GMHzIS0fPRa7ivjwGgYrM2%2F8oc%2Fw%3D&reserved=0>
Reset the password in the settings table
UPDATE Settings SET value = '' WHERE name LIKE '%password%';
Restart and populate them again from the admin.
Once encoded, they should not change on restart.
HTH.
Francois
Le ven. 4 févr. 2022 à 12:59, Nicolas De Ville De Goyet via GeoNetwork-users <geonetwork-users@lists.sourceforge.net> a écrit :
Dear all,
I already wrote to this mailing list for a problem with an H2
database
growing substantially without apparent reasons. This created a
very slow
geonetwork website. The suggestion I received was to move to
PostgreSQL
for a production environment, which I did.
Today, again, I have a very slow geonetwork, resulting often in a
Out of
Memory error when I try to reach the landing page. Checking the
database, I noticed that the settings table weight 391Mb, which
seems a
lot as there are only 118 rows in the table!
My question is: Is this a 'normal' size for a working geonetwork
database, considering that I have around 200 metadata records (mostly
harvested)?
One 'strange' info I find in the setting table is the
system/publication/doi/doipassword value which is an encrypted
password,
but it is more than 65.000 characters. It seems quite a lot.
Thanks for your help!
Best regards,
Nicolas de Ville
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeonetwork-users&data=04|01|ndeville%40naturalsciences.be|a91222db10ab4d7ecb4408d9e7d77c11|4da8d35db472419c9e15665786aadbfb|1|0|637795734952051107|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=nLTYN5RvJpd%2BFq7koZnL1yBhyhnXllh%2BVB8bf7oUODw%3D&reserved=0>
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fgeonetwork&data=04|01|ndeville%40naturalsciences.be|a91222db10ab4d7ecb4408d9e7d77c11|4da8d35db472419c9e15665786aadbfb|1|0|637795734952051107|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D|3000&sdata=HcOmuUG66XFWNfpOKWFq2Ul9SpCzvuwwTuPberAY4m8%3D&reserved=0>