Tag Archive: workaround


Western Digital released firmware upgrade 1.04.10 yesterday (November 27th) for the Western Digital WD TV Live Network-ready HD Media Player and Western Digital WD TV Live Plus HD Media Player.  This caused the media players (little boxes that hook up to the tv) to no longer see some network media servers such as Playon from MediaMall Technologies.

There is currently no fix but we do have a workaround:  downgrade the firmware to 1.03.49.  Don’t worry it is very easy.

  1. Download the firmware from Western Digital
  2. Unzip the file to a USB thumb drive (make sure you put it in the top directory)
  3. Insert the thumb drive into the WD box
  4. Press the Home button (blue button)
  5. Upgrade the firmware (note that the version number displayed for the old firmware will show up as a larger number – this is necessary for it to downgrade the firmware)
  6. That’s it

Sybase

We’ve been upgrading a number of Sybase ASE databases from the end-of-life’d 12.5.x to v15.0.3 esd 4 the last few weeks.   My coworker (Degang He) ran into an interesting error when the upgrade process was failing on sysprocedures.

Database ‘my_db’: beginning upgrade step [ID 26]: alter table (table sysprocedures)
Command has been aborted.

Msg 3461, Level 20, State 1:
Server ‘my_server’, Line 1:
Database ‘my_db’: upgrade could not install required upgrade item ’26′. Please refer to previous error messages to determine the problem. Fix the problem, then try again.

Msg 3451, Level 20, State 1:
Server ‘my_server’, Line 1:
Database ‘my_db’: upgrade has failed for this database. Please refer to previous messages for the cause of the failure, correct the problem and try again.

Msg 3454, Level 20, State 1:
Server ‘my_server’, Line 1:

Database ‘my_db’: ASE could not completely upgrade this database; upgrade item 1501 could not be installed.

We looked on Sybase’s Solved Cases and Google but didn’t find anything that would really fit the problem.  So we called up Sybase Technical Support.  Somdev Sharma of Sybase was able to determine that this was a bug in the ASE 15x codeline and provided a workaround:

CR #643188:

Title Online database failed with 3461 error during upgrade , ‘max parallel degree’ >1

Workaround:

Before online the database, disable parallel sort via sp_configure ‘max parallel degree’,1

Sanitized:

Online database failed with 3461, 3451 and 3454 errors during upgrade sysprocedures table (upgrade  item ’26′). If ‘max parallel degree’ > 1, then please disable parallel sort with sp_configure ‘max parallel degree’, 1.

After disabling parallel sort, the database was upgraded successfully.

The following is a patch for bug 45563 in Exception::Class::TCF:

Useless localization of scalar assignment at Exception-Class-TCF/lib/Exception/Class/TCF.pm line 255.

Index: lib/Exception/Class/TCF.pm
===================================================================
— lib/Exception/Class/TCF.pm (revision 83)
+++ lib/Exception/Class/TCF.pm (working copy)
@@ -251,8 +251,11 @@
my($block,@catches) = @_;
my($exc,@args,$res);
&$pushFrame;
- $HANDLE_WARN &&
- local ( $SIG{‘__WARN__’} = sub { throw Exception::Class::TCF::Warning @_; } );
+
+ if ($HANDLE_WARN) {
+ local ( $SIG{‘__WARN__’} ) = sub { throw Exception::Class::TCF::Warning @_; };
+ }
+
$dTHROWING = 0;
$res = eval { &$block() };
$exc = $EXCEPTION;

On my media server, I wanted to set up Perl’s CPAN but when I ran install Bundle::CPAN, I ctrl-c’d out of it when I noticed that bzip2 wasn’t installed.  Silly me.  Soon after I started receiving:

Can’t call method “value” on an undefined value at /usr/share/perl5/IO/Uncompress/RawInflate.pm

Reinstalling Perl and all the related ubuntu packages doesn’t fix it, nor does removing the ~root/.cpan dir.  There is an easy workaround though.

# aptitude remove libcompress-raw-zlib-perl
Reading package lists… Done
Building dependency tree      
Reading state information… Done
Reading extended state information      
Initializing package states… Done
Building tag database… Done      
The following packages are BROKEN:
  libio-compress-zlib-perl
The following packages have been kept back:
  bind9-host dnsutils libbind9-30 libisccfg30
The following packages will be REMOVED:
  libcompress-raw-zlib-perl
0 packages upgraded, 0 newly installed, 1 to remove and 4 not upgraded.
Need to get 0B of archives. After unpacking 319kB will be freed.
The following packages have unmet dependencies:
  libio-compress-zlib-perl: Depends: libcompress-raw-zlib-perl (>= 2.008) but it is not installable
Resolving dependencies…
The following actions will resolve these dependencies:

Remove the following packages:
apparmor-utils
libcompress-zlib-perl
libio-compress-zlib-perl
libmp3-tag-perl
librpc-xml-perl
libwww-perl
libxml-parser-perl
ubuntu-standard

Score is 592

Accept this solution? [Y/n/q/?]

Make a note of the packages that it will remove, then tell it to go ahead. It will remove these packages!

Start cpan, and type in

install Bundle::CPAN

. When it is complete, reinstall the ubuntu packages that you removed earlier (for example):

# aptitude install apparmor-utils libcompress-zlib-perl libio-compress-zlib-perl libmp3-tag-perl librpc-xml-perl libwww-perl libxml-parser-perl ubuntu-standard

That’s it. Your cpan is working again :)