DX Cluster and Band map not working

7 posts / 0 new
Last post
DL1CPA
DL1CPA's picture
DX Cluster and Band map not working

Hello..

I have following problem:
DX Cluster is connected, but no spots are showing, and band map, too.
No spots. I use xdx and this was running.

If I start cqrlog with --debug=1 I get this:

Hello Chris, this is DB0SUE-7 in Kiel
running DXSpider V1.55 build 0.136
Cluster: 404 nodes, 254 local / 4905 total users Max users 8278 Uptime 556 04:22
DL1CPA de DB0SUE-7 21-May-2015 1914Z dxspider >
DX de VE3MMB: 21297.0 JW9JKA 1914Z FN03
Enter critical section On Receive
Leave critical section On Receive
DX de IZ2BKD: 14217.0 II2EXPO Special call II2EXPO 1914Z
Enter critical section On Receive
Leave critical section On Receive
DX de LZ5WV: 18153.0 AO150E itu award 1914Z
Enter critical section On Receive
Leave critical section On Receive
OnCloseQuery - NewQSO

(I had a crash with other programms and cqrlog)

DL1CPA
DL1CPA's picture
The problem in not solved yet

The problem in not solved yet. if i start cqrlog with --debug=2 is can see this:
login:dl1cpaHello Chris, this is DB0SUE-7 in Kielrunning DXSpider V1.55 build 0.136Cluster: 396 nodes, 295 local / 4976 total users  Max users 8278  Uptime 579 21:55DL1CPA de DB0SUE-7 14-Jun-2015 1247Z dxspider >DX de N4GG:      50107.0  CO8LY                                       1247Z EM74Enter critical section On ReceiveLeave critical section On ReceiveDX de K4MM:      50105.1  KP4EIT       USB                            1247Z EL97Enter critical section On ReceiveLeave critical section On ReceiveDX de EA8AVK:    21017.1  LU1DZ        test WWSA                      1247Z IL28Enter critical section On ReceiveLeave critical section On ReceiveDX de KW4BY:     21070.0  TG9IIN       tnx Ilias 73                   1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KC1CYT:    50137.5  W1XX         cq contest                     1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de R9XM:      21017.3  LU1DZ                                       1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KU8Y:    1296107.3  K9EA                                        1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KZ4TT:     50160.0  AB4B         EM60<>EM64IT                   1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de WB5TUF:    50108.0  C6ATA                                       1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de K4LRX:     14040.0  T8CW         up 1 big signal in Ky.         1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de NM3G:      50155.1  K4HZ         RTTY                           1247ZEnter critical section On ReceiveLeave critical section On ReceiveDX de DL3YEE: 10368110.0  I6XCK        53s jn63qo-jo50lx 839km        1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de DL3YEE: 10368105.0  I6XCK        53s jn63qo-jo50lx 839km        1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de IK6DTB:    50150.0  IK6WEZ       JN72EG<>JN72EF                 1248Z JN72Enter critical section On ReceiveLeave critical section On ReceiveDX de EA8DO:     24940.0  8Q7CQ        up                             1248Z IL18Enter critical section On ReceiveLeave critical section On ReceiveDX de KD4JRX:    50120.0  ZF1EJ        EK-99>FM14 WATHA NC            1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de NG1R:     432105.0  NG1R         CW                             1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de G3YJR:    144205.0  G5TO/P       IO93 square cq contest         1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de LA3VJA:    21278.0  TA7IZG       5-9 plus                       1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de WN3SIX:    50108.0  C6ATA        Blasting into FN11 5X9 ++      1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de 4J5A:      24950.0  4K2015BAKU                                  1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KF4WE:    144200.0  K5QE         EM56NL<>EM31CJ                 1248ZEnter critical section On ReceiveLeave critical section On ReceiveDX de K4WW:      14093.0  DL0LK        RTTY DRCG                      1249Z EM79Enter critical section On ReceiveLeave critical section On ReceiveDX de DL9KI:     28121.5  LU8HGI                                      1249ZEnter critical section On ReceiveLeave critical section On ReceiveDX de F8DGY:     50093.3  F5KCK/78                                    1249Z JN18Enter critical section On ReceiveLeave critical section On ReceiveDX de KI4DJG:   432100.0  N1GC         EM82EN<ES>EM95 tnx             1249ZEnter critical section On ReceiveLeave critical section On ReceiveDX de EC1YL:     21278.1  TA7IZG       Tnx Ipek 88                    1249ZEnter critical section On ReceiveLeave critical section On ReceiveDX de W1EBM:     18082.0  SV8/OE3GSA   Gerd op/MM QRP                 1249ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KI4DJG:   144170.0  N1GC         EM82EN<ES>EM95 gm tnx          1249ZEnter critical section On ReceiveLeave critical section On ReceiveDX de W4HLD:     50134.0  KP4EIT                                      1249ZEnter critical section On ReceiveLeave critical section On ReceiveDX de NW0W:      50082.9  K0YW                                        1250Z EM47Enter critical section On ReceiveLeave critical section On ReceiveDX de IK6WEZ:    50150.0  IK6DTB       cq dx                          1250Z JN72Enter critical section On ReceiveLeave critical section On ReceiveDX de KF4WE:    144200.0  N9XKH        EM56NL<>                       1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KI4DJG:    50180.0  N1GC         EM82EN<ES>EM95                 1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de PY7XAF:    21270.0  4L4C         tnx QSO.                       1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de W4GA:      50141.0  N4BP         EM74QC<ES>EL96UD up and down   1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de AB1A:      50108.0  C6ATA        FL15>>FN42 59+                 1250ZEnter critical section On ReceiveLeave critical section On ReceiveDBPing - select * from cqrlog001.db_versionDBPing - select * from cqrlog001.db_versionDX de KG9Z:      50096.0  K8MFO        Cqn Contest                    1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de 7L4IOU:    14095.5  K0XB         RTTY                           1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de CN8AMA:    21278.0  TA7IZG       TNX 59/59 IN MOROCCO           1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de NA2M:      14087.0  W4EYJ        RTTY                           1250Z FN31Enter critical section On ReceiveLeave critical section On ReceiveDX de F5PCV:     18090.0  F6BBQ/P                                     1250Z JO10Enter critical section On ReceiveLeave critical section On ReceiveDX de IK8LVL:    14210.0  II8IYL/P     iyl2015                        1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de WB5TUF:    50141.0  N4BP                                        1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de WN3SIX:    50115.0  NP4A         Blasting into FN11 5X9 +       1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de RA0TU:     18072.6  T6EU         cq                             1250Z OO06Enter critical section On ReceiveLeave critical section On ReceiveDX de N4GG:      50120.0  ZF1EJ                                       1251Z EM74Enter critical section On ReceiveLeave critical section On ReceiveDX de RA4PQ:     14040.1  T8CW         tnx new one Up 1.5             1250ZEnter critical section On ReceiveLeave critical section On ReceiveDX de PA3DJY:    21023.0  YD1DPM       correction call                1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de G2FT:      28457.0  EA8AOC       JO02<>IL18RF Tnx 73s           1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de CX2AQ:     21005.0  ZZ90IARU     CW                             1251Z GF15Enter critical section On ReceiveLeave critical section On ReceiveDX de DF1JC:    144320.0  M0VXX/P      JO31OG<TR>IO82RJ CQ Contest    1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de W4HLD:     50115.0  NP4A                                        1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de WB5TUF:    50133.9  WC4H                                        1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de RC7M:      18160.0  RZ5D/AM                                     1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de AA4U:      50143.4  CO8ZZ        FL10                           1251Z EM64Enter critical section On ReceiveLeave critical section On ReceiveDX de PY1ME:     28121.1  CE3FIK                                      1251Z GG87Enter critical section On ReceiveLeave critical section On ReceiveDX de K5TR:      50144.0  K5TR                                        1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de W0AIH:     50098.0  W0UC         EN44                           1251Z EN44Enter critical section On ReceiveLeave critical section On ReceiveDX de KJ4UGO:    50120.0  ZF1EJ        73!!!                          1252Z EM64Enter critical section On ReceiveLeave critical section On ReceiveDX de KU8Y:     222111.0  W9SNR/R                                     1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de R3HD:      18092.0  J28NC        UP 2                           1251ZEnter critical section On ReceiveLeave critical section On ReceiveDX de PY7XAF:    21270.0  4L4C         CQing DX.                      1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de SP2WW:     14215.0  SP2CYK/P     spff1139                       1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de RZ6BS:     28505.0  PR7AH                                       1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de IR1X:      21036.3  VP2MKV       CW                             1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de CT1EJB:    28453.0  YT3T         Tks QSO Sasa 73's              1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KW4RZ:     50120.0  ZF1EJ        EM60QK<ES>EK99IG               1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KW4BY:     21070.0  YV6AE        73                             1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KF4WE:    144200.0  K9RU         EM56NL<>EM69WS                 1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de VU2DED:    24940.0  8Q7CQ        up 3                           1252Z MK68Enter critical section On ReceiveLeave critical section On ReceiveDX de OZ2LP:     14210.0  II8IYL/P                                    1252ZEnter critical section On ReceiveLeave critical section On ReceiveDX de W4IY:     144214.5  W4IY         FM08                           1252Z FM08Enter critical section On ReceiveLeave critical section On ReceiveDX de SV2CBN:    28076.0  3B8IK        jt65                           1253Z KN17Enter critical section On ReceiveLeave critical section On ReceiveDX de UA2FT:     14247.0  YT3X/P       FF-036                         1253Z KO04Enter critical section On ReceiveLeave critical section On ReceiveDX de 7N2UQC:     7041.6  UA0OK        RTTY TEST                      1253ZEnter critical section On ReceiveLeave critical section On ReceiveDX de KU8Y:     432110.0  W9SNR/R                                     1253ZEnter critical section On ReceiveLeave critical section On ReceiveDX de F4HMR:     14244.0  F4GFE/P                                     1253Z JN18Enter critical section On ReceiveLeave critical section On Receive
 
In cqrlog, on telnet/web cluster is nothing to see. only the welcome message from the cluster:
Hello Chris, this is DB0SUE-7 in Kielrunning DXSpider V1.55 build 0.136Cluster: 396 nodes, 295 local / 4976 total users  Max users 8278  Uptime 579 21:55DL1CPA de DB0SUE-7 14-Jun-2015 1247Z dxspider >
Bandmap is also empty.
I don't have any idea what can be worng.
 

DL1CPA
DL1CPA's picture
after the update to 1.9.1 the

after the update to 1.9.1 the same problem. DXcluster and bandmap no messages, no spots.

cqrlog with debug=1

shows the following lines:

DX de SO3Z: 144349.0 GW8JLY JO82LJIO81JM tnx 0942Z
Enter critical section On Receive
Leave critical section On Receive
x_prefix:GW
dx_cont: EU
Freq: 144.349
Call: GW8JLY
Color: clBlack
Index_: 2
2016-01-05 10:42:37 add to bandmap GW8JLY
select * from call_alert where callsign = 'GW8JLY'

Deleted data on position:0
DX de SV1GRN: 21070.0 DB8ZQ/QRP 0942Z KM18
Enter critical section On Receive
Leave critical section On Receive
DX de UA3QII: 14125.0 UA3QII RAFA 5 OKEAH 0942Z
Enter critical section On Receive
Leave critical section On Receive
DX de TC5OCK: 21205.0 TC5OCK CQ CQ 0943Z
Enter critical section On Receive
Leave critical section On Receive
DX de RU4PAA: 14176.0 RC4R airfield UWKK 0943Z
Enter critical section On Receive
Leave critical section On Receive
DX de IK0IKB: 7065.0 II0IEM special call 0943Z JN61
Enter critical section On Receive
Leave critical section On Receive
DX de WP4JCF: 1838.0 WL7SJ now -20... 0943Z FK68
Enter critical section On Receive
Leave critical section On Receive
DX de UT7AT: 21227.8 RA9MDA tnx QSO 0943Z
Enter critical section On Receive
Leave critical section On Receive

DL1CPA
DL1CPA's picture
Hello,

Hello,
is it possible that it is an error with the call_alert?
if i do:
preferences => DXcluster => Callsign alert i get this ERROR message:

: Error executing query: Table 'cqrlog001.call_alert' doesn't exist.

Press OK to ignore and risk data corruption.
Press Cancel to kill the program.

If i make a new database (test999) the cluster works.
Is it a problem with the index of the database?
I don't know anything about databases.... can i "reindex" or something the database?
All my old logs don't work, but new logs are running.

ok2cqr
ok2cqr's picture
Re: Hello,

yes, that will be the problem.

Open QSO list window, in menu choose SQL console. The SQL console window appears. Please enter this command:

select * from db_version;

and now click to the first icon from the left on the toolbar. It's green Play icon. On the lower part of the window should something appear. Please send me what you will see there. Thank you!

73 Petr

DL1CPA
DL1CPA's picture
Hello,

Hello,
oh, I forgot. The call_alert table hasen't a colum. I viewed the table and the database with dbvis. The new accounts/logs has a column. The old logs not.

The output form the command "select * from db_version" is: 10

The output from "select * from call_alert" is an error message with:
SQL error: : Error executing query: Table 'cqrlog001.call_alert' doesn't exist

The file exists, but with no content. I copied the files from a backup with the same result. => no table inside.

How can i create the right files/tables?

DL1CPA
DL1CPA's picture
and... i can't create a table

and... i can't create a table with DBVIS. DBVIS needs a passwort an an username to create a table.