Skip to main content

Questions tagged [event]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
24 views

Will a replicated event cause issues?

I've got the replication configuration shown in the image. Everything replicates to everywhere. One of the tables maintains session data which has rows that must be deleted due to expiration. I ...
user22044385's user avatar
0 votes
0 answers
27 views

Structure for table to record events in other tables?

Say I have three tables: people groups memberships with the following primary keys: uid gid uid+gid I would like to record events such the creation/deletion off people/groups/memberships. I could ...
loris's user avatar
  • 103
0 votes
0 answers
89 views

Event driven architecture in Postgres?

I'm trying to create an automated trigger event (Postgres is my main DB) on something like this: Orders table ---------------- Order_Expiry_Date: Date Customer_email: String When as soon as ...
Neil's user avatar
  • 101
3 votes
3 answers
696 views

Impact of index on a "status" field with one (guaranteed) change

Introduction I have a PostgreSQL table setup as a queue/event-source. I would very much like to keep the "order" of the events (even after the queue item has been processed) as a source for ...
WesAtWork's user avatar
  • 133
0 votes
0 answers
19 views

SQLcode in event is not working

I am trying to make a summary table of another table with an event that runs every hour in mySQL (it is a mySQL database of my website). If i just run my code in the query box it works. And if i add ...
Remi 's user avatar
4 votes
1 answer
1k views

Extended event - slow queries and waits

I have an extended event which filters on my slow queries. I have created the following script for it. CREATE EVENT SESSION [SlowQueriesAndStatementsLargerThan3Seconds] ON SERVER ADD EVENT sqlserver....
Peter's user avatar
  • 2,372
0 votes
1 answer
174 views

MariaDB Understanding "Event" Interval

I've created my first EVENT: ALTER EVENT flush_logs_event ON SCHEDULE EVERY 6 HOUR COMMENT 'Rotate /var/log/mysql/master-bin*' DO FLUSH LOGS; I changed it from "12" to "6" ...
Ron Piggott's user avatar
0 votes
2 answers
131 views

MS SQL: Execute Database Request after Server Start

I need to execute a request (Stored Procedure) to MS SQL Server after Windows restart, i.e. as soon as the database is accessible. How can I do that? Is there a possibility to register a database ...
Bernd Morgeneyer's user avatar
0 votes
2 answers
574 views

Need help in getting mysql event scheduled every monday and wednesday

I have coded an event as below to run every Monday and Wednesday, but it runs only on Monday and doesn't on Wednesday. delimiter | CREATE EVENT IF NOT EXISTS evnt_demo_ref_fs_test ON SCHEDULE EVERY 1 ...
Mushtaq's user avatar
1 vote
1 answer
106 views

How to create date ranges of events coming from an API where open state represents the date range and close state the gaps between the ranges?

I would like to store date/time ranges in PostgreSQL of some arbitrary events that have a state of open or closed and a date/time of when the state changed. Events coming from an API will have the ...
feketegy's user avatar
  • 121
0 votes
0 answers
540 views

MySQL event scheduler -- Event running at wrong time

I have created a event to run EVERY 1 DAY at 3:15 (am). I know that timezones affects events and actually I create a query to check the START time in mysql.event (GMT timezone) and information_schema....
Jesus Uzcanga's user avatar
-2 votes
1 answer
268 views

SQL Server Event Log Summary [closed]

I want to generate a daily summary of SQL Server Event Logs which will be sent via email. I have currently been able to set up SQL email alerts for error logs,but they are sent individualy when an ...
ModernDBAwithModernTasks's user avatar
1 vote
1 answer
2k views

HKEngineEventFile at Log folder of SQL Server

There were inconsistency issue in our database as asked in this question. Same is fixed now and database is running without any issue. I noticed that SQL service was rebooted many times in last 3 ...
Learning_DBAdmin's user avatar
1 vote
1 answer
1k views

Mysql 8 event scheduler timezone

I'm a bit confused about the event scheduler. First off, it is running and working, but the timezone handling confuses me a bit, as it seems it's not what is documented on events metadata It says ...
Sebastian Witt's user avatar
0 votes
1 answer
3k views

MySQL schedular every day in a time periode every hour

This schedular i made doesn't work how i would like it to work. The idea is that it will run every day in a time periode from 06:15:00 till 23:59:59 and in that only periode run every hour That ...
F T's user avatar
  • 11
0 votes
1 answer
669 views

Generate Script for Event Notification

I need to migrate my Event Notifications from current server to another one. I would like to generate that code, but I couldn't find an way to do that. Try 1 I have tried reverse engineering from ...
Rafael Dontal Gonçalez's user avatar
-1 votes
1 answer
45 views

If true then insert event [closed]

I have an insert statement that inserts events into a table. I need it to NOT insert if these events contain specific words or even specific username executing the event. Thought this would be easy ...
CrashWave's user avatar
1 vote
1 answer
51 views

event get not executed

I'm on 2 debian8 box's with mysql-5.7.19. I have a master slave replication running, replicating one db (db1.1) from master to slave (db2.1). Replicated db's on master and slave have same names. ...
jgnoss's user avatar
  • 93
-1 votes
1 answer
2k views

Troubleshooting ORA-12012, ORA-02194 and ORA-06512 errors

On one of installations I see the following errors during job execution: alert.log: Wed Aug 16 16:57:27 2017 Errors in file c:\oracle\product\10.2.0\admin\db\bdump\db_j009_3868.trc: ...
Ievgen's user avatar
  • 1
1 vote
0 answers
497 views

Postgres upsert perform multiple actions _OR_ versioning of events in an "append only" store

Background I am running on postgres 9.5 I have a table with events (in theory, it is, currently, an append only store). Certain event types can appear only once on a given date. (So currently, we ...
Yaneeve's user avatar
  • 177
1 vote
2 answers
670 views

DDL-trigger for ALTER_AUTHORIZATION

I need to perform some audit, when change of a securable ownership, such as ALTER AUTHORIZATION ON SCHEMA::[SchemaName] TO [PrincipalName]; happens in database. Database scope DDL-trigger seems an ...
i-one's user avatar
  • 2,354
3 votes
2 answers
2k views

Does not writing a checkpoint record damage anything?

I got an alert Event ID: 3619. Could not write a checkpoint record in database 'ID ####' because the log is out of space I know why it happened, I have addressed the issue, backed up the t-logs, ...
James Jenkins's user avatar
0 votes
0 answers
2k views

SQL server Log shipping Copying failed due to incorrect username and password

I have 2 sql server 2008 servers with log shipping. Now im trying to add one more secondary server to the existing log shipping. While copying the log files to secondary I got the below error on SQL ...
TheDataGuy's user avatar
  • 1,950
2 votes
1 answer
313 views

MySQL 5.6 events are created disabled and they don't run

I am using the normal syntax to create an event, but they are created disabled and they never run: create event p1 on schedule at now() on completion preserve enable do call proc1(); I added enable ...
Manal's user avatar
  • 21
0 votes
1 answer
987 views

MySQL Event Help - Update column value for each row every 15 minutes

Okay so if I have a login database: id | email | pass | attempts ---------------------------- 1 | "" | "" | 4 2 | "" | "" | 2 Attempts marks the number of attempts made at logging ...
j. Doe's user avatar
  • 1
1 vote
0 answers
275 views

MySQL Event scheduler not generating CSV

The scheduler seems to be running from INFORMATION_SCHEMA.EVENTS but there is no CSV output. The event scheduler has to automatically produce a csv to pass on the data to another system. It's like ...
mish's user avatar
  • 11
0 votes
1 answer
25 views

How to name a new table storing location at which transaction occurred [closed]

My client wants to begin collecting data about where transactions occurred. We have a list of their events and locations where payments might be received, I'm just stumped on what to call the table ...
BoatCode's user avatar
  • 101
6 votes
1 answer
34k views

How to turn Event Scheduler On permanently in MySQL?

How do I turn on the event scheduler in mysqld permanently? I'm using phpMyAdmin and I have scheduled an event to copy records from one table to another everyday at a specific time, but the records ...
user1930115's user avatar
1 vote
0 answers
827 views

MySQL event scheduler doesn't work

I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00. CREATE EVENT IF NOT EXISTS actualizar_prueba ON SCHEDULE ...
william's user avatar
  • 21
1 vote
1 answer
225 views

How to update MySQL data within intranet from MySQL data in cloud?

I am currently using a MySQL DB located within the intranet. Only the people within the LAN can access the information. I'm trying to re-create the MySQL DB in a cloud provider. This can be accessed ...
Charlesliam's user avatar
14 votes
1 answer
60k views

Scheduling an event every day at a given time

I want my event to run everyday at 00:20. I am confused in scheduling of the time. Should I be using the first option or the second one? Option 1 CREATE EVENT my_event ON SCHEDULE EVERY 1 DAY ...
Femme Fatale's user avatar
3 votes
1 answer
36k views

column auto updated after 24 hours in mysql

i have a table T1 with column : Name State time mon 1 2014-01-09 11:23:00 tue 0 2014-01-07 14:40:00 wed 2 2014-01-08 09:23:00 thu ...
simplifiedDB's user avatar
12 votes
1 answer
32k views

Where EVENTS history are logged/recorded in MySql?

I just setup some stored procedures to run in the event scheduler using CREATE EVENT. I'm trying to find where (if somewhere) the history of it running is stored. I looked at the docs but couldn't ...
tucaz's user avatar
  • 245
2 votes
1 answer
11k views

Setting timezone per database in MySQL

I wanted to know if MySQL let the admin set a timezone per database ? I have three different databases for three different customers. Each of them being in their own timezone. I would like to load the ...
Spredzy's user avatar
  • 2,248