Re: [Chicken-hackers] pastiche db drop

2014-02-04 Thread Jörg F. Wittenberger
As this thread is already a bit off-topic I feel compelled to add a "me too" story here as well. You know what: the whole Askemos/BALL thing we have been working on for the past decade is made that way (and I actually felt sorry when I read about the incident thinking "could not have happened

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Andy Bennett
Hi, > Ow ow ow ow. When a system I was responsible for fell off the Internet > for 24+ hours due to a power failure in the building where the servers > were,... I was debugging an issue with one of our data providers the other day and I found some items in the log that I thought were unrelated

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Alaric Snell-Pym
On 03/02/14 14:13, John Cowan wrote: > > On the other hand, that was the *only* time the system went down in a > serious way. It was a Mickey-Mouse-watch design: if you drop it, > it stops; but if you pick it up and shake it, it works again. > In particular, if the web and FTP sites were messed

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Christian Kellermann
* John Cowan [140203 15:14]: > Alaric Snell-Pym scripsit: > > > Bah! Why did the sql engine (sqlite?) not reject that as a syntax error? > > Sqlite does reject it: > > [cowan@vrici ~]$ sqlite3 > SQLite version 3.8.0.2 2013-09-03 17:11:13 > Enter ".help" for instructions > Enter SQL statements t

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread John Cowan
Alaric Snell-Pym scripsit: > Bah! Why did the sql engine (sqlite?) not reject that as a syntax error? Sqlite does reject it: [cowan@vrici ~]$ sqlite3 SQLite version 3.8.0.2 2013-09-03 17:11:13 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> delete from pastes wh

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Alaric Snell-Pym
On 03/02/14 09:53, Christian Kellermann wrote: > Hi there, > > I have just dropped pastiche's database accidentally by omitting > an equal sign during spam deletion. > > That is: > > delete from pastes where hash "6e4bc38a652603314074d80094b39197fee50ac2"; Bah! Why did the sql engine (sqlite?)

Re: [Chicken-hackers] pastiche db drop

2014-02-03 Thread Christian Kellermann
* Christian Kellermann [140203 10:55]: > I had a copy of the db which has been taken around december 9th > 2013 and copied that over to the server. Thanks to Mario we now have a backup dated Feb 1st back in action. Thanks so much! -- In the world, there is nothing more submissive and weak than

[Chicken-hackers] pastiche db drop

2014-02-03 Thread Christian Kellermann
Hi there, I have just dropped pastiche's database accidentally by omitting an equal sign during spam deletion. That is: delete from pastes where hash "6e4bc38a652603314074d80094b39197fee50ac2"; I had a copy of the db which has been taken around december 9th 2013 and copied that over to the serv