{"id":1104,"date":"2013-09-10T21:37:35","date_gmt":"2013-09-11T02:37:35","guid":{"rendered":"http:\/\/blografia.net\/vicm3\/?p=1104"},"modified":"2013-09-10T15:50:16","modified_gmt":"2013-09-10T20:50:16","slug":"svn-and-its-new-sqlite-format-again","status":"publish","type":"post","link":"https:\/\/blografia.net\/vicm3\/2013\/09\/svn-and-its-new-sqlite-format-again\/","title":{"rendered":"SVN and its new sqlite format again"},"content":{"rendered":"<p>I been a user of svn for a quite long time now, and had to work around certain \u00abfeatures\u00bb, like berkeley.db locking on multiuser home directories, the migration to FS logs, and problems working with multi platform environments, most of it its documented on this blog.<\/p>\n<p>Yeah, git is sexy, and fast&#8230; on linux, on windows had some issues, not that terribly bad, so why no migrate to git? Well I tested after DC12 as Jose migrated our sourceforge repository to gitorius, and also as having helped first hand with the migration of one big source on DC11, I tested beginning this year&#8230; what stopped me? well the Tortoise client for git is still lacking some features that svn had, but this was not the blocker, I wanted to had my origin on an Internet available machine, so the place for testing was DH as they host my personal blog and hobbies sites, and that was the blocker, CPU over usage on checkout&#8230; process watch killed my big clones and even small commits, yes I have voted for DH to implement better use of git and|or make it easier but with no avail, and since 2009-09-22 svn I have worked fine with DH as central repository on the net (since 2004, for this particular one.)<\/p>\n<p>I\u2019m planning on give a try again ending the semester, and had some Ideas to try that last time don&#8217;t even considered&#8230; but I would not even have think on this if not for svn migrating from their old .svn per directory to a monolithic .svn on master directory and changing to SQLITE format, in the past if you make a mistake like using one encoding or character not compatible with another OS, simply you can rename|delete .svn local directory and fix on other OS, return to the offended OS and do svn update to fix missing files with the broken names&#8230;<\/p>\n<p>Last weekend I forgot to change a pipe \u201c|\u201d on a name that committed at work (Debian) and at home (Win7) it break my windows repo, so I tried the know old solution just to find that I can\u2019t delete|rename per directory .svn anymore, <a title=\"De svn y su nuevo formato sqlite\" href=\"http:\/\/blografia.net\/vicm3\/2012\/08\/de-svn-y-su-nuevo-formato-sqlite\/\">to be fair I have this same problem last year but this time where more complex<\/a>&#8230; as I attempted svn cleanup and got stuck on update | cleanup one needing the other, and if I have checked <a title=\"De svn y su nuevo formato sqlite\" href=\"http:\/\/blografia.net\/vicm3\/2012\/08\/de-svn-y-su-nuevo-formato-sqlite\/\">my old entry about svn and sqlite here on august 2012<\/a> have noted that I need sqlite, faster&#8230; and that this time was equally complex&#8230;<\/p>\n<p>I tried deleting the locks from wc.db with DELETE from LOCKS; and no luck, as the affected repo still tried to add the files with the offending names, after reading some other responses to similar problems [1],[2].[3] I became aware that the WORK_QUEUE table holds what is pending and having a backup of the same file go ahead with DELETE from WORK_QUEUE; then things go faster, of course the repo needed a svn cleanup, and after what looked like long time a svn update that got me working again&#8230;<\/p>\n<p>BTW if you need a &#8216;gratis&#8217;|FREE as in beer visual GUI for sqlite I found sqlitespy [4] that is easier in some ways than doing the command line work from last year, at least in Windows&#8230;.<\/p>\n<p>[1] <a href=\"http:\/\/subversion.tigris.org\/ds\/viewMessage.do?dsForumId=463&amp;dsMessageId=2908955\">http:\/\/subversion.tigris.org\/ds\/viewMessage.do?dsForumId=463&amp;dsMessageId=2908955<\/a><br \/>\n[2] <a href=\"http:\/\/superuser.com\/questions\/550706\/cleanup-fails-after-failed-merge-svn-1-7-x\/550707\">http:\/\/superuser.com\/questions\/550706\/cleanup-fails-after-failed-merge-svn-1-7-x\/550707<\/a><br \/>\n[3] <a href=\"http:\/\/stackoverflow.com\/questions\/127932\/working-copy-xxx-locked-and-cleanup-failed-in-svn\">http:\/\/stackoverflow.com\/questions\/127932\/working-copy-xxx-locked-and-cleanup-failed-in-svn<\/a><br \/>\n[4] <a href=\"http:\/\/www.yunqa.de\/delphi\/doku.php\/products\/sqlitespy\/index\">http:\/\/www.yunqa.de\/delphi\/doku.php\/products\/sqlitespy\/index<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I been a user of svn for a quite long time now, and had to work around certain \u00abfeatures\u00bb, like berkeley.db locking on multiuser home directories, the migration to FS logs, and problems working with multi platform environments, most of &hellip; <a href=\"https:\/\/blografia.net\/vicm3\/2013\/09\/svn-and-its-new-sqlite-format-again\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5,9,10,8,7],"tags":[152,150,100,154,153,151,149,155],"class_list":["post-1104","post","type-post","status-publish","format-standard","hentry","category-debraye","category-educacion","category-planetalinux","category-sysadmin","category-web","tag-error","tag-git","tag-linux","tag-names","tag-pipe","tag-svn","tag-tortoise","tag-update"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1537,"url":"https:\/\/blografia.net\/vicm3\/2016\/01\/bits-of-code-php-and-self-signed-cert-on-moodle\/","url_meta":{"origin":1104,"position":0},"title":"Bits of code, php and self signed cert on Moodle","author":"vicm3","date":"22 enero, 2016","format":false,"excerpt":"And a hack, if you happen to have a Moodle 2.6.x with phpmailer old library and you had php5.6.x you may find if you use ssl\/tls to send mail that now php is strictier with self signed certificates, well there are good documentation on php.net about [1] and [2] but\u2026","rel":"","context":"En \u00abEducaci\u00f3n\u00bb","block_context":{"text":"Educaci\u00f3n","link":"https:\/\/blografia.net\/vicm3\/category\/educacion\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":33,"url":"https:\/\/blografia.net\/vicm3\/2004\/11\/svn\/","url_meta":{"origin":1104,"position":1},"title":"svn","author":"vicm3","date":"11 noviembre, 2004","format":false,"excerpt":"Bien en algun momento tuve que implementar subversion, es probable que en la version que alguien este instalando en este momento ya no haya ningun problema (de hecho en la ultima que tengo noticia, se puede elegir entre usar Berkeley DB y otro metodo para evitar problemas, pero si alguien\u2026","rel":"","context":"En \u00abGeneral\u00bb","block_context":{"text":"General","link":"https:\/\/blografia.net\/vicm3\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1316,"url":"https:\/\/blografia.net\/vicm3\/2014\/05\/about-documentation\/","url_meta":{"origin":1104,"position":2},"title":"About documentation","author":"vicm3","date":"23 mayo, 2014","format":false,"excerpt":"Yesterday as I attended to a talk on OpenMooc\u00a0at CUAED, on the part of the documentation about it, was mentioned that it's somewhat outdated and some parts are plain missing as they are a small working group (only four), it came to my mind this nice quote\u00a0\"Documentation is like sex:\u2026","rel":"","context":"En \u00abGeneral\u00bb","block_context":{"text":"General","link":"https:\/\/blografia.net\/vicm3\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1824,"url":"https:\/\/blografia.net\/vicm3\/2017\/12\/visualizacion-de-trabajo-distribuido\/","url_meta":{"origin":1104,"position":3},"title":"Visualizaci\u00f3n de trabajo distribuido","author":"vicm3","date":"5 diciembre, 2017","format":false,"excerpt":"Hace mucho tiempo vi una visualizaci\u00f3n de como se desarrolla Moodle [0], lo cual es muy interesante, de hecho me pareci\u00f3 tan interesante que le dedique un rato a eso y cree un par de visualizaciones de proyectos en los que estaba trabajando o a los que tenia acceso con\u2026","rel":"","context":"En \u00abGeneral\u00bb","block_context":{"text":"General","link":"https:\/\/blografia.net\/vicm3\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/kwA-yfVXnuk\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1407,"url":"https:\/\/blografia.net\/vicm3\/2014\/12\/two-things-are-infinite-the-universe-and-human-stupidity\/","url_meta":{"origin":1104,"position":4},"title":"Two things are infinite: the universe and human stupidity","author":"vicm3","date":"10 diciembre, 2014","format":false,"excerpt":"I think that reality is better than fiction, so take this as a fiction story... well short of... The full quote that gives nave to this post it's \"Two things are infinite: the universe and human stupidity; and I'm not sure about the universe.\" Albert Einstein. Monday lost five hours\u2026","rel":"","context":"En \u00abDebraye\u00bb","block_context":{"text":"Debraye","link":"https:\/\/blografia.net\/vicm3\/category\/debraye\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1691,"url":"https:\/\/blografia.net\/vicm3\/2016\/11\/automagic-moodle-update\/","url_meta":{"origin":1104,"position":5},"title":"Automagic Moodle update","author":"vicm3","date":"14 noviembre, 2016","format":false,"excerpt":"Well its monday so semi auto magic roll of patches on CentOS via yum-cron on Debian broken for some dumb and strong firewall rules but applied via unattended updates now done through a ssh tunnel using tsocks, been thinking on create a permanent tunnel or one based on apt.conf and\u2026","rel":"","context":"En \u00abDebraye\u00bb","block_context":{"text":"Debraye","link":"https:\/\/blografia.net\/vicm3\/category\/debraye\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/posts\/1104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/comments?post=1104"}],"version-history":[{"count":0,"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/posts\/1104\/revisions"}],"wp:attachment":[{"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/media?parent=1104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/categories?post=1104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blografia.net\/vicm3\/wp-json\/wp\/v2\/tags?post=1104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}