Re: Sqlite crashing after upgrade from 0.11 to 1.0

[Mete Kural]

This problem started happening more and more frequently. Almost every day these days. Here is another screenshot I got of the error attached. Anybody has any ideas?

Thanks,

Mete

On Thursday, October 25, 2012 9:01:57 AM UTC-7, Mete Kural wrote:

Hello All,

I recently upgraded from Trac 0.11 to 1.0 on our Windows 2003 server. Most all seems to be working well for the last two weeks however python.exe crashes every few days now and I have to terminate it and restart Trac. This is the error log from Event Viewer:

Faulting application python.exe, version 0.0.0.0, faulting module _sqlite3.pyd, version 0.0.0.0, fault address 0x00004755

We have Python 2.5 and Sqlite 3.0.

What do you think would be the most likely to work action on my part to avoid these errors from happening? Should I upgrade Sqlite from 3.0 to the latest 3.7?

Thanks,

Mete

[Steffen Hoffmann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have a suspect, but it depends. Do you have any Trac plugins enabled,
and if YES, which ones and which versions/revisions?

Steffen Hoffmann
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlCj4qoACgkQ31DJeiZFuHem6ACfXcthXxoBxhz8yAmBWFzwn0vf
S2YAnjNeoLaNRceOwuzr3x2oa1rnaaGY
=Wv7o
-----END PGP SIGNATURE-----

[Mete Kural]

Hello Steffen,

I have these plugins installed as I can see in the Admin->Plugins screen:

testmanagementplugin 0.11.3
tracxmlrpc 1.0.0

We haven't really been using the testmanagementplugin plugin but we've
been trying to use the XML-RPC plugin through Trac's Mylyn Eclipse
plug-in. We have been selecting the "XML-RPC" Access Type in the Trac
Repository Settings screen in the Trac Mylyn plugin. We noticed that the
access through the Trac Mylyn plugin is spotty these days too, even when
Trac is actually up.

Thanks,
Mete

[RjOllos]

On Thursday, October 25, 2012 9:01:57 AM UTC-7, Mete Kural wrote:

We have Python 2.5 and Sqlite 3.0.

SQLite 3.0 was released in 2004 (1). Not knowing any more about this than you, my move would be to replicate my environment, try the upgrade and see if it fixes the issue.

(1) http://www.sqlite.org/draft/changes.html

[Mete Kural]

Thank you, I will keep this in mind. I am trying one thing at the moment to see if that works. I asked all developers to follow the below steps in their Eclipse:

1) In Eclipse, Click Window->Show View->Other->Mylyn->Team Repositories
2) Right click on "Wintouch Trac Repository" in that view and click Properties.
3) Expand "Additional Settings".
4) Under "Access Type" select "Web" instead of XML-RPC.
5) Click Finish.

I noticed that with Trac 1.0, "Web" option works fine. We used to use XML-RPC in the past cause that was the thing that worked with our old version of Trac (0.11). I am thinking that perhaps it's the xmlrpc plugin that's crashing Trac so let's see if crashes stop happening as we get off of XML-RPC.

Meanwhile I was trying to find instructions on how to uninstall the XmlRpcPlugin but I couldn't find it here:
http://trac-hacks.org/wiki/XmlRpcPlugin
Does anybody have any idea how I would uninstall this plugin from our Trac 1.0 environment?

Thanks,
Mete

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/DuWKDtYBceEJ.
To post to this group, send email to trac-...@googlegroups.com.
To unsubscribe from this group, send email to trac-users+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

[Ryan Ollos]

On Thu, Nov 15, 2012 at 3:16 PM, Mete Kural <me...@touchtonecorp.com> wrote:

[...]

Meanwhile I was trying to find instructions on how to uninstall the XmlRpcPlugin but I couldn't find it here:
http://trac-hacks.org/wiki/XmlRpcPlugin
Does anybody have any idea how I would uninstall this plugin from our Trac 1.0 environment?

Is it necessary to uninstall it (assuming you mean "remove entirely from the python environment")? I think it might be sufficient to just disable it (but perhaps that is what you were asking for anyway):

[components]

tracrpc.* = disabled 

[Mete Kural]

Oh ok, I see. So I went in to Administration in Trac and disabled those components. I attached a screenshot of what I did. Do you think this is adequate?

Thanks,
Mete

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.

[Ryan Ollos]

On Thu, Nov 15, 2012 at 3:44 PM, Mete Kural <me...@touchtonecorp.com> wrote:

Oh ok, I see. So I went in to Administration in Trac and disabled those components. I attached a screenshot of what I did. Do you think this is adequate?

I think so, but I can't say for certain. The components will still be loaded by Trac, but I would guess that won't effect your system in most situations.

[Mete Kural]

Hopefully. I guess I will find out in a few days whether Trac crashes again or not. Thank you all for your help!
-Mete

[Steffen Hoffmann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 15.11.2012 02:23, Mete Kural wrote:
> On 11/14/12 10:28 AM, Steffen Hoffmann wrote:
>> On 14.11.2012 18:49, Mete Kural wrote:
>>> On Thursday, October 25, 2012 9:01:57 AM UTC-7, Mete Kural
>>> wrote:
>>>> Hello All,
>>>>
>>>> I recently upgraded from Trac 0.11 to 1.0 on our Windows 2003
>>>> server. Most all seems to be working well for the last two
>>>> weeks however python.exe crashes every few days now and I have
>>>> to terminate it and restart Trac. This is the error log from
>>>> Event Viewer:
>>>>
>>>> Faulting application python.exe, version 0.0.0.0, faulting
>>>> module _sqlite3.pyd, version 0.0.0.0, fault address 0x00004755
>>>>
>>>> We have Python 2.5 and Sqlite 3.0.
>>>>
>>>> What do you think would be the most likely to work action on
>>>> my part to avoid these errors from happening? Should I upgrade
>>>> Sqlite from 3.0 to the latest 3.7?
>>>>

>>> This problem started happening more and more frequently. Almost
>>> every day these days. Here is another screenshot I got of the
>>> error attached. Anybody has any ideas?

>> I have a suspect, but it depends. Do you have any Trac plugins
>> enabled, and if YES, which ones and which versions/revisions?

> I have these plugins installed as I can see in the Admin->Plugins
> screen:
>
> testmanagementplugin 0.11.3 tracxmlrpc 1.0.0
>
> We haven't really been using the testmanagementplugin plugin but
> we've been trying to use the XML-RPC plugin through Trac's Mylyn
> Eclipse plug-in. We have been selecting the "XML-RPC" Access Type in
> the Trac Repository Settings screen in the Trac Mylyn plugin. We
> noticed that the access through the Trac Mylyn plugin is spotty these
> days too, even when Trac is actually up.

Hm, so this is obviously not confirming my suspect. What I had in mind
was the AccountManagerPlugin, that has known issues with current code,
that are related to the new single-sign-on feature. I'll fix that soon.

So I've no good idea or hint left, that you could follow, sorry. I just
know, that SQLite is rather weak when it comes to fast concurrent
access, and you should try PostgreSQL to sort that out, if you can.

Steffen Hoffmann

PS: Please take care for your posting habits. They make it unnecessary
hard to follow-up on your answers. Thanks in advance for considering a
change.

- --
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlCtSAoACgkQ31DJeiZFuHeX2QCgxNcCVgmbZWruQA64WGUc0Kop
MYQAoMyUgUR4yGE+2IK5cbGVjsJpsEk4
=tFwS
-----END PGP SIGNATURE-----

[Mete Kural]

Hello again!

This error has still been happening. Basically Trac crashes once or twice a week and I have to restart it. It's become quite a headache. I've been trying to figure out how to upgrade SQlite from 3.3.4 which I have to the latest version 3.7.17. The instructions for upgrading SQlite from 3.x.x to 3.x.x are these:

http://trac.edgewall.org/wiki/PySqlite#UpgradingSQLitefrom3.x.yto3.x.z

So basicaly it tells me to run these commands:

$ mv trac.db trac-old.db
 $ LD_LIBRARY_PATH=/opt/sqlite-3.2.8/lib /opt/sqlite-3.2.8/bin/sqlite3 \
     trac-old.db .dump | \
   LD_LIBRARY_PATH=/opt/sqlite-3.3.4/lib /opt/sqlite-3.3.4/bin/sqlite3 trac.db

Our server is a Windows server and I just can't find the installation folder for sqlite that has a bin folder in it like above. Where would the above folder be located in my case? I had originally installed Trac 0.11 with Phython 2.5 on this Windows server. It was pretty much a standard installation that came with the built-in SQlite 3.3.4 inside Python 2.5.

Thank you,

Mete

[RjOllos]

On Wednesday, May 22, 2013 4:02:34 PM UTC-7, Mete Kural wrote:

Our server is a Windows server and I just can't find the installation folder for sqlite that has a bin folder in it like above. Where would the above folder be located in my case? I had originally installed Trac 0.11 with Phython 2.5 on this Windows server. It was pretty much a standard installation that came with the built-in SQlite 3.3.4 inside Python 2.5.

Having the SQLite tools installed is not a requirement for running Trac, so you probably don't have them installed on your system. You can get them from here:

http://www.sqlite.org/download.html 

[Mete Kural]

Thank you very much for that information.

Do I need to install the "SQLite tools" in order to upgrade the default SQLite that came within Trac to the latest SQLite then?

Thanks,
Mete

--
You received this message because you are subscribed to a topic in the Google Groups "Trac Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/trac-users/KwoWq-FSInc/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to trac-users+...@googlegroups.com.

To post to this group, send email to trac-...@googlegroups.com.

Visit this group at http://groups.google.com/group/trac-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[RjOllos]

On Wednesday, May 22, 2013 5:20:26 PM UTC-7, Mete Kural wrote:

Thank you very much for that information.

Do I need to install the "SQLite tools" in order to upgrade the default SQLite that came within Trac to the latest SQLite then?

I have never run that procedure, but it sounds like you need to install the tools. Note in the previous section on "Upgrading SQLite from 2.x to 3.x" says "install both SQLite 2.8 and SQLite 3.x". So I think we can be fairly sure that installation of the SQLite tools is required.

[Mete Kural]

Hello there,

Thank you for the tips. I examined the pysqlite documentation a little more and figured out that I shall install the latest Windows executable of pysqlite which will automatically fetch a recent version of SQlite. So I downloaded pysqlite-2.6.3.win32-py2.5.exe (as I have Phython 2.5 installed) from here: http://code.google.com/p/pysqlite/downloads/list

The installer detected my Python directory properly and completed the installation. Now when I run import trac.db.sqlite_backend as sql and check for sql.sqlite_version, sql.have_pysqlite, and sql.sqlite.version, I get these results respectively:

(3, 7, 6, 2)
2
'2.6.3'

And I did not really run these commands at any point:

 $ mv trac.db trac-old.db
 $ LD_LIBRARY_PATH=/opt/sqlite-3.2.8/lib /opt/sqlite-3.2.8/bin/sqlite3 \
     trac-old.db .dump | \
   LD_LIBRARY_PATH=/opt/sqlite-3.3.4/lib /opt/sqlite-3.3.4/bin/sqlite3 trac.db

Trac seems to be running fine , even after restarting the physical server. So do you think I properly upgraded SQlite/Pysqlite for Trac? It seems to me to be so but not having run the above commands leave doubt in my mind. Let me let Trac run like this for a few days and see if it ceases to crash any more or not.

Thanks,
Mete