# Database Problems **URL:** \ **Category:** C2\ **Created:** [June 22, 2007, 8:47am UTC](https://forums.collective2.com/t/database-problems/4699 "2007-06-22T08:47:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![MatthewKlein](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/matthewklein/32/21382_2.png) [@MatthewKlein](https://forums.collective2.com/u/MatthewKlein)\ **Post date:** [June 22, 2007, 8:47am UTC](https://forums.collective2.com/t/database-problems/4699/1 "2007-06-22T08:47:06Z")
Last night, the main database crashed. It appears that some recently added trading systems were lost. We have a replication server, which is designed to act as a hot backup… but of course it is offline at this moment, about to be shipped to a geographically remote facility (so that we can be prepared in case our main data center has some sort of disaster or attack). It may be possible to reconstruct the lost systems from the binary server logs, using the replication server. I will know whether this is possible, and perhaps even succeed, within a few hours. All I can ask is that you try your best to stay patient while I work on this course of action. I will keep you informed here of progress. ---
**Author:** ![richard\_haines](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/richard_haines/32/618_2.png) [@richard\_haines](https://forums.collective2.com/u/richard_haines)\ **Post date:** [June 22, 2007, 10:02am UTC](https://forums.collective2.com/t/database-problems/4699/2 "2007-06-22T10:02:43Z")
Mathew you are a busy man this morning. Target 50 went long and covered its short on the open. Not showing yet. No hurry. Thanks ---
**Author:** ![ScienceTrader](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/sciencetrader/32/4_2.png) [@ScienceTrader](https://forums.collective2.com/u/ScienceTrader)\ **Post date:** [June 22, 2007, 10:12am UTC](https://forums.collective2.com/t/database-problems/4699/3 "2007-06-22T10:12:23Z")
I can access the site through my browser, but TradeBullet says it is "unable to connect to remote server" ---
**Author:** ![MatthewKlein](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/matthewklein/32/21382_2.png) [@MatthewKlein](https://forums.collective2.com/u/MatthewKlein)\ **Post date:** [June 22, 2007, 10:20am UTC](https://forums.collective2.com/t/database-problems/4699/4 "2007-06-22T10:20:01Z")
Let me take care of that. Hang on ---
**Author:** ![ScienceTrader](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/sciencetrader/32/4_2.png) [@ScienceTrader](https://forums.collective2.com/u/ScienceTrader)\ **Post date:** [June 22, 2007, 10:27am UTC](https://forums.collective2.com/t/database-problems/4699/5 "2007-06-22T10:27:08Z")
seems to work fine now, thanks! ---
**Author:** ![JulesEllis2](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@JulesEllis2](https://forums.collective2.com/u/JulesEllis2)\ **Post date:** [June 24, 2007, 6:03pm UTC](https://forums.collective2.com/t/database-problems/4699/6 "2007-06-24T18:03:28Z")
Given the presumed severity of the problem, I believe you did a good job in dealing with it (or probably more important, with previous preventive measures). From the post of ST I infer that the essential funtions of the site were repaired within one hour. I only noticed the problem via some minor forum malfunction. ---
**Author:** ![ScienceTrader](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/sciencetrader/32/4_2.png) [@ScienceTrader](https://forums.collective2.com/u/ScienceTrader)\ **Post date:** [June 24, 2007, 8:44pm UTC](https://forums.collective2.com/t/database-problems/4699/7 "2007-06-24T20:44:41Z")
As always, Matthew was on top of the problem and fixed it–given how severe it was–quickly. I also appreciated the notification box at the top of the page. ---
**Author:** ![MatthewKlein](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/matthewklein/32/21382_2.png) [@MatthewKlein](https://forums.collective2.com/u/MatthewKlein)\ **Post date:** [June 24, 2007, 9:47pm UTC](https://forums.collective2.com/t/database-problems/4699/8 "2007-06-24T21:47:55Z")
Thanks, guys. We were lucky to have set up some basic replication in the weeks before. As I mentioned earlier, I am also in the process of setting up multiple colocation facilities, in different geographic areas, in case one facility should suffer catastrophic failure. This should be complete within a few weeks. ---
**Author:** ![Lindq](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/lindq/32/238_2.png) [@Lindq](https://forums.collective2.com/u/Lindq)\ **Post date:** [June 25, 2007, 1:08am UTC](https://forums.collective2.com/t/database-problems/4699/9 "2007-06-25T01:08:21Z")
Charts for some systems (including mine - Bounce Systems) have not updated based on Friday’s market and account action. ---
**Author:** ![MatthewKlein](https://yyz2.discourse-cdn.com/flex028/user_avatar/forums.collective2.com/matthewklein/32/21382_2.png) [@MatthewKlein](https://forums.collective2.com/u/MatthewKlein)\ **Post date:** [June 25, 2007, 9:33am UTC](https://forums.collective2.com/t/database-problems/4699/10 "2007-06-25T09:33:19Z")
Yes. All charts should get caught up during the course of today (Monday). If midnight Eastern time rolls around and your chart is out of date, email me. Once again, sorry for the trouble.