มีการเรียกใช้งาน ฟังก์ชั่น ของ triger แล้ว error ทำให้ mysqld เขียน error log ไฟล์ ไม่หยุด เขียนทุกครั้งที่เกิด error ทำให้ขนาด error log ไฟล์ โตขี้นไปเรื่อย ๆ โดยข้อความ ที่เขียน มีดังนี้
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:12 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:12 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:16 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:16 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:16 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:16 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:17 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:17 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:21 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:21 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:21 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:21 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:22 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[inv_test.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:22 [Note] Event Scheduler: [sa@127.0.0.1].[pcu_hdb.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:26 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_draw_list_tx] Table 'hos.sp_run' doesn't exist
160823 15:19:26 [ERROR] Event Scheduler: [sa@127.0.0.1][hos.event_call_sp_check_stock_item_unit_trx] Table 'hos.sp_run' doesn't exist
160823 15:19:26 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_draw_list_tx] event execution failed.
160823 15:19:26 [Note] Event Scheduler: [sa@127.0.0.1].[hos.event_call_sp_check_stock_item_unit_trx] event execution failed.
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_draw_list_tx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][pcu_hdb.event_call_sp_check_stock_item_unit_trx] Table 'pcu_hdb.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_draw_list_tx] Table 'inv_test.sp_run' doesn't exist
160823 15:19:27 [ERROR] Event Scheduler: [sa@127.0.0.1][inv_test.event_call_sp_check_stock_item_unit_trx] Table 'inv_test.sp_run' d...
ไม่ทราบว่าจะแก้ไขอย่างไรครับ
หัวข้อ: พบข้อผิดพลาดของ triger (อ่าน 1535 ครั้ง)