[Dxspider-support] MYSQL Server Disconnects
Jason Begley
jayray at digitalgoat.com
Fri Mar 2 02:33:30 GMT 2012
Here are some debugs, seems like if it looses connection to the server
(timeout or restart) it does not reconnect despite the fact that it
looks like there is a check built in to see if it is still connected
KY9J connected from 127.0.0.1
-> D KY9J Hello Jason Begley, this is KY9J-2 in Charlestown IN USA
-> D KY9J running DXSpider V1.55 build 0.104
KY9J channel func state 0 -> prompt
-> D KY9J #########################################################
-> D KY9J #By default there is no posting until UR registered #
-> D KY9J #Pse Set password on internet connects with set/password#
-> D KY9J #########################################################
-> E KY9J 0
-> D KY9J *Echoing is currently disabled, set/echo to enable
-> D KY9J Cluster: 1 nodes, 1 local / 1 total users Max users 1
Uptime 0 00:00
-> D KY9J KY9J-2>
<- I KY9J connect wr3d
connect 4: timeout set to 60
connect 4: timeout set to 300
CONNECT 4 sort: telnet command: wr3d.dxcluster.net 7300
Connected 4 to wr3d.dxcluster.net 7300
-> D KY9J connection to WR3D started
-> D KY9J KY9J-2>
connect 4: This is the WR3D (ex N2TLY) DXCluster system using DXSpider
software%0D
connect 4: expecting: "login:" received: "This is the WR3D (ex N2TLY)
DXCluster system using DXSpider software%0D
"
connect 4: This is the WR3D (ex N2TLY) DXCluster system using DXSpider
software%0D
If your terminal doesn't echo characters, please set the 'local%0D
echo' option (this is only likely to affect Microsoft users)%0D
login:
connect 4: expecting: "login:" received: "This is the WR3D (ex N2TLY)
DXCluster system using DXSpider software%0D
If your terminal doesn't echo characters, please set the 'local%0D
echo' option (this is only likely to affect Microsoft users)%0D
login: "
connect 4: got: "login:" sending: "KY9J-2"
connect 4: KY9J-2%0D
%0D
DXChannel WR3D created (3)
<- O WR3D telnet
-> B WR3D 0
-> E WR3D 0
WR3D channel func state 0 -> init
<- I WR3D KY9J-2
<- I WR3D
<- I WR3D *** Connected to WR3D in Baltimore
<- I WR3D PC18^DXSpider Version: 1.56 Build: 0.17 Git: 281b5d6
pc9x^5456^
WR3D channel func state init -> init
DXSpider version 1.56 build 0.17
Do px9x set on WR3D
send_local_config: doing pc9x
-> D WR3D PC92^KY9J-2^8598^A^^5WR3D:109.69.104.145^H99^
-> D WR3D PC92^KY9J-2^8598.01^K^5KY9J-2:5455:0.104^1^1^H99^
-> D WR3D PC20^
<- I WR3D PC92^WR3D^8598^A^^5KY9J-2:99.119.146.17^H99^
WR3D channel func state init -> init92
Do pc9x set on WR3D
<- I WR3D PC92^WR3D^8598.01^K^5WR3D:5456:0.17^17^3^H99^
<- I WR3D PC22^
WR3D channel func state init92 -> normal
<- I KY9J exit
DXCommand
KY9J disconnected
-> D KY9J KY9J-2>
DXChannel KY9J destroyed (3)
<- I WR3D PC11^50110.0^KH6OO^ 2-Mar-2012^0223Z^tnx 579
bill^LU5FF^EA6VQ-1^H22^~
<- I WR3D PC92^S50DXS^8603^A^^1RK3ZZ:79.140.72.253^H97^
-> D WR3D PC51^WR3D^KY9J-2^1^
<- I WR3D PC51^KY9J-2^WR3D^0^
<- I WR3D PC51^KY9J-2^WR3D^1^
-> D WR3D PC51^WR3D^KY9J-2^0^
<- I WR3D PC92^W7PKT^8604^D^^1W7MGW^H95^
<- I WR3D PC92^VE9SC^8603^C^7VE9EMO:5455^H96^
<- I WR3D
PC92^VE9SC^8603.01^C^5VE9SC:5455^4IK4ICZ-6^7VE9EMO^5IK5YZW-6^5ZL2AQY-10^5PY3NZ-8^5E73DU-6^5PA1RBZ^6IK7IMO-6^7PA4JJ-3^5N6WS-6^5IW9FDD-6^5KB1H^7EA4URE^1W1GQ-1^5VE1CFB^1NC8C^5EI7MRE^7W1AAA^6IZ0FKE^5SV5FRI-1^5GB7DXG-1^5VE1DXI^5NN1D^5UT1U^5HB9ON-9^H96^
<- I WR3D PC92^VE1CFB^8627^K^5VE1CFB:5455:0.38^2^1^H95^
<- I WR3D PC92^DB0ERF-5^8616^A^^6OK0DXP:127.0.0.1^H93^
<- I WR3D PC92^OH2J^8617^A^^1OH6FXL^H96^
<- I WR3D PC92^VE1DXI^8617^D^^1W2OR^H97^
<- I WR3D PC92^US6IQ-1^8703^D^^5RW3XA-8^H96^
<- I WR3D PC92^RW3XA-8^8628^D^^5US7IQZ-1^H95^
<- I WR3D PC92^ZL2AQY-10^8650^D^^5US7IQZ-1^H97^
<- I WR3D PC92^US6IQ-1^8707^D^^5ZL2AQY-10^H96^
<- I WR3D PC92^US6IQ-1^8708^D^^5RV0AEV-1^H96^
<- I WR3D PC92^RV0AEV-1^8630^D^^5US7IQZ-1^H94^
<- I WR3D PC92^WR3D^8635^D^^5US7IQZ-1^H99^
<- I WR3D PC92^DB0SUE-7^8635^D^^5US7IQZ-1^H97^
<- I WR3D PC92^US6IQ-1^8710^D^^5DB0SUE-7^H96^
<- I WR3D PC92^US6IQ-1^8710.01^D^^5WR3D^H96^
<- I WR3D PC92^GB7RAU^8637^A^^1G7RES:109.234.179.241^H97^
<- I WR3D
PC92^W6RFU^8639^C^7K6SY:5451^1K6KSY^1K6SY-6^1W6BCQ^1K6SY-9^1KJ6Y^1K6SY-1^1WB6OFE-1^1K6JW^H97^
queue msg (0)
<- I WR3D PC92^F1OYP-8^8580^D^^5ON4KVI-3^H95^
<- I WR3D PC92^N2NRD-1^8647.01^D^^5AE5E-2^H95^
<- I WR3D PC92^GB7UJS^8647^D^^1IZ7JVR^H97^
<- I WR3D PC61^50035.9^VE4VHF^02-Mar-2012^0224Z^539 building
FP53^VY0HL^VE7CC-1^65.181.35.84^H96^~
DBD::mysql::db do failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 85.
at /spider/perl/DXSql.pm line 85
eval {...} called at /spider/perl/DXSql.pm line 85
DXSql::do('DXSql::mysql=HASH(0xa7517a0)', 'insert into spot
values(NULL,50035.9,\'VE4VHF\',1330655040,\'...') called at
/spider/perl/DXSql.pm line 140
eval {...} called at /spider/perl/DXSql.pm line 140
DXSql::spot_insert('DXSql::mysql=HASH(0xa7517a0)',
'ARRAY(0x99cf618)') called at /spider/perl/Spot.pm line 193
Spot::add(50035.9, 'VE4VHF', 1330655040, '539 building FP53',
'VY0HL', 197, 197, 'VE7CC-1', 3, ...) called at
/spider/perl/DXProtHandle.pm line 219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^50035.9^VE4VHF^02-Mar-2012^0224Z^539 building FP53^VY0HL...',
'WR3D', 'PC61', 50035.9, 'VE4VHF', '02-Mar-2012', '0224Z', ...) called
at /spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^50035.9^VE4VHF^02-Mar-2012^0224Z^539 building FP53^VY0HL...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
DBD::mysql::db commit failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 90.
at /spider/perl/DXSql.pm line 90
DXSql::commit('DXSql::mysql=HASH(0xa7517a0)') called at
/spider/perl/Spot.pm line 194
Spot::add(50035.9, 'VE4VHF', 1330655040, '539 building FP53',
'VY0HL', 197, 197, 'VE7CC-1', 3, ...) called at
/spider/perl/DXProtHandle.pm line 219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^50035.9^VE4VHF^02-Mar-2012^0224Z^539 building FP53^VY0HL...',
'WR3D', 'PC61', 50035.9, 'VE4VHF', '02-Mar-2012', '0224Z', ...) called
at /spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^50035.9^VE4VHF^02-Mar-2012^0224Z^539 building FP53^VY0HL...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
<- I WR3D
PC92^VE9EMO-9^9172^C^5VE9EMO-9:5455^5VE9SC^1K5PO^5VE2PKT-9^5WB3FFV-2^H94^
<- I WR3D PC92^PY3NZ-8^8662^D^^1PY3YD-2^1PY3YD^H95^
<- I WR3D PC41^W8FIB^1^Harold^H28^~
<- I WR3D PC41^W8FIB^2^Merrillville, IN^H25^~
<- I WR3D
PC61^10102.6^VP2MSN^02-Mar-2012^0224Z^up^N9NX^VE7CC-1^207.118.159.13^H95^~
DBD::mysql::db do failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 85.
at /spider/perl/DXSql.pm line 85
eval {...} called at /spider/perl/DXSql.pm line 85
DXSql::do('DXSql::mysql=HASH(0xa7517a0)', 'insert into spot
values(NULL,10102.6,\'VP2MSN\',1330655040,\'...') called at
/spider/perl/DXSql.pm line 140
eval {...} called at /spider/perl/DXSql.pm line 140
DXSql::spot_insert('DXSql::mysql=HASH(0xa7517a0)',
'ARRAY(0x99cf618)') called at /spider/perl/Spot.pm line 193
Spot::add(10102.6, 'VP2MSN', 1330655040, 'up', 'N9NX', 208,
226, 'VE7CC-1', 11, ...) called at /spider/perl/DXProtHandle.pm line 219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^10102.6^VP2MSN^02-Mar-2012^0224Z^up^N9NX^VE7CC-1^207.118...',
'WR3D', 'PC61', 10102.6, 'VP2MSN', '02-Mar-2012', '0224Z', ...) called
at /spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^10102.6^VP2MSN^02-Mar-2012^0224Z^up^N9NX^VE7CC-1^207.118...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
DBD::mysql::db commit failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 90.
at /spider/perl/DXSql.pm line 90
DXSql::commit('DXSql::mysql=HASH(0xa7517a0)') called at
/spider/perl/Spot.pm line 194
Spot::add(10102.6, 'VP2MSN', 1330655040, 'up', 'N9NX', 208,
226, 'VE7CC-1', 11, ...) called at /spider/perl/DXProtHandle.pm line 219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^10102.6^VP2MSN^02-Mar-2012^0224Z^up^N9NX^VE7CC-1^207.118...',
'WR3D', 'PC61', 10102.6, 'VP2MSN', '02-Mar-2012', '0224Z', ...) called
at /spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^10102.6^VP2MSN^02-Mar-2012^0224Z^up^N9NX^VE7CC-1^207.118...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
<- I WR3D PC92^EI7SDX^8671^K^5EI7SDX:5455:0.92^6^5^H97^
<- I WR3D PC92^9A0DXC^8671^D^^5SV1CPO-8^H96^
<- I WR3D PC92^ON4KVI-3^8675^D^^1F1OYP-8^H94^
<- I WR3D PC92^GB7DJK^8672^A^^1VE3FDT:99.227.228.173^H98^
<- I WR3D PC92^W1DX^8672^A^^7W4IEN:68.64.241.198^H97^
<- I WR3D PC92^F1OYP-8^8613^D^^5F1OYP-6^H97^
<- I WR3D PC92^VE9SC^8663^C^7W1AAA:5455^H97^
<- I WR3D PC92^PE1ITR-8^8707^D^^5IK2XDE-9^H96^
<- I WR3D PC92^W0MU-1^8682^D^^1W0GLB^H96^
<- I WR3D PC92^W0MU-1^8682.01^A^^1N2NRD-1^H96^
<- I WR3D PC92^IK6ZDE-6^8584^D^^5IW0QNL-6^H95^
<- I WR3D PC92^IK6ZDE-6^8584.01^D^^5IK2XDE-9^H95^
<- I WR3D PC92^JA2YYF-9^8694^A^^1JA6BJV:175.28.135.174^H96^
<- I WR3D PC92^F5MZN-3^8667^K^5F5MZN-3:5455:0.33^4^9^H96^
<- I WR3D PC92^W6RFU^8699^D^^5N7TR^H97^
queue msg (0)
<- I WR3D PC92^SV2XI-6^8700.02^A^^5SV1CPO-8^H94^
<- I WR3D PC92^SV1CPO-8^8700^A^^5SV2XI-6:94.67.139.247^H96^
<- I WR3D PC92^SV1CPO-8^8700.01^K^5SV1CPO-8:5455:0.98^4^0^H94^
<- I WR3D PC92^SM7GVF-6^8706^A^^1RK4S:77.40.117.50^H97^
<- I WR3D PC92^EA4RCH-5^8708^D^^1N4YKU^H97^
<- I WR3D PC92^EA4RCH-5^8708.01^A^^1LU1XPA^H97^
<- I WR3D PC92^IR4X-6^8708^K^5IR4X-6:5455:0.9^2^1^H96^
<- I WR3D PC92^N3BSQ-1^8709^A^^7W8BS^H98^
<- I WR3D PC92^IK6ZDE-6^8587^D^^5F6BVP-2^H96^
<- I WR3D PC92^IK6ZDE-6^8587.01^A^^7F1OYP-8:82.125.207.140^H96^
<- I WR3D PC92^IK6ZDE-6^8603^D^^5F1OYP-8^H95^
<- I WR3D PC92^VE9EMO-9^9226^D^^5VE9SC^H96^
<- I WR3D PC92^VE9SC^8703^D^^5VE9EMO^H96^
<- I WR3D PC92^VE9SC^8703.01^D^^5EA4URE^H96^
<- I WR3D PC92^VE9SC^8703.02^D^^5W1AAA^H96^
<- I WR3D PC92^W1DX^8713^D^^5VE9SC^H97^
<- I WR3D PC92^EA4URE-5^8714^D^^5VE9SC^H96^
<- I WR3D PC92^DB0TIT-5^8715^K^5DB0TIT-5:5455:0.82^2^1^H94^
<- I WR3D PC92^SV1IW-9^8716^D^^5SZ1SV^H97^
<- I WR3D PC41^PT9ZE^1^JOE^H97^~
<- I WR3D PC41^PT9ZE^2^BRAZIL^H97^~
<- I WR3D PC41^PT9ZE^3^21 19 S 55 42 W^H97^~
<- I WR3D PC92^LU9DA-6^8718^D^^5F1OYP-6^H96^
<- I WR3D PC92^N6WS-6^8723^D^^5F1OYP-6^H97^
<- I WR3D PC92^AE5E-1^8720^D^^1K4VHV^1N2NRD-1^1N2TU-16^1NO4Y^1W2OR^H96^
<- I WR3D PC92^AE5E-1^8720.01^A^^1HR1/K2LCT^1NN4DF^H96^
<- I WR3D PC92^W0MU-1^8724^A^^1W0GLB^H96^
<- I WR3D PC92^PY3NZ-8^8730^A^^1PY3KN-11^H94^
<- I WR3D PC92^DB0FHN-6^8732^K^5DB0FHN-6:5455:0.26^3^4^H95^
<- I WR3D PC92^GB7BAA^8732^K^5GB7BAA:5455:0.93^9^3^H97^
<- I WR3D PC92^JA2YYF-9^8734^K^5JA2YYF-9:5455:0.82^15^9^H96^
<- I WR3D PC92^DB0ERF-5^8741^A^^1DJ1MS:212.114.186.132^H96^
<- I WR3D PC92^ZL2ARN-10^8744^K^5ZL2ARN-10:5455:0.100^7^6^H96^
<- I WR3D PC92^W1NR^8745^D^^1AA1V^H98^
<- I WR3D PC92^W8BS^8745^D^^5N3BSQ^H95^
<- I WR3D PC61^7133.00^C6ANM^02-Mar-2012^0225Z^
^KO4GS^VE7CC-1^98.166.63.178^H96^~
DBD::mysql::db do failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 85.
at /spider/perl/DXSql.pm line 85
eval {...} called at /spider/perl/DXSql.pm line 85
DXSql::do('DXSql::mysql=HASH(0xa7517a0)', 'insert into spot
values(NULL,7133.0,\'C6ANM\',1330655100,NULL...') called at
/spider/perl/DXSql.pm line 140
eval {...} called at /spider/perl/DXSql.pm line 140
DXSql::spot_insert('DXSql::mysql=HASH(0xa7517a0)',
'ARRAY(0x99cf618)') called at /spider/perl/Spot.pm line 193
Spot::add(7133.0, 'C6ANM', 1330655100, '', 'KO4GS', 14, 226,
'VE7CC-1', 11, ...) called at /spider/perl/DXProtHandle.pm line 219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^ ^KO4GS^VE7CC-1^98.166.6...',
'WR3D', 'PC61', 7133.00, 'C6ANM', '02-Mar-2012', '0225Z', ...) called at
/spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^ ^KO4GS^VE7CC-1^98.166.6...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
DBD::mysql::db commit failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 90.
at /spider/perl/DXSql.pm line 90
DXSql::commit('DXSql::mysql=HASH(0xa7517a0)') called at
/spider/perl/Spot.pm line 194
Spot::add(7133.0, 'C6ANM', 1330655100, '', 'KO4GS', 14, 226,
'VE7CC-1', 11, ...) called at /spider/perl/DXProtHandle.pm line 219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^ ^KO4GS^VE7CC-1^98.166.6...',
'WR3D', 'PC61', 7133.00, 'C6ANM', '02-Mar-2012', '0225Z', ...) called at
/spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^ ^KO4GS^VE7CC-1^98.166.6...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
<- I WR3D PC61^7133.00^C6ANM^02-Mar-2012^0225Z^Bahamas
LOTW^W2FAL^VE7CC-1^65.75.92.241^H94^~
DBD::mysql::db do failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 85.
at /spider/perl/DXSql.pm line 85
eval {...} called at /spider/perl/DXSql.pm line 85
DXSql::do('DXSql::mysql=HASH(0xa7517a0)', 'insert into spot
values(NULL,7133.0,\'C6ANM\',1330655100,\'Ba...') called at
/spider/perl/DXSql.pm line 140
eval {...} called at /spider/perl/DXSql.pm line 140
DXSql::spot_insert('DXSql::mysql=HASH(0xa7517a0)',
'ARRAY(0x99cf618)') called at /spider/perl/Spot.pm line 193
Spot::add(7133.0, 'C6ANM', 1330655100, 'Bahamas LOTW', 'W2FAL',
14, 226, 'VE7CC-1', 11, ...) called at /spider/perl/DXProtHandle.pm line
219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^Bahamas LOTW^W2FAL^VE7CC...',
'WR3D', 'PC61', 7133.00, 'C6ANM', '02-Mar-2012', '0225Z', ...) called at
/spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^Bahamas LOTW^W2FAL^VE7CC...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
DBD::mysql::db commit failed: MySQL server has gone away at
/spider/perl/DXSql.pm line 90.
at /spider/perl/DXSql.pm line 90
DXSql::commit('DXSql::mysql=HASH(0xa7517a0)') called at
/spider/perl/Spot.pm line 194
Spot::add(7133.0, 'C6ANM', 1330655100, 'Bahamas LOTW', 'W2FAL',
14, 226, 'VE7CC-1', 11, ...) called at /spider/perl/DXProtHandle.pm line
219
DXProt::handle_11('DXProt=HASH(0xaa4bb00)', 61,
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^Bahamas LOTW^W2FAL^VE7CC...',
'WR3D', 'PC61', 7133.00, 'C6ANM', '02-Mar-2012', '0225Z', ...) called at
/spider/perl/DXProt.pm line 433
DXProt::normal('DXProt=HASH(0xaa4bb00)',
'PC61^7133.00^C6ANM^02-Mar-2012^0225Z^Bahamas LOTW^W2FAL^VE7CC...')
called at /spider/perl/DXChannel.pm line 722
DXChannel::process() called at /spider/perl/cluster.pl line 544
<- I WR3D PC92^W0MU-1^8747^K^5W0MU-1:3034^11^12^H94^
<- I WR3D PC92^N2NRD-1^8747.01^K^5N2NRD-1:3034^5^2^H94^
<- I WR3D
PC92^KB1H^8750^C^5KB1H:5455^1N4FX^1KB1H-4^1KB1H-6^1KB1H-7^1W4VIC^1KB1H-8^1AC4HB^1N4BAA^1W1UJ-4^5WB3FFV-2^1WA1BXY^1W1PX^5K3WW^5N3BSQ-1^5K7SDX^1IW0RFB^1NB1U^1K1PU^5VE9SC^1NZ1U^1W1ECT^5HB9CA^5AE3N-2^5W1UJ^1KT1B^1N5GJ^5W1DX^5WT3Q^5IT9WDY-6^1W1NK^H97^
Thanks & 73
Jason
KY9J
More information about the Dxspider-support
mailing list