Mysql stopped again, WD sending duplicate data over and over

Archive Archived Weather Display Problems
1

Version 10.16h ran for 30 hours then got stuck on this error.

Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 7:46:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 7:48:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 7:50:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 7:52:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 7:54:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 7:56:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 7:58:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:00:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:02:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:04:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:06:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:08:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:10:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:12:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:14:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:16:01 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:18:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:20:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:22:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:24:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:26:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:28:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:30:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:32:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:34:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:36:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:38:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:40:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:42:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:44:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:46:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:48:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:50:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:52:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:54:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:56:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 8:58:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:00:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:02:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:04:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:06:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:08:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:10:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:12:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:14:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:16:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:18:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:20:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:22:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:24:01 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:26:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:28:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:30:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:32:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:34:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:36:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:38:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:40:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:42:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:44:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:46:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:48:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:50:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:52:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:54:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:56:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 9:58:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:00:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:02:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:04:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:06:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:08:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:10:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:12:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:14:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:16:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:18:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:20:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:22:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:24:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:26:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:28:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:30:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:32:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:34:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:36:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:38:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:40:01 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:42:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:44:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:46:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:48:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:50:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:52:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:54:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:56:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 10:58:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:00:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:02:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:04:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:06:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:08:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:10:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:12:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:14:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:16:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:18:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:20:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:22:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:24:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:26:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:28:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:30:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:32:00 AM 8/28/2004
ERROR: mySQL Error Code: (1062)
Duplicate entry ‘CARY_WEATH-2004-08-28-06:31:14’ for key 1 at time/date 11:34:00 AM 8/28/2004

2

Try deleting the duplicate record from your database and see if WD recovers.

Also check that clientraw.txt is updating correctly on your machine. I think the MySQL updater picks up its data from that file. If the file isn’t being updated the DB updater will keep on trying to use the same data over and over again.

3

what i need to do is do a check that its not updating data that is the same time/date (the key column)
i will do that for the next release version

4

one thing that has come to my attention:
if the weather station name is less than 10 charecters long, then the time stamp is also inlcuded …
so i have the wdmysql checking for the first :, i.e the time stamp, and then stripping that off
that might help…
but i see you have the date in front of the time stamp
can you post here your clientraw.txt file
thanks
as the actual time stamp is the time that the data is written too…not from the actual data…

next version will have wdmysql vers 1.4

5

Here is my clientraw:

12345 0.0 0.0 287 26.2 64 1019.3 51.0 279.0 753.0 0.1 1.1 25.3 48 0.0 4 24.0 41 2 2.0 24.0 28.4 0.0 -100.0 -100.0 -100.0 41 69 0 18 1 51 CARY_WEATHER-6:01:51_PM 0 0 30 8 100 100 100 80 1 0 100 26.2 32.9 26.5 22.5 5 Stopped_raining -6.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22.2 18.9 3026.1 30/8/2004 34.6 30.5 26.5 22.5 0.0 4 0 1 0 2 0 0 0 0 0 26.4 26.4 26.5 26.5 26.5 26.5 26.4 26.3 26.3 26.3 51.0 51.0 51.0 51.0 51.0 51.0 51.0 51.0 51.0 51.0 27.7 20.9 27.3 13.3 0 287

I think the problem is in wdmysql fetching the data rather than the client raw function stopping. Are there any errors that could occur in the code that would cause WDmysql to stop fetching the data from WD (via registry or clientraw) but continue trying to update the database with the last data that was successfully fetched?

When I restarted WD, I ended up with 2 wdmysql’s running, the original one still seemed to be trying to update with old data, but the new one seemed to be working - it seemed like the original one was stuck with old data for some reason.
/Ian

6

vers 1.5 of the mysql is uploading with wd beta 10.16L, ready soon
please try that one
thanks

7

i did end up with this problem after a connection to the database was lost (internet connection lost breifly or something)…then the key violation occured…
a restart fixed it…
so maybe i need to have it log out and then relog back into the database to get going again when there is a key violation.,…i will try that