I have a simple form system that registers in the bank the amount of daily benefits of a person in the company.
The database does not return this data in most cases. The problem began to happen after last week's server's HD's burned out. We were able to recover the databases, but came back with this problem.
An example of what happens:
Suppose I log on to the system:
ID: 11 | Prestação: Atendimento | Quantidade: 10|
ID: 12 | Prestação: Palestra | Quantidade: 5 |
ID: 13 | Prestação: Audiências | Quantidade: 2 |
If I make a SELECT
in the bank using ID
of the specific installment, the registry is not brought even though it is in the bank :
select * from prestacoes where prestacao_id = 11;
If I make another SELECT
using IN()
, the record that did not return previously (11), returns with another:
select * from prestacoes where prestacao_id in(11,12)
Worst of all is that this happens with just a few specific records. Suppose the records with the problem are ID's 11 and 13, the 12 returns normally.
We suspect corrupted data but it still does not make sense, and the homologation database has had the same problem for a week. Before that, it was perfect.