this is the case. Recently, when there is an occasional Mysql insert operation in the system, some field data of a record is lost. When I check the printed sql statement, there is a value, such as
:
before the insert operation, I output the attributes of the entity class to confirm that it has a value, and then I also print the insert SQL, as shown in figure 1, which also has a value, so I want to know why this problem is caused?
known:
1: no other update operation affects this data, because the time has been confirmed, and there are printed SQL statements
2: in the database field length, the length of both fields is sufficient
3: occasionally there are such problems, which are not 1 or 2 problems, but a series of
-2018-05-30 16:09 additional-
the binlog:
that I just went to the server to check is that the insert statement is executed and has the value
INSERT INTO jn_ebs_order_header (id,order_id,order_sn,order_add_time,order_status,pay_status,sale_type,ware_house,order_amount,goods_amount,shipping_fee,pay_type,pay_id,pay_name,pay_time,pay_sn,serial_no,user_id,user_mobile,user_settle_status,user_settle_time,discount_mode,). Pop_period_no,bonus,recharge,discount_amount,suppliers_id,suppliers_code,suppliers_name,marketing_type,operate_id,service_fee_deduction,service_amount,shipping_status,pop_status,invoice_status,refund,refund_amount,cost_rate,created_by_user,created_office,created_dtm_loc,created_time_zone,updated_by_user,updated_office,updated_dtm_loc,updated_time_zone,bonus_platform,bonus_shop) VALUES (null,286349,"18052917587253",1527605225,1,2,0, "jn020",294.85276.00,18.85,1,2," Wechat app payment", 152760524305668001687pr "4200000130201805291425980374" 33437, "13924928030" pyrrhenium "0meme" penguin ", 0.00pyrmum 0.00pyrum 0.00pyrum 1697" S1803150001 ", "Guangzhou Little Bee Fruit Trade Co., Ltd.," Guangzhou Little Bee Fruit Trading Co., Ltd., 1, zero, and so on. "","", "2018-05-29 22 22 purl 04 zero)