This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

100% CPU usage problem - with migrate_sqlite_to_postgres script

I recently noticed a high CPU load on our 220. Yesterday I rebooted it and the CPU load dropped back to a more normal value of around 10%. But then today I checked again and it is back up to 100%. The log shows that the jump happened at 4:30am. I searched the logs bug found nothing. Then I logged into the 220 and noticed this process:
/usr/bin/perl /usr/local/bin/migrate_sqlite_to_postgres.pl
which started at 4:30am.

It seems to be a script that should have only run 1 time, but keeps running everyday at 4:30am.

Can I kill it?

This thread was automatically locked due to age.

0 jimd over 17 years ago

Nevermind. I just read through the release notes for 7.300 and I see that Astaro has switched to a new database. That script must be doing the conversion.
Cancel
Vote Up 0 Vote Down

Cancel
0 jimd over 17 years ago in reply to jimd

This script is still running after 3 days. Is that normal?
Cancel
Vote Up 0 Vote Down

Cancel
0 Monarch over 17 years ago in reply to jimd

This is completely dependent on the amount of logging data you have.

I want to cite the release notes here:
resulting operation *may* run for many hours/days for environments with large amounts of existing log data

Regards,
Bastian
Cancel
Vote Up 0 Vote Down

Cancel