← Back to team overview

maria-discuss team mailing list archive

Re: Some records come out after some time

 

Hi Roberto,
thanks for your response.

I using InnoDB but not transaction, i use only insert statement without
beginTransaction(), commit() and rollBack().


Il giorno sab 28 mar 2020 alle ore 16:28 Roberto Spadim <
roberto@xxxxxxxxxxxxx> ha scritto:

> Probably you are using transaction and not commiting
>
> Em sáb, 28 de mar de 2020 às 06:01, Armando B. <hmandevteam@xxxxxxxxx>
> escreveu:
>
>> Hi all,
>> i have a MariaDB Server (*10.1.35*) with an InnoDB and a table with an
>> Autoincrement ID field and some other data (no foreign keys but only
>> index). This table have few records (~10000) that are increased with a
>> csv import each some weeks.
>>
>> I saw that sometimes, after import process, some records are hidden and
>> come out after some time (also 40 min.)
>>
>> could you help me ?
>> Armando
>> --
>>   Themonospot http://github.com/armando-basile/themonospot/
>>   Monosim http://github.com/armando-basile/monosim/
>>   Comex-Project http://github.com/armando-basile/comex-project/
>>   ViviVasto app
>> https://play.google.com/store/apps/details?id=com.armandobasile.vivivasto
>>   vdr-getchannels - https://github.com/armando-basile/vdr-getchannels
>>   vdr-scripts - https://github.com/armando-basile/vdr-scripts
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
> --
> Roberto Spadim
> SPAEmpresarial - Software ERP/Scada
> Eng. Automação e Controle, Eng. Financeira
>


-- 
  Themonospot http://github.com/armando-basile/themonospot/
  Monosim http://github.com/armando-basile/monosim/
  Comex-Project http://github.com/armando-basile/comex-project/
  ViviVasto app
https://play.google.com/store/apps/details?id=com.armandobasile.vivivasto
  vdr-getchannels - https://github.com/armando-basile/vdr-getchannels
  vdr-scripts - https://github.com/armando-basile/vdr-scripts

Follow ups

References