[Mono-dev] npgsql error on Mono

[Joe Audette]

Hi Francisco,

Thanks for the response.

> Did you try to execute your command with psql on console?

Well its in my web app so I don't have an easy way to run it from the
command line.

> It is very odd that you can execute from windows with no errors and from
> gnu/linux don't.

Yes thats why it seems like a Mono issue.

> Also, this error indicate some problem loading an internal postgresql
> library which gives support for plpgsql server side language.
>
> I never saw this error. Do you have more than one postgresql installed?
>

I don't think so. I'm using a VM under VMWare and installed pgsql from
Yast. The machine was upgraded from open sues 10.2 to 10.3 but after
the initial upgrade it was working fine and only recently after
updating Mono from svn this error started appearing. The file that it
says it can't load does exist and as I say runnig the same web code on
windows and using the very same pgsql database on the vm there is no
error at all.

Npgsql.NpgsqlException:
could not load library "/usr/lib/postgresql/plpgsql.so":
/usr/lib/postgresql/plpgsql.so: undefined symbol: get_func_arg_info
Severity: ERROR
Code: 58P01
 at Npgsql.NpgsqlConnector.CheckErrors () [0x00000]
 at Npgsql.NpgsqlConnector.CheckErrorsAndNotifications () [0x00000]
 at Npgsql.NpgsqlCommand.ExecuteCommand () [0x00000]
 at Npgsql.NpgsqlCommand.ExecuteScalar () [0x00000]
 at (wrapper remoting-invoke-with-check) Npgsql.NpgsqlCommand:ExecuteScalar ()
 at mojoPortal.Data.NpgsqlHelper.ExecuteScalar
(Npgsql.NpgsqlConnection connection, CommandType commandType,
System.String commandText, Npgsql.NpgsqlParameter[] commandParameters)
[0x00000]
 at mojoPortal.Data.NpgsqlHelper.ExecuteScalar (System.String
connectionString, CommandType commandType, System.String commandText,
Npgsql.NpgsqlParameter[] commandParameters) [0x00000]
 at mojoPortal.Data.DBSiteUser.UpdateLastActivityTime (Guid userGuid,
DateTime lastUpdate) [0x00000]
 at mojoPortal.Business.SiteUser.UpdateLastActivityTime () [0x00000]
 at mojoPortal.Web.Global.Application_EndRequest (System.Object
sender, System.EventArgs e) [0x00000]
 at (wrapper delegate-invoke)
System.MulticastDelegate:invoke_void_object_EventArgs
(object,System.EventArgs)
 at System.Web.HttpApplication.PipelineDone () [0x00000]

Best,

Joe


-- 
Joe Audette
Software Solutions Architect
Source Tree Solutions, LLC
joe.audette at gmail.com
http://www.sourcetreesolutions.com
http://www.mojoportal.com