Check if autocommit is off Em dom, 12 de abr de 2020 às 17:12, Armando B. <hmandevt...@gmail.com> 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 < > robe...@spadim.com.br> ha scritto: > >> Probably you are using transaction and not commiting >> >> Em sáb, 28 de mar de 2020 às 06:01, Armando B. <hmandevt...@gmail.com> >> 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@lists.launchpad.net >>> 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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp