Unable to reconnect to database: There is insufficient system memory in resource pool 'internal' to run this query.

350540's Avatar

350540

19 Apr, 2018 06:03 AM

I'm trying to make bacpac:

"C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe" /Action:Export /SourceServerName:tcp:myserver.sqlserver.sequelizer.com,1433 /SourceDatabaseN ame:dbname /SourceUser:username /SourcePassword:password /TargetFile:script.bacpac /p:Storage=File
Connecting to database 'dbname' on server 'tcp:myserver.sqlserve
r.sequelizer.com,1433'.
Extracting schema
Extracting schema from database
*** Error exporting database:Could not extract package from specified database. Unable to reconnect to database: There is insufficient system memory in resource pool 'internal' to run this query.
There is insufficient system memory in resource pool 'internal' to run this query.

What's wrong? Yesterday this script worked fine.

  1. Support Staff 1 Posted by rune on 19 Apr, 2018 07:43 AM

    rune's Avatar

    Hi,

    Can you try and give this another shot? Seems like there might've been some contention on the shared database server hosting your database (associated with the app on your account). Let me know if it still causes trouble, but keep in mind that the shared SQL server service will at times have variable performance and lower availability (so shouldn't be used for production purposes). Happy to help find alternatives if you need a production-ready solution!

    Best,
    Rune

  2. rune closed this discussion on 19 Apr, 2018 07:43 AM.

Discussions are closed to public comments.
If you need help with AppHarbor please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac