[Dxspider-support] MYSQL duplication/mass insertion on restart

[Dirk Koopman G1TLH]

On 14/02/12 20:28, Jason R Begley wrote:
> I don't recall how I set this up, and it was going to be semi-temporary
> until I started integrating it into my webpage.. I normally write this
> stuff down, but in this case I didn't... Shame on me.. Below is the
> output: I also just ran as normal below, and you can see that I ran it
> as root and it crashed because it couldnt write to the spot file, then I
> restarted and you can see the behavior... it starts re-importing the
> spots from the start.
> TU!
> KY9J
>
> cluster
> DXSpider V1.55, build 0.94 (git: 6262a02) started
> Copyright (c) 1998-2012 Dirk Koopman G1TLH
> loading prefixes ...
> US Database not loaded
> loading band data ...
> loading user file system ...
> starting listeners ...
> Internal port: localhost 27754 using IntMsg
> External Port: 0.0.0.0 7300 using ExtMsg::login
> load badwords: Ok
> Starting Dupe system
> Read in Messages
> Read in Aliases
> Start WWV
> Start WCY
> Starting DX Spot system
> initialising spot tables
> inserted 0 spots from 2011 305
> inserted 2589 spots from 2011 306
> inserted 5483 spots from 2011 307
> inserted 6375 spots from 2011 308
> inserted 10836 spots from 2011 309
> inserted 15462 spots from 2011 310
> inserted 6410 spots from 2011 311
> inserted 5983 spots from 2011 312
> inserted 5693 spots from 2011 313
> ^CSpot::init(/spider/perl/Spot.pm:135):
> 135: $count++;
> DB<1> T
> . = Spot::init('Spot') called from file `cluster.pl' line 487
> DB<1> c
>

Okaaayyyy...

On the console (as a sysop user) what does:

sh/var $main::dbh->show_tables

say?

Dirk