Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

Meta Data backups are failing due to timeout issue

shobhit_shukla
Padawan

Hi Bogdan,

We are facing an issue of Metadata Backup failure. We are receiving continuous backup failure alert for the backups. When we retrigger the meta data backup through backup.sh its failing with below error.

Error: [R0001] Query terminated because timeout has been reached. (Session: 1728542603309875201)

1 REPLY 1

exa-Nico
Community Manager
Community Manager

Hi @shobhit_shukla My guess is the database has a set query timeout which is aborting one of the queries that takes longer to execute. Could you check it with the following query:

SELECT * FROM EXA_PARAMETERS WHERE PARAMETER_NAME = 'QUERY_TIMEOUT'
Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution