6.2 UI Crash and other pains

PDinCAPDinCA Posts: 642 Silver 1
edited September 30, 2009 12:58PM in SQL Backup Previous Versions
Looks like the UI Exception reported for 6.1 didn't make it...(http://www.red-gate.com/messageboard/viewtopic.php?t=9301) 6.2 crashes, which makes it a tool I am reluctant to go into. Right now, I can continue to use the UI despite the fact that I have an unresponded-to Exception dialog open from the latest crash.

What was I doing? Merely clicked on a server while all the server connections had yet to refresh - that's the first crash. I restarted and waited for every connection to refresh. I started the server component upgrades and I made one of my clicks while another server was refreshing - Crash! And that's the box I will not dismiss because I can't be bothered to keep restarting the UI!

I upgraded one of the servers - SS2K8, WS2K8. It took two tries. 1st time it failed at the version number check, so I hit "Retry" more out of hope than confidence, and it completed! But, all I now see is a big fat X for that box - and it has been 10 minutes or more since the upgrade and the other two virtuals that were created from the same image are all good after the upgrade. Surprise! If I right-click and poke it with a "Refresh" stick, it refreshes just fine :wink:

Tried to upgrade a cluster. No joy. Failed at step 4 - version comparison. This is a physical box running SS2000 under Windows 2003. Guess I'll have to remote in for that one... What is disturbing is that the "Run setup on server" completes successfully but the version comparison barfs - why? I asked the upgrader to handle both nodes, BTW. "Retry", (three times) did nothing this time. Active-passive configuration.

Tried to upgrade the newer cluster - foolish idea! Failed at step 4. This is a SS2008 box under Windows Server 2008. Asked for upgrade of both nodes. Active-passive configuration. Fails on Retry. More remote-in upgrading... :cry:

One of the virtuals has been red-X'd since I launched the UI. It likes being poked with a "Refresh" right-click stick :x. And that box took two cycles to upgrade successfully, like the first one. SS2K this time.

Here's the Exception info:
SQLBackup

Unable to open the database file
unable to open database file
WorkerExecutionException

   at RedGate.SQLBackup.Engine.ConfigurableThreadPool.a(Exception )
   at RedGate.SQLBackup.Engine.ConfigurableThreadPool.a.b()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

----------

SQLiteException

Unable to open the database file
unable to open database file

   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at g.g(Server )
   at g.b(Object )

Having upgraded all the nodes individually, and having closed the UI, I restarted it. OOPS! The Exception dialog was still open when I closed the main UI. I was informed there was already a copy of SQLBackup running - not! Task Manager, nuke process tree...

Restarted UI. Expanded the first group, "Production", and all are good - upgrades all have the UI version. Expanded the second group, "Virtuals", IMMEDIATE CRASH :x Here's that exception:
SQLBackup

Insertion failed because the database is full
database or disk is full
WorkerExecutionException

   at RedGate.SQLBackup.Engine.ConfigurableThreadPool.a(Exception )
   at RedGate.SQLBackup.Engine.ConfigurableThreadPool.a.b()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

----------

SQLiteException

Insertion failed because the database is full
database or disk is full

   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at g.g(Server )
   at g.b(Object )
I can assure you that I have 79GIGS free on my c: drive.
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...

Comments

  • Thank you for your post, I apologise you are encountering issues with SQL Backup.

    The error you are receiving is usually due to the cached history for the server becoming corrupt.

    Can you please try the following :

    1. Close the SQL Backup GUI.

    2. Locate the following folder on the machine running the GUI - %USERPROFILE%\local settings\Application Data\Red Gate\SQL Backup\Server Data

    3. Delete this folder and it's contents.

    4. Open the SQL Backup GUI.

    Please confirm that this resolves your issue.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    I have got a small app for checking and repairing the SQL CE data store that you can run on the server, which may be able to repair the database without having to delete it and potentially lose any backup history. It does require .NET to be installed on the server, because MS don't seem to give you a COM object for SQL CE that doesn't need .NET.

    Maybe you could give this a try and let me know how it goes.
    ftp://support.red-gate.com/utilities/Re ... aStore.zip
  • PDinCAPDinCA Posts: 642 Silver 1
    Anu, I followed your instructions to the letter. Crash, and Crash - both the "Full" and "Unable to open" occurred in succession.

    Brian, when you say "server", I wonder which of the 8 you mean - all of them!? It doesn't seem to matter whether I expand the Production group first or the Virtuals, whichever is done second provokes the crash.

    SQLBackup GUI is installed on my laptop and one other server. The GUI hasn't been used on that server in at least 3 months as it's a fallback install. Server components are on the monitored servers, including the server where the GUI is installed. Which .Net do I need - as in, is 3.5 the correct version to have to install up to? And, as we are DBA-challenged, what is the effect of the .Net install as in, will the clusters need rebooting, what other effects are there? Risk is not something I want to entertain right now.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi,

    I think that on the surface it's a client-side issue because SQLLite is the technology used to host the SQL Backup console's data cache. However, since you have deleted the data from there, I'd guess that the server-side data is corrupt. The evidence does not give us a clear conclusion, though. If you can, I think you should run the server side utility to verify all of the SQL CE databases that SQL Backup uses on the server-side. If you aren't allowed .NET on the SQL Server, then you can't do that.
  • PDinCAPDinCA Posts: 642 Silver 1
    I just upgraded the fallback server (Windows Server 2003 SP2) and I can expand and contract ALL Groups and Servers at will with ZERO crashes. By "at will", I mean "going crazy expanding, forcing refresh, collapsing, expanding in a different sequence" a.k.a. "DIE YOU DOG!" and it wouldn't die :D

    This leads me to believe that the Servers are fine and that the problem lies with the UI... Laptop is Windows XP Pro SP3 with every Windows Update applied as of this morning - BEFORE the latest reboot and crash sequence.

    Any log files I can send, or anything I can run for you to capture activity? - more than happy to do so...


    Please don't forget the upgrade issues where it says the server upgrade is OK but the version comparison fails.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • RBARBA Posts: 152 Silver 3
    Hi PDinCA,

    A number of your valild concerns are bring addressed. The unhandled exception you experience when expanding server groups may be related to a local cache issue that occurs when the file is locked (either by another application or perhaps concurrent activity within the GUI).
    Which .Net do I need - as in, is 3.5 the correct version to have to install up to?
    You will need the .NET 2.0 framework to run the UI. This carries no risk.
    "Run setup on server" completes succesfully
    Sadly, this just means that the installer was executed and not that the executable succeeded in its task. Remote install of the service only works in a subset of security scenarios. For clusters especially, running the manual installer is recommended. The messages that the install dialogue presents have been changed for the next release to be more helpful.

    For your UI issues, the exception data and the description you described should be enough for now, though if you encounter any more bugs or annoyances more information would be appreciated.

    Thanks,
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    Well, 3 1/2 weeks later and I now have NO working SQL Backup!

    I open the UI, get the "Upgrade the cache..." dialog, try EITHER the "Now" or the "Later" option and OK it, then I get to see the main window but either by just waiting or trying to expand a Group the UI dies without a message or exception - POOF!

    I have deleted the Server cache files under \Server Data from C:\Documents and Settings\<<user>>\Local Settings\Application Data\Red Gate\SQL Backup

    In the \SQL Backup folder there is a lockfile.pid 0KB file that's locked by some process or other. It is dated 1/11/2008... Should I attempt to unlock it and whack it?

    I AM DEAD IN THE WATER!
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Hi PDinCA,

    The UI dies without message or exception? That is most disturbing.

    You can enable logging by placing the following registry key:

    HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\Client"FullLogging" set to "1" (REG_SZ)

    Which will hopefully shed some light.
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    Added a new node for the key, then added the value. Ran UI and predicatably it died.

    Location of the log file(s) you need?
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • PDinCA wrote:
    Added a new node for the key, then added the value. Ran UI and predicatably it died.

    Location of the log file(s) you need?

    You should be able to find them here:

    C:\Documents and Settings\[USERNAME]\Local Settings\Application Data\Red Gate\Logs\SQL Backup

    Cheers,
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    Here's the content of the log file after turning on full logging:
    09:22:10.777|Verbose|UI                  |1  |Loaded RedGate.Shared.Utils, Version=7.3.0.25, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Shared.Utils.dll
    09:22:10.808|Info   |UI                  |1  |SQL Backup Client 6.2.0.134
    09:22:10.808|Info   |UI                  |1  |=======================================
    09:22:12.230|Verbose|UI                  |1  |Loaded System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
    09:22:12.277|Verbose|UI                  |1  |Loaded System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll
    09:22:12.402|Verbose|UI                  |1  |Loaded System.Data.SQLite, Version=1.0.54.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139 C:\Program Files\Red Gate\SQL Backup 6\System.Data.SQLite.dll
    09:22:12.589|Verbose|UI                  |1  |Loaded System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll
    09:22:12.964|Verbose|UI                  |1  |Loaded RedGate.SQLCompare.ASTParser, Version=8.0.0.309, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.SQLCompare.ASTParser.dll
    09:22:12.980|Verbose|UI                  |1  |Loaded RedGate.Shared.SQL, Version=7.3.0.25, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Shared.SQL.dll
    09:22:13.073|Verbose|UI                  |1  |Loaded Antlr3.Runtime, Version=3.1.2.41038, Culture=neutral, PublicKeyToken=3a9cab8f8d22bfb7 C:\Program Files\Red Gate\SQL Backup 6\Antlr3.Runtime.dll
    09:22:13.183|Verbose|UI                  |1  |Loaded System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll
    09:22:13.448|Verbose|UI                  |1  |Loaded System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll
    09:22:56.934|Verbose|UI                  |1  |Loaded DevExpress.XtraEditors.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraEditors.v7.2.dll
    09:22:56.981|Verbose|UI                  |1  |Loaded DevExpress.Utils.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.Utils.v7.2.dll
    09:22:57.074|Verbose|UI                  |1  |Loaded DevExpress.Data.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.Data.v7.2.dll
    09:22:57.215|Verbose|UI                  |1  |Loaded DevExpress.XtraBars.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraBars.v7.2.dll
    09:23:00.402|Verbose|UI                  |1  |Loaded Syncfusion.Grid.Windows, Version=6.102.0.34, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89 C:\Program Files\Red Gate\SQL Backup 6\Syncfusion.Grid.Windows.dll
    09:23:00.465|Verbose|UI                  |1  |Loaded Syncfusion.Shared.Base, Version=6.102.0.34, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89 C:\Program Files\Red Gate\SQL Backup 6\Syncfusion.Shared.Base.dll
    09:23:00.652|Verbose|UI                  |1  |Loaded Syncfusion.Core, Version=6.102.0.34, Culture=neutral, PublicKeyToken=632609b4d040f6b4 C:\Program Files\Red Gate\SQL Backup 6\Syncfusion.Core.dll
    09:23:02.934|Verbose|UI                  |1  |Loaded RedGate.Shared.Controls, Version=7.4.0.7, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Shared.Controls.dll
    09:23:03.262|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.278|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.278|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.278|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.340|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.340|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.340|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.340|Verbose|UI                  |1  |Connection state of  now NotConnected
    09:23:03.340|Verbose|UI                  |1  |SEL: Selected 9268D399-5F97-438f-A815-DA326F2CF787
    09:23:03.699|Verbose|UI                  |1  |Loaded DevExpress.XtraGrid.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraGrid.v7.2.dll
    09:23:05.574|Verbose|UI                  |1  |Loaded DevExpress.XtraTreeList.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraTreeList.v7.2.dll
    09:23:06.168|Verbose|UI                  |1  |SEL: Selected Saddleback
    09:23:08.324|Verbose|UI                  |1  |Loaded RedGate.Update.Client, Version=2.2.0.3, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Update.Client.dll
    09:24:03.357|Verbose|UI                  |5  |BackupApplication: Requesting DM update for visible, expanded/selected servers.
    09:24:58.217|Verbose|UI                  |1  |SEL: Selected Production
    09:24:58.530|Verbose|UI                  |1  |Connection state of eSQL now PreConnecting
    09:24:58.530|Verbose|UI                  |6  |Connection state of eSQL now Connecting
    09:24:58.561|Verbose|UI                  |1  |Connection state of mceRPRT now PreConnecting
    09:24:58.561|Verbose|UI                  |1  |Connection state of PD-SQLDB now PreConnecting
    09:24:58.577|Verbose|UI                  |15 |Connection state of mceRPRT now Connecting
    09:24:58.577|Verbose|UI                  |16 |Connection state of PD-SQLDB now Connecting
    09:25:02.202|Verbose|UI                  |1  |DataManager: Queueing data request 61660876 on mceRPRT
    09:25:02.217|Verbose|UI                  |17 |DataManager: EXEC DataReq ActivityHistoryByDates 61660876 on mceRPRT
    09:25:02.233|Verbose|UI                  |15 |Connection state of mceRPRT now Successful
    09:25:02.264|Verbose|UI                  |17 |DataManager: XFORM AHByDates to UpdateReq for DataReq 61660876 on mceRPRT
    09:25:02.295|Verbose|UI                  |17 |DataManager: Queueing UpdateReq 7185836 on mceRPRT from 9/13/2009 12:00:00 AM to 9/14/2009 9:25:02 AM
    09:25:02.327|Verbose|UI                  |20 |DataManager: EXEC UpdateReq 7185836 on mceRPRT
    09:25:02.327|Verbose|UI                  |20 |mceRPRT is updating is None
    09:25:02.327|Verbose|UI                  |20 |mceRPRT continuing updating
    09:25:02.342|Verbose|UI                  |20 |mceRPRT checking sync
    09:25:02.420|Verbose|UI                  |6  |Connection state of eSQL now Successful
    09:25:02.514|Verbose|UI                  |1  |DataManager: Queueing data request 28475059 on eSQL
    09:25:02.514|Verbose|UI                  |17 |DataManager: EXEC DataReq ActivityHistoryByDates 28475059 on eSQL
    09:25:02.514|Verbose|UI                  |17 |DataManager: XFORM AHByDates to UpdateReq for DataReq 28475059 on eSQL
    09:25:02.514|Verbose|UI                  |17 |DataManager: Queueing UpdateReq 54804024 on eSQL from 9/13/2009 12:00:00 AM to 9/14/2009 9:25:02 AM
    09:25:02.545|Verbose|UI                  |20 |mceRPRT is updating is None
    09:25:02.561|Verbose|UI                  |20 |DataManager: XFORM UpdateReq 7185836 to DataReq 61660876 on mceRPRT
    09:25:02.561|Verbose|UI                  |20 |DataManager: Queueing data request 61660876 on mceRPRT
    09:25:02.561|Verbose|UI                  |17 |DataManager: EXEC DataReq ActivityHistoryByDates 61660876 on mceRPRT
    09:25:02.577|Verbose|UI                  |17 |DM: mceRPRT SQL: SELECT * FROM activityhistory WHERE end &gt; 633883968000000000 and start &lt; 633885171021865533 and  server_identity = 2 ORDER BY end DESC
    09:25:02.577|Verbose|UI                  |17 |Process delegate is: ey::a
    09:25:02.608|Verbose|UI                  |21 |DataManager: EXEC UpdateReq 54804024 on eSQL
    09:25:02.608|Verbose|UI                  |21 |eSQL is updating is None
    09:25:02.608|Verbose|UI                  |21 |eSQL continuing updating
    09:25:02.608|Verbose|UI                  |21 |eSQL checking sync
    
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Hi PDinCA,

    Apologies for the untimely reply. I have been looking into this one and can reproduce the bug if the local cache files are locked by another application. (The lockfile.pid is used to ensure only one copy of the UI is running at a time. It should only be locked when the UI is running and is probably not related to what you're experiencing).

    Can you please check if any other programs have a lock on the local cache files? These are named X.dat where X is an integer, and live in Local Settings\Application Data\Red Gate\SQL Backup\Server Data.

    You can use sysinternals process explorer to identify which programs have a file open (CTRL-F). So just before expanding the second server group please quickly check which application has the lock.

    I might also like to have a look at your localDataCache.dat file. This contains the mappings of instance names to X.dat filenames. If that's ok, please email it to me at (robin.anderson [at] red-gate.com).
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    I used "Unlocker 1.8.7" and right-clicked each of the 1.dat, 2.dat, 3.dat and localDataCache.dat files. None of them has a locking handle and the SQL Backup UI is running - I haven't expanded any server group as instructed.

    Email of local....dat incoming.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Hi,

    By the look of the errors you are getting the locks will only be held very temporarily. Are you running a virus scanner, does it have an on-access check? If that took an exclusive lock while it was checking the files then that could cause the errors you are seeing.

    Would it be possible to exclude that directory from your virus scanner/temporarily disable it and see if you continue to see problems?

    Thanks,

    James
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
  • The localdatacache seems fine. If there are no locks on the files, then SQB should not throw an exception when it tries to use them.

    Perhaps a filemon/procmon trace would shed some light? Then we could see exactly what's happening when the crash occurs.
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    edited September 29, 2009 3:12PM
    James:
    SO Close! I excluded every subfolder under Local Settings\Application Data\Red Gate\ from Symantec's Endpoint Protection.

    I managed to expand the Production group and two of its servers, but when I expanded the Development Group - poof! No Exception, no message, just "gone"...

    Do I need to do any excludes on the servers too?

    Robin:
    filemon/procmon are unfamiliar to me, so I'd need some assistance to set them up... Details?

    When I first open SQL Backup, I get the "Upgrading Activity Cache" dialog every time - it never appears to complete, even having managed to keep the UI active for a few minutes. I usually choose the default "Upgrade Now" but even if I choose "Later" I get the error: "Some cache files could not be upgraded. It may initially take a few minutes to display activity history for some servers." I whacked the entire Server Data folder content and now, upon attempted expansion of the Development group:
      localDataCache.dat 4.dat 4.dat-journal 6.dat 6.dat-journal 7.dat 8.dat 8.dat-journal
    As the files are binary, I can't see the content of the %journal files... Do you want them?

    ALL:
    Took the sledgehammer approach and uninstalled 6.2, rebooted, reinstalled from fresh Toolbelt download and:
      1. Added Production Group and each of three servers under it. 2. Added Dev Group and the first virtual OK. 3. Tried to add a SS2000 instance and the UI crashed with no exception. 4. When SQL Backup restarted, I received the "Upgrading Cache" dialog, chose "Now" and my list of groups and servers was EMPTY. 5. Re-added the Production Group and all 3 servers. OK. 6. Closed SQL Backup. 7. Restarted SQL Backup and my Group is intact. 8. Added the DEV Group and one server. OK. 9. Exit and restart - OK. 10. Tried to add a SS2008 instance - crash! 11. Went to the SS2000 and SS2008 "failed addition" servers and ran the SQB Install on both virtuals. 12. Tried to re-add the SS2008 instance - CRASH!
    Full Logging is still turned on.

    What can I send you that may help?
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • PDinCAPDinCA Posts: 642 Silver 1
    Hi,

    I think that on the surface it's a client-side issue because SQLLite is the technology used to host the SQL Backup console's data cache. However, since you have deleted the data from there, I'd guess that the server-side data is corrupt. The evidence does not give us a clear conclusion, though. If you can, I think you should run the server side utility to verify all of the SQL CE databases that SQL Backup uses on the server-side. If you aren't allowed .NET on the SQL Server, then you can't do that.

    I ran the utility on the SS2008 instance under Windows Server 2008 - the one that bombed in the post above and the utility exceptioned:
    ************** Exception Text **************
    System.BadImageFormatException: An attempt was made to load a program with an incorrect format. &#40;Exception from HRESULT: 0x8007000B&#41;
       at System.Data.SqlServerCe.NativeMethods.DllAddRef&#40;&#41;
       at System.Data.SqlServerCe.SqlCeEngine..ctor&#40;&#41;
       at RepairSQBDataStore.SDFDataStore..ctor&#40;String filename&#41; in D:\Documents\brian.donahue\My Documents\Visual Studio 2008\Projects\RepairSQBDataStore\RepairSQBDataStore\SDFDataStore.cs:line 15
       at RepairSQBDataStore.Form1.butVerify_Click&#40;Object sender, EventArgs e&#41; in D:\Documents\brian.donahue\My Documents\Visual Studio 2008\Projects\RepairSQBDataStore\RepairSQBDataStore\Form1.cs:line 174
       at System.Windows.Forms.Control.OnClick&#40;EventArgs e&#41;
       at System.Windows.Forms.Button.OnMouseUp&#40;MouseEventArgs mevent&#41;
       at System.Windows.Forms.Control.WmMouseUp&#40;Message& m, MouseButtons button, Int32 clicks&#41;
       at System.Windows.Forms.Control.WndProc&#40;Message& m&#41;
       at System.Windows.Forms.ButtonBase.WndProc&#40;Message& m&#41;
       at System.Windows.Forms.Button.WndProc&#40;Message& m&#41;
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc&#40;Message& m&#41;
       at System.Windows.Forms.NativeWindow.Callback&#40;IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam&#41;
    
    
    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3074 &#40;QFE.050727-3000&#41;
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
    ----------------------------------------
    RepairSQBDataStore
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///T:/PD-IT/Software/Red-Gate/RepairSQBDataStore/RepairSQBDataStore.exe
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3053 &#40;netfxsp.050727-3000&#41;
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3053 &#40;netfxsp.050727-3000&#41;
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3053 &#40;netfxsp.050727-3000&#41;
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    System.Management
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3053 &#40;netfxsp.050727-3000&#41;
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
    ----------------------------------------
    System.ServiceProcess
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3053 &#40;netfxsp.050727-3000&#41;
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
    ----------------------------------------
    System.Data.SqlServerCe
        Assembly Version: 9.0.242.0
        Win32 Version: 3.0.5300.0
        CodeBase: file:///T:/PD-IT/Software/Red-Gate/RepairSQBDataStore/System.Data.SqlServerCe.DLL
    ----------------------------------------
    
    I uninstalled the SQB Server Components and reinstalled and still it crashes.

    Ideas?
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Here's a thought - have you tried running the UI from another terminal (pointing to the same servers)?

    If it still crashes, then we know the problem relates to something server-side and if it doesn't then it's something with the UI on certain hardware/software.
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCA wrote:
    Robin:
    filemon/procmon are unfamiliar to me, so I'd need some assistance to set them up... Details?

    filemon was a tool my microsft sysinternals that logs all file IO - saying which applications did what to which file during the period it was collecting data.

    It was replaced by procmon, which is the same but also records registry, network and other data. When you start it up, it automatically starts capturing data.

    procmon.png

    Click the magnifying glass button (blue arrow) to stop it collecting. Then make sure only the file button (red) is selected, since we're not interested in the other info it can collect. Then clear the display (white page with eraser button) and start collection again. Then make the UI crash and stop collection. File>Save the trace in the default format. This file should hopefully tell me what was happening at the time.

    n.b. the trace file can get big quickly - if it's too large to email, procmon has filtering capability (can right click a row which you assume is not relevant and remove all similar entries).
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    RBA wrote:
    Here's a thought - have you tried running the UI from another terminal (pointing to the same servers)?

    If it still crashes, then we know the problem relates to something server-side and if it doesn't then it's something with the UI on certain hardware/software.
    That's the issue with the Windows Server 2003 UI crashing - it points to the same groups and servers.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • PDinCA wrote:
    RBA wrote:
    Here's a thought - have you tried running the UI from another terminal (pointing to the same servers)?

    If it still crashes, then we know the problem relates to something server-side and if it doesn't then it's something with the UI on certain hardware/software.
    That's the issue with the Windows Server 2003 UI crashing - it points to the same groups and servers.

    So you can get the UI to crash from multiple machines?

    I have the server list from the file you supplied - but can you tell me if there is anything interesting or unusual about the instances in the list that might help me reproduce this?
    Robin Anderson
    Development
    Red-Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    The Dev Virtuals are SS2008 under Windows Server 2008 except for the 2 suffixed 2K, which are SS2000 under Windows Server 2003.

    The latest UI crash after the reinstall was when I tried to add mceSTGsql. I ran the server-side install on that box but it still crashes the UI. I also tried to add the mceDEVsql2K server, and after the crash also ran the server-side install. Still cannot add either server, but I have the mceDEVsql server up fine...

    I just took a chance and added the mceUATsql server successfully! So I closed the UI and when I restarted it and expanded the dev group, the mceUATsql server showed the "red X" and then the UI crashed.

    I just disabled Symantec's Endpoint Protection completely and Lavasoft's Ad-Aware Service is suspended.

    I managed to add mceSTGsql successfully.

    Adding mceDEVsql2K\ECOM crashed the UI - that's the one I ran the server-side install for yesterday.

    Deleted the Dev Virtuals Group. Closed UI. Restarted. Added Dev Virtuals group. Added mceDEVsql - OK so far. Closed UI. Restarted. Tried to add the mceUATsql SS2008/WS2008 instance and crashed.

    Now I've successfully added mceSTGsql again...

    There really doesn't appear to be a clear pattern here... Any benefit in your remoting in?
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • have replied by email to coordinate.
    Robin Anderson
    Development
    Red-Gate Software
Sign In or Register to comment.