[Maria-discuss] Some records come out after some time
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
Probably you are using transaction and not commiting Em sáb, 28 de mar de 2020 às 06:01, Armando B. <hmandevteam@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
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@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. <hmandevteam@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
Check if autocommit is off Em dom, 12 de abr de 2020 às 17:12, Armando B. <hmandevteam@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 < roberto@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. <hmandevteam@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
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@spadim.com.br> ha scritto:
Check if autocommit is off
Em dom, 12 de abr de 2020 às 17:12, Armando B. <hmandevteam@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 < roberto@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. <hmandevteam@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
-- 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
participants (2)
-
Armando B. -
Roberto Spadim