Re: uh... segfault. mod_perl, Apache::DBI and other atrocities.

[chromatic]

You don't need to re-use modules and pragmas, though I doubt that's causing your troubles. I'd remove them from within your subroutines anyway, because they're not doing anything for you. (Move 'use DBI' to the start of the program, or say require DBI instead.)

I saw segfaults with mod_perl due to the interaction of XML::Parser and the trimmed-down Expat shipped with Apache. I had to rebuild Apache and disable Expat linkings (with 1.3.20, it's something like --disable-rule=EXPAT) to fix it, but it worked correctly after that.

I'd suggest revising your code, testing again, testing with a very very simple "Hello, World!" mod_perl program, and then trying the recompile. Unless someone comes up with a better suggestion, that is.

[vaevictus]

I'll try rebuilding without Expat... And ... 1. I removed all the extra uses and moved use dbi (it was like that cause i copied out of a package... and of course it still produces the same segfaults...

[blakem]

Although recompiling apache is a somewhat involved solution (depending on how it got compiled in the first place) I would second the recommendation. I also have run into segfault issues with XML::Parser and the built in apache expat.