Onderwerp over de download Spotnet Database Cleanup

[submarines]

ik dank u zeer en hij werkt zeer goed

[Magsel]

Heeft de foutmelding die ik krijg dan wellicht niets met x64 te maken?

De details zijn te vinden in de spoiler.

Spoiler: show

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Devart.Data.SQLite.SQLiteException (0x80004005): The database file is locked
database is locked
at Devart.Data.SQLite.a2.b(br A_0)
at Devart.Data.SQLite.br.l()
at Devart.Data.SQLite.p.g()
at Devart.Data.SQLite.SQLiteDataReader.c()
at Devart.Data.SQLite.SQLiteCommand.InternalExecute(CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at Devart.Data.SQLite.SQLiteConnection.Commit()
at Devart.Data.SQLite.v.q()
at Devart.Common.DbConnectionBase.Close()
at SpotnetDBCleanup.CleanupTool.bgSpotDeleter_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.488 (RTMLDR.030319-4800)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
SpotnetDBCleanup
Assembly Version: 1.0.0.7
Win32 Version: 1.0.0.7
CodeBase: file:///C:/Program%20Files%20(x86)/SpotnetDbCleanup/SpotnetDBCleanup.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.454 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.463 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Devart.Data.SQLite
Assembly Version: 3.10.111.0
Win32 Version: 3.10.111.0
CodeBase: file:///C:/Program%20Files%20(x86)/SpotnetDbCleanup/Devart.Data.SQLite.DLL
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.468 (RTMLDR.030319-4600)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.450 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.450 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Devart.Data
Assembly Version: 5.0.212.0
Win32 Version: 5.0.212.0
CodeBase: file:///C:/Program%20Files%20(x86)/SpotnetDbCleanup/Devart.Data.DLL
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Als ik op quit klik, moet ik nog een keer op quit klikken en dan krijg ik:


Ik weet niet meer wat er gebeurde als ik op continue drukte met versie 1006. Dat is al weer enige maanden terug.

Is de laatste versie nu ook voor W7 x64 geschikt?

Het heeft altijd al gewerkt op x64. Het werkt op 32 en op 64 bit. Ik zelf heb ook w7 x64!

[submarines]

ikzelf heb w7 x64 en verschillende pc's; heb op ééntje bovenvermelde error gehad en op continue geklikt; verliep vlekkeloos

zie in de changelog en in het programma dat de retentie nu verhoogd is naar 2000 (max=1999), vraag me wel af wie zo'n oude db nog zou hebben die dan nog zou werken

[spidow]

************** Exception Text **************
Devart.Data.SQLite.SQLiteException (0x80004005): The database file is locked
database is locked

Dit betekend dat de sqlite database van spotnet op slot staat. Ik zal eens kijken of ik dit kan unlocken in de tool!

[Magsel]

Dat zou top zijn spidow.
Is er ook een manier om dit zelf makkelijk te doen of moet ik dan in SQLite onwijze commando's gaan zitten tikken?
Heb je tevens enig idee waarom bij mij de database locked is?

Ah en de foutmelding als op continue klik:

Tevens moet ik mijn PC daarna herstarten omdat ik anders de melding krijg dat de database locked is als ik SN start.

[spidow]

Misschien is het opgelost in de nieuwe versie die ik er net op heb gezet. Succes!

[submarines]

spidow werkt hier weer als een zonnetje op W7 X64

[Magsel]

Dank je wel voor de nieuwe versie spidow.
Deze doet het denk ik wel.

Ik krijg eerst deze melding:


Vervolgens toch wel deze melding:

Met de details in de spoiler:

Spoiler: show

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Devart.Data.SQLite.SQLiteException (0x80004005): The database file is locked
database is locked
at Devart.Data.SQLite.a2.b(br A_0)
at Devart.Data.SQLite.br.l()
at Devart.Data.SQLite.p.g()
at Devart.Data.SQLite.SQLiteDataReader.c()
at Devart.Data.SQLite.SQLiteCommand.InternalExecute(CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at Devart.Data.SQLite.SQLiteConnection.Commit()
at Devart.Data.SQLite.v.q()
at Devart.Common.DbConnectionBase.Close()
at SpotnetDBCleanup.CleanupTool.bgSpotDeleter_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.488 (RTMLDR.030319-4800)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
SpotnetDBCleanup
Assembly Version: 1.0.0.8
Win32 Version: 1.0.0.8
CodeBase: file:///C:/Program%20Files%20(x86)/SpotnetDbCleanup/SpotnetDBCleanup.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.454 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.463 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Devart.Data.SQLite
Assembly Version: 3.10.111.0
Win32 Version: 3.10.111.0
CodeBase: file:///C:/Program%20Files%20(x86)/SpotnetDbCleanup/Devart.Data.SQLite.DLL
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.468 (RTMLDR.030319-4600)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.450 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.450 built by: RTMLDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Devart.Data
Assembly Version: 5.0.212.0
Win32 Version: 5.0.212.0
CodeBase: file:///C:/Program%20Files%20(x86)/SpotnetDbCleanup/Devart.Data.DLL
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Als ik dan op continue klik, krijg ik vervolgens deze melding:

Ik moet echter wel een stuk of 3x rechtsboven op het kruisje van de tool klikken en telkens op continue klikken voordat de tool daadwerkelijk wordt afgesloten.

Het resultaat is een wijziging in de grootte en datum van de database:


-- [bericht automatisch samengevoegd - 17 okt 2011, 11:17] --

hmmmm zojuist weer SN gestart. Zoek ik op "pirates of the caribbean" krijg ik de volgende foutmelding:

Zodra ik de database van voor de cleanup terugzet en ik start SN dan kan ik wel zoeken.

[SPiET]

Ik krijg de error dat ie het

"Kon de spotnet.exe config niet vinden in local appdata"

had eerst de files in een aparte dir gezet, nu dan bij de spotnet db zelf maar geen resultaat!

[Horza]

super blij met dit tooltje
echter krijg ik nog wel de foutmelding database file gelockt is
ik gebruik win 7 64bit service pack 1

Spoiler: show

ie het einde van dit bericht voor meer informatie over het aanroepen
van JIT-foutopsporing (Just In Time) in plaats van dit dialoogvenster.

************** Tekst van uitzondering **************
Devart.Data.SQLite.SQLiteException (0x80004005): The database file is locked
database is locked
bij Devart.Data.SQLite.a2.b(br A_0)
bij Devart.Data.SQLite.br.l()
bij Devart.Data.SQLite.p.g()
bij Devart.Data.SQLite.SQLiteDataReader.c()
bij Devart.Data.SQLite.SQLiteCommand.InternalExecute(CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords)
bij Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
bij Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
bij Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
bij Devart.Common.DbCommandBase.ExecuteNonQuery()
bij Devart.Data.SQLite.SQLiteConnection.Commit()
bij Devart.Data.SQLite.v.q()
bij Devart.Common.DbConnectionBase.Close()
bij SpotnetDBCleanup.CleanupTool.bgSpotDeleter_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
bij System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
bij System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)


************** Geladen assembly's **************
mscorlib
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.239 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
SpotnetDBCleanup
Assembly-versie: 1.0.0.8
Win32-versie: 1.0.0.8
CodeBase: file:///C:/Program%20Files/SpotnetDBCleanup/SpotnetDBCleanup.exe
----------------------------------------
System.Windows.Forms
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.235 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.236 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Devart.Data.SQLite
Assembly-versie: 3.10.111.0
Win32-versie: 3.10.111.0
CodeBase: file:///C:/Program%20Files/SpotnetDBCleanup/Devart.Data.SQLite.DLL
----------------------------------------
System.Data
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.237 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.233 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Transactions
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Configuration
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.233 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Devart.Data
Assembly-versie: 5.0.212.0
Win32-versie: 5.0.212.0
CodeBase: file:///C:/Program%20Files/SpotnetDBCleanup/Devart.Data.DLL
----------------------------------------
System.EnterpriseServices
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
mscorlib.resources
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.235 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/mscorlib.resources/v4.0_4.0.0.0_nl_b77a5c561934e089/mscorlib.resources.dll
----------------------------------------
System.Windows.Forms.resources
Assembly-versie: 4.0.0.0
Win32-versie: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_nl_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------

************** JIT-foutopsporing **************
Als u JIT-foutopsporing wilt inschakelen, moet in het configuratiebestand voor deze
toepassing of computer (machine.config) de waarde
jitDebugging in het gedeelte system.windows.forms zijn ingesteld.
De toepassing moet ook zijn gecompileerd terwijl foutopsporing
was ingeschakeld.

Bijvoorbeeld:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

Wanneer JIT-foutopsporing is ingeschakeld, worden onverwerkte uitzonderingen
naar het JIT-foutopsporingsprogramma gestuurd dat op de computer is geregistreerd
en worden niet door dit dialoogvenster verwerkt.