the last message was not clear.
So, I made sql syntax error and run the program, with my old syntax, and
exception was caught, so the error should be somewhere else.
On Wed, Apr 16, 2014 at 10:45 AM, Nemanja Savic <vlasi...@gmail.com> wrote:
> 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ć
>
--
Nemanja Savić
_______________________________________________
Discuss-gnuradio mailing list
Discuss-gnuradio@gnu.org
https://lists.gnu.org/mailman/listinfo/discuss-gnuradio
