View Issue Details

IDProjectCategoryView StatusLast Update
0022234mantisbtcsvpublic2017-02-03 10:33
Reporterfman Assigned Tocproensa  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Product Version1.2.19 
Summary0022234: Exporting more than 20000 issues, downloaded CSV file has zero bytes
Description

Hi:
I've a mantis installation with 210000 records on mantis_bug_table.
I set a filter and get 20000 issues, in order to try to export on CSV first action I've done was increase memory limit.
Anyway I always get a zero byte file.
Do you have any hint/ suggestion?

best regards

TagsNo tags attached.

Relationships

related to 0020424 closedcproensa Export to CSV and Excel fails with large issue count 

Activities

dregad

dregad

2017-01-23 09:41

developer   ~0055267

I have never tried to export such large amount of data. Maybe the export script is timing out [1] ? Check your system logs.

[1] http://php.net/manual/en/info.configuration.php#ini.max-execution-time

fman

fman

2017-01-23 10:48

reporter   ~0055268

Hi
I'm going to increase max-execution-time, retest and provide feedback

fman

fman

2017-01-23 10:54

reporter   ~0055269

Hi
I've added in csv_export.php

$execseconds='60000';
set_time_limit ($execseconds);

retested and seems everything is OK, thanks a lot.

My mistake I've supposed that => helper_begin_long_process(); will do the set.

I will continue test and provide more feedback

fman

fman

2017-01-23 11:08

reporter   ~0055270

Oops I've done first test with a different filter (only 7000 bugs) with 20000 does not work.
I've added a log to write info to a file and all info seems to be there, I do not understand if issue is related to some limit in ob_start()
any hint ?

cproensa

cproensa

2017-01-23 14:51

developer   ~0055273

In old versions, CSV / Excel export is known to have linear memory growth, so with a big number of bugs, the script can end with error due to php memory limits (see 0020424)
This was fixed in v1.3.1, and then improved in later versions.
Time will always grow linearly with export size, but at least it will finish given enough time.

fman

fman

2017-01-23 15:15

reporter   ~0055274

@cproensa
Thanks a lot, I'm going to test with 2.0.0 and provide feedback.

cproensa

cproensa

2017-01-23 16:05

developer   ~0055276

Thanks @fman
I am resolving this issue as it looks like a dupicate of a previous bug, which is already fixed.
If you find new issues, with a current mantis release, report it with updated info.

fman

fman

2017-01-24 06:05

reporter   ~0055283

Hi
can confirm that issue is fixed on 2.0.0

thanks a lot