Bug #114903 for Spreadsheet-Read: segmentation fault when reading an xlsx-file

Tue May 31 08:53:25 2016 stefan.ziegler [...] gfk.com - Ticket created

Subject:	segmentation fault when reading an xlsx-file
Date:	Tue, 31 May 2016 12:52:49 +0000
To:	"bug-Spreadsheet-Read [...] rt.cpan.org" <bug-Spreadsheet-Read [...] rt.cpan.org>
From:	"Ziegler, Stefan (GfK)" <stefan.ziegler [...] gfk.com>

Hi HMBRAND, unfortunately I get an error "segmentation fault" when reading an xlsx-sheet. If I delete two sheets in the file, it works. In another step I have delete the other sheets, it also works!?! Attached you will find the xlsx, which doesn't work (File Early Ad Haircare_error) and the other files working (*works*). Would you be so kind and take a look at these files and maybe you will find a solution. I am not sure, if this is a problem in the Spreadsheet::Read module or in another module (a list of the installed modules is also attached - maybe it is useful). The server is: Oracle Linux Server release 5.8 / perl-version: This is perl, v5.8.8 built for i386-linux-thread-multi Thanks a lot in advance Stefan -- Stefan Ziegler Specialist Data Management | Operations | CE GfK | Nordwestring 101 | 90419 Nuremberg | Germany stefan.ziegler@gfk.com www.gfk.com Show quoted text

________________________________ GfK SE, Nuremberg, Germany, commercial register at the local court Amtsgericht Nuremberg HRB 25014; Management Board: Matthias Hartmann (CEO), Christian Diedrich (CFO), Dr. Gerhard Hausruckinger, David Krajicek, Alessandra Cama; Chairman of the Supervisory Board: Dr. Arno Mahlert This email and any attachments may contain confidential or privileged information. Please note that unauthorized copying, disclosure or distribution of the material in this email is not permitted.

Download early_BHT.zip
application/x-zip-compressed 801.7k

Message body not shown because it is not plain text.

Message body is not shown because sender requested not to inline it.

Fri Jun 03 09:09:50 2016 HMBRAND [...] cpan.org - Correspondence added

I will most likely have to mark this as invalid. I can open these files without problems using Spreadsheet::ParseXLSX-0.23 $ perl -MDP -MSpreadsheet::Read -wE'DDumper (ReadData ("rt114903-fail.xlsx", attr => 1)->[0])' { error => undef, parser => 'Spreadsheet::ParseXLSX', sheet => { 'Delivery Schedule' => 17, Index => 1, 'Norms DE' => 11, 'Norms ES' => 12, 'Norms F' => 13, 'Norms PL' => 14, 'Norms RU' => 15, 'Norms TR' => 16, 'Norms UK' => 10, 'col UK' => 4, 'hairf DE' => 6, 'hairf ES' => 5, 'hairf FR' => 8, 'hairf UK' => 2, 'hairm DE' => 7, 'hairm FR' => 9, 'hairm UK' => 3 }, sheets => 17, type => 'xlsx', version => '0.23' } You did not declare which parser you use in the background. You can see that using $ perl -MDP -MSpreadsheet::Read=parses -wE'say parses ("xlsx")' Spreadsheet::ParseXLSX As Spreadsheet::Read does *NOT* parse the files itself, not being able to open a spreadsheet file is in 98% of the case to blame on the parser being used.

Fri Jun 03 09:09:50 2016 The RT System itself - Status changed from 'new' to 'open'

Fri Jun 03 09:27:21 2016 stefan.ziegler [...] gfk.com - Correspondence added

Subject:	AW: [rt.cpan.org #114903] segmentation fault when reading an xlsx-file
Date:	Fri, 3 Jun 2016 13:27:02 +0000
To:	"bug-Spreadsheet-Read [...] rt.cpan.org" <bug-Spreadsheet-Read [...] rt.cpan.org>
From:	"Ziegler, Stefan (GfK)" <stefan.ziegler [...] gfk.com>

Hi, you are right - sorry for the confusion - the issue belongs to the parser. Please close and reject the query! Kind regards Stefan Show quoted text

-----Ursprüngliche Nachricht----- Von: H.Merijn Brand via RT [mailto:bug-Spreadsheet-Read@rt.cpan.org] Gesendet: Freitag, 3. Juni 2016 15:10 An: Ziegler, Stefan (GfK) Betreff: [rt.cpan.org #114903] segmentation fault when reading an xlsx-file <URL: https://rt.cpan.org/Ticket/Display.html?id=114903 > I will most likely have to mark this as invalid. I can open these files without problems using Spreadsheet::ParseXLSX-0.23 $ perl -MDP -MSpreadsheet::Read -wE'DDumper (ReadData ("rt114903-fail.xlsx", attr => 1)->[0])' { error => undef, parser => 'Spreadsheet::ParseXLSX', sheet => { 'Delivery Schedule' => 17, Index => 1, 'Norms DE' => 11, 'Norms ES' => 12, 'Norms F' => 13, 'Norms PL' => 14, 'Norms RU' => 15, 'Norms TR' => 16, 'Norms UK' => 10, 'col UK' => 4, 'hairf DE' => 6, 'hairf ES' => 5, 'hairf FR' => 8, 'hairf UK' => 2, 'hairm DE' => 7, 'hairm FR' => 9, 'hairm UK' => 3 }, sheets => 17, type => 'xlsx', version => '0.23' } You did not declare which parser you use in the background. You can see that using $ perl -MDP -MSpreadsheet::Read=parses -wE'say parses ("xlsx")' Spreadsheet::ParseXLSX As Spreadsheet::Read does *NOT* parse the files itself, not being able to open a spreadsheet file is in 98% of the case to blame on the parser being used.

________________________________ GfK SE, Nuremberg, Germany, commercial register at the local court Amtsgericht Nuremberg HRB 25014; Management Board: Matthias Hartmann (CEO), Christian Diedrich (CFO), Dr. Gerhard Hausruckinger, David Krajicek, Alessandra Cama; Chairman of the Supervisory Board: Dr. Arno Mahlert This email and any attachments may contain confidential or privileged information. Please note that unauthorized copying, disclosure or distribution of the material in this email is not permitted.

Fri Jun 03 10:08:48 2016 HMBRAND [...] cpan.org - Status changed from 'open' to 'rejected'

Sat Jun 11 05:47:41 2016 SREZIC [...] cpan.org - Correspondence added

Stefan, can you provide a link to the other issue? (either using RT fields, or just by adding another comment) On 2016-06-03 09:27:21, stefan.ziegler@gfk.com wrote: Show quoted text

> Hi, > > you are right - sorry for the confusion - the issue belongs to the > parser. > > Please close and reject the query! > > Kind regards > Stefan > > > -----Ursprüngliche Nachricht----- > Von: H.Merijn Brand via RT [mailto:bug-Spreadsheet-Read@rt.cpan.org] > Gesendet: Freitag, 3. Juni 2016 15:10 > An: Ziegler, Stefan (GfK) > Betreff: [rt.cpan.org #114903] segmentation fault when reading an > xlsx-file > > <URL: https://rt.cpan.org/Ticket/Display.html?id=114903 > > > I will most likely have to mark this as invalid. > > I can open these files without problems using Spreadsheet::ParseXLSX- > 0.23 > > $ perl -MDP -MSpreadsheet::Read -wE'DDumper (ReadData ("rt114903- > fail.xlsx", attr => 1)->[0])' > { error => undef, > parser => 'Spreadsheet::ParseXLSX', > sheet => { > 'Delivery Schedule' => 17, > Index => 1, > 'Norms DE' => 11, > 'Norms ES' => 12, > 'Norms F' => 13, > 'Norms PL' => 14, > 'Norms RU' => 15, > 'Norms TR' => 16, > 'Norms UK' => 10, > 'col UK' => 4, > 'hairf DE' => 6, > 'hairf ES' => 5, > 'hairf FR' => 8, > 'hairf UK' => 2, > 'hairm DE' => 7, > 'hairm FR' => 9, > 'hairm UK' => 3 > }, > sheets => 17, > type => 'xlsx', > version => '0.23' > } > > You did not declare which parser you use in the background. You can > see that using > > $ perl -MDP -MSpreadsheet::Read=parses -wE'say parses ("xlsx")' > Spreadsheet::ParseXLSX > > As Spreadsheet::Read does *NOT* parse the files itself, not being able > to open a spreadsheet file is in 98% of the case to blame on the > parser being used. > > ________________________________ > > > GfK SE, Nuremberg, Germany, commercial register at the local court > Amtsgericht Nuremberg HRB 25014; Management > Board: Matthias Hartmann (CEO), Christian Diedrich (CFO), Dr. Gerhard > Hausruckinger, David Krajicek, Alessandra Cama; Chairman of the > Supervisory Board: Dr. Arno Mahlert > This email and any attachments may contain confidential or privileged > information. Please note that unauthorized copying, > disclosure or distribution of the material in this email is not > permitted.

Thu Jul 14 07:39:29 2016 stefan.ziegler [...] gfk.com - Correspondence added

Subject:	AW: [rt.cpan.org #114903] segmentation fault when reading an xlsx-file
Date:	Thu, 14 Jul 2016 11:39:15 +0000
To:	"bug-Spreadsheet-Read [...] rt.cpan.org" <bug-Spreadsheet-Read [...] rt.cpan.org>
From:	"Ziegler, Stefan (GfK)" <stefan.ziegler [...] gfk.com>

Hi Slaven, sorry for the late response! I haven't made a new request - because I found a solution in another forum: https://github.com/doy/spreadsheet-parsexlsx/issues/20 You have only to add the following two lines at the beginning of your script (if you use a perl version below 5.15.5): use XML::Twig; XML::Twig::_set_weakrefs(0); Kind regards Stefan -- Stefan Ziegler Specialist Data Management GfK T +49 911 395 3033 Show quoted text

-----Ursprüngliche Nachricht----- Von: Slaven_Rezic via RT [mailto:bug-Spreadsheet-Read@rt.cpan.org] Gesendet: Samstag, 11. Juni 2016 11:48 An: Ziegler, Stefan (GfK) Betreff: [rt.cpan.org #114903] segmentation fault when reading an xlsx-file <URL: https://rt.cpan.org/Ticket/Display.html?id=114903 > Stefan, can you provide a link to the other issue? (either using RT fields, or just by adding another comment) On 2016-06-03 09:27:21, stefan.ziegler@gfk.com wrote:

> Hi, > > you are right - sorry for the confusion - the issue belongs to the > parser. > > Please close and reject the query! > > Kind regards > Stefan > > > -----Ursprüngliche Nachricht----- > Von: H.Merijn Brand via RT [mailto:bug-Spreadsheet-Read@rt.cpan.org] > Gesendet: Freitag, 3. Juni 2016 15:10 > An: Ziegler, Stefan (GfK) > Betreff: [rt.cpan.org #114903] segmentation fault when reading an > xlsx-file > > <URL: https://rt.cpan.org/Ticket/Display.html?id=114903 > > > I will most likely have to mark this as invalid. > > I can open these files without problems using Spreadsheet::ParseXLSX- > 0.23 > > $ perl -MDP -MSpreadsheet::Read -wE'DDumper (ReadData ("rt114903- > fail.xlsx", attr => 1)->[0])' > { error => undef, > parser => 'Spreadsheet::ParseXLSX', > sheet => { > 'Delivery Schedule' => 17, > Index => 1, > 'Norms DE' => 11, > 'Norms ES' => 12, > 'Norms F' => 13, > 'Norms PL' => 14, > 'Norms RU' => 15, > 'Norms TR' => 16, > 'Norms UK' => 10, > 'col UK' => 4, > 'hairf DE' => 6, > 'hairf ES' => 5, > 'hairf FR' => 8, > 'hairf UK' => 2, > 'hairm DE' => 7, > 'hairm FR' => 9, > 'hairm UK' => 3 > }, > sheets => 17, > type => 'xlsx', > version => '0.23' > } > > You did not declare which parser you use in the background. You can > see that using > > $ perl -MDP -MSpreadsheet::Read=parses -wE'say parses ("xlsx")' > Spreadsheet::ParseXLSX > > As Spreadsheet::Read does *NOT* parse the files itself, not being able > to open a spreadsheet file is in 98% of the case to blame on the > parser being used. > > ________________________________ > > > GfK SE, Nuremberg, Germany, commercial register at the local court > Amtsgericht Nuremberg HRB 25014; Management > Board: Matthias Hartmann (CEO), Christian Diedrich (CFO), Dr. Gerhard > Hausruckinger, David Krajicek, Alessandra Cama; Chairman of the > Supervisory Board: Dr. Arno Mahlert This email and any attachments may > contain confidential or privileged information. Please note that > unauthorized copying, disclosure or distribution of the material in > this email is not permitted.

________________________________ GfK SE, Nuremberg, Germany, commercial register at the local court Amtsgericht Nuremberg HRB 25014; Management Board: Matthias Hartmann (CEO), Christian Diedrich (CFO), Dr. Gerhard Hausruckinger, David Krajicek, Alessandra Cama; Chairman of the Supervisory Board: Dr. Arno Mahlert This email and any attachments may contain confidential or privileged information. Please note that unauthorized copying, disclosure or distribution of the material in this email is not permitted.