Hello again,
Marcus, you are right, my syntax is not any more correct but there is
backwards compatibility. I initiated error on my own and everything works
fine, so I would say there should be rather something more serious.
On Tue, Apr 15, 2014 at 4:31 PM, Marcus Müller <mar...@hostalia.de> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Nemanja,
>
> Simple explanation:
> You haven't fixed your syntax for the first except clause.
> Going back to my other post, it should read
> "except mdb.Error as e:", not "except mdb.Error, e".
>
> Because you didn't do that, "e" is undefined in your except clause.
> This raises a NameError in your except clause, which doesn't get
> handled. Fix the except syntax.
>
> Also, don't do system.exit() in a multithreaded application, unless
> you really know what you're doing. You'll end up with unfinished data,
> broken database commits and so on.
>
> Greetings,
> Marcus
>
> On 15.04.2014 15:40, Nemanja Savic wrote:
> > Hi again,
> >
> > so, the exception appeared again. Just to remind:
> > thread[thread-per-block[0]: <gr_block db_logger2 (65)>]: caught
> > unrecognized exception
> >
> > I can't find what (65) means. This time complete block of code was
> > encapsulated by try and except but nothing was caught.
> >
> > Here is my code:
> >
> > def handle_msg(self, msg): try: message =
> > pmt.pmt_symbol_to_string(msg) msg_lines = message.split('\n')
> > sensor_id = msg_lines[0] vendor = msg_lines[2] sensor_type =
> > msg_lines[3] time = msg_lines[1] querry = "INSERT INTO `%s`.`%s`
> > (`id` ,`sens_id` ,`vendor`, `sensor_type`, `det_id`) VALUES (NULL ,
> > '%s', '%s', '%s','%s');" % (self._db_name, self._det_table,
> > sensor_id, vendor, sensor_type, self._id) cur = self._con.cursor()
> > cur.execute(querry) except mdb.Error, e: print "Unexpected error
> > while trying to insert into table" print 50*'-' print 50*'-' print
> > "Error %d: %s" % (e.args[0],e.args[1]) sys.exit(1)
> >
> > except: print 'msg handler exception' print 50*'-' print message
> > print msg_lines print 50*'-'
> >
> > Except this function there is also constructor and additional
> > function for setting the database up (it is called only in
> > constructor). There is no work function as this block nly receives
> > messages and writes to database. Is there any idea how can I catch
> > this?
> >
> > Thanx
> >
> >
> >
> > On Thu, Mar 20, 2014 at 4:34 PM, Marcus Müller <mar...@hostalia.de>
> > wrote:
> >
> > Hi Nemanja,
> >
> > your except syntax is wrong, most probably you wanted to use
> > "except ExceptionType as e" instead, refer to
> > http://docs.python.org/2/tutorial/errors.html
> >
> > Anyway, have you tried surrounding all your handler code with a
> > try and catch not only the database related errors?
> >
> > Greetings, Marcus
> >
> > On 20.03.2014 15:58, Nemanja Savic wrote:
> >>>> Dear gnuradioers,
> >>>>
> >>>> I would like to ask againi if somebody can help me
> >>>> understand this: thread[thread-per-block[0]: <gr_block
> >>>> db_logger2 (62)>]: caught unrecognized exception
> >>>>
> >>>> I have two blocks of db_logger type and it looks like only
> >>>> one catch this unrecognized exception and another keeps
> >>>> working fine.
> >>>>
> >>>> best and thank you
> >>>>
> >>>>
> >>>> On Mon, Mar 3, 2014 at 12:55 PM, Nemanja Savic
> >>>> <vlasi...@gmail.com> wrote:
> >>>>
> >>>>> Hi all guys,
> >>>>>
> >>>>> I have a block which is responsible to receive certain
> >>>>> messages from other blocks and to write the data from the
> >>>>> message into database. Sometimes the following exception
> >>>>> occures and the block stops writing into database:
> >>>>>
> >>>>> thread[thread-per-block[0]: <gr_block db_logger2 (62)>]:
> >>>>> caught unrecognized exception
> >>>>>
> >>>>> The structure of the block is really simple:
> >>>>>
> >>>>> def handle_msg(self, msg): message =
> >>>>> pmt.pmt_symbol_to_string(msg) msg_lines =
> >>>>> message.split('\n') try: sensor_id = msg_lines[0] vendor =
> >>>>> msg_lines[2] sensor_type = msg_lines[3] time = msg_lines[1]
> >>>>> #try: querry = "INSERT INTO `%s`.`%s` (`id` ,`sens_id`
> >>>>> ,`vendor`, `sensor_type`, `det_id`) VALUES (NULL , '%s',
> >>>>> '%s', '%s','%s');" % (self._db_name, self._det_table,
> >>>>> sensor_id, vendor, sensor_type, self._id) # print querry
> >>>>> cur = self._con.cursor() cur.execute(querry) except
> >>>>> mdb.Error, e: print "Unexpected error while trying to
> >>>>> insert into table" print msg_lines print 50*'-' print
> >>>>> "Error %d: %s" % (e.args[0],e.args[1]) sys.exit(1)
> >>>>>
> >>>>> Is there any way to track this problem and find the cause?
> >>>>>
> >>>>> Best regards,
> >>>>>
> >>>>> -- Nemanja Savić
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> Discuss-gnuradio mailing list Discuss-gnuradio@gnu.org
> >>>> https://lists.gnu.org/mailman/listinfo/discuss-gnuradio
> >>>>
> >>
> >> _______________________________________________ Discuss-gnuradio
> >> mailing list Discuss-gnuradio@gnu.org
> >> https://lists.gnu.org/mailman/listinfo/discuss-gnuradio
> >>
> >
> >
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQEcBAEBAgAGBQJTTULeAAoJEBQ6EdjyzlHtRIcH/2kpne7BIFs7hb0YyYAEGh00
> Z4oDFaekEmL5j3GSmPojmREqjVvbHCaHohgBDPQh45SleBQ/I88t8GvcNEqZa2VB
> djH9a34uDu/IY5kZTaH2yNisEJq2QNMo6BNjelQTE52u6/53vrBzxgbPgTT1u8Ci
> XxST0WUnpIyHemBGZK7cR6WAiGffimXpA3Rr5vH0c6WK2ytIM9BCvtRd9T2o+bOc
> GnXNqcV0Rny/j53i4rfbxuynI8Y+FROcASZUPo/IjZQOA/Sp2R0UkMQZGXzLUAB1
> x8Ugy1uDe+p+qgBxUVC7AE5+0s0E2R/H4EmzP9HcluiXqMhzPfHwux2ghjfXoyc=
> =5274
> -----END PGP SIGNATURE-----
>
--
Nemanja Savić
_______________________________________________
Discuss-gnuradio mailing list
Discuss-gnuradio@gnu.org
https://lists.gnu.org/mailman/listinfo/discuss-gnuradio
