Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] Asterisk 13.8.0 alembic database update fails.


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
harley at thepeterscla...
Guest





PostPosted: Fri Apr 01, 2016 3:58 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

I get the following error when trying to update date the database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is wrong.

OS=Debian Jessie, fully up to date.

INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade 2d078ec071b7 -> 26d7f3bf0fa5,
add bind_rtp_to_media_address to pjsip
INFO [alembic.migration] Running upgrade 26d7f3bf0fa5 -> 136885b81223,
add regcontext to pjsip
INFO [alembic.migration] Running upgrade 136885b81223 -> 423f34ad36e2,
fix pjsip qualify timeout
Traceback (most recent call last):
File "/usr/bin/alembic", line 9, in <module>
load_entry_point('alembic==0.6.5', 'console_scripts', 'alembic')()
File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 298,
in main
CommandLine(prog=prog).main(argv=argv)
File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 293,
in main
self.run_cmd(cfg, options)
File "/usr/lib/python2.7/dist-packages/alembic/config.py", line 279,
in run_cmd
**dict((k, getattr(options, k)) for k in kwarg)
File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 125,
in upgrade
script.run_env()
File "/usr/lib/python2.7/dist-packages/alembic/script.py", line 203,
in run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/lib/python2.7/dist-packages/alembic/util.py", line 212, in
load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python2.7/dist-packages/alembic/compat.py", line 58,
in load_module_py
mod = imp.load_source(module_id, path, fp)
File "config/env.py", line 74, in <module>
run_migrations_online()
File "config/env.py", line 67, in run_migrations_online
context.run_migrations()
File "<string>", line 7, in run_migrations
File "/usr/lib/python2.7/dist-packages/alembic/environment.py", line
688, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/lib/python2.7/dist-packages/alembic/migration.py", line
258, in run_migrations
change(**kw)
File "config/versions/423f34ad36e2_fix_pjsip_qualify_ti.py", line 17,
in upgrade
with op.batch_alter_table('ps_aors') as batch_op:
AttributeError: 'module' object has no attribute 'batch_alter_table'

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
jcolp at digium.com
Guest





PostPosted: Fri Apr 01, 2016 4:07 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

Harley Peters wrote:
Quote:
I get the following error when trying to update date the database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is wrong.

OS=Debian Jessie, fully up to date.

What version of Alembic is installed and how did you install it - from a
package or pip? A change may have gone in which somehow requires a newer
version.

--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
george.joseph at fairv...
Guest





PostPosted: Fri Apr 01, 2016 4:08 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On Fri, Apr 1, 2016 at 3:06 PM, Joshua Colp <jcolp@digium.com (jcolp@digium.com)> wrote:
Quote:
Harley Peters wrote:
Quote:
I get the following error when trying to update date the database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is wrong.

OS=Debian Jessie, fully up to date.

What version of Alembic is installed and how did you install it - from a package or pip? A change may have gone in which somehow requires a newer version.


​and what version of python-sqlalchemy​?


 
Quote:


--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Back to top
kharwell at digium.com
Guest





PostPosted: Fri Apr 01, 2016 4:12 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On Fri, Apr 1, 2016 at 4:08 PM, George Joseph <george.joseph@fairview5.com (george.joseph@fairview5.com)> wrote:
Quote:



On Fri, Apr 1, 2016 at 3:06 PM, Joshua Colp <jcolp@digium.com (jcolp@digium.com)> wrote:
Quote:
Harley Peters wrote:
Quote:
I get the following error when trying to update date the database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is wrong.

OS=Debian Jessie, fully up to date.

What version of Alembic is installed and how did you install it - from a package or pip? A change may have gone in which somehow requires a newer version.


​and what version of python-sqlalchemy​?


 







Looks like the batch migration functionality went into alembic version 0.7.0:

http://alembic.readthedocs.org/en/latest/batch.html#batch-migrations

 
Quote:
Kevin Harwell
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: http://digium.com & http://asterisk.org
Back to top
harley at thepeterscla...
Guest





PostPosted: Fri Apr 01, 2016 4:16 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On 04/01/2016 04:06 PM, Joshua Colp wrote:
Quote:
Harley Peters wrote:
Quote:
I get the following error when trying to update date the database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is wrong.

OS=Debian Jessie, fully up to date.

What version of Alembic is installed and how did you install it - from a
package or pip? A change may have gone in which somehow requires a newer
version.


alembic [0.6.5+ds-1]
python-sqlalchemy [0.9.8+dfsg-0.1]

Looks like the alembic version maybe to old.

Harley


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
george.joseph at fairv...
Guest





PostPosted: Fri Apr 01, 2016 4:23 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On Fri, Apr 1, 2016 at 3:15 PM, Harley Peters <harley@thepetersclan.com (harley@thepetersclan.com)> wrote:
Quote:
On 04/01/2016 04:06 PM, Joshua Colp wrote:
Quote:
Harley Peters wrote:
Quote:
I get the following error when trying to update date the database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is wrong.

OS=Debian Jessie, fully up to date.

What version of Alembic is installed and how did you install it - from a
package or pip? A change may have gone in which somehow requires a newer
version.


alembic [0.6.5+ds-1]
python-sqlalchemy [0.9.8+dfsg-0.1]

Looks like the alembic version maybe to old.




It was SQLite that needed the batch processing.  ​Let me see if I can find an alternative​.



 
Quote:


Harley


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Back to top
george.joseph at fairv...
Guest





PostPosted: Fri Apr 01, 2016 4:26 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On Fri, Apr 1, 2016 at 3:22 PM, George Joseph <george.joseph@fairview5.com (george.joseph@fairview5.com)> wrote:
Quote:



On Fri, Apr 1, 2016 at 3:15 PM, Harley Peters <harley@thepetersclan.com (harley@thepetersclan.com)> wrote:
Quote:
On 04/01/2016 04:06 PM, Joshua Colp wrote:
Quote:
Harley Peters wrote:
Quote:
I get the following error when trying to update date the database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is wrong.

OS=Debian Jessie, fully up to date.

What version of Alembic is installed and how did you install it - from a
package or pip? A change may have gone in which somehow requires a newer
version.


alembic [0.6.5+ds-1]
python-sqlalchemy [0.9.8+dfsg-0.1]

Looks like the alembic version maybe to old.




It was SQLite that needed the batch processing.  ​Let me see if I can find an alternative​.








​Harley, can you open a Jira issue for this?​
 
Quote:

 
Quote:


Harley


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users






Back to top
harley at thepeterscla...
Guest





PostPosted: Fri Apr 01, 2016 4:30 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On 04/01/2016 04:26 PM, George Joseph wrote:
Quote:


On Fri, Apr 1, 2016 at 3:22 PM, George Joseph
<george.joseph@fairview5.com <mailto:george.joseph@fairview5.com>> wrote:



On Fri, Apr 1, 2016 at 3:15 PM, Harley Peters
<harley@thepetersclan.com <mailto:harley@thepetersclan.com>> wrote:

On 04/01/2016 04:06 PM, Joshua Colp wrote:

Harley Peters wrote:

I get the following error when trying to update date the
database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is
wrong.

OS=Debian Jessie, fully up to date.


What version of Alembic is installed and how did you install
it - from a
package or pip? A change may have gone in which somehow
requires a newer
version.


alembic [0.6.5+ds-1]
python-sqlalchemy [0.9.8+dfsg-0.1]

Looks like the alembic version maybe to old.



It was SQLite that needed the batch processing. ​Let me see if I
can find an alternative​.


​Harley, can you open a Jira issue for this?​



Harley



--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by
http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every
Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users






Never done it before.
Where url?

Harley

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
george.joseph at fairv...
Guest





PostPosted: Fri Apr 01, 2016 4:33 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On Fri, Apr 1, 2016 at 3:30 PM, Harley Peters <harley@thepetersclan.com (harley@thepetersclan.com)> wrote:
Quote:
On 04/01/2016 04:26 PM, George Joseph wrote:
Quote:


On Fri, Apr 1, 2016 at 3:22 PM, George Joseph
<george.joseph@fairview5.com (george.joseph@fairview5.com) <mailto:george.joseph@fairview5.com (george.joseph@fairview5.com)>> wrote:



    On Fri, Apr 1, 2016 at 3:15 PM, Harley Peters
    <harley@thepetersclan.com (harley@thepetersclan.com) <mailto:harley@thepetersclan.com (harley@thepetersclan.com)>> wrote:

        On 04/01/2016 04:06 PM, Joshua Colp wrote:

            Harley Peters wrote:

                I get the following error when trying to update date the
                database via
                contrib/ast-db-manage/alembic -c config.ini upgrade head.
                Every previous update has always worked any idea what is
                wrong.

                OS=Debian Jessie, fully up to date.


            What version of Alembic is installed and how did you install
            it - from a
            package or pip? A change may have gone in which somehow
            requires a newer
            version.


        alembic [0.6.5+ds-1]
        python-sqlalchemy [0.9.8+dfsg-0.1]

        Looks like the alembic version maybe to old.



    It was SQLite that needed the batch processing.  ​Let me see if I
    can find an alternative​.


​Harley, can you open a Jira issue for this?​



        Harley



        --
        _____________________________________________________________________
        -- Bandwidth and Colocation Provided by
        http://www.api-digital.com --
        New to Asterisk? Join us for a live introductory webinar every
        Thurs:
        http://www.asterisk.org/hello

        asterisk-users mailing list
        To UNSUBSCRIBE or update options visit:
        http://lists.digium.com/mailman/listinfo/asterisk-users








Never done it before.
Where url?




https://issues.asterisk.org




 
Quote:


Harley

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Back to top
jcolp at digium.com
Guest





PostPosted: Fri Apr 01, 2016 4:33 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

Harley Peters wrote:
Quote:

Never done it before.
Where url?

The issue tracker is located at https://issues.asterisk.org/jira and an
account can be created using the site at https://signup.asterisk.org/

Cheers,

--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
harley at thepeterscla...
Guest





PostPosted: Fri Apr 01, 2016 4:43 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

On 04/01/2016 04:26 PM, George Joseph wrote:
Quote:


On Fri, Apr 1, 2016 at 3:22 PM, George Joseph
<george.joseph@fairview5.com <mailto:george.joseph@fairview5.com>> wrote:



On Fri, Apr 1, 2016 at 3:15 PM, Harley Peters
<harley@thepetersclan.com <mailto:harley@thepetersclan.com>> wrote:

On 04/01/2016 04:06 PM, Joshua Colp wrote:

Harley Peters wrote:

I get the following error when trying to update date the
database via
contrib/ast-db-manage/alembic -c config.ini upgrade head.
Every previous update has always worked any idea what is
wrong.

OS=Debian Jessie, fully up to date.


What version of Alembic is installed and how did you install
it - from a
package or pip? A change may have gone in which somehow
requires a newer
version.


alembic [0.6.5+ds-1]
python-sqlalchemy [0.9.8+dfsg-0.1]

Looks like the alembic version maybe to old.



It was SQLite that needed the batch processing. ​Let me see if I
can find an alternative​.


​Harley, can you open a Jira issue for this?​



Harley



--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by
http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every
Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users





What do I create the issue under Asterisk or something else?
Don't really see a category for it.

Harley

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
jcolp at digium.com
Guest





PostPosted: Fri Apr 01, 2016 4:45 pm    Post subject: [asterisk-users] Asterisk 13.8.0 alembic database update fai Reply with quote

Harley Peters wrote:
Quote:
What do I create the issue under Asterisk or something else?
Don't really see a category for it.

Asterisk is the project and you can leave the rest as-is. It'll get
changed if it makes sense.

--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services