Project is springboot + mybatis, running two months appear this kind of situation, page submit data after deposited in the database, two months is normal, only a single memory storage, and the log is not an error, this table is not set the primary key of the business logic is deleted according to the table and other related fields cycle data to insert data in the table, there are a great god know what circumstance under meeting occurrence this situation

CodePudding user response:

You see the log, such a problem, you write these lines, look not to come out,

CodePudding user response:

reference 1st floor selling fruit net reply:

you see the log, this problem, you write these lines, look not to come out,

Log is not an error, in the case of production circumstances, two months at a time

CodePudding user response:

Handle multiple business in one transaction? There is something wrong with one of the business, leading to the back of the data is not dealt with, or you take out the data sheet, run it in a test environment

CodePudding user response:

Try, everything is normal, there is something wrong with the transaction will be in the console print error messages, no error message, however, a single problem on production, try it with the test

CodePudding user response:

This kind of problem, unless personally screening and testing, and is a guess, because for this problems, which need to be very detailed information, in addition, anyone considering problems, there may be error, this kind of mistake a person may not be aware of it, this led to a reported problems may be one-sided and there is error,

CodePudding user response:

Party a together since the screening and test no appear this kind of problem, is appeared on the production, also don't know what is the operation, launched two months a list

CodePudding user response:

Check whether there is in the related table under the trigger?

CodePudding user response:

refer to 7th floor freedom and responsibility response:

check related tables have a trigger?

no

CodePudding user response:

Suppose TABLE2 table data, the following statements can be successfully executed:
INSERT INTO TABLE1 SELECT * FROM TABLE2.

INSERT INTO TABLE1 SELECT * FROM TABLE2 WHERE 1=2;
Don't complain, also won't insert any data,

CodePudding user response:

Only insert statement without the select clause, simply insert statement, and it is accidental phenomena, two months only once