Is it possible to somehow emulate the self_recursion option in the Watcom-SQL dialect for a trigger?
I would like to completely eliminate the possibility of recursively calling a trigger ("Triggers firing themselves").
We have several database servers in AWS cloud in ap-southeast-2 region. On each server we have several SAP ASA 17 databases (17.0.10.5963), running as Windows services.
Each service is configured as delayed auto start. On 24.02 24 and 26.02.24 we had...
I observe a strange (incorrect?) calculation in minutes (SQL Anywhere Server Version 17.0.10.5963):
BEGIN
declare ClockOn time;
declare ClockOff time;
set ClockOn = cast('09:59:59.999' as time);
set ClockOff = cast('10:00:00.001' as time);
select Clo...
Today the client (SQL Anywhere Network Server Version 17.0.10.5963) encountered the following situation when connecting to the database. For example:
I. 11/29 12:01:59. Connection from 10.2.2.70:50753 assigned connection ID 1302
I. 11/29 12:02:29. Co...
The database (SQL Anywhere 17) is "attacked" by an unknown application.
We receive dozens of messages:
I. 11/17 13:07:20. Connection from XX.X.XX.XXX:XXXXX assigned connection ID 224
E. 11/17 13:07:20. Connection ID 224: Connection error '28000': Inv...
Thanks for clarifying.
ps If we add the date to the time, then, unfortunately, nothing changes.
BEGIN
declare ClockOn timestamp;
declare ClockOff timestamp;
set ClockOn = cast('2024-01-15 09:59:59.999' as timestamp);
set ClockOff = cast('2024-01-...
ps Maybe it's time for a checkpoint and everything is frozen?
I. 11/29 11:39:54. Starting checkpoint of "D4w" (D4w.db) at Tue Nov 29 2022 11:39
I. 11/29 11:40:31. Finished checkpoint of "D4w" (D4w.db) at Tue Nov 29 2022 11:40
I. 11/29 11:48:33. Start...
There are events in the database ("Connect" and "Disconnect") that write information about the connection and disconnection to a special table. The last entry before the database restart was at 12:01:22.440:
233357433,,2022-11-29 12:01:22.440,,567,,5...
