Bug #22217 Internal scheduler error 6
| Submitted: | 10 Sep 2006 0:13 | Modified: | 27 Sep 2006 15:45 |
|---|---|---|---|
| Reporter: | SEO 10 | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Stored Routines | Severity: | S1 (Critical) |
| Version: | 5.1.12-BK, 5.1.11 | OS: | Linux (Linux) |
| Assigned to: | Andrey Hristov | CPU Architecture: | Any |
| Tags: | crypted error, Internal scheduler error 6, mysql eror, php | ||
[10 Sep 2006 0:13]
SEO 10
[11 Sep 2006 16:47]
Valeriy Kravchuk
Thank you for a bug report. Verified just as described with latest 5.1.12-BK on Linux: openxs@suse:~/dbs/5.1> bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.1.12-beta-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from test; ERROR 1146 (42S02): Table 'test.test' doesn't exist mysql> create table test (c1 int); Query OK, 0 rows affected (0.02 sec) mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM test; Query OK, 1 row affected (0.02 sec) mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM test; ERROR 1558 (HY000): Internal scheduler error 6
[27 Sep 2006 15:45]
Andrey Hristov
Please try newer 5.1.12 from bk :
mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM
-> of_xxx.xxx_ip_log WHERE logtime < UNIX_TIMESTAMP()-86400
->
-> ;
Query OK, 0 rows affected (0.08 sec)
mysql> CREATE EVENT IF NOT EXISTS xxx_clearips ON SCHEDULE EVERY 1 DAY DO DELETE FROM of_xxx.xxx_ip_log WHERE logtime < UNIX_TIMESTAMP()-86400;
Query OK, 0 rows affected, 1 warning (0.07 sec)
mysql> show warnings;
+-------+------+-------------------------------------+
| Level | Code | Message |
+-------+------+-------------------------------------+
| Note | 1524 | Event 'xxx_clearips' already exists |
+-------+------+-------------------------------------+
1 row in set (0.00 sec)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.