Bamboo startup or runtime error due to ORA-00257 archiver error
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
問題
Bamboo doesn't start up or has a runtime error. The following message appears in the atlassian-bamboo.log file:
[BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@30fc16d3 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
or just
ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
原因
The ORA-00257 error is thrown by Oracle when the archive destination disk or volume is full. Here's the cause taken from the Oracle website:
The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.
ソリューション
Check the available space on the filesystem where the Oracle archive redo logs are stored. This can be done with the following SQL query:
show parameter log_archive;
- If the disk is full, try to free space using any of the following methods:
- Compressing older files.
- Removing older archives.
- Adding more storage.
There's an archived thread on Oracle community that goes over the troubleshooting in more detail.