Does the following "Attempt to reload definition" message come from the SQL Anywhere 16 server? (Google hasn't been much help)

SQL Anywhere Network Server Version
E. 04/22 08:23:24. Attempt to reload definition for event "rroad_monitor_sample_loop" failed due to concurrent event execution

AFAIK it appears when a particular TRIGGER EVENT is executed, in legacy code which has been executed billions of times over the years without this symptom.

If this is an (undocumented?) SQL Anywhere message, is it an exception that would (should?) be trapped by EXCEPTION WHEN OTHERS THEN?

Bad news: The code has EXCEPTION handlers everywhere; i.e., in the triggering block and in the event handler itself, and neither of them saw an exception.

Good news: Stopping and restarting dbsrv16 made it go away.

Bad news: A repro is unlikely :)

asked 22 Apr, 08:47

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 22 Apr, 09:02

The noted message does get generated by the server. This message will be printed to the server console log when an event is being prepared to be executed, the event is marked as needing to be reloaded (for example, due to DDL having been executed on the database), and the attempt to reload the event definition failed (for not entirely understood reasons ... but looks to be related to having multiple occurrences of a single event executing at the same time).

This message cannot be trapped by an exception clause because the issue is raised on the worker that is attempting to execute the event. I.e. it is running asynchronous to the worker that triggered the event.

AFAICT There is no easy way to detect when this has happened (except scanning the console log for the message).

permanent link

answered 24 Apr, 08:52

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 22 Apr, 08:47

question was seen: 85 times

last updated: 24 Apr, 08:52