[freeside-devel] Tonights oddness (page doesn't work coming from print)

[Dave Burgess]

ivan wrote:

> I'm not sure I agree with that explanation.
>
> The code isn't written such that database operations are expected to
> complete in any amount of time;  you can run the web interface on one
> machine and the database server on a separate machine.
>

It's just my impression.  When I switched the server from the network address to
the loopback address, all of the problems went away.  That was the only change; I
suppose there could have been some other coincident cause.  Of course, 127.0.0.1
exists in the /etc/hosts file, while the dbserver name didn't.  That was why I
suspected the resolver as a possible culprit.

Basically, I just wanted you to know that I a) found a way around the problem and
b) gave you a first shot answer if it comes up again.

It possible that I was also tickling a bug in the database somewhere; I just can't
say for sure.  I know it's fixed (for now) and I'm happy with the solution.

Dave

>
> On Mon, Jan 21, 2002 at 11:30:31AM -0600, Dave Burgess wrote:
> > Ivan (et al),
> >
> > I was close on my guess about the database updates.
> >
> > I was sending the server out to the network for the database update, but the
> > database server was actually on the same system.  Not using the localhost
> > connection introduced just enough delay in the database updates that it
> > caused the programs using the data to fail.  I suspect it was a problem
> > with slow DNS; I can't say for sure.  Once I switched over to the
> > localhost connector, everything went fine.
> >
> > Dave
> >
> > ivan wrote:
> >
> > > On Tue, Dec 11, 2001 at 07:46:46PM -0600, Dave Burgess wrote:
> > > >
> > > > [Tue Dec 11 19:34:13 2001] [error] [asp] [5000] [error] Can't call
> > > > method "balance" on an undefined value at
> > > > /usr/pkg/lib/perl5/site_perl/5.6.1/FS/cust_pay.pm line 103 during global
> > > > destruction. <--> , /usr/pkg/lib/perl5/site_perl/5.6.1/Apache/ASP.pm
> > > > line 1574
> > >
> > > Okay, this one is even weirder.  I can't imagine how the interpreter would
> > > wind up in cust_pay::insert during global destruction.
> > >
> > > The only way I could see the "Can't call method "balance" on an undefined
> > > value at /usr/pkg/lib/perl5/site_perl/5.6.1/FS/cust_pay.pm line 103" error
> > > being generated is if you tried to insert an FS::cust_pay object that had
> > > an invalid custnum... but I can't for the life of me figure out how you'd
> > > get there during global destruction.
> > >
> > > >
> > > > Line 103 in cust_pay.pm seems to be a call to qsearchs on the
> > > > cust_main table, but that doesn't really make any sense, since
> > > > there haven't been any updates to that table in two days.  Is it
> > > > possible that we're missing a 'commit' someplace?
> > >
> > > Hua?
> > >
> > > >  Line 307 in
> > > > cust_main.cgi is
> > >
> > > The code below is from cust_main.pm, not view/cust_main.cgi...
> > >
> > > > "foreach my $svc_something ( @{$cust_pkgs->{$cust_pkg}} ) {"
> > > >
> > > > so there seems to be something happening all of a sudden....
> > > >
> > > > One thing I didn't mention: the server returns an "Internal Server Error"
> > > > everytime this happens.
> > > >
> > > > Dave
> > >
> > > --
> > > _ivan
> >
>
> --
> _ivan