{"id":18,"date":"2005-12-15T09:07:00","date_gmt":"2005-12-15T09:07:00","guid":{"rendered":"http:\/\/10.168.29.5\/blog\/?p=18"},"modified":"2010-02-15T08:35:10","modified_gmt":"2010-02-15T08:35:10","slug":"del-icio-us-down","status":"publish","type":"post","link":"https:\/\/davidsterry.com\/blog\/2005\/12\/del-icio-us-down\/","title":{"rendered":"del.icio.us down"},"content":{"rendered":"<p>Over the past day we&#8217;ve seen some weirdness over at del.icio.us. Last night I saw this error:<\/p>\n<p align=\"center\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;font-size:78%;\"><b>System error<\/b><\/span><\/p>\n<table border=\"0\" cellpadding=\"1\" cellspacing=\"0\">\n<tbody>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;font-size:78%;\"><b>error:<\/b> <\/span><\/td>\n<td align=\"left\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;font-size:78%;\">Can&#8217;t call method &#8220;prepare&#8221; on an undefined value at \/www\/del.icio.us\/comp\/user\/get line 13.<br \/><\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;font-size:78%;\"><b>context:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;font-size:78%;\">    <\/p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n<tbody>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>&#8230;<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>9:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\">my $usedb = &#8216;master&#8217;;<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>10:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\">my $ret;<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>11:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>12:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\">if (!$auth_user) { $usedb = &#8216;user&#8217; }<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>13:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><span style=\"color:red;\">if (!exists ($db->{$usedb})) { $usedb = &#8216;master&#8217; }<\/span><\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>14:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\">$user_name_q->{$usedb} = $db->{$usedb}->prepare(&#8216;select * from users where user_name = ?&#8217;);<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>15:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\">my $query = $user_name_q->{$usedb};<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>16:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\">$query->execute(lc($user_name));<\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>17:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;\"><b>&#8230;<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>   <\/span><\/td>\n<\/tr>\n<tr>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;font-size:78%;\"><b>code stack:<\/b> <\/span><\/td>\n<td align=\"left\" nowrap=\"nowrap\" valign=\"top\"><span style=\"font-family:Verdana,Arial,Helvetica,sans-serif;font-size:78%;\">  \/www\/del.icio.us\/comp\/user\/get:13<br \/>\/www\/del.icio.us\/site\/dhandler:194<br \/>\/www\/del.icio.us\/site\/autohandler:110<br \/> <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>   <span style=\"font-size:78%;\"><a href=\"http:\/\/del.icio.us\/dsterry#raw\">raw error<\/a><br \/><\/span><\/p>\n<p>Then on clicking raw error it showed this stuff here:<br \/><a name=\"raw\"><\/a>  <\/p>\n<pre><br \/><span style=\"font-size:85%;\">Can't call method \"prepare\" on an undefined value at \/www\/del.icio.us\/comp\/user\/get line 13.<br \/><br \/>Trace begun at \/usr\/share\/perl5\/HTML\/Mason\/Exceptions.pm line 131<br \/>HTML::Mason::Exceptions::rethrow_exception('Can\\'t call method \"prepare\" on an undefined value at \/www\/del.icio.us\/comp\/user\/get line 13.^J') called at \/www\/del.icio.us\/comp\/user\/get line 13<br \/>HTML::Mason::Commands::__ANON__('dbh', undef, 'user_name', 'dsterry', 'auth_user', 'dsterry') called at \/usr\/share\/perl5\/HTML\/Mason\/Component.pm line 134<br \/>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1d3f4f0)', 'dbh', undef, 'user_name', 'user', 'auth_user', 'user') called at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 1069<br \/>eval {...} at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 1068<br \/>HTML::Mason::Request::comp(undef, undef, 'dbh', undef, 'user_name', 'user', 'auth_user', 'user') called at \/www\/del.icio.us\/site\/dhandler line 194<br \/>HTML::Mason::Commands::__ANON__('dbh', undef, 'auth_user', 'user', 'items', 100, 'tagview', 'cloud', 'tagsort', 'alpha', 'bundleview', 'hide', 'cookies', 'HASH(0x1b52740)', 'browser', 'ff') called at \/usr\/share\/perl5\/HTML\/Mason\/Component.pm line 134<br \/>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1b14410)', 'dbh', undef, 'auth_user', 'user', 'items', 100, 'tagview', 'cloud', 'tagsort', 'alpha', 'bundleview', 'hide', 'cookies', 'HASH(0x1b52740)', 'browser', 'ff') called at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 1074<br \/>eval {...} at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 1068<br \/>HTML::Mason::Request::comp(undef, undef, 'dbh', undef, 'auth_user', 'user', 'items', 100, 'tagview', 'cloud', 'tagsort', 'alpha', 'bundleview', 'hide', 'cookies', 'HASH(0x1b52740)', 'browser', 'ff') called at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 760<br \/>HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x1ad11c0)', 'dbh', undef, 'auth_user', 'user', 'items', 100, 'tagview', 'cloud', 'tagsort', 'alpha', 'bundleview', 'hide', 'cookies', 'HASH(0x1b52740)', 'browser', 'ff') called at \/www\/del.icio.us\/site\/autohandler line 110<br \/>HTML::Mason::Commands::__ANON__ at \/usr\/share\/perl5\/HTML\/Mason\/Component.pm line 134<br \/>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1b52bd0)') called at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 1069<br \/>eval {...} at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 1068<br \/>HTML::Mason::Request::comp(undef, undef, undef) called at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 338<br \/>eval {...} at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 338<br \/>eval {...} at \/usr\/share\/perl5\/HTML\/Mason\/Request.pm line 297<br \/>HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x1ad11c0)') called at \/usr\/share\/perl5\/HTML\/Mason\/ApacheHandler.pm line 134<br \/>eval {...} at \/usr\/share\/perl5\/HTML\/Mason\/ApacheHandler.pm line 134<br \/>HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x1ad11c0)') called at \/usr\/share\/perl5\/HTML\/Mason\/ApacheHandler.pm line 793<br \/>HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x1acc1c0)', 'Apache=SCALAR(0x1087150)') called at (eval 43) line 8<br \/>HTML::Mason::ApacheHandler::handler('\r\nHTML::Mason::ApacheHandler', 'Apache=SCALAR(0x1087150)') called at \/dev\/null line 0<br \/>eval {...} at \/dev\/null line 0<\/span><br \/><\/pre>\n<p> then Wednesday from around 4:30 pm to Thursday 1:00 am PST del.icio.us was down showing the following message:<\/p>\n<p><span style=\"font-size:85%;\"><span style=\"font-family: verdana; font-weight: bold;\"> del.icio.us is down for maintenance. we&#8217;ll be back in one hour.<\/span><\/span><\/p>\n<p>I just checked again, I saw my user page and then I saw the first error again. It kind of looks like the database is having issues. Unfortunately all this meant that Alex&#8217;s <a href=\"http:\/\/sandbox.sourcelabs.com\/livemarks\">Livemarks<\/a> and my <a href=\"#\">Trends<\/a>(retired in 2008) were both having issues today too. Hope they get all this worked out soon&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Over the past day we&#8217;ve seen some weirdness over at del.icio.us. Last night I saw this error: System error error: Can&#8217;t call method &#8220;prepare&#8221; on an undefined value at \/www\/del.icio.us\/comp\/user\/get line 13. context: &#8230; 9: my $usedb = &#8216;master&#8217;; 10: my $ret; 11: 12: if (!$auth_user) { $usedb = &#8216;user&#8217; } 13: if (!exists ($db->{$usedb})) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-trend-sweet-trend"],"_links":{"self":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/comments?post=18"}],"version-history":[{"count":2,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/posts\/18\/revisions"}],"predecessor-version":[{"id":204,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/posts\/18\/revisions\/204"}],"wp:attachment":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/media?parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/categories?post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/tags?post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}