- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Why SQLite does not work on OpenVMS
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2012 01:21 PM
11-20-2012 01:21 PM
Why SQLite does not work on OpenVMS
Sure facts: http://vouters.dyndns.org/tima/OpenVMS-SQLite-A_possible-reason_why_SQLite_does_not_work_under_OpenVMS.html
Untested: SQLite executed in a threaded environment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2012 11:12 AM
11-21-2012 11:12 AM
Re: Why SQLite does not work on OpenVMS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2012 12:20 PM
11-21-2012 12:20 PM
Re: Why SQLite does not work on OpenVMS
Does SQLite work any better with the SSIO beta kit installed? See http://www.openvms.org/stories.php?story=12/10/15/5186309?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-29-2012 01:50 AM
11-29-2012 01:50 AM
Re: Why SQLite does not work on OpenVMS
Harmut,
As usual you do not give your test conditions. In consequence, your conclusions are always unexploitable and subject to caution. I ran the code on several three different VMS IA64 computers. When the test reproducer runs on VMS IA64 V8.4 with latest UPDATE patch, the test reproducer runs forever in a single VMS process. When in a second process you run sqlite> .read sqllite.cmd then the two VMS processes hang. This means even when non-threaded, the test reproducer hangs in such conditions. If you run the test reproducer in one process and sqlite> .read sqllite.cmd in parallel you will notice the hang even on a single CPU running OpenVMS IA64 V8.3 UPDATE 12. If you run the test reproducer in two VMS processses under OpenVMS IA64 V8.4 latest UPDATE, you will notice an apparent hang for a few seconds and one process will display errno = 0 and the other will continue in sequence.
The bug is NOT in the code I show on my Web site. There is a bug within your CRTL/VMS for it to return fcntl set to - 1 and errno set to 0.
For Craig,
I won't beleive SQLite will run much better on OpenVMS whichever the SQLite code is. SQLite depends too much upon file locks. As long as this problem is not cured, SQLite won't run much better on OpenVMS. My guess is that this smells a race condition within the VMS kernel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-29-2012 07:54 AM - edited 11-29-2012 07:55 AM
11-29-2012 07:54 AM - edited 11-29-2012 07:55 AM