Обсуждение: BUG #8760: Large Objects
The following bug has been logged on the website: Bug reference: 8760 Logged by: Rabi Email address: rabigul@gmail.com PostgreSQL version: 9.1.0 Operating system: Ubuntu Description: HI, I'm seeing errors whilst Asterisk is trying to run Insert command and add voice messages into Postgresql DB. here are asterisk instructions to define large objects https://wiki.asterisk.org/wiki/display/AST/Storing+Voicemail+in+PostgreSQL+via+ODBC ERROR: invalid large-object descriptor: 16551 ERROR: current transaction is aborted, commands ignored until end of transaction block ERROR: current transaction is aborted, commands ignored until end of transaction block ERROR: invalid large-object descriptor: 16552 ERROR: current transaction is aborted, commands ignored until end of transaction block ERROR: current transaction is aborted, commands ignored until end of transaction block Could you please advise if this is the bug in software and needs updated patch? I have several time re run configs and did alot of troubleshooting but don't find much help. thanking you in advance. Cheers
On Thu, Jan 9, 2014 at 9:01 PM, <rabigul@gmail.com> wrote: > I'm seeing errors whilst Asterisk is trying to run Insert command and add > voice messages into Postgresql DB. > here are asterisk instructions to define large objects > > > https://wiki.asterisk.org/wiki/display/AST/Storing+Voicemail+in+PostgreSQL+via+ODBC > > > ERROR: invalid large-object descriptor: 16551 > ERROR: current transaction is aborted, commands ignored until end of > transaction block > ERROR: current transaction is aborted, commands ignored until end of > transaction block > ERROR: invalid large-object descriptor: 16552 > ERROR: current transaction is aborted, commands ignored until end of > transaction block > ERROR: current transaction is aborted, commands ignored until end of > transaction block > > > Could you please advise if this is the bug in software and needs updated > patch? > I have several time re run configs and did alot of troubleshooting but don't > find much help. This is a bug of your application. This error simply means that this application is expecting a large object that it cannot find, symbolized by the invalid descriptor OID reported in the message. Regards, -- Michael
Hello, Michael. You wrote: MP> On Thu, Jan 9, 2014 at 9:01 PM, <rabigul@gmail.com> wrote: >> I'm seeing errors whilst Asterisk is trying to run Insert command and add >> voice messages into Postgresql DB. >> here are asterisk instructions to define large objects >> >> >> https://wiki.asterisk.org/wiki/display/AST/Storing+Voicemail+in+PostgreSQL+via+ODBC >> >> >> ERROR: invalid large-object descriptor: 16551 >> ERROR: current transaction is aborted, commands ignored until end of >> transaction block >> ERROR: current transaction is aborted, commands ignored until end of >> transaction block >> ERROR: invalid large-object descriptor: 16552 >> ERROR: current transaction is aborted, commands ignored until end of >> transaction block >> ERROR: current transaction is aborted, commands ignored until end of >> transaction block >> >> >> Could you please advise if this is the bug in software and needs updated >> patch? >> I have several time re run configs and did alot of troubleshooting but don't >> find much help. MP> This is a bug of your application. This error simply means that this MP> application is expecting a large object that it cannot find, MP> symbolized by the invalid descriptor OID reported in the message. One more notice. All operations on LO (oids) must be done inside transaction bloc. Thus there should always be call for COMMIT or ROLLBACK before another try to put LO to the table. I'm not sure about your code, but you should check this too. MP> Regards, MP> -- MP> Michael -- With best wishes, Pavel mailto:pavel@gf.microolap.com