Are you over 18 and want to see adult content?
More Annotations
![A complete backup of https://nukitomo.me](https://www.archivebay.com/archive6/images/dd24d78a-ee1f-4d6c-9375-5e79c3fc59b7.png)
A complete backup of https://nukitomo.me
Are you over 18 and want to see adult content?
![A complete backup of https://cardiffbay.co.uk](https://www.archivebay.com/archive6/images/e9999f83-fa3d-4384-965e-f5a0b82c3cd8.png)
A complete backup of https://cardiffbay.co.uk
Are you over 18 and want to see adult content?
![A complete backup of https://costakreuzfahrten.de](https://www.archivebay.com/archive6/images/a8880fa9-3b77-4a09-b049-79ee8221aa7d.png)
A complete backup of https://costakreuzfahrten.de
Are you over 18 and want to see adult content?
![A complete backup of https://greencouponcodes.com](https://www.archivebay.com/archive6/images/7818a8bf-933a-4f14-9add-0c909cea1bc8.png)
A complete backup of https://greencouponcodes.com
Are you over 18 and want to see adult content?
![A complete backup of https://crime-scene-investigator.net](https://www.archivebay.com/archive6/images/db5bd6b5-5447-43f4-bc6a-c52b64018c71.png)
A complete backup of https://crime-scene-investigator.net
Are you over 18 and want to see adult content?
![A complete backup of https://roofingmegastore.co.uk](https://www.archivebay.com/archive6/images/5f57df56-bccf-4070-a93c-5f60de74b3a4.png)
A complete backup of https://roofingmegastore.co.uk
Are you over 18 and want to see adult content?
![A complete backup of https://thevarsityhotel.co.uk](https://www.archivebay.com/archive6/images/62c1549d-a1e6-4b96-bdb0-8aaef5e93494.png)
A complete backup of https://thevarsityhotel.co.uk
Are you over 18 and want to see adult content?
![A complete backup of https://justtravelcover.com](https://www.archivebay.com/archive6/images/529f15c3-8067-48f4-a861-0340a71d7e23.png)
A complete backup of https://justtravelcover.com
Are you over 18 and want to see adult content?
![A complete backup of https://eausecours.org](https://www.archivebay.com/archive6/images/49bf27b6-8acc-404c-b9bf-1f9bd3208da9.png)
A complete backup of https://eausecours.org
Are you over 18 and want to see adult content?
![A complete backup of https://suomela.fi](https://www.archivebay.com/archive6/images/b196fe34-56aa-4f3c-af09-d1ebd2167d7d.png)
A complete backup of https://suomela.fi
Are you over 18 and want to see adult content?
Favourite Annotations
![A complete backup of schulstad.com.pl](https://www.archivebay.com/archive5/images/ae1d3e29-c453-46ad-9a08-5170f924fec7.png)
A complete backup of schulstad.com.pl
Are you over 18 and want to see adult content?
![A complete backup of marketfinance.com](https://www.archivebay.com/archive5/images/6736121a-0aea-4d4d-9206-6f6f9db704ee.png)
A complete backup of marketfinance.com
Are you over 18 and want to see adult content?
![A complete backup of gplus-antworten.de](https://www.archivebay.com/archive5/images/3a0f2550-36ce-420a-a9fd-042e8c2e6b15.png)
A complete backup of gplus-antworten.de
Are you over 18 and want to see adult content?
![A complete backup of televizeseznam.cz](https://www.archivebay.com/archive5/images/b27b8460-524f-4ce3-94ae-83cefd4abdab.png)
A complete backup of televizeseznam.cz
Are you over 18 and want to see adult content?
![A complete backup of thefunnyblog.org](https://www.archivebay.com/archive5/images/57f03040-cc21-40fd-84ce-f03c8dfeb910.png)
A complete backup of thefunnyblog.org
Are you over 18 and want to see adult content?
Text
INSTANT BADGER
Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: HOW TO CREATE AND SAVE AN AMI IMAGE FROM AAUTHOR:ALISTAIR DAVIDSON
One snag I encountered early on in my migration of Cragwag and Sybilline to Amazon's EC2 Cloud, was that I needed to take a snapshot of my running instance and save it as a new Amazon Machine Image (AMI). I'd created a bare-bones Debian image from a public AMI (32-bit Lenny, 5.0, not much else) and then installed a few standard software packages on it - mysql, ruby, apache, etc etc etc. INSTANT BADGER: VERSION CONTROL WITH SUBVERSION AND Been looking at version control systems for use with our CF development. After a lot of investigation, I decided to go with Subversion (SVN) for the server, and TortoiseSVN for the client. These two nifty little tools are free (as in beer) and open source, and they're self-hosting : i.e. the source code and version control for Subversion is done with INSTANT BADGER: THE PERENNIAL RSS AUTHENTICATION DILEMMA It's a common problem, one that has cropped up many times for me over the last few years. You build a secure system, locked up behind a login so that only authenticated users can access the tightly-controlled data, and everything's fine - and then you come tothe RSS feeds.
INSTANT BADGER: SVN OVER SSH (SVN+SSH://) ON WINDOWS VIA Svn over ssh (svn+ssh://) on Windows via cygwin and PuTTy. One of the more obvious things lacking from Windows is an ssh (secure shell) client, and this has caused me no end of grief trying to check out code from Subversion repositories on servers that require ssh access - such as our own. svn+ssh://alistair@ (saved PuTTY session name) / etc INSTANT BADGER: IN DEFENCE OF HUNGARIAN NOTATION I started typing a comment on Pete Bell's post Why Not Hungarian, but it got a bit too long so I've put my two-penn'orth here. Hungarian notation, for me, can be very useful, but maybe not in the form that's most commonly understood. INSTANT BADGER: REGEX TO FULLY VALIDATE RFC822 EMAIL ADDRESSES Mail::RFC822::Address - a module that tells you whether the given string is a valid email address or not. Most email validators only check the absolute basics - e.g. some characters followed by an at-sign, followed by some more characters and at least one dot. But have you ever actually read RFC822, the critical RFC that defines thestandard of
INSTANT BADGER: MYSQL "ROW SIZE TOO LARGE" WHEN SAVING Joseph D. Purcell said. A fantastic article! Thank you for writing it! Two notes worth mentioning: 1. DYNAMIC vs COMPRESSED: the key difference between the two is COMPRESSED also uses zlib compression on the data. In cases where storage space is not a constraint, using "ROW_FORMAT=COMPRESSED" will avoid the unnecessary CPU load ofcompressing data.
INSTANT BADGER: I STILL MISS CFOUTPUT It's been about a year now since I last coded CF in anger, and what coding I've done since then has been mainly in Java and Ruby On Rails. These days, most of my coding is done in my spare time, which is a resource in increasingly short supply - so coding actually tends to be done during my random bouts of insomnia. INSTANT BADGER: 04/01/2005 I've been in my current job for nearly a year now, and I've been strongly advocating a move to the FLiP methodology for most of that time. Responses to the idea have varied from strong support amongst the developers and project managers, to more cautious support from the business owners who aren't sure about buy-in from clients, to "cautious-agreement-in-principle-but-not-yet-convinced" fromINSTANT BADGER
Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: HOW TO CREATE AND SAVE AN AMI IMAGE FROM AAUTHOR:ALISTAIR DAVIDSON
One snag I encountered early on in my migration of Cragwag and Sybilline to Amazon's EC2 Cloud, was that I needed to take a snapshot of my running instance and save it as a new Amazon Machine Image (AMI). I'd created a bare-bones Debian image from a public AMI (32-bit Lenny, 5.0, not much else) and then installed a few standard software packages on it - mysql, ruby, apache, etc etc etc. INSTANT BADGER: VERSION CONTROL WITH SUBVERSION AND Been looking at version control systems for use with our CF development. After a lot of investigation, I decided to go with Subversion (SVN) for the server, and TortoiseSVN for the client. These two nifty little tools are free (as in beer) and open source, and they're self-hosting : i.e. the source code and version control for Subversion is done with INSTANT BADGER: THE PERENNIAL RSS AUTHENTICATION DILEMMA It's a common problem, one that has cropped up many times for me over the last few years. You build a secure system, locked up behind a login so that only authenticated users can access the tightly-controlled data, and everything's fine - and then you come tothe RSS feeds.
INSTANT BADGER: SVN OVER SSH (SVN+SSH://) ON WINDOWS VIA Svn over ssh (svn+ssh://) on Windows via cygwin and PuTTy. One of the more obvious things lacking from Windows is an ssh (secure shell) client, and this has caused me no end of grief trying to check out code from Subversion repositories on servers that require ssh access - such as our own. svn+ssh://alistair@ (saved PuTTY session name) / etc INSTANT BADGER: IN DEFENCE OF HUNGARIAN NOTATION I started typing a comment on Pete Bell's post Why Not Hungarian, but it got a bit too long so I've put my two-penn'orth here. Hungarian notation, for me, can be very useful, but maybe not in the form that's most commonly understood. INSTANT BADGER: REGEX TO FULLY VALIDATE RFC822 EMAIL ADDRESSES Mail::RFC822::Address - a module that tells you whether the given string is a valid email address or not. Most email validators only check the absolute basics - e.g. some characters followed by an at-sign, followed by some more characters and at least one dot. But have you ever actually read RFC822, the critical RFC that defines thestandard of
INSTANT BADGER: MYSQL "ROW SIZE TOO LARGE" WHEN SAVING Joseph D. Purcell said. A fantastic article! Thank you for writing it! Two notes worth mentioning: 1. DYNAMIC vs COMPRESSED: the key difference between the two is COMPRESSED also uses zlib compression on the data. In cases where storage space is not a constraint, using "ROW_FORMAT=COMPRESSED" will avoid the unnecessary CPU load ofcompressing data.
INSTANT BADGER: I STILL MISS CFOUTPUT It's been about a year now since I last coded CF in anger, and what coding I've done since then has been mainly in Java and Ruby On Rails. These days, most of my coding is done in my spare time, which is a resource in increasingly short supply - so coding actually tends to be done during my random bouts of insomnia. INSTANT BADGER: 04/01/2005 I've been in my current job for nearly a year now, and I've been strongly advocating a move to the FLiP methodology for most of that time. Responses to the idea have varied from strong support amongst the developers and project managers, to more cautious support from the business owners who aren't sure about buy-in from clients, to "cautious-agreement-in-principle-but-not-yet-convinced" from INSTANT BADGER: VERSION CONTROL WITH SUBVERSION AND Been looking at version control systems for use with our CF development. After a lot of investigation, I decided to go with Subversion (SVN) for the server, and TortoiseSVN for the client. These two nifty little tools are free (as in beer) and open source, and they're self-hosting : i.e. the source code and version control for Subversion is done with INSTANT BADGER: STATSVN I'm a big fan of SVN, and I know it's in very common use throughout the development community, so I thought I'd give a shout out to an interesting project that extracts some fascinating SVN stats and draws lots of pretty pictures - StatSVN. We've now added a StatSVN task to our build scripts, and the figures it kicks out are just great - once you start looking, you can lose yourself in there INSTANT BADGER: 08/01/2009 Over the weekend I was having a fiddle around with the layout on Cragwag, as the existing design was a bit, shall we say, emergent.I'd being trying to avoid a LHS column, because everything always seems to end up with one, but in the end I had to give up and just go with it. INSTANT BADGER: 11/01/2012 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: RAKE GOTCHA ON WINDOWS Anonymous said An easier way to do this is to go to c:\ruby\bin and copy one of the bat files (I copied gem.bat), edit the file to say 'rake' instead of 'gem' and then you need to copy the rake.rb file (c:\ruby\bin\rake.rb) to be instead just rake (c:\ruby\bin\rake) and then you don't have to modify any of your code anyway since now 'rake' at the command line will work. INSTANT BADGER: "YOU LOOK A LOT COOLER ON THE WEBSITE...." Last night's London CFUG had a good detailed introduction to Model-Glue and Reactor from Mark Drew, and a good-as-ever beer session in the pub afterwards.I'm intrigued by Model-Glue, and I'm tempted to give it a go on a medium-size project that I'm prototyping at themoment.
INSTANT BADGER: 08/01/2013 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: 04/01/2005 I've been in my current job for nearly a year now, and I've been strongly advocating a move to the FLiP methodology for most of that time. Responses to the idea have varied from strong support amongst the developers and project managers, to more cautious support from the business owners who aren't sure about buy-in from clients, to "cautious-agreement-in-principle-but-not-yet-convinced" from INSTANT BADGER: "CANNOT REDECLARE EXCHANGE" ERROR ON AMQP Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: COMMENT SPAM EXTORTION RACKET? This comment on Trampoline Systems' blog made me smile - hello , my name is Richard and I know you get a lot of spammy comments , I can help you with this problem . I know a lot of spammers and I will ask them not to post on your site.INSTANT BADGER
Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: HOW TO CREATE AND SAVE AN AMI IMAGE FROM AAUTHOR:ALISTAIR DAVIDSON
One snag I encountered early on in my migration of Cragwag and Sybilline to Amazon's EC2 Cloud, was that I needed to take a snapshot of my running instance and save it as a new Amazon Machine Image (AMI). I'd created a bare-bones Debian image from a public AMI (32-bit Lenny, 5.0, not much else) and then installed a few standard software packages on it - mysql, ruby, apache, etc etc etc. INSTANT BADGER: THE PERENNIAL RSS AUTHENTICATION DILEMMA It's a common problem, one that has cropped up many times for me over the last few years. You build a secure system, locked up behind a login so that only authenticated users can access the tightly-controlled data, and everything's fine - and then you come tothe RSS feeds.
INSTANT BADGER: VERSION CONTROL WITH SUBVERSION AND Been looking at version control systems for use with our CF development. After a lot of investigation, I decided to go with Subversion (SVN) for the server, and TortoiseSVN for the client. These two nifty little tools are free (as in beer) and open source, and they're self-hosting : i.e. the source code and version control for Subversion is done with INSTANT BADGER: MYSQL "ROW SIZE TOO LARGE" WHEN SAVING Joseph D. Purcell said. A fantastic article! Thank you for writing it! Two notes worth mentioning: 1. DYNAMIC vs COMPRESSED: the key difference between the two is COMPRESSED also uses zlib compression on the data. In cases where storage space is not a constraint, using "ROW_FORMAT=COMPRESSED" will avoid the unnecessary CPU load ofcompressing data.
INSTANT BADGER: IN DEFENCE OF HUNGARIAN NOTATION I started typing a comment on Pete Bell's post Why Not Hungarian, but it got a bit too long so I've put my two-penn'orth here. Hungarian notation, for me, can be very useful, but maybe not in the form that's most commonly understood. INSTANT BADGER: SVN OVER SSH (SVN+SSH://) ON WINDOWS VIA One of the more obvious things lacking from Windows is an ssh (secure shell) client, and this has caused me no end of grief trying to check out code from Subversion repositories on servers that require ssh access - such as our own. I'd previously managed to get access by forcing my username in the URL of the repository along with a savedPuTTY session name:
INSTANT BADGER: I STILL MISS CFOUTPUT It's been about a year now since I last coded CF in anger, and what coding I've done since then has been mainly in Java and Ruby On Rails. These days, most of my coding is done in my spare time, which is a resource in increasingly short supply - so coding actually tends to be done during my random bouts of insomnia. INSTANT BADGER: REGEX TO FULLY VALIDATE RFC822 EMAIL ADDRESSES I love Perl. No, I really do - I can sit and look at the really good examples for hours, and still have no clue what they're doing. And here is a fantastic example. Mail::RFC822::Address - a module that tells you whether the given string is a valid email address or not. Most email validators only check the absolute basics - e.g. some characters followed by an at-sign, followed by some more INSTANT BADGER: 04/01/2005 I've been in my current job for nearly a year now, and I've been strongly advocating a move to the FLiP methodology for most of that time. Responses to the idea have varied from strong support amongst the developers and project managers, to more cautious support from the business owners who aren't sure about buy-in from clients, to "cautious-agreement-in-principle-but-not-yet-convinced" from INSTANT BADGER: STATSVN I'm a big fan of SVN, and I know it's in very common use throughout the development community, so I thought I'd give a shout out to an interesting project that extracts some fascinating SVN stats and draws lots of pretty pictures - StatSVN. We've now added a StatSVN task to our build scripts, and the figures it kicks out are just great - once you start looking, you can lose yourself in there INSTANT BADGER: RAKE GOTCHA ON WINDOWS Anonymous said An easier way to do this is to go to c:\ruby\bin and copy one of the bat files (I copied gem.bat), edit the file to say 'rake' instead of 'gem' and then you need to copy the rake.rb file (c:\ruby\bin\rake.rb) to be instead just rake (c:\ruby\bin\rake) and then you don't have to modify any of your code anyway since now 'rake' at the command line will work. INSTANT BADGER: VERSION CONTROL WITH SUBVERSION AND Been looking at version control systems for use with our CF development. After a lot of investigation, I decided to go with Subversion (SVN) for the server, and TortoiseSVN for the client. These two nifty little tools are free (as in beer) and open source, and they're self-hosting : i.e. the source code and version control for Subversion is done with INSTANT BADGER: 08/01/2009 Over the weekend I was having a fiddle around with the layout on Cragwag, as the existing design was a bit, shall we say, emergent.I'd being trying to avoid a LHS column, because everything always seems to end up with one, but in the end I had to give up and just go with it. INSTANT BADGER: 11/01/2012 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: "YOU LOOK A LOT COOLER ON THE WEBSITE...." Last night's London CFUG had a good detailed introduction to Model-Glue and Reactor from Mark Drew, and a good-as-ever beer session in the pub afterwards.I'm intrigued by Model-Glue, and I'm tempted to give it a go on a medium-size project that I'm prototyping at themoment.
INSTANT BADGER: 08/01/2013 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: 04/01/2005 I've been in my current job for nearly a year now, and I've been strongly advocating a move to the FLiP methodology for most of that time. Responses to the idea have varied from strong support amongst the developers and project managers, to more cautious support from the business owners who aren't sure about buy-in from clients, to "cautious-agreement-in-principle-but-not-yet-convinced" from INSTANT BADGER: "CANNOT REDECLARE EXCHANGE" ERROR ON AMQP Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: COMMENT SPAM EXTORTION RACKET? This comment on Trampoline Systems' blog made me smile - hello , my name is Richard and I know you get a lot of spammy comments , I can help you with this problem . I know a lot of spammers and I will ask them not to post on your site.INSTANT BADGER
Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: IMPLEMENTING AGILE 2) We log a ticket for each user story. The ticket name is the "As a (type of user) I want to (feature) ", the first line of the description is the "..so that (benefit). ". After that, we can add however much more context and supporting information we need, but the title and first line always follow that format so that we can alwayssee:
INSTANT BADGER: HOW TO CREATE AND SAVE AN AMI IMAGE FROM A One snag I encountered early on in my migration of Cragwag and Sybilline to Amazon's EC2 Cloud, was that I needed to take a snapshot of my running instance and save it as a new Amazon Machine Image (AMI). I'd created a bare-bones Debian image from a public AMI (32-bit Lenny, 5.0, not much else) and then installed a few standard software packages on it - mysql, ruby, apache, etc etc etc. INSTANT BADGER: MORE CFHTTP WEIRDNESS Here's a question for you - Why would a previously solid, stable, Win2K3 box running CFMX6.1 standard suddenly start throwing ajava.lang.N
INSTANT BADGER: 05/01/2009 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: MYSQL "ROW SIZE TOO LARGE" WHEN SAVING Joseph D. Purcell said. A fantastic article! Thank you for writing it! Two notes worth mentioning: 1. DYNAMIC vs COMPRESSED: the key difference between the two is COMPRESSED also uses zlib compression on the data. In cases where storage space is not a constraint, using "ROW_FORMAT=COMPRESSED" will avoid the unnecessary CPU load ofcompressing data.
INSTANT BADGER: 08/01/2013 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: THIS SHOULD NOT BE POSSIBLE We're having a bizarre problem with MySQL 5.0.32 on Debian in a highly-concurrent environment, using the ActiveRecord JDBC adapter. We've also seen it on 5.0.51 on Ubuntu. INSTANT BADGER: FAKING A LEFT OUTER JOIN IN QUERY-OF-QUERIES Just picked up on Rip's post about Query-of-Queries tricks and thought I'd add share a trick I came up with some months ago. One of the big things missing from Queries-of-Queries, IMHO, is support for Left Outer Joins. You can join two queries together using an "old-style" implied join like so: INSTANT BADGER: 04/01/2005 I've been in my current job for nearly a year now, and I've been strongly advocating a move to the FLiP methodology for most of that time. Responses to the idea have varied from strong support amongst the developers and project managers, to more cautious support from the business owners who aren't sure about buy-in from clients, to "cautious-agreement-in-principle-but-not-yet-convinced" fromINSTANT BADGER
Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: IMPLEMENTING AGILE 2) We log a ticket for each user story. The ticket name is the "As a (type of user) I want to (feature) ", the first line of the description is the "..so that (benefit). ". After that, we can add however much more context and supporting information we need, but the title and first line always follow that format so that we can alwayssee:
INSTANT BADGER: HOW TO CREATE AND SAVE AN AMI IMAGE FROM A One snag I encountered early on in my migration of Cragwag and Sybilline to Amazon's EC2 Cloud, was that I needed to take a snapshot of my running instance and save it as a new Amazon Machine Image (AMI). I'd created a bare-bones Debian image from a public AMI (32-bit Lenny, 5.0, not much else) and then installed a few standard software packages on it - mysql, ruby, apache, etc etc etc. INSTANT BADGER: MORE CFHTTP WEIRDNESS Here's a question for you - Why would a previously solid, stable, Win2K3 box running CFMX6.1 standard suddenly start throwing ajava.lang.N
INSTANT BADGER: 05/01/2009 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: MYSQL "ROW SIZE TOO LARGE" WHEN SAVING Joseph D. Purcell said. A fantastic article! Thank you for writing it! Two notes worth mentioning: 1. DYNAMIC vs COMPRESSED: the key difference between the two is COMPRESSED also uses zlib compression on the data. In cases where storage space is not a constraint, using "ROW_FORMAT=COMPRESSED" will avoid the unnecessary CPU load ofcompressing data.
INSTANT BADGER: 08/01/2013 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: THIS SHOULD NOT BE POSSIBLE We're having a bizarre problem with MySQL 5.0.32 on Debian in a highly-concurrent environment, using the ActiveRecord JDBC adapter. We've also seen it on 5.0.51 on Ubuntu. INSTANT BADGER: MORE CFHTTP WEIRDNESS Here's a question for you - Why would a previously solid, stable, Win2K3 box running CFMX6.1 standard suddenly start throwing ajava.lang.N
INSTANT BADGER: 11/01/2012 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: 01/01/2008 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: 08/01/2013 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: 04/01/2006 Last night's London CFUG had a good detailed introduction to Model-Glue and Reactor from Mark Drew, and a good-as-ever beer session in the pub afterwards.I'm intrigued by Model-Glue, and I'm tempted to give it a go on a medium-size project that I'm prototyping at themoment.
INSTANT BADGER: TWITTER WILL SOON DIE Twitter Will Soon Die - the second Tipping Point approaches. Maybe I'm sticking my neck out, but it's inevitable - hear me out here. By now you're surely familiar with the concept of The Tipping Point as espoused by Malcolm Gladwell -. This has been adopted as a central tenet of the Web 2.0+ business model, and is surely now almost as INSTANT BADGER: THIS SHOULD NOT BE POSSIBLE We're having a bizarre problem with MySQL 5.0.32 on Debian in a highly-concurrent environment, using the ActiveRecord JDBC adapter. We've also seen it on 5.0.51 on Ubuntu. INSTANT BADGER: "FED-EX" SOCIAL ENGINEERING / ID THEFT SCAM? Alistair Davidson said. I found myself in a quandary after this - torn between on the one hand, telling people so that they stop and think for a second if they're caught bleary-eyed at 7am, but on the other hand - really REALLY wanting to avoidn sending one of INSTANT BADGER: 12/01/2006 Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
INSTANT BADGER: MYSQL IDLE CONNECTIONS STILL HOLDING LOCKS MySQL idle connections still holding locks. We had an interesting problem today. We were seeing very slow single-row updates (>30s) on our (innodb) scheduled_jobs table, and a large number of the update queries were failing with a LOCK WAIT TIMEOUT. The updates were using the primary key, so they should be pretty fast - but they weren't.INSTANT BADGER
Rants, raves and random thoughts on Ruby, Rails and Rabbit, plus Java, CFMX, methodologies, and development in general. And too muchalliteration.
MONDAY, AUGUST 05, 2013 UNO ILLEGALARGUMENT DURING IMPORT PHASE: SOURCE FILE CANNOT BE READ. URL SEEMS TO BE AN UNSUPPORTED ONE. Creating Word documents in a fully linux-based environment can be tricky. There is a trick you can do which is basically saving html with a .doc extension, which allows Word to open the resulting document, but it has some drawbacks - if you try to make any changes and save it again, you can't save it as a .doc, etc etc. So we have a multi-step chain of services set up on our Quill Platform to allow us to render our articles as genuine Word documents.In the Rails app:
* User clicks 'download as word doc' on an article - this results in a request like this: GET /articles/1234.doc * Check for an existing word doc representing the correct version of the requested article. If it's there, serve it back as a document. Ifnot....
* Render as a string, and save a WordDocumentConversion object which encapsulates the resulting HTML * Submit a job to Resque to perform the actual conversion. * Redirect the user, and flash a message saying "That document might take a minute or two to generate - we'll email it to you when it'sready"
In the Resque job:
* Load the WordDocumentConversion * POST the saved HTML as a file input to our DocumentConverter web service - a little Sinatra app which provides a RESTful endpointaround LibreOffice
* Save the response as a file named .doc, in binary mode, and emailit to the user.
In the DocumentConverter web service: * accept the POST-ed HTML content * invoke UNOCONV - a command line python script that wraps the LibreOffice / OpenOffice headless document conversion service. * respond with the binary content of the returned Word doc. It all works pretty well, most of the time, and was a good exercise in building complexity through keeping each individual part very simple. However, we recently moved our live platform servers from the US-EAST EC2 region over to the EU-WEST region, and took the opportunity to rebuild them from scratch on updated Ubuntu, and while setting up our staging server we got the above error ( 'UNO IllegalArgument during import phase: Source file cannot be read. URL seems to be an unsupported one.' ) which had us scratching our headsfor most of Friday.
To cut a long story short, this is another instance of what we refer as "Tao errors" - the error which can be seen is not the true error. When it says that the URL is unsupported, what it actually means is "I can't handle the file format you've requested" - usually because there are some LibreOffice OpenOffice packages missing. If you've only installed the base & core packages, that's not enough - to be able to render Word documents, you need to actually install the "writer" package as well. A quick scan of the unoconv documentation does give you this little tidbit - > Various sub-packages are needed for specific import or export > filters, e.g. XML-based filters require the xsltfilter subpackage, > e.g. libobasis3.5-xsltfilter.>
> Important > Neglecting these requirements will cause unoconv to fail with > UNHELPFUL AND CONFUSING ERROR MESSAGES. - so I guess we were warned... but still, problem solved at last. Posted by Alistair Davidsonat 2:21 pm
40 comments:
FRIDAY, JANUARY 04, 2013 MYSQL "ROW SIZE TOO LARGE" WHEN SAVING MANY TEXT FIELDS Using MySQL? InnoDB table type? Got a table with several TEXT or BLOB fields? Getting a "Row size too large" error when saving a row with lots of text in those TEXT fields? Confused, because you thought the whole point of TEXT fields was that they stored the text off-table?Well, read on....
_disclaimer: if you're storing many text fields in a relational database table, you might want to look again at whether that's the right place and method for storing that data - if it looks like a document and quacks like a document, then hey, maybe a document store would be more appropriate? But that's a whole other topic..._ The detail is in the MySQL docs 14.4.5. How InnoDB Stores Variable-Length Columns, but
I'll give a quick summary here. It hinges on the _file format _of yourInnoDB engine.
As the docs say:
> Early versions of InnoDB used an unnamed file format (now called > Antelope) for database files. With that format, tables were defined > with ROW_FORMAT=COMPACT (or ROW_FORMAT=REDUNDANT) and INNODB STORED > UP TO THE FIRST 768 BYTES OF VARIABLE-LENGTH COLUMNS (SUCH AS BLOB > AND VARCHAR) IN THE INDEX RECORD within the B-tree node, with the > remainder stored on the overflow pages._(emphasis mine)_
_
_ So with the Antelope file format, it's perfectly possible to store a single TEXT field up to 2GB without encountering the "Row size too large" error, but it's _not _possible to store 10 x 1k TEXT fields - because InnoDB will store the first 768 bytes of each TEXT field on the record itself, and exceed the row size limit of 8192 bytes. The solution is straightforward (well, mostly :) - change your innodb_file_format variable to Barracuda,
and alter the table to use the DYNAMIC or COMPRESSED row_format. This will store the entire contents of the TEXT fields "off-page" - SET GLOBAL innodb_file_format=Barracuda; SET GLOBAL innodb_file_per_table=ON; ALTER TABLE (your table) ROW_FORMAT=COMPRESSED; - and you're good to go. The one complication is if you're running on Amazon RDS, in which case you'll get an error saying you don't have SUPER privileges. If that's the case, you just need to set the innodb_file_format parameter in your RDS instance parameter group, and allow a few seconds for it to propagate to all your instances._
_
Posted by Alistair Davidsonat 11:24 am
31 comments:
Labels: amazon
, aws
, database
, innodb
,
innodb_file_format
,
mysql , rds
Older Posts
Home
Subscribe to: Posts (Atom)SEARCH THIS BLOG
ABOUT ME
* Alistair Davidson
London, United
Kingdom
I'm apdavidson, and I'm at gmail.com View my complete profileBLOG ARCHIVE
* ▼ 2013 (2)
* ▼ August (1)
* UNO IllegalArgument during import phase: Source fi... * ► January (1)* ► 2012 (7)
* ► November (1) * ► September (2)* ► May (1)
* ► February (1) * ► January (2)* ► 2011 (4)
* ► November (1) * ► September (1)* ► May (1)
* ► February (1)* ► 2010 (2)
* ► July (1)
* ► June (1)
* ► 2009 (18)
* ► December (1) * ► October (4) * ► September (2)* ► August (3)
* ► July (1)
* ► May (3)
* ► April (1)
* ► March (1)
* ► January (2)* ► 2008 (9)
* ► October (1)* ► August (1)
* ► June (1)
* ► April (1)
* ► February (1) * ► January (4)* ► 2007 (35)
* ► December (2) * ► November (1) * ► October (4) * ► September (2)* ► August (3)
* ► July (1)
* ► June (5)
* ► May (3)
* ► March (5)
* ► February (7) * ► January (2)* ► 2006 (76)
* ► December (4) * ► November (3) * ► October (7) * ► September (5) * ► August (11)* ► July (7)
* ► June (4)
* ► May (5)
* ► April (7)
* ► March (12)
* ► February (6) * ► January (5)* ► 2005 (21)
* ► December (2) * ► November (3) * ► October (4) * ► September (2)* ► August (3)
* ► July (2)
* ► June (1)
* ► May (3)
* ► April (1)
* ► 2004 (7)
* ► September (1)* ► August (1)
* ► July (3)
* ► June (1)
* ► April (1)
OTHER LINKS
* iTrigga.com - Content As A Service * Dynamove (climbing blog)POPULAR POSTS
*
How to create and save an AMI image from a running instance*
Svn over ssh (svn+ssh://) on Windows via cygwin and PuTTy*
MySQL "Row size too large" when saving many text fields*
Faking a Left Outer Join in Query-of-Queries*
Memcached Cache Invalidation Made Easy RANDOM PHOTOS FROM MY FLICKRwww.FLICKR.com
More of
Dr Snooks' photos
TWITTER WIDGET
Watermark theme. Powered by Blogger .Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0