← Back to team overview

maria-discuss team mailing list archive

Re: Some records come out after some time

 

Check if autocommit is off

Em dom, 12 de abr de 2020 às 17:12, Armando B. <hmandevteam@xxxxxxxxx>
escreveu:

> 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
>
>
-- 
Roberto Spadim
SPAEmpresarial - Software ERP/Scada
Eng. Automação e Controle, Eng. Financeira

Follow ups

References