CQRLog error "Access Violation"

13 posts / 0 new
Last post
N3MOW
CQRLog error "Access Violation"

Just built a new PC with Minit 17.1. As my prevous version of CQRLog used MySQL I installed MySql 5.6. Then I installed CQRLog V. 1.8.3. That Installed MariaDB. I was able to run and import my log into CQRLog OK. As I use MySQL databases in other projects I imported my MySQL database to MySQL using MySQL Workbench. Now when I start CQRLog I get the error "Access violation, Press OK and risk data corruption or press Cancel to kill program". Pressing either option kills the program. Not too worried about the log as I still have a backup.
I suspect this is a conflict between MariaDB and MySQL. How do I fix this? I'd like to have the features of 1.8.3 but have it run in MySQL.
Regards,
Marty

N3MOW
More problems with CQR Errors

Tried to run CQRLog on a second PC with an existing installation. This does not run either. Got "Error cannot conect to database server failure". Then "Appears you are using Apparmor". Add line @{Home}/.config/cqrlog/database/**rwk, into etc/apparmor.d/usr.sbin.mysqdd. Or run /user/share/cqrlog/cqrtest-apparmor-fix. Did the later no change. Looked at the file /etc/apparmor.d/usr.bin.mysqdd it is empty and tels me that it is disabled by default.
I say again that this was a running instance of CQRLog. Some thing has changed. Perhaps an update to MariaDB.
Now the PC mention in the issue above works. Did nothing but reboot the PC this morning. Strange that it's happening on two seperate PC's. I'll try to restart the second PC later this morning.
Marty

Marty, N3MOW

ok2cqr
ok2cqr's picture
Re: More problems with CQR Errors

Hi Marty,
 
I already solved similar problem on my father's computer with old Ubuntu 10.04. Something happened and file usr.sbin.mysqld was empty. I had to use file from my computer to fix it.
Here is the content of the file:
# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>
 
/usr/sbin/mysqld {
  #include <abstractions/base>
  #include <abstractions/nameservice>
  #include <abstractions/user-tmp>
  #include <abstractions/mysql>
  #include <abstractions/winbind>
 
  capability dac_override,
  capability sys_resource,
  capability setgid,
  capability setuid,
 
  network tcp,
 
  /etc/hosts.allow r,
  /etc/hosts.deny r,
 
  /etc/mysql/*.pem r,
  /etc/mysql/conf.d/ r,
  /etc/mysql/conf.d/* r,
  /etc/mysql/*.cnf r,
  /usr/lib/mysql/plugin/ r,
  /usr/lib/mysql/plugin/*.so* mr,
  /usr/sbin/mysqld mr,
  /usr/share/mysql/** r,
  /var/log/mysql.log rw,
  /var/log/mysql.err rw,
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,
  /var/log/mysql/ r,
  /var/log/mysql/* rw,
  /var/run/mysqld/mysqld.pid rw,
  /var/run/mysqld/mysqld.sock w,
  /run/mysqld/mysqld.pid rw,
  /run/mysqld/mysqld.sock w,
 
  /sys/devices/system/cpu/ r,
 
  # Site-specific additions and overrides. See local/README for details.
  #include <local/usr.sbin.mysqld>
  @{HOME}/.config/cqrlog/database/** rwk,
}
 
Save it to /etc/apparmor.d/usr.sbin.mysqld and use cqrlog-apparmor-fix script.
 
73 Petr

N3MOW
RE: More problems with CQR Errors

Petr,
The fix worked. From the comments in the origial file (Below) I think this may occur each time MariaDB updates.
 
# This file is intensionally empty to disable apparmor by default for newer# versions of MariaDB, while providing seamless upgrade from older versions# and from mysql, where apparmor is used.## By default, we do not want to have any apparmor profile for the MariaDB# server. It does not provide much useful functionality/security, and causes# several problems for users who often are not even aware that apparmor# exists and runs on their system.## Users can modify and maintain their own profile, and in this case it will# be used.## When upgrading from previous version, users who modified the profile# will be promptet to keep or discard it, while for default installs# we will automatically disable the profile.
 
Still not sure why I had trouble with the new install on Mint 17.1. That PC has both MySQL and MariaDB and Workbench running. It still appears to be working. Will be setting up rig contron next.
 
Again Thanks for your help.
Marty, N3MOW
 
 

Marty, N3MOW

oz1hyi
same falilure

I have same failure, and I can't fix it.. I do not know how to do... Working Linux Mint17 Qiana..  Mint woud not let me edit the file or insert the lines Petr has writtn for his father...
I know how to start my pc.. and push button to start CQR log... and thats is it... ( tryed with Gnome Commander to edit the file / copy the file... but got the message Cant save or rename,, so I have a logprogram witch is not working and I hacve not hne mood for trying a new logprogram.
Sorry for my spelling
OZ1HYI  Willy

ok2cqr
ok2cqr's picture
Re: same falilure

Hi Willy,
 
send me an email to petr@ok2cqr.com and I will sned you the file you can copy to it's location. You have to do it as root user (using sudo command).
 
73 Petr, OK2CQR

N3MOW
same Failure

Willy,
 
The reason you cannot edit the file is that you must do it as root. If you are totaly new to Linux, get a good book on it before you edit files as root. Also you should do it from the terminal window. Maybe there is a Linux guru in your area who can help you get started.
 
Regards,
Marty

Marty, N3MOW

hg5acz
Access violation

Hi everybody!

I have got the "access violation" error. Up to this evening cqrlog was working properly. But now after "creating filter" always i read the error message.

I created new database, but some problem. I do not have ideas what is happaning now in my system.
(it were not any update or similar thing....)

Could somebody help me?

The debug output:

It takes about 0 minutes and 15 seconds 484 miliseconds
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
TApplication.HandleException Access violation
Stack trace:
$000000000042622A
$0000000000523027
$000000000044AE19
$0000000000449F0A
$000000000042E6D1
$000000000074A551
$000000000044C0A8
$000000000075821D
$000000000074791A
$0000000000747840
$00000000004501C0
$0000000000745E68
$0000000000764BEA
$0000000000760F38
$0000000000449A72
$000000000044EAD2
$0000000000450763
WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
TApplication.HandleException: there was another exception during showing the first exception
Stack trace:
$000000000314E0E8
$00000000005CD2AF
$000000000080903E
$00000000005CCF4B
$000000000077201A
$0000000000772939
$000000000042E6D1
$00000000007E3599
$00000000008A84C5
Closing ini file ...

(cqrlog:19161): GLib-CRITICAL **: Source ID 16 was not found when attempting to remove it

(cqrlog:19161): GLib-CRITICAL **: Source ID 15 was not found when attempting to remove it

(cqrlog:19161): GLib-CRITICAL **: Source ID 48 was not found when attempting to remove it

(cqrlog:19161): GLib-CRITICAL **: Source ID 47 was not found when attempting to remove it

(cqrlog:19161): GLib-CRITICAL **: Source ID 53 was not found when attempting to remove it

(cqrlog:19161): GLib-CRITICAL **: Source ID 52 was not found when attempting to remove it
[TGtk2WidgetSet.Destroy] WARNING: There are 1 TimerInfo structures left, I'll free them

OH3EVM
Hi!

Hi!
Today, i think program updated DXCC database or something.. soon after that i got the access violation and now no start.
debug gives me this? cqrlog --debug=1**** DEBUG LEVEL 1 ****Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.soLoading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.soLoading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.3**************************MySQL version: 5.7************************************************************MySQL version assigned: 5.7**********************************[FORMS.PP] ExceptionOccurred   Sender=EAccessViolation  Exception=Access violation  Stack trace:  $0000000000428E65  $000000000045B965                                                                                                                                                                                                                                 TApplication.HandleException Access violation                                                                                                                                                                                                         Stack trace:                                                                                                                                                                                                                                        $0000000000428E65                                                                                                                                                                                                                                   $000000000045B965                                                                                                                                                                                                                                 Closing ini file ...                                   

OH3EVM
Thanks to OH1KH for this. 

Thanks to OH1KH for this.  Delete /home/your_username/.config/cqrlog/lotw1.txt and start again 
 
WORKS!

VE2EVN
Had the same issue tonight.

Had the same issue tonight. Removed the lotw1.txt and it starts again.
Running 2.0.1 I just saw this issue is fixed in the newest version. I guess it's time to update.

Marc

DL8WOW
I've the same problem

I've the same problem directly after the automatically update of the DXCC database.
Fortunately I've a backup available. After reinstallation all works properly again.

VE3KTB
same for me

Must be Friday the 13th!  I had an access violation pop up while running WSJT-X in remote mode and when I went to restart cqrlog if was given an immediate access violation error.  The usr.sbin.mysqld was indeed empty, and I copied in the file details from Petr as listed earlier in the thread.  That failed to fix it, but I then found and deleted the lotw1.txt file and I was back in business.  So OH1KH has earned his beer!
 
73,
Pierre VE3KTB

Pierre Fogal
VE3KTB/KC0IGY
on Arch Linux