← Back to team overview

maria-discuss team mailing list archive

Re: Some records come out after some time

 

autocommit
<https://mariadb.com/kb/en/library/server-system-variables/#sysvar_autocommit>
ON

Il giorno lun 13 apr 2020 alle ore 01:46 Roberto Spadim <
roberto@xxxxxxxxxxxxx> ha scritto:

> 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
>


-- 
  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

References