BMS-HOSxP Community
HOSxP => แจ้งปัญหา / ขอความช่วยเหลือ => ข้อความที่เริ่มโดย: thanee.sri ที่ สิงหาคม 23, 2016, 15:27:40 PM
-
มีการเรียกใช้งาน ฟังก์ชั่น ของ 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...
ไม่ทราบว่าจะแก้ไขอย่างไรครับ
-
ปัญหาคือขนาดของไฟล์ .err โตขึ้นเรื่อย ๆ ครับ เคยมีขนาดถึง 3 GB เลยครับ
-
hosxp_pcu ver 3.59.3.31 Mysql server 5.5.31 mariadb
ครับ น่าจะเป็นมาตั้งแต่เริ่มใช้งาน stock inventory ครับ