The condition class sql-temporary-error is used to signal an error that results from other users using the same database. This can be a table lock, but also running out of various resources.
It means the code can work without change, once the other users stop using the database.
LispWorks User Guide and Reference Manual - 13 Feb 2015