pilerimport

[Former user]

Any idea on what would be cause?

OS -Centos 6.5 DB - MySQL Piler - 0.1.24

Background issue - 1st import failed, i have emptied the attachment tbl and metadata tbl and try pilerimport again resulted in below.

Note: I am simply importing from a directory using pilerimport -d /path/somename. Sample email is attached.

Apr 8 19:10:33 mailarchive pilerimport[3973]: 400000005343d93307f7c1bc00ededb53881: cannot open frame file: 400000005343d93307f7c1bc00ededb53881.m Apr 8 19:10:33 mailarchive pilerimport[3973]: 400000005343d93307f7c1bc00ededb53881: cannot open: 400000005343d93307f7c1bc00ededb53881.m Apr 8 19:10:33 mailarchive pilerimport[3973]: 400000005343d93307f7c1bc00ededb53881: error storing message: 400000005343d93307f7c1bc00ededb53881.m Apr 8 19:11:57 mailarchive pilerimport[3976]: 400000005343d98716b76ff4007c94e00747: cannot open frame file: 400000005343d98716b76ff4007c94e00747.m Apr 8 19:11:57 mailarchive pilerimport[3976]: 400000005343d98716b76ff4007c94e00747: cannot open: 400000005343d98716b76ff4007c94e00747.m Apr 8 19:11:57 mailarchive pilerimport[3976]: 400000005343d98716b76ff4007c94e00747: error storing message: 400000005343d98716b76ff4007c94e00747.m Apr 8 19:12:55 mailarchive pilerimport[3979]: 400000005343d9c13ae7895400e2ce1362bc: cannot open frame file: 400000005343d9c13ae7895400e2ce1362bc.m Apr 8 19:12:55 mailarchive pilerimport[3979]: 400000005343d9c13ae7895400e2ce1362bc: cannot open: 400000005343d9c13ae7895400e2ce1362bc.m Apr 8 19:12:55 mailarchive pilerimport[3979]: 400000005343d9c13ae7895400e2ce1362bc: error storing message: 400000005343d9c13ae7895400e2ce1362bc.m

Regards Harry

[Hari Murugan]

Dear jsuto,

I have managed to resolve the issue by a clean install. However, the imported email seems to have some issue, Please refer to screenshot -

regards Harry

[Janos SUTO]

Hello Harry,

it must be a bogus search hit coming from sphinx. I recommend you to reset the sphinx database, then run "cd /tmp; reindex -a"

To reset the sphinx index data, do the following:

• stop searchd, then rm /var/piler/sphinx/*
• indexer --all (run this command as user piler)
• start searchd

[Hari Murugan]

When i run "cd /tmp; reindex -a", i am faced with "Segmentation Fault"

Regards Harry

[Janos SUTO]

I recommend you to upgrade to the current master branch (see the Downloads menu above). The segfault problem is an unfortunate issue got in 0.1.24. However it's been fixed for a while.

[Janos SUTO]

I hope the issue is solved by now. Otherwise be sure to reopen it.