in reply to error dbi

I'm going to guess the cause is that you have statement handles which you never called finish on before you tried to call disconnect on the main DBI handle. After you're done retrieving results from a handle (as returned from prepare in your sample) you should call finish to let DBI and your database know you're done so it can do whatever it needs to do (freeing up resources, closing whatever, yadda yadda yadda).

The cake is a lie.
The cake is a lie.
The cake is a lie.

Replies are listed 'Best First'.
Re^2: error dbi
by bigup401 (Pilgrim) on Oct 16, 2020 at 13:32 UTC

    ok me i never notic that, that i have to call finish even on select statment, i thought finish is called on update or delete or anything when COMMIT() is called

[reply]
Re^2: error dbi
by bigup401 (Pilgrim) on Oct 16, 2020 at 14:05 UTC

    i tried to call finish on after execute, but db can't allow fetch without excute

    i dont think you can call finish when your still fetching info

[reply]

      o.O

      • prepare your statement to get a handle
      • execute to fetch results
      • call whatever fetch routines to retrieve all the results
      • WHEN YOU ARE DONE FETCHING RESULTS call finish on the handle

      *plonk*

      Edit: Obviously from the errors in the OP he's not fetching all the results from the queries and he's not scoping his handles such that they're destroyed before the DB handle is cleaned up, so he either needs to explicitly finish when he's not going to fetch anything more or properly scope the handles so they're cleaned up automagically as documented. Given the historical behavior of the source that's unlikely.

      The cake is a lie.
      The cake is a lie.
      The cake is a lie.

[reply]
[d/l]
[select]
        DBI:

        > When all the data has been fetched from a SELECT statement, the driver will automatically call finish for you. So you should not call it explicitly except when you know that you've not fetched all the data from a statement handle and the handle won't be destroyed soon.

        map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]
[reply]
[d/l]

        thanks its working now

[reply]

In Section Seekers of Perl Wisdom