For what it's worth, I worked through a series of apparently random
connection errors when I was using MSSQL database. Searching the net it
appeared to be a problem with MSSQL and not web2py DAL. I decided to change
the database to Postgres. There were some challenges getting Postgres
installed on windows, namely due to security rights on the install folder.
It's been a week now with no connection issues, I still have my fingers
crossed.
I was running from source because these errors were crashing web2py
service, here are the type of errors I was getting:
DEBUG: connect attempt 0, connection error:
Traceback (most recent call last):
File "C:\web2py\gluon\dal.py", line 7610, in __init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
File "C:\web2py\gluon\dal.py", line 3323, in __init__
if do_connect: self.reconnect()
File "C:\web2py\gluon\dal.py", line 627, in reconnect
self.connection = f()
File "C:\web2py\gluon\dal.py", line 3321, in connector
return self.driver.connect(cnxn,**driver_args)
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server
Driver]Timeout expired (0) (SQLDriverConnect); [01S00] [Microsoft][ODBC SQL
Server Driver]Invalid connection string attribute (0)')
On Tuesday, November 12, 2013 11:54:59 PM UTC-5, Tim Richardson wrote:
>
> Rocket running as a windows service possibly doesn't like attempts to
> write to stderr.
>
>
> Traceback (most recent call last):
> File "d:\web2py_internet\gluon\restricted.py", line 217, in restricted
> exec ccode in environment
> File "d:/web2py_internet/applications/patient_form/models/db.py"
> <https://localhost:8041/admin/default/edit/patient_form/models/db.py>, line
> 132, in <module>
> db_ps_1BE = DAL('xxx', lazy_tables=True, pool_size=10, attempts=20)
> File "d:\web2py_internet\gluon\dal.py", line 7537, in __init__
> sys.stderr.write('DEBUG: connect attempt %i, connection error:\n%s' % (k,
> tb))
> IOError: [Errno 9] Bad file descriptor
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
