Search Results for 'Duplicate entry'

[afzal]

above problem was related to mysql authentication.
that is solved now i think now there is connection between rapidscada and mysql.

but i get another error

2021-03-17 15:38:27 Error export current data to DB MySQL – localhost: Duplicate entry ‘2021-03-17 15:38:26-101’ for key ‘cnldata.PRIMARY’

[Mikhail]

Is the “duplicate entry” error critical in your situation or can be ignored?

[bencyau]

Hello,

I am observing strange behavior in DBExport (MySQL8.0), that the data generated into the database seem to randomly start and stop.

The system seemed to work OK with some inputs, then got stuck on one.

The only input is the sample OPC channel 201. And the system seems to got stuck on this entry, and generated many of the same error message as below:

2018-12-06 15:27:35 Error export current data to DB MySQL – localhost: Duplicate entry ‘2018-12-06 15:11:20-201’ for key ‘PRIMARY’

Thanks.

[csshenrapid]

It is the same to MYSQL database, and the error information is following:
2018-04-18 13:35:31 Error export current data to DB MySQL – 192.168.88.139:3306: Duplicate entry ‘2018-04-18 13:35:00-21’ for key ‘PRIMARY’

[Romiros]

from log:

2015-09-01 18:34:05 Ошибка при экспорте текущих данных в БД MySQL – localhost: Duplicate entry ‘2015-09-01 18:32:42-1’ for key ‘PRIMARY’

from log 2:
Модуль экспорта данных
———————-
Состояние: норма

Источники данных
—————-
1. MySQL – localhost; состояние: ошибка экспорта; в очереди тек/арх/соб: 5/0/0; экспортировано тек/арх/соб: 18/0/11; пропущено тек/арх/соб: 0/0/0

Current data is written normally, although the error log. Archives no. Another question – historical data are written into the same table, or need to create another?

Прошу прощения за мой английский
Текущие данные пишутся нормально, хотя в логе ошибка. Архивов нет. Еще вопрос – архивные данные пишутся в ту же таблицу или надо создавать отдельную?