Full log deletion

Post Reply
iw7dmh
Advanced Class
Posts: 30
Joined: 02 Nov 2013, 21:24

Full log deletion

Post by iw7dmh »

Hello,

I am doing some tests on Log4OM v2 (portable version) with a MySQL database.
Everything works fine but I can't do a full log deletion using the QSO Manager.
I read about the Bulk Deletion on the manual, but, once I select all the qsos and hit the DEL button, the program stucks and after 10/15 mins I have to kill the Log4OM process.
In the database at the moment I have only 6500 qso but in the end, the number should reach about 150.000.
Thank you in advance for any help.

Best 73'
Enzo, iw7dmh
Top
User avatar
G4POP
Log4OM Alpha Team
Posts: 11617
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Full log deletion

Post by G4POP »

Enzo,
Try deleting in the recent QSO window instead
73 Terry G4POP
Top
iw7dmh
Advanced Class
Posts: 30
Joined: 02 Nov 2013, 21:24

Re: Full log deletion

Post by iw7dmh »

Hi Terry,

thank you very much for the answer.
I unlocked the QSO list, then selected all the QSO with the second bottom-left button the hit the DEL button.
Unfortunately the behaviour is the same: the main window is freezed, than I have to kill the process.
Maybe I am missing something

73' Enzo
Top
User avatar
G4POP
Log4OM Alpha Team
Posts: 11617
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Full log deletion

Post by G4POP »

sounds like something associated with MYQSL operation because I tested with SQLite and this does not occur

I suggest that until we can check this our that you create a new database and use MySQL Manager to delete the existing database from MySQL
73 Terry G4POP
Top
User avatar
ei6kw
Advanced Class
Posts: 42
Joined: 28 Oct 2020, 12:23

Re: Full log deletion

Post by ei6kw »

Enzo,
Did you try to tick "Drop Current database.... " option in import window?
__
73!
de EI6KW, Slav
[url]https://www.hamqth.com/ei6kw[/url]
Top
iw7dmh
Advanced Class
Posts: 30
Joined: 02 Nov 2013, 21:24

Re: Full log deletion

Post by iw7dmh »

Ok, dropping the database worked fine.
Also doing a deletion using MySql Workbench worked (obviously) fine.
Anyway, I selected only ten (10) qso and tried again a bulk deletion. This could happen more frequently then a full deletion. The result was only one qso has been deleted.
So I extracted the debug log and, as you can see below, the [DeleteQso] function causes the systematic error [EXCEPTION] Parameter 'QsoId' has already been defined..
Maybe this can help Andrea in finding and fixing the error.
Note that all the qsos were imported from an ADIF downloaded with the Lotw Report function.

73' Enzo
iw7dmh

Code: Select all

2022-06-17 06:48:54.0745 DEBUG:     * [Countries][SearchCallsign][3976 ms] : Performing Search Callsign on call G8HXE on date 17/06/2022 06:48:54 
2022-06-17 06:48:54.4824 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:54.4951 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:54.5078 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.1699 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.2824 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.2824 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.2824 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.2824 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.2938 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.3050 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.3050 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.3050 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.3160 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.3160 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.3160 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.3160 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.3388 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.3388 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.3388 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.3388 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.3512 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.3512 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.3608 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.3608 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.3728 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.3728 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.3728 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.3728 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.3947 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.3947 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.3947 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.3947 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.4055 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.4055 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.4055 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.4055 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:55.4280 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137606 
2022-06-17 06:48:55.4280 INFO:        [DbMysql] : DELETE QSO WITH SQL PARAM QsoId 20220617063137610 
2022-06-17 06:48:55.4280 ERROR:       [DbMysql][DeleteQso] : MYSQL DeleteQso exception while removing QSO (multiple)
                                      [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
2022-06-17 06:48:55.4280 ERROR:       [#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==][MoveNext] : [EXCEPTION] Parameter 'QsoId' has already been defined. MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter 'QsoId' has already been defined.
   in MySql.Data.MySqlClient.MySqlParameterCollection.InternalAdd(MySqlParameter value, Nullable`1 index)
   in MySql.Data.MySqlClient.MySqlParameterCollection.AddWithValue(String parameterName, Object value)
   in L4ONG.DAL.MYSQL.DbMysql.DeleteQso(List`1 qsoIds)
   in L4ONG.Controls.QsoControl.UCQsoGrid.#=zjg9esO6JtquMjotlUn2mZ91_yIu8q7a8sg==.MoveNext()
2022-06-17 06:48:57.7486 DEBUG:       [Countries][SearchCallsign] : Performing Search Callsign on call DK6AH on date 17/06/2022 06:48:57
Top
Post Reply

Return to “User support”