由於資料庫鎖定，嘗試安裝AVP套裝時，Avamar Installer （AVI） 停止回應

Summary: 由於資料庫鎖定，安裝AVP套裝時，Avamar Installer （AVI） 會停止回應。

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

環境：Avamar 伺服器版本 7.2.1-32，但可能適用於更新版本。

安裝AVP套裝時，Avamar Installer 介面 （AVI） 會停止回應。

安裝進度

重新啟動瀏覽器時，顯示 AVI 正在「正在安裝」套件。
選取「Continue」（繼續） 結果沒有進度。  
軟體更新頁面
 
 
 

Cause

Avamar Installer 記錄 /usr/local/avamar/var/avi/server_log/avinstaller.log* 顯示; 
Jun 15, 2017 4:50:01 PM com.avamar.avinstaller.process.InstallManager install
INFO: Starting a new process instance.
Jun 15, 2017 4:50:01 PM com.avamar.avinstaller.process.UserInputManager getCurrentUserInput
INFO: Returned cached user input for checksum: bdc8a9876130f3199be845ca1d7866a5
Jun 15, 2017 4:50:01 PM com.avamar.avinstaller.process.PVM startProcessInstanceByKey
INFO: Starting processKey: upgrade-client-downloads20161009Oct101476054930 with userInputs: {}
Jun 15, 2017 4:50:01 PM org.hibernate.transaction.JDBCTransaction commit
SEVERE: JDBC commit failed
java.sql.SQLException: database is locked
at org.sqlite.DB.throwex(DB.java:855)
at org.sqlite.DB.exec(DB.java:138)
at org.sqlite.SQLiteConnection.commit(SQLiteConnection.java:512)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:170)
.
. -----------8<---------- SNIP!-----------8<---------- 
.
at com.avamar.avinstaller.process.InstallManager.install(InstallManager.java:125)
at com.avamar.avinstaller.monitor.Installer.run(Installer.java:46)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: database is locked

如 avinstaller 記錄專案所暗示，PosgreSQL avi 資料庫會鎖定。
根本原因不明。工程錯誤272057記錄 AVinstaller 無法寫入 AVI 資料庫的類似案例。
這發生在每小時MCS排清作業期間。
導致資料庫處於鎖定狀態的多個同時作業。

Resolution

解決方案：
重新啟動 AVI 可能會移除資料庫鎖定。
以下命令顯示如何停止，然後啟動AVIDB和tomcat。

如果行為仍然存在，請聯絡 Dell 支援。 
admin@avamar:~/>: sudo avinstaller.pl --help | grep "stop\|start"
--start                   starts avidb and tomcat if not up
--stop                    stops avidb and tomcat

Example:-

admin@avamar:~/>: sudo avinstaller.pl --stop
INFO: Waiting for Tomcat to shutdown
INFO: Shutting down avidb.
Stopping the database server.
Database server stopped.
INFO: Stopped the database.
 


admin@avamar:~/>: sudo avinstaller.pl --start
INFO: Starting avidb.
Starting the database server.
Waiting for postmaster to start .
Connected to DBI:Pg:dbname=postgres;port=5558.
INFO: Started the database.
/usr/local/avamar-tomcat/bin/startup.sh
Using CATALINA_BASE:   /usr/local/avamar-tomcat
Using CATALINA_HOME:   /usr/local/avamar-tomcat
Using CATALINA_TMPDIR: /usr/local/avamar-tomcat/temp
Using JRE_HOME:        /usr
Using CLASSPATH:       /usr/local/avamar-tomcat/bin/bootstrap.jar:/usr/local/avamar-tomcat/bin/tomcat-juli.jar
Tomcat started.

Affected Products

Avamar

Products

Avamar, Avamar Server
Article Properties
Article Number: 000046163
Article Type: Solution
Last Modified: 06 Feb 2025
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.